Forum Discussion

realtordotcom's avatar
realtordotcom
Contributor
8 years ago

Sorting based on replies count, giving wrong result.

Am trying to sort posts based on replies count, but we are getting wrong result from the query.   Please find below query which am using for sorting.   select * from messages where depth = 0 ORDE...
realtordotcom's avatar
realtordotcom
Contributor
8 years ago

 

Since there are so many posts without reply am not able to find if it is properly working in ascending order or not.

 

But according to my requirement i need to show most replied post in DESC order, where LIQL query not giving response count in proper order.

 

Some where in the middle replies count mismatch order returning from below LIQLquery.

 

select * from messages where depth = 0 ORDER BY replies.count(*) DESC