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:

Qual tabela contém a URL do post?

Dev

rmoff Fevereiro 4, 2021, 10:00am 3

Obrigado, isso é ótimo.

A título de informação, com o hífen não funcionou, então, em vez disso:

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

usei

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

Tudo resolvido

Tópico		Respostas	Visualizações
Is there any way to extract a URL to a post from Discourse backend DB? Development	2	1112	25 de Setembro de 2019
User-posted code blocks in a category Data & reporting sql-query	3	362	13 de Maio de 2024
Where to find post contents in the database Support	3	1000	19 de Setembro de 2020
Understanding what our users are posting about Data & reporting sql-query	9	456	20 de Junho de 2024
Data explorer query: find posts without replies Data & reporting sql-query	4	1007	15 de Fevereiro de 2021

Qual tabela contém a URL do post?

Tópicos relacionados