I’m using the data explorer to build a query which shows a user’s posts - which table can I use to return the URL of the post? I assumed it would be on posts but I don’t see it. This is my query so far SELECT u.email,c.name as post_category FROM posts p left join user_emails u on p.user_id = u.us…

In SQL it is '/t/-' || topics.id || '/' || posts.post_number Which on your example would be SELECT u.email,c.name as post_category, '/t/-' || t.id || '/' || p.post_number as post_url FROM posts p left join user_emails u on p.user_id = u.user_id left join topics t on p.topic_id=t.id left join cat…

Thanks, that’s great. FWIW with the hyphen it didn’t work, so instead of this: '/t-/' || topics.id || '/' || posts.post_number I used '/t/' || topics.id || '/' || posts.post_number All sorted :+1:

Quale tabella contiene l'URL del post?

Sviluppatore

rmoff 4 Febbraio 2021, 10:00am 3

Grazie, è ottimo.

Per tua informazione, con il trattino non funzionava, quindi invece di questo:

'/t-/' || topics.id || '/' || posts.post_number

ho usato

'/t/' || topics.id || '/' || posts.post_number

Tutto a posto

Argomento		Risposte	Visualizzazioni
Is there any way to extract a URL to a post from Discourse backend DB? Development	2	1112	Settembre 25, 2019
User-posted code blocks in a category Data & reporting sql-query	3	362	Maggio 13, 2024
Where to find post contents in the database Support	3	1000	Settembre 19, 2020
Understanding what our users are posting about Data & reporting sql-query	9	456	Giugno 20, 2024
Data explorer query: find posts without replies Data & reporting sql-query	4	1007	Febbraio 15, 2021

Quale tabella contiene l'URL del post?

Argomenti correlati