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 …

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

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!)

Anforderung für komplexen Benutzeraktivitätsbericht

Gemeinschaft Daten & Berichterstattung

Grayden_Shand (Grayden Shand) 2. August 2021 um 12:50 12

@Paul_King

Diese Abfrage könnte hilfreich sein.

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

Thema		Antworten	Aufrufe
Discourse Data Explorer Plugin official , data-explorer , included-in-core	31	82161	22. Oktober 2025
Admin dashboard report reference guide Site Management reference , dashboard-reports , sql-query , reporting	32	7705	3. März 2026
User Page Metrics Data & reporting sql-query	6	143	27. Februar 2025
Access reports JSON data via Pipedream Dev rest-api	2	826	28. Juli 2021
Daily graph of user time online Feature	3	2152	4. Dezember 2025

Anforderung für komplexen Benutzeraktivitätsbericht

Verwandte Themen