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
