Forum Discussion

wpigoury's avatar
wpigoury
Mentor
10 years ago

API v2 _ Problem with ORDER BY

Hi,   I wanted to play a little with LiQL requests and tried to execute this request I found in the API v2 documentation: SELECT id, topics.count(*), messages.count(*), views FROM boards ORDER BY ...
  • AlexW's avatar
    AlexW
    10 years ago

    The top of the document mentioned that the features are added in 15.1. Make sure your community have upgraded to 15.1.

     

    But for the use case mentioned, you should be able to do something like this in previous versions:

     

    SELECT * FROM messages where category.id = '<category>' and depth=0 ORDER BY post_time DESC

     

    Hope this helps.

VarunGrazitti's avatar
VarunGrazitti
Boss
10 years ago
Exactly, as OlivierS mentioned, using * doesn't return the board views. The documentation needs to be corrected for V2.