# 应有数据的报告为空

**URL:** https://meta.discourse.org/t/private-topics-not-showing-up-in-posts-created-report/382079
**Category:** Data & reporting
**Tags:** dashboard-reports
**Created:** [2025 年9 月 9 日 15:43 UTC](https://meta.discourse.org/t/private-topics-not-showing-up-in-posts-created-report/382079 "2025-09-09T15:43:04Z")
**Posts on this page:** 1
**Showing post:** 6

<div class="post-metadata">

### 作者： ![Moin](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/moin/32/554653_2.png) [@Moin](https://meta.discourse.org/u/Moin)
#### 发布日期： [2025 年9 月 9 日 18:07 UTC](https://meta.discourse.org/t/private-topics-not-showing-up-in-posts-created-report/382079/6 "2025-09-09T18:07:55Z")

</div>

数据浏览器应该可以获取数据。此主题中的查询返回按日期划分的帖子数量，类似于仪表板报告

> [@Dashboard Report - Posts](https://meta.discourse.org/t/dashboard-report-posts/288579?u=moin):
>
> This is an SQL version of the Dashboard Report for Posts. This report provides a daily count of posts created within a specified date range. It is designed to track the activity in regular topics, excluding posts from private messages and other special archetypes. --[params] -- date :start\_date -- date :end\_date SELECT p.created\_at::date AS "Day", COUNT(p.id) AS "Count" FROM posts p INNER JOIN topics t ON t.id = p.topic\_id AND t.deleted\_at ISNULL WHERE p.created\_at::date BETWEEN :sta…

我认为它不会受到私有主题的影响，因此您无需更改任何内容即可使用它。

---

_[View the full topic](https://meta.discourse.org/t/private-topics-not-showing-up-in-posts-created-report/382079)._