Hi, We are using Discourse for our community platform and we have a bit different Quarterly system required for our team reporting which is sent out to the Staff members. [image] Currently, the Quarterly shows the month from May 30th till August 30th. But, we want to see the result from May 1st…

Your query would only return topics if they were created at exactly midnight on that date. If you’re looking for topics created any time on that day, you would use something like this: SELECT * FROM topics WHERE created_at >= '2022-05-01' AND created_at < '2022-05-02'

The date ranges in your screenshot are based on the current date. You can use Data Explorer to pull out more tailored views. [صورة] Discourse Data Explorer Plugin plugin discourse2 Summary Discourse Data Explorer allows you to make SQL queries against your live database,…

Thanks for the reply. We do have this plugin and I was for e.g. able to get a simple select query for that particular table. e.g. SELECT * FROM topics LIMIT 1 Link to CSV file However, if I modify the same query to get the results from Month of May, I get no result i,e. SELECT * FROM topics W…

Thank you. That gives me the results I wanted :slight_smile:

اختيار الربع بنتائج بطريقة مخصصة

الدعم

Stephen (Stephen) 30 أغسطس 2022، 5:47م 3

تستند نطاقات التاريخ في لقطة الشاشة الخاصة بك إلى التاريخ الحالي. يمكنك استخدام مستكشف البيانات لسحب طرق عرض أكثر تخصيصًا.

الموضوع		الردود	مرات العرض
Topic Count Per User for Custom Date? Support	1	833	4 أغسطس 2020
Run Data Explorer queries with the Discourse API Integrations data-explorer , how-to , rest-api	14	13502	6 مايو 2025
Find posts "solved" in specific month Data & reporting solved , sql-query	4	1565	29 مارس 2019
Custom time period in Dashboard Data & reporting	7	830	27 يناير 2022
Discourse Data Explorer Plugin official , data-explorer , included-in-core	31	82455	22 أكتوبر 2025

اختيار الربع بنتائج بطريقة مخصصة

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