Is there a simple way to search or filter posts by the “last checked by” date appended by the #automation plugin? I’d love to quickly identify wiki posts that are getting “stale” to have staff regularly go through make sure things are still accurate. It looks like the timestamp is just in the body of the post, not in its properties. I could probably just crawl my own site and use some regex to pull the timestamps into a list, but I was hoping there might be some built-in method of accomplishing this.

Hello and welcome @jcarlson :slight_smile: I believe that info is stored in the topic_custom_fields table with the name of discourse_automation_last_checked_at (and another for last_checked_by). If you have the data explorer you could use a query to pull out a list of topics based on that info.

Well, I think I will be adding the Data Explorer! Thank you! I didn’t realize those attributes were being stored. Would I see topic_custom_fields anywhere in the post’s JSON, or is it stored someplace else? We’re on week two of running our org’s Discourse, and still getting settled in.

Use "Last checked by" timestamp to search / filter posts

Product Support

jcarlson (Josh Carlson) July 15, 2024, 4:44pm 4

Just got Data Explorer running. This is fantastic!

Topic		Replies	Views
Order/Filter searched topics by latest update to First Post Product Support search	3	650	February 13, 2024
How to fetch all topics since a given time? Development	5	1238	November 13, 2019
Setting up the 'Append last checked by' automation Site Management automation , how-to	1	857	May 6, 2025
Automatically Reflect Timestamp of Old WordPress Posts WordPress	2	645	May 25, 2018
Bug Blog: “LastPosted” reveals non-public data about users, exploited to gain advantages Feature	3	698	November 19, 2018

Use "Last checked by" timestamp to search / filter posts

Related topics