In a support discussion titled ‘Identifying posts that haven’t been resolved automatically,’ Thas raises the issue that some community posts lack a marked solution despite ongoing conversation, and asks if it’s possible to automatically flag and notify staff about such unresolved topics—perhaps via weekly or fortnightly alerts. JammyDodger suggests using a Data Explorer query to identify topics without a solution (i.e., no post marked as ‘accepted answer’) and automating notifications via recurring private messages. They include a sample SQL query that filters unsolved topics by category, age (within 14 days), and status (not deleted or closed), excluding those with a solution post. A screenshot illustrates scheduling a PM with query results. This approach allows targeted follow-up on unresolved support threads without manual review.
Hello,
So we have noticed that there are certain posts on the community that have not satisfied the users question. As in there is some conversation around it but no answer. This has been missed. I wondered if there’s a way to automatically identify these queries and receive notifications.
It may mean that we receive notifications for all the posts that have not been ticked on the ‘solution’ box weekly/fortnightly, is this possible?
Thanks
I think running a data explorer query to identify exactly which topics fit the criteria and then getting the results sent in a recurring PM using Automation should do what you want. 
Something like:
-- [params]
-- int_list :category_id = 4, 5, 6
WITH solved_topics AS (
SELECT p.topic_id
FROM posts p
INNER JOIN topic_custom_fields tcf ON tcf.value::int = p.id
WHERE tcf.name = 'accepted_answer_post_id'
AND p.deleted_at ISNULL
AND post_number = 1
)
SELECT t.id AS topic_id,
t.created_at::date "Created Date"
FROM topics t
WHERE t.id NOT IN (SELECT topic_id FROM solved_topics)
AND t.user_id > 0
AND t.deleted_at ISNULL
AND t.closed = false
AND t.category_id IN (:category_id)
AND t.created_at > CURRENT_DATE - INTERVAL '14 DAYS'
ORDER BY 2