Feature request: search filter to see messages/topics with timer reminders set


(Tobias Eigen) #1

I was just showing the topic timer reminder feature to a colleague, and she is very impressed by it and would like to start using it to reach out to members via PM and to remind herself to follow up if there is no reply.

I realized after the call that it is not possible to see a list of topics and messages for which you have set a topic timer, which would be helpful in this use case. The alternative is to set up some separate system for tracking who has replied and who needs a reply, e.g. a spreadsheet.

One way to handle this would be to add a filter to the search for messages/topics that have a timer set.

For admin purposes it’d also be interesting anyway to see this information whether or not this filter is added to search - is there a query for getting it via the data explorer?

(David Taylor) #2

Give this a try:

SELECT execute_at,
CASE status_type
   WHEN 1 THEN 'Close'
   WHEN 2 THEN 'Open'
   WHEN 3 THEN 'Publish to category'
   WHEN 4 THEN 'Delete'
   WHEN 5 THEN 'Reminder'
   ELSE 'Unknown'
END as type,
category_id, user_id, topic_id, based_on_last_post 
FROM topic_timers 
WHERE deleted_at IS NULL
ORDER BY execute_at ASC

Remove WHERE deleted_at IS NULL if you want to see timers that have already been executed

(Tobias Eigen) #3

that worked! and is super helpful. thank you!