Query to return topic actions done by a certain user?

Hi,

A user unnecessarily renamed and recategorized some topics. I noticed some, but I think there are others. I’d like to have the list using a data explorer query.

ask.discourse.org was of no help for this request, so perhaps some knowledgeable users here will have more to share :slight_smile:
I’m not even sure which table(s) to look at to start.

2 Likes

I think the post revisions table could be a good start.

SELECT *
from post_revisions
where user_id = 1
order by updated_at desc

I’ve created several queries – some of them quite complex and including parameters – with the help of ChatGPT.

There’s definitely a learning curve, but as your prompting improves and with a basic understanding of SQL, using the Data Explorer actually becomes fun :slight_smile: