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

متطلب تقرير نشاط المستخدم المعقد

مجتمع البيانات والتقارير

Grayden_Shand (Grayden Shand) 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	23 يوليو 2026
Discourse Data Explorer Plugin official , data-explorer , included-in-core	30	85453	22 أكتوبر 2025
Admin dashboard report reference guide Site Management reference , sql-query , dashboard-reports , reporting	31	8936	3 مارس 2026
User Page Metrics Data & reporting sql-query	6	295	27 فبراير 2025
Access reports JSON data via Pipedream Development rest-api	2	895	28 يوليو 2021

متطلب تقرير نشاط المستخدم المعقد

الموضوعات ذات الصلة