Forum Discussion

phani's avatar
phani
Advisor
8 years ago

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

 

 

  • ChhamaJ's avatar
    ChhamaJ
    8 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

  • ChhamaJ's avatar
    ChhamaJ
    Khoros Staff
    8 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