# Filtre sans réponse

**URL:** https://meta.discourse.org/t/unanswered-filter/126257
**Category:** Theme component
**Tags:** official, unanswered-filter
**Created:** [Août 20, 2019, 7:08 UTC](https://meta.discourse.org/t/unanswered-filter/126257 "2019-08-20T07:08:43Z")
**Posts on this page:** 1
**Showing post:** 37

<div class="post-metadata">

### Author: ![Moin](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/moin/32/554653_2.png) [@Moin](https://meta.discourse.org/u/Moin)
#### Post date: [Décembre 8, 2023, 5:09 UTC](https://meta.discourse.org/t/unanswered-filter/126257/37 "2023-12-08T17:09:23Z")

</div>

Vous pourriez utiliser l’explorateur de données pour obtenir ces sujets

> [@Filter topics not answered by Staff](https://meta.discourse.org/t/filter-topics-not-answered-by-staff/207739/8?u=moin):
>
> Hi Karen, The query below lists all topics that have not been responded to by the Staff, even if the topic has already received a response from the community. --[params] --date :start\_date = 2021-01-01 --date :end\_date = 2021-12-31 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.created\_at::date BETWEEN :start\_date AND :end\_date AND t.id NOT IN ( SELECT p.topic\_id FROM posts p JOIN users u ON p.user\_id = u.id …

---

_[View the full topic](https://meta.discourse.org/t/unanswered-filter/126257)._