We want count of replies/comments to ideas throughout the community for particular duration
@ADS_PSI - If you are looking for REST API solution, below API call would work for you.
Count of comment on a particular idea
SELECT count(*) FROM messages WHERE thread.id = '<threadid>' AND post_time > 1454348367000 AND post_time < 1454953167993
Count of comments within a board.
SELECT count(*) FROM messages WHERE board.id = '<idea.board.id>' AND post_time > 1454348367000 AND post_time < 1454953167993
In above examples, you will need to pass the timestamp for that particular duration you want to get the count.
This thread might be useful.
Can we get count of comments/replies for all idea not for particular ID?
Thanks
@ADS_PSI -
You can pass conversation.style='idea' to fetch the comment of all ideas.
SELECT count(*) FROM messages WHERE conversation.style='idea' AND depth > 0 AND post_time > 1454348367000 AND post_time < 1454953167993
Welcome to the Technology board!
Curious about our platform? Looking to connect on social technology? You've come to the right place!