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 …

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) 02.Август.2021 12:50:07 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	23.07.2026
Discourse Data Explorer Plugin official , data-explorer , included-in-core	30	85453	22.10.2025
Admin dashboard report reference guide Site Management reference , sql-query , dashboard-reports , reporting	31	8936	03.03.2026
User Page Metrics Data & reporting sql-query	6	295	27.02.2025
Access reports JSON data via Pipedream Development rest-api	2	895	28.07.2021

Требования к сложному отчету о пользовательской активности

Связанные темы