attempting to pull all message content in threads
- 6 years ago
To fetch all messages associated with a particular post, you can use the constraint where topic.id='[Unique ID for the message]'
Eg.you can try the following by replacing '3415' with the ID for the post, of which you require all messages
https:/[your domain]/api/2.0/search?q=SELECT * from messages where topic.id='3415' order by post_time desc
This will fetch you all the replies associated with the message/post.
Here is the link for documentation of the same.
https://developer.khoros.com/khoroscommunitydevdocs/docs/liql-examples
Hope this helps.
Please give kudos if you find this post useful and mark it as Solution if it answers your query.
Regards
Tarun Kumar
- 6 years ago
In addition to that, if you just want to get all the replies from the your last 10 topics in board with id 'devforum':
(only replies: depth > 0, only topics: depth = 0)
SELECT id FROM messages WHERE board.id = 'devforum' AND depth = 0 ORDER BY post_time DESC LIMIT 10
Now just list through the returned ids with what Tarun wrote.