Forum Discussion

Maven

8 years ago

Solved

API for unanswered topics

Hello, Is there an API call that can provide all unanswered topics in a community? Thanks, Thomas

TariqHussain
8 years ago
tkearsley - Below is the call to fetch all the post which doesn't have any reply yet.

SELECT * FROM messages WHERE replies.count(*)=0 AND depth=0
Documentation https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&collection=messages#constraints-replies.count(*)

To fetch all the post which doesn't have any solution.

SELECT * FROM messages WHERE is_solution = true and depth = 0
Documentation: https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&collection=messages#constraints-is_solution

Expert

8 years ago

Yes, there is to use V1 you can use.

/restapi/vc/unanswered

To use V2 API call you can use

select *from messages where replies.count(*)=0 and depth=0

Check out the document for more info

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

Thanks,
Srujana Satya