Howto/doc on 'data explorer'

[lejeczek]

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.

[Moin]

Did you find

Data Explorer Tutorial - Part 1 - Writing Your First Query

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.

[lejeczek]

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.

[JammyDodger]

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?

[lejeczek]

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”

[JammyDodger]

Copy and paste?

[lejeczek]

Page Publishing

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 …

[pfaffman (Jay Pfaffman)]

“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.

[lejeczek]

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.