I am looking for a way to get Discourse to generate activity reports in the form of an overview of all user activity between any two custom dates each year (current built in functionality only seems to have preset ranges, and only in relation to today’s date), and to save the results out to a excel …

[画像] Paul_King: Can one query take as input filtered output from another query? No, you would have to copy/paste sections of the query. [画像] Paul_King: Also can email list based interaction definitely be included? The posts table in the database includes a via_email boolean, so yes yo…

Is the ‘baked-in’ user activity reporting functionality handled via SQL queries that I can copy from anywhere and tinker with? - so I don’t end up spending weeks reinventing the wheel?

Are you looking at the “daily engaged users” report? That’s generated with this logic , which uses ActiveRecord (so no raw SQL). But still, the logic might be a useful starting point.

I am aiming for a per user activity report, in csv format, spanning from one date to another. The end goal is to give each user an activity points score for the year (or other period) based on messages received/read online or via email, messages posted online or via email, and where messages with l…

The user directory logic can be found here: discourse/app/models/directory_item.rb at 1e66e4602f408d7b2d1105b6c228542dce7f4b38 · discourse/discourse · GitHub

Hmm, not looking like a trivial undertaking to replicate via SQL (at least not for me), as I will need to learn enough SQL to pull it off from scratch at the same time, if there is nothing similar enough I can copy from directly. Last time I did any programming was many years ago in high school, wh…

Yeah I think this will require a reasonable knowledge of SQL to implement. If you have a budget for the work, you might be able to find someone who can help in the Marketplace

Cheers, I don’t have a budget (forum generates little donation income beyond basic hosting costs), but looking like I may have to go that way anyway

Many thanks! I tried it, but am getting a syntax error PG::SyntaxError: ERROR: syntax error at or near “WITH” LINE 13: WITH date_range AS ( (apologies, I sent a PM to you via that thread before twigging that you and the original author there are one and the same!)

複雑なユーザーアクティビティレポート要件

コミュニティデータとレポート

Grayden_Shand (Grayden Shand) 2021 年 8 月 2 日午後 12:50 12

@Paul_King

このクエリが役立つかもしれません。

https://meta.discourse.org/t/daily-weekly-or-total-stats-by-user-over-a-specified-time-range/275167u=grayden_shand

トピック		返信	表示
Data Explorer :handshake: AI - Generate Data Explorer queries with AI Announcements data-explorer , ai	0	202	2026 年 7 月 23 日
Discourse Data Explorer Plugin official , data-explorer , included-in-core	30	85453	2025 年 10 月 22 日
Admin dashboard report reference guide Site Management reference , sql-query , dashboard-reports , reporting	31	8936	2026 年 3 月 3 日
User Page Metrics Data & reporting sql-query	6	295	2025 年 2 月 27 日
Access reports JSON data via Pipedream Development rest-api	2	895	2021 年 7 月 28 日

複雑なユーザーアクティビティレポート要件

関連トピック