主题提醒列表

支持
1

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.

2

By reminders do you mean bookmarks? Or topic timers?

3

I mean topic timers, sorry for unclear.

4

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.

5

需要明确的是，目前确实没有方法可以获取所有设置了主题计时器的主题列表，对吗？

6

目前无法通过主用户界面实现，但你可以通过数据探索器完成：

-- [params]
-- user_id :username

SELECT topic_id
FROM topic_timers
WHERE status_type = 5
  AND user_id = :username
  AND deleted_at IS NULL

编辑：@wesochuck 我已更新查询，确保同时忽略已过期的和手动删除的计时器。虽然 execute_at 能够捕获设置为未来日期的提醒，但它也会包含那些在到期前被手动删除的提醒。我想这并不理想。

7

谢谢，这样可以。我还添加了 and execute_at > CURRENT_DATE，这样我只会获取未来设置的记录。