# 已解决改进：允许成员表明他们正在经历已报告的问题

**URL:** https://meta.discourse.org/t/solved-improvements-allowing-members-to-indicate-theyre-experiencing-a-reported-issue/402498
**Category:** Announcements
**Tags:** solved
**Created:** [2026年五月13日 13:05 UTC](https://meta.discourse.org/t/solved-improvements-allowing-members-to-indicate-theyre-experiencing-a-reported-issue/402498 "2026-05-13T13:05:16Z")
**Posts on this page:** 1
**Showing post:** 58

<div class="post-metadata">

### Author: ![mcwumbly](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/mcwumbly/32/103861_2.png) [@mcwumbly](https://meta.discourse.org/u/mcwumbly)
#### Post date: [2026年八月1日 15:26 UTC](https://meta.discourse.org/t/solved-improvements-allowing-members-to-indicate-theyre-experiencing-a-reported-issue/402498/58 "2026-08-01T15:26:54Z")

</div>

> [@EricGT](#):
>
> 此功能是否包含一份管理员报告，显示哪些主题收到了“我也是”点击，最好按点击次数降序排列？

我直接将你的问题作为提示词，在数据浏览器界面中创建了一份报告：

提示词：

> 一份管理员报告，显示哪些主题收到了“我也是”点击，最好按点击次数降序排列，筛选条件为未关闭的主题，并包含一个参数用于指定主题最后被顶起的时间范围

查询语句：

```sql
-- [params]
-- date :start_date = 2026-02-01
-- date :end_date = 2026-08-01

SELECT
  t.id AS topic_id,
  t.title,
  COUNT(si.id) AS me_too_count,
  t.bumped_at AS last_bumped_at
FROM discourse_solved_shared_issues si
JOIN topics t ON t.id = si.topic_id
JOIN categories c ON c.id = t.category_id
WHERE t.deleted_at IS NULL
  AND t.archetype = 'regular'
  AND t.closed IS FALSE
  AND t.archived IS FALSE
  AND t.visible IS TRUE
  AND c.read_restricted IS FALSE
  AND t.bumped_at >= CAST(:start_date AS date)
  AND t.bumped_at < CAST(:end_date AS date) + INTERVAL '1 day'
GROUP BY t.id, t.title, t.bumped_at
ORDER BY me_too_count DESC

```

如果需要，也可以将其添加到仪表盘中。

* * *

话虽如此，我也设想可以将其直接集成到新仪表盘的“支持”部分中。

---

_[View the full topic](https://meta.discourse.org/t/solved-improvements-allowing-members-to-indicate-theyre-experiencing-a-reported-issue/402498)._