Re: Order by database question

Hi Alex thanks, I suspected that the fact that I was scanning two separate indexes prevented proper ordering - from reading the select tutorial (very good piece that one) - but I wanted to confirm. Added Aux and just replaced the select with your db line and it works. On Mon, May 1, 2017 at

Re: Order by database question

Hi Henrik, > (class +UrlTag +Macropisobj) > (rel id(+Key +Number)) > (rel url (+Ref +Link) NIL (+Url)) > (rel usr (+Ref +Link) NIL (+User)) > (rel tag (+Aux +Ref +Link) (usr) NIL (+Tag)) > ... > SELECT * FROM UrlTag WHERE usr = Usr ORDER BY id DESC LIMIT 0,50 > > I

Re: Order by database question

That could be because of +Key. Am 01.05.2017 02:18 schrieb "Henrik Sarvell" : > Hi list, > > I've been looking through the docs and all my notes but it looks like I'm > not managing to get the result I want no matter how I try. > > I've got this E/R: > > (class +UrlTag

Order by database question

Hi list, I've been looking through the docs and all my notes but it looks like I'm not managing to get the result I want no matter how I try. I've got this E/R: (class +UrlTag +Macropisobj) (rel id(+Key +Number)) (rel url (+Ref +Link) NIL (+Url)) (rel usr (+Ref +Link) NIL