Is there a way I get a quick list of topics that have been either created or updated in the last 7 days on my own discourse please?

Great idea @Mittineague ! I took your code and add some new code :wink: I tested, works like a charm --[params] --string :interval = 1 week --int :limit SELECT id, CONCAT(' ', title, ' ') AS html$topic, created_at as posted FROM topics WHERE age(created_at) < interval :interval AND archetype != 'private_message' GROUP BY id ORDER BY created_at DESC LIMIT :limit v1.1 added :rocket:

Do you have the Data Explorer plugin?

Thanks. No I didn’t know about that cool. Now to write the correct query

Did you create one? If not, check this query: --[params] --string :interval = 1 week --int :limit SELECT id, title, created_at as posted FROM topics WHERE age(created_at) < interval :interval AND archetype != 'private_message' GROUP BY id ORDER BY created_at DESC LIMIT :limit List updated :rocket:

Thanks. Have managed to install plug in. So will try this next. :+1:

thank you, this seems to be working, I assume limit is the number of results returned ? in case there are 1000’s ? How could I include URL in the results? i see this is not in posts and there are a few different one

[image] adamprocter: I assume limit is the number of results returned ? in case there are 1000’s ? Limit is the number of results returned and you must SET the limit on your query before run it. See this: [image] [image] adamprocter: How could I include URL in the results? Try this: --[params] --string :interval = 1 week --int :limit SELECT tu.topic_id, t.title, t.created_at as posted FROM topics t, topic_users tu WHERE t.id = tu.topic_id AND age(t.created_at) < interval :interval AND t.archetype != 'private_message' GROUP BY tu.topic_id, t.title, t.created_at ORDER BY t.created_at DESC LIMIT :limit

Last 7 days of topics

Product Support

Mittineague (Mittineague) April 13, 2018, 7:37pm 8

Something like this should display a link in the results if you want that instead of the URL.

CONCAT('<a href = "/t/', topics.id, '">', topics.title) 
   AS html$topic

Topic		Replies	Views
How to fetch all topics since a given time? Development	5	1242	November 13, 2019
How to get top 3 topic which have most active replies in last 30 days Development	0	410	January 30, 2023
Order/Filter searched topics by latest update to First Post Product Support search	3	653	February 13, 2024
Topics created_since API Product Support	2	580	February 25, 2019
Data Explorer query for topics N+ days old, that are unsolved Data & reporting sql-query	2	720	July 19, 2023

Last 7 days of topics

Related topics