Re: Query ordered by node name

2020-05-19 Thread jorgeeflorez .
Hi Julian, thanks for your reply. > You could try the Oak Index Definition Generator. > > http://oakutils.appspot.com/generate/index > I regularly use that page to generate the index definitions I need. It was odd, when I tried the suggested index it was not chosen. It was cheaper to traverse. I

Re: Query ordered by node name

2020-05-19 Thread Julian Sedding
Or alternatively try [function = "fn:name()"], i.e. with the brackets "()". Regards Julian On Tue, May 19, 2020 at 10:57 AM Julian Sedding wrote: > > Hi Jorge > > You could try the Oak Index Definition Generator. > > http://oakutils.appspot.com/generate/index > > FWIW, in the "name" property

Re: Query ordered by node name

2020-05-19 Thread Julian Sedding
Hi Jorge You could try the Oak Index Definition Generator. http://oakutils.appspot.com/generate/index FWIW, in the "name" property node it sets [name = ":name"] instead of [function = "fn:name"]. I don't know if that makes a difference and which is better, if any. Regards Julian On Mon, May

Query ordered by node name

2020-05-18 Thread jorgeeflorez .
Hello, with the following query I am able to get file nodes ordered by name: SELECT * FROM [nt:file] AS s WHERE ISCHILDNODE(s, [/repo1/pruebaJF1]) ORDER BY NAME([s]) DESC unfortunately, because I do not have an index, on a big repository I have warnings like: WARN