I would like to compare how many topics went unanswered in July 2018 versus how many went unanswered in July 2019.
Solved! Go to Solution.
The below queries can help you to get the topics count which were posted in a specific month but not resolved yet.
For July 2019
For July 2018
You can run it you have studio/admin access.
Studio > API Browser
Here is the screenshot for your reference https://prnt.sc/px8v6p
We only have Studio on staging. Is there any way to do this on the live site?
You can use the below URL to run it for production. You need to replace the base URL with your community base URL
Thank you!! So helpful.
I have tried this and it works a treat - thanks for the tip! When I "select * from..." I get a size of 25 but when I changed the query to "select count(*) from..." I get a count of 969. Do you know why this is?
By default, API returns 25 results. You can pass a specific limit up to 1000 to get more results.
Welcome to the Technology board!Curious about our platform? Looking to connect on social technology? You've come to the right place!