find
@Query(value = "
SELECT user_queue.user_id userId,
queue.queue_id queueId,
queue.current_user_id currentUserId,
queue.track_expenses trackExpenses,
user_queue.is_active isActive,
user_queue.progress,
user_queue.completes,
user_queue.skips,
user_queue.expenses
FROM user_queue
JOIN queue ON user_queue.queue_id = queue.queue_id
WHERE user_id = (SELECT user_id
FROM "user"
WHERE token = :token)
AND user_queue.queue_id = :queueId ;
",
Returns user_queue model with custom fields for a particular user token and queueId
Parameters
token
user token