Forum Discussion
Payal
9 years agoDirector
Hi amuthan,
You can use V2 Query to fetch recent posts with replies count and accepted solution.
V2 Query:
Select replies.count(*),id,subject,post_time,conversation.solved from messages where depth = 0 ORDER BY post_time DESC
Hope this helps.
You can use V2 Query to fetch recent posts with replies count and accepted solution.
V2 Query:
Select replies.count(*),id,subject,post_time,conversation.solved from messages where depth = 0 ORDER BY post_time DESC
Hope this helps.