Forum Discussion

keithkelly's avatar
keithkelly
Leader
9 months ago

Can I find the count of unanswered topics (for a given forum) for a certain date?

We're starting to track "unanswered topics" as a KPI.   Is it possible to grab this historically?  (e.g.:  "For each forum, return the count of unanswered topics on February 1st, 2024") I'm okay wit...
HariniVuppala's avatar
HariniVuppala
Expert

keithkelly The below query might be helpful to you to get the unanswered topics count.

select count(*) from messages where conversation.solved=false and board.id="boardid" and depth=0 and post_time > 2024-02-01T00:00:00.000-00:00 and post_time < 2024-02-01T23:59:59.999-00:00

DasariPrashanth's avatar
DasariPrashanth
Helper
9 months ago

yes, this should work, but I think >=, <= should be used instead of >,< for post_time constraint