find
@Query(value = "
SELECT queueId, queueName, color, isActive, name onDutyUserName, dateJoined
FROM (SELECT user_queue.queue_id queueId,
queue.name queueName,
queue.color,
user_queue.is_active isActive,
queue.current_user_id currentUserId,
user_queue.date_joined dateJoined
FROM user_queue
JOIN queue ON user_queue.queue_id = queue.queue_id
WHERE user_id = (SELECT user_id
FROM "user"
WHERE token = :token)) queue_details
JOIN "user" ON currentUserId = "user".user_id
ORDER BY queueName;
",
Returns a list of user_queue models for a particular user token
Parameters
token
user token