Hi, how can I find a list of my active reminders and reminders of other users (when I am admin)? For example, I set some reminders for topics and want to review them.
By reminders do you mean bookmarks? Or topic timers?
I mean topic timers, sorry for unclear.
List of topic reminders needs in case if I want to cancel some reminders. Users could watch or cancel their reminders. Staff could manage all reminders.
To be clear, there is NOT a way to get a list of all your topics that currently have topic timers, correct?
Not currently through the main user interface, but you can through the Data Explorer:
-- [params] -- user_id :username SELECT topic_id FROM topic_timers WHERE status_type = 5 AND user_id = :username AND deleted_at IS NULL
Edit: @wesochuck I updated the query to make sure it ignores both expired and manually deleted timers. While
execute_at does make sure to catch reminders that were set at a future date, it will also include any that were manually deleted before they expired. I imagine that’s not ideal.
Thanks, that works. I also added
and execute_at > CURRENT_DATE so I only get ones that are set in the future.