Selecting the Quarter results in custom way. The user usman wants to customize the quarterly reporting in Discourse to show results from May 1st to July 30th instead of the default May 30th to August 30th. Stephen suggests using the Data Explorer plugin to create tailored views. usman tries using the plugin but needs help with a SQL query to get results from a specific month. simonk assists by providing a modified query that returns topics created on a specific day, and usman confirms that this solution works.
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.
Currently, the Quarterly shows the month from May 30th till August 30th.
But, we want to see the result from May 1st till July 30th.
Please tell us how it can be possible from the UI OR if there is a way to use some sort of Plugin which can query the database directly.
Thanks
The date ranges in your screenshot are based on the current date. You can use Data Explorer to pull out more tailored views.
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
However, if I modify the same query to get the results from Month of May, I get no result
i,e.
SELECT * FROM topics WHERE created_at='2022-05-01' LIMIT 5
Can you please help.
Thanks
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'
Thank you. That gives me the results I wanted 