findQueueParticipants

@Query(value = " SELECT user_queue.user_id userId, "user".name userName, user_queue.expenses, user_queue.is_active isActive FROM user_queue JOIN "user" ON user_queue.user_id = "user".user_id WHERE user_queue.queue_id = :queueId ; ", nativeQuery = true)
abstract fun findQueueParticipants(queueId: Long): List<QueueParticipants>

Returns a list of users participating in a particular queue

Parameters

queueId
  • id of queue