How do I search for a deleted post that has a specific keyword in the title? Adding ?status=deleted to the basic search URL doesn’t seem to work.

[image] Loki: How do I search for a deleted post that has a specific keyword in the title? I don’t think there is any way to do this through the Discourse search page. I can see how having a filter to search for deleted posts could be useful for site admins though. Data Explorer queries can be used to return deleted topics and posts. Something like the query below could help: --[params] -- string :term SELECT id AS topic_id FROM topics WHERE deleted_at IS NOT NULL AND title LIKE CONCAT('%', :term, '%') For site’s on our hosting, you can also contact our support team and we’ll find the topic for you.

Thanks for the reply. Our mods are not familiar with Data Explorer. For now, we can do a search for all deleted posts (/latest?status=deleted) and do a page search for the word. If it’s fairly recent we’ll find it that way. Otherwise, we can ask you all for help. Can we consider this a (low priority) request to have a deleted filter eventually added to the search pane for staff?

[image] Loki: Our mods are not familiar with Data Explorer. For moderators to use the query you’d need to add the query and then give your site’s moderators access to it. We can help you set that up through our private support if it’s something you’d like to try in the future. [image] Loki: Can we consider this a (low priority) request to have a deleted filter eventually added to the search pane for staff? For sure. There may be a technical reason for why that hasn’t already been implemented, but there have been a few times where I’ve needed to search for deleted topics and posts.

@sam is opposed to it as it could bloat full text index, and I tend to agree it’s not that useful of a feature.

Hi, this works very well in general, but in the following situation it didn’t: We happened to have the first post of a topic hidden following a flag, which means that the whole topic god hidden. Nothing weird in that, but this topic couldn’t be found with the query, although it was present in the /latest?status=deleted list. Is there a way to also find these topics with a query? (like, they’re deleted, but not really deleted :grin: )

look at this query and modify it as needed. [image] Delete deleted-posts permanently in bulk? Support Excellent, glad to hear that did the job for you. So for the sake of combining the answers, one can use the following in the Rails console to destroy all topics that were deleted more than 90 days ago, repeating as many times as necessary if there are more than 1000 topics: Topic.with_deleted.where(deleted_at: ...90.days.ago).limit(1000).destroy_all After that has completed, the following can be used to destroy all posts that have been orphaned from destroyed topics: Post.find_by_sql("select …

Searching for deleted topics with a keyword in title

Product Support

IAmGav (Gavin Perch) February 21, 2022, 10:39am 8

look at this query and modify it as needed.

Topic		Replies	Views
How to get all the deleted posts for a specific topic Development rest-api	1	1147	May 13, 2020
Some issues with searching (sorting, searching deleted posts and such) Product Support	8	1121	March 21, 2022
Bulk deletion of topics Product Support	8	1010	March 8, 2023
Link to find all deleted posts by all users in a particular period Product Support	4	1128	June 21, 2021
Topic titles missing from deleted posts page when OP is deleted Bug	3	1103	December 28, 2022

Searching for deleted topics with a keyword in title

Related topics