Topics Voted On

data & reporting
,
1

Topics Voted On

Returns the topic(s) and creation date of current and archived votes for a given user

-- [params]
-- user_id :user

SELECT dvv.topic_id,
       dvv.created_at::date AS "Voted On",
       CASE WHEN dvv.archive = TRUE THEN 'Archived' ELSE 'Current' END AS "Current?"
FROM discourse_voting_votes dvv
WHERE dvv.user_id = :user
ORDER BY dvv.archive, dvv.created_at