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.user_id left join topics t on p.topic_id=t.id left join categories c on t.category_id = c.id where p.created_at < '2021-03-01T00:00:00.000Z' GROUP BY u.email,u.user_id,c.name thanks.

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 categories c on t.category_id = c.id where p.created_at < '2021-03-01T00:00:00.000Z' GROUP BY u.email,u.user_id,c.name

באיזו טבלה נמצא ה-URL של הפוסט?

מפתח

rmoff 4 בפברואר,‏ 2021,‏ 10:00am 3

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

נושא		תגובות	צפיות
Is there any way to extract a URL to a post from Discourse backend DB? Development	2	1128	25 בספטמבר,‏ 2019
User-posted code blocks in a category Data & reporting sql-query	3	405	13 במאי,‏ 2024
Where to find post contents in the database Product Support	3	1012	19 בספטמבר,‏ 2020
Understanding what our users are posting about Data & reporting sql-query	9	546	20 ביוני,‏ 2024
Data explorer query: find posts without replies Data & reporting sql-query	4	1027	15 בפברואר,‏ 2021

באיזו טבלה נמצא ה-URL של הפוסט?

נושאים קשורים