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 …

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) 8월 2, 2021, 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	7월 23, 2026
Discourse Data Explorer Plugin official , data-explorer , included-in-core	30	85453	10월 22, 2025
Admin dashboard report reference guide Site Management reference , sql-query , dashboard-reports , reporting	31	8936	3월 3, 2026
User Page Metrics Data & reporting sql-query	6	295	2월 27, 2025
Access reports JSON data via Pipedream Development rest-api	2	895	7월 28, 2021

복잡한 사용자 활동 보고서 요구 사항

Related topics