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

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

2 Likes

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

6 Likes

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

1 Like

This should give you what you what you are looking for once you get the Data Explorer plugin installed.

6 Likes

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 the results I got with the more complex query.

1 Like