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

Support
1

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.

2

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.

2 Likes
3

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.

4

Just got Data Explorer running. This is fantastic!

1 Like
5

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.