Is there a way to Search by Posts with No Staff replies on it.? It would be helpful to find posts easily that way! Thanks so much

I’m pretty sure you’re going to need to use the Discourse Data Explorer . I’m not aware of this being surfaced via search in any way.

This should give you what you what you are looking for once you get the Data Explorer plugin installed. [image] Return all non-PM topics that have not received a staff reply SELECT t.id topic_id, category_id FROM topics t WHERE t.deleted_at IS NULL AND t.category_id IS NOT NULL AND t.id NOT …

I was playing with some queries using group_users, topic_users and topics when I noticed a topics field moderator_posts_count and got excited!!! I tried SELECT topics.id as topic_id FROM topics WHERE topics.moderator_posts_count < 1 :sadpanda: not so lucky, there was a lot of difference from t…

Is there a way to Search by Posts with No Staff replies on it

Community Building Data & reporting

James_Anderson (James Anderson) August 16, 2019, 10:37pm 6

Thank you so much I’ll go check it out!

Topic		Replies	Views
Return all non-PM topics that have not received a staff reply Data & reporting sql-query	0	256	August 17, 2019
How to show non-staff posts with zero replies Product Support	2	743	November 16, 2022
How to find topics without a reply from someone other than the topic owner? Product Support	0	1324	February 15, 2021
Filter topics not answered by Staff Data & reporting sql-query	4	1124	November 2, 2021
How to find my replies that didn't get a reply? Product Support	5	981	July 18, 2017

Is there a way to Search by Posts with No Staff replies on it

Related topics