Forum Discussion

luk's avatar
luk
Boss
6 years ago

API v2 Problem with ORDER BY multiple fields

SuzieH The docs @https://lithosphere.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&v2.main=usingliql#orderBy say In the ORDER BY block, you can order your query results....
  • allensmith81's avatar
    allensmith81
    6 years ago

    Hi,

     

    is it not that you have not set a sort order on depth and so the call is assuming your passing a sort order of DEFAULT which is invalid.

    should it not be:

    SELECT id, short_title, view_href, depth, position FROM categories WHERE depth <= 2 AND id IN('<catid_1>', '<catid_2>', '<catid_n>') ORDER BY depth DESC, position ASC

    ?

     

allensmith81's avatar
allensmith81
Boss

Hi,

 

is it not that you have not set a sort order on depth and so the call is assuming your passing a sort order of DEFAULT which is invalid.

should it not be:

SELECT id, short_title, view_href, depth, position FROM categories WHERE depth <= 2 AND id IN('<catid_1>', '<catid_2>', '<catid_n>') ORDER BY depth DESC, position ASC

?

 

luk's avatar
luk
Boss
6 years ago

Awesome, that's the only combination I didn't think of =)...thanks a lot!

  • SuzieH's avatar
    SuzieH
    Khoros Alumni (Retired)
    6 years ago

    Thanks, allensmith81 and luk.

    I'll add a better example in the docs to clarify. Sorry for the confusion.