Package es.kukenan.smartfi.microservice.communication.repository

Interface MessageChannelPriorityRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<MessageChannelPriority,MessageChannelPriorityId>, org.springframework.data.repository.Repository<MessageChannelPriority,MessageChannelPriorityId>

@Repository
public interface MessageChannelPriorityRepository
extends org.springframework.data.repository.CrudRepository<MessageChannelPriority,MessageChannelPriorityId>

Spring Data repository used to access the message_channel_priority in BBDD. See MessageChannelPriority.

Method Summary

Modifier and Type	Method	Description
List<MessageChannelPriority>	findByMessageAndLanguageOrderByOrderAsc(Message message, int language)	Find all registries by message and language order by order field.
List<MessageChannelPriority>	findByMessageOrderByOrderAsc(Message message)	Find all registries by message order by order field.

Methods inherited from interface org.springframework.data.repository.CrudRepository

count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findAll, findAllById, findById, save, saveAll

Method Details

findByMessageOrderByOrderAsc

List<MessageChannelPriority> findByMessageOrderByOrderAsc(Message message)

Find all registries by message order by order field.

Parameters:

message - message to filter

Returns:

registries list

findByMessageAndLanguageOrderByOrderAsc

@Query(nativeQuery=true,
       value="SELECT * FROM message_channel_priority p INNER JOIN message m on p.message_id = m.id INNER JOIN template t on p.template_id = t.id WHERE m.id = :message and t.user_language_id = :language ORDER BY p.order asc")
List<MessageChannelPriority> findByMessageAndLanguageOrderByOrderAsc(@Param("message")
 Message message,
 @Param("language")
 int language)

Find all registries by message and language order by order field.

Parameters:

message - the message which associated

language - the user language

Returns:

registries list