Forum Discussion

Maven

8 years ago

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

3 Replies

TariqHussain
Boss
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
tkearsley
Maven
8 years ago
Thanks!
satya
Expert
8 years ago
Hi tkearsley,

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