I need to build a report of posts made by a specific group of people so I pull a list of those from posts table, joined by users and topics. This gives me a nice view of the content for each post, its author, which topic it belongs to and which category it’s in. I’d like to also include a link to th…

You might have a look at What cool data explorer queries have you come up with? . The url is /t/post.topic_id/post.post_number if I remember the field names exactly right.

The slug is also stored in the topics table.

C'è un modo per estrarre l'URL di un post dal database backend di Discourse?

Sviluppatore

pfaffman (Jay Pfaffman) 25 Settembre 2019, 1:31am 2

Potresti dare un’occhiata a (Superseded) What cool data explorer queries have you come up with?.

L’URL è /t/post.topic_id/post.post_number se ricordo esattamente i nomi dei campi.

Argomento		Risposte	Visualizzazioni
Which table holds the post URL? Development	2	481	Febbraio 4, 2021
Is there any way I can get all the urls of my discourse instance in a csv or xml file? Support	4	1211	Ottobre 29, 2018
Can I send an external URL to the Discourse API for it to return topics linking to that URL? Support rest-api	5	131	Dicembre 30, 2025
Finding list of shared links Feature	2	626	Maggio 2, 2019
Navigate to the posts from "Popular Link" inside a Topic Feature	1	473	Settembre 2, 2022

C'è un modo per estrarre l'URL di un post dal database backend di Discourse?

Argomenti correlati