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...
Forum Discussion
Thanks for confirming DougS. I tried adding additional constraints to my query to try and trick it into sorting properly. Unfortunately, if you use followers.id you cannot add additional ones.
Guess I'll have to wait with publishing these components until the issue is fixed.
Looks like this is still happening btw. Both of these give me results in descending order:
<#assign query_follow = restadmin("2.0","/search?q=" + "SELECT login FROM users WHERE followers.id = '${user.id}' ORDER BY login ASC LIMIT 10"?url) />
<#list query_follow.data.items as q>
${q.login}<br/>
</#list>
<br/>
<#assign query_follow = restadmin("2.0","/search?q=" + "SELECT login FROM users WHERE followers.id = '${user.id}' ORDER BY login DESC LIMIT 10"?url) />
<#list query_follow.data.items as q>
${q.login}<br/>
</#list>
