Count of replies/comments to ideas throughout the community for particular duration

[ADS_PSI]

We want count of replies/comments to ideas throughout the community for particular duration 

[TariqHussain]

@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. 

[ADS_PSI]

Can we get count of comments/replies for all idea not for particular ID?

Thanks 

[TariqHussain]

@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

https://lithosphere.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&collec...