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

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

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

jomaxro (Joshua Rosenfeld) August 16, 2019, 10:24pm 5

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.

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

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

Related topics