Solved improvements: Allowing members to indicate they're experiencing a reported issue

News and Events הודעות
58

Used your question as a prompt directly in the data explorer UI to create one:

Prompt:

an admin report showing which topics have received “Me too” clicks, preferably sorted by count in descending order, filtered to open topics, with a params for date range when topic was last bumped

Query:

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

And that can be added in the dashboard as well, if desired.

That said, I could imagine this being directly integrated into the “support” section of the new dashboard as well.

לייק 1