I have a folder that have some sub-folders named as 8134, 9094 along with only text. The query builder predicate `orderby=@jcr:content/jcr:title` sorts the folder names if there are no numbers in the folder names. But if they do, the sort oder is not correct. What am i missing or doing wrong?
Not sorted if the folder names have numbers in them:
Sorted, if the folder names do not have numbers in them:
That is also correct and since your use-case doesn't actually depend on the particular property and you simply wanted to see the correct order of the folder, you could even use orderby=path to get same results.
Please mark this thread as solved once you evaluate all the possibilities.
The way folders are setup by customer is that they are using a "friendly name" (jcr:title) for display, while node name is kind of ID so they can identify it (according to their internal legacy database). As below
So i had to change my query sort based on "node name" (orderby=nodename) instead of "jcr:title".