# Consulta do Data Explorer para tópicos com N+ dias, não resolvidos

**URL:** https://meta.discourse.org/t/data-explorer-query-for-topics-n-days-old-that-are-unsolved/272020
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [Julho 18, 2023, 8:29pm UTC](https://meta.discourse.org/t/data-explorer-query-for-topics-n-days-old-that-are-unsolved/272020 "2023-07-18T20:29:27Z")
**Posts on this page:** 1
**Showing post:** 3

<div class="post-metadata">

### Author: ![Canapin](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/canapin/32/119591_2.png) [@Canapin](https://meta.discourse.org/u/Canapin)
#### Post date: [Julho 19, 2023, 8:47am UTC](https://meta.discourse.org/t/data-explorer-query-for-topics-n-days-old-that-are-unsolved/272020/3 "2023-07-19T08:47:51Z")

</div>

Fico feliz que você tenha descoberto. 🙂

Pode não ser muito útil para apenas dois números, mas caso você não saiba, é possível adicionar parâmetros dinâmicos às consultas do [Data Explorer](https://meta.discourse.org/t/32566?silent=true), o que permitiria selecionar facilmente o intervalo com entradas em vez de editar diretamente a consulta: [Discourse Data Explorer](https://meta.discourse.org/t/discourse-data-explorer/32566#declaring-parameters-in-your-query-8)

---

_[View the full topic](https://meta.discourse.org/t/data-explorer-query-for-topics-n-days-old-that-are-unsolved/272020)._