Forum Discussion

phani's avatar
phani
Advisor
9 years ago
Solved

How to apply sorting on multiple columns using LIQL V2 query?

Hi,

 

I am trying to get recent messages from top Kudoed message list.

Following is the query that I am using.

SELECT * FROM messages ORDER BY kudos.sum(weight) desc, post_time DESC

 

I remember it was working before. Now it's not working. The query is always giving top kudos messages only.

Can somebody help me to find the right query?

 

Thanks,

Phani

 

 

Views
Sign in to react to this post
  • ChhamaJ's avatar
    ChhamaJ
    9 years ago

    Hi phani 

     

    This multiple sort feature is only supported in LIA release version 17.2 +. If your community is on a version less than 17.2, then this might not work. 

     

    Hope this helps.

     

    Regards,
    Chhama

4 Replies

  • ChhamaJ's avatar
    ChhamaJ
    Khoros Alumni (Retired)
    9 years ago

    Hi phani 

     

    This multiple sort feature is only supported in LIA release version 17.2 +. If your community is on a version less than 17.2, then this might not work. 

     

    Hope this helps.

     

    Regards,
    Chhama

    Sign in to react to this post
  • phani's avatar
    phani
    Advisor
    9 years ago

    Hi ChhamaJ,

     

    This is what I am missing. Thank you for your quick response on this. I really appreciate your help.

    It would be nice if we have this information in the release notes.

    Could you please share the document that has multiple sorting information.

     

    Thanks & Regards,

    Phani

    Sign in to react to this post