PerBonomi
9 years agoBoss
ORDER BY doesn't sort
Hi everyone. I've been using Liql for quite some time now and it never presented an issue when sorting.
Now, however, when I try the below queries they both sort the same way, descending, regardless of whether I choose ORDER BY ASC or DESC.
Has anyone come across this phenomenon and found a fix? Perhaps I missed a memo somewhere?
Ascending:<br/> <#assign query = restadmin("2.0","/search?q=" + "SELECT login FROM users WHERE followers.id = '${user.id}' ORDER BY login ASC LIMIT 10"?url) /> <#list query.data.items as q> ${q.login}<br/> </#list> <br/>Descending:<br/> <#assign query = restadmin("2.0","/search?q=" + "SELECT login FROM users WHERE followers.id = '${user.id}' ORDER BY login DESC LIMIT 10"?url) /> <#list query.data.items as q> ${q.login}<br/> </#list>