Hi Piotr, thank You. I knew it was not easy thing but I had to ask :). If I have some free time maybe I will see what I can do. Jorge
El vie., 13 de dic. de 2019 6:13 a. m., Piotr Tajduś <[email protected]> escribió: > Hi, > AFAIK there is no direct way to do it, it uses java String comparing. > You would have to split name into metadata like basename and number and > order using both of them, or use names with preceding zeros, like > analisis 00001. Also be aware, that ordering is case sensitive, so you > will have all upper letters before lower letters A-Za-z so you may need > to order by lower() or upper() functions. > > Best regards, > Piotr > > > On 11.12.2019 13:10, jorgeeflorez . wrote: > > Hi all, > > > > I am just wondering, because the customer will probably ask me. Is it > > possible or is there a way to have node name alphabetical ordering? when > I > > execute for example: > > > > SELECT * FROM [nt:file] AS s WHERE ISCHILDNODE(s, [/repo4/Carpeta > > 72224012]) ORDER BY NAME([s]) ASC > > > > So instead of getting > > > > 1. /repo4/Carpeta 72224012/analisis 1 > > 2. /repo4/Carpeta 72224012/analisis 10 > > 3. /repo4/Carpeta 72224012/analisis 2 > > > > I could get > > 1. /repo4/Carpeta 72224012/analisis 1 > > 2. /repo4/Carpeta 72224012/analisis 2 > > 3. /repo4/Carpeta 72224012/analisis 10 > > > > I am also setting offset and limit to the query, by the way. > > > > Thanks. > > > > Best regards. > > > > Jorge > > > >
