Forum Discussion

keithkelly's avatar
keithkelly
Leader
2 years 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
2 years ago

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
    2 years ago

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