Forum Discussion

Jk07's avatar
Jk07
Adept
2 years ago

Post Details

How to get Particular post details. like no. of posts ,kudos,views,author and replies.   this data should be based on a particular post id.
kkritika's avatar
kkritika
Mentor
2 years ago

Jk07 The details can be fetched via below API

Select kudos.sum(weight),metrics.views,author,replies.count(*) from messages where id='POST_ID'

 

To get the replies to the post, use - 

SELECT * FROM messages WHERE parent.id = 'POST_ID'