Hi guys. Would there be a doc/tutorial for non-webdev on how to use data/queries/results in topics/posts? I searched but failed to find one. Thanks.

Did you find [image] Data Explorer Tutorial - Part 1 - Writing Your First Query Data & reporting discourse Want to extract some data from your Discourse site but not sure where to start? You’ve come to the right place! This is a #tutorial guide for beginners who are new to the Data Explorer. If you’re already familiar with SQL and how to use the Data Explorer, then you will most likely not need to read these topic, and may want to check out our #data-reporting category instead. The goal of this guide is to help you get a basic grasp of how to use the Data Explorer to create reports … Maybe the other topics with #sql-tutorial help you too.

Thanks. I’ve thumbed through it - perhaps I’ve gone blind - but cannot see bits which would mention “incorporating” queries/results into a topic/post, into its content.

How people do it then or how to understand when someone says “.. manually created a new topic using the data from the Published Pages query above, then published it at `/pub/index..” ? That is a quote from another topic about “indexing published pages”

[image] Page Publishing Site Management Indexing Published Pages While we’re waiting for the Index or search published pages feature, here is a way to do it manually. Finding Published Pages Using the Discourse Data Explorer you can create a new Published Pages query: SELECT CONCAT('/pub/', pp.slug) AS URL, pp.topic_id FROM published_pages pp ORDER BY pp.id Providing an Index Surely one can Run Data Explorer queries with the Discourse API to create and maintain an index of published pages. This might even be doable with the Custom …

“manually created” for means that they created the topic normally and pasted in the stuff from the data explorer. It might help if you say more about the specific problem that you are actually trying to solve.

Oh. I presumed that - since it looked like a “hot” topic to me - that proposed idea was a solution to have a dynamic index of published pages. I thought that was the idea behind it - to have TOC/index for published pages, dynamic index.

I am stuck. I’m trying to use the query to. create a new group and copy all existing members into that group. I understand the part of getting to data explorer, naming it etc. I’ve copied the query - now where to do I paste it? I’ve pasted it to the text box to the right of the Select area but nothing happens. sorry for the elementary question but I’m on a time crunch to get this done. tx Bronwyn

[image] IrisBetty: I’m trying to use the query to. create a new group Data explorer is only for exploring data, not changing it. If you need to change something with code, and don’t have access to run stuff in rails, then you need to use the API. [image] IrisBetty: create a new group and copy all existing members into that group. What problem is this solving? Do you really want to create a new group that has every user on the system on it? You can’t use @everyone or @tl0?

Howto/doc on 'data explorer'

Product Support

JammyDodger October 10, 2023, 8:50am 4

I don’t believe this is currently something you can do. There is an Automation that will send results to a PM or email. Perhaps you could check that out and see how it does it?

Topic		Replies	Views
Discourse Data Explorer Plugin official , data-explorer , included-in-core	30	87364	October 22, 2025
Data Explorer Tutorial - Part 1 - Writing Your First Query Data & reporting data-explorer , sql-tutorial	0	1717	September 5, 2023
Group forum members based on topics viewed? Product Support	3	1768	September 26, 2018
Export topics to Excel Product Support	12	1586	March 30, 2021
Data Explorer Queries accessible to public Feature data-explorer	10	4222	February 11, 2020

Howto/doc on 'data explorer'

Related topics