A user is seeking a way to obtain a list of topic close events from the logs. 1101010 initially believes it’s not possible, as topic closure doesn’t appear to be logged. codinghorror clarifies the terminology, and 1101010 confirms they mean topic closure, not post locking. sam suggests using the Data Explorer plugin with a query to find close actions in posts, but 1101010 notes that the plugin is not installed on their instance.
It doesn’t seem like there is.
Also I tried searching but couldn’t find anything about this, sorry.
But yes, I note there are events for deletion and the like but nothing for closing topics.
Is that because this is a leader action and we don’t log those? Would be good to note the Leader actions somewhere if not.
Thanks
What do you mean “lock”? Do you mean close the topic? Or are you referring to the per-post action?
Apologies, yes I mean close the topic. Because of the padlock symbol being what I saw in my mind’s eye I could only think of lock as it’s the one on other forums.
I would not be searching for topic close events… instead for all posts that are close actions in data explorer should do the trick.
Try this query:
SELECT topic_id, user_id, action_code, created_at
FROM posts
WHERE post_type = 3 AND action_code like '%closed%'
ORDER BY created_at DESC
LIMIT 100
Ah okay, thanks a lot.
We don’t have that plugin installed. I’ll see if the owner wants it but probably it won’t happen.
It’s not wildly important I just wondered if I was missing something that could tell us this.
Thanks for the help