# זיהוי פוסטים שלא נפתרו אוטומטית

**URL:** <https://meta.discourse.org/t/identifying-posts-that-havent-been-resolved-automatically/261616>\
**Category:** Product Support\
**Created:** [13 באפריל,‏ 2023,‏ 3:59pm UTC](https://meta.discourse.org/t/identifying-posts-that-havent-been-resolved-automatically/261616 "2023-04-13T15:59:57Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)\
**Post date:** [10 ביוני,‏ 2023,‏ 11:34am UTC](https://meta.discourse.org/t/identifying-posts-that-havent-been-resolved-automatically/261616/2 "2023-06-10T11:34:25Z")

</div>

I think running a [data explorer](https://meta.discourse.org/t/32566?silent=true) 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. 👍

 ![schedule a pm with data explorer results](https://global.discourse-cdn.com/meta/original/4X/9/0/9/909b0eabfac5fa5b12717a200c3e8e6aa1f2c87c.png)

Something like:

```sql
-- [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 

```

---

_[View the full topic](https://meta.discourse.org/t/identifying-posts-that-havent-been-resolved-automatically/261616)._