Khoros Community

Frequent Advisor
Frequent Advisor

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

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

3 Replies 3
Highlighted
Honored Contributor
Honored Contributor

Re: 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. 

Give kudos if you find my posts helpful or mark solution if it answers your query.
Tariq
Reply
Loading...
Frequent Advisor
Frequent Advisor

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

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

Thanks 

Reply
Loading...
Honored Contributor
Honored Contributor

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

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

Give kudos if you find my posts helpful or mark solution if it answers your query.
Tariq
Reply
Loading...