We love Data Explorer plugin! Already constructed few specific queries to look for sensitive words and phrases.
But we wander is it possible to see the SQL behind standard reports available on Discourse Dashboard? That can enable us to learn a lot and start constructing customised reports
I think those ones are found in https://github.com/discourse/discourse/tree/main/app/models/concerns/reports, though may not be as easy to decipher as some of the ones shared in data-explorer topics.
There are some good tricks in this topic too for some of the Data-Explorer automagic you can leverage to make the results more interactive:
If there are any queries in particular you’re trying to create feel free to spin up a topic and ‘think out loud’, as we’re always looking for more examples we can add to our community pool.
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.