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.

AlexW's avatar
AlexW
Lithium Alumni (Retired)

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.

wpigoury's avatar
wpigoury
Mentor
10 years ago
As for the messages query, it's not what I'm looking to achieve.
I don't want to retrieve messages but contest boards.
We have a page listing all our contests and right now I have to load all of them and then reverse the result which is not optimal.