In a support discussion titled “Use ‘Last checked by’ timestamp to search / filter posts,” jcarlson asks if there’s a built-in way to filter posts by the “last checked by” timestamp added by the automation plugin, aiming to identify stale wiki posts for review. JammyDodger replies that this data is stored in the topic_custom_fields table under keys like discourse_automation_last_checked_at and last_checked_by, and suggests using Data Explorer to query it. jcarlson expresses gratitude and clarifies they didn’t realize the data was stored separately, noting they’re still settling into their Discourse instance. In a follow-up, jcarlson confirms they’ve successfully set up Data Explorer and finds it fantastic. The discussion highlights a practical workflow for maintaining content freshness using Discourse’s plugin and data tools.
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.
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.
