find
@Query(value = "
SELECT queue.queue_id queueId,
queue.name queueName,
queue.color queueColor,
queue.is_important isImportant,
queue.track_expenses trackExpenses
FROM queue
JOIN user_queue ON queue.queue_id = user_queue.queue_id
WHERE queue.current_user_id = user_queue.user_id
AND queue.current_user_id = (SELECT user_id
FROM "user"
WHERE token = :token)
AND queue.queue_id in (SELECT queue_id
FROM user_queue
GROUP BY queue_id
HAVING COUNT(*) > 1)
ORDER BY queue.name, queue.is_important DESC;
",
Returns queues for which a particular user is on duty
Parameters
token
user token