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

Community Building Data & reporting

AI-generated summary

Searching for Posts with No Staff Replies

There is no built-in search feature to find posts with no staff replies. To achieve this, jomaxro and James_Anderson suggest using the Data Explorer plugin.

tshenry provides a SQL query to find the desired posts:

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 IN (
    SELECT p.topic_id
    FROM posts p 
    JOIN users u ON p.user_id = u.id
    WHERE  u.admin = 't' OR u.moderator = 't'
      AND p.post_number > 1
  )

Mittineague attempted to use the moderator_posts_count field in the topics table but found inconsistencies in the results compared to the more complex query.

1

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

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.

6

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

7

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

8

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.