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:

Quelle table contient l'URL du post ?

Dev

rmoff Février 4, 2021, 10:00 3

Merci, c’est super.

Pour information, avec le tiret, cela ne fonctionnait pas, donc au lieu de ceci :

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

j’ai utilisé

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

Tout est réglé

Sujet		Réponses	Vues
Is there any way to extract a URL to a post from Discourse backend DB? Development	2	1112	Septembre 25, 2019
User-posted code blocks in a category Data & reporting sql-query	3	362	Mai 13, 2024
Where to find post contents in the database Support	3	1000	Septembre 19, 2020
Understanding what our users are posting about Data & reporting sql-query	9	456	Juin 20, 2024
Data explorer query: find posts without replies Data & reporting sql-query	4	1007	Février 15, 2021

Quelle table contient l'URL du post ?

Sujets connexes