Public
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Mentor

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

@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

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

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

Welcome to the Technology board!

Curious about our platform? Looking to connect on social technology? You've come to the right place!

Are you a Khoros customer? For direct assistance from our Support team, please visit the Support Forum.