https://connect.hyland.com/t5/nuxeo-forum/order-by-parent-path/m-p/327905#M14906 <P>Hello,</P> <P>Using NXQL, I can't order documents by parent path. If I use <STRONG>order by ecm:path</STRONG> I will get <EM>/folder/a_folder/doc.pdf</EM> before <EM>/folder/b-doc.pdf</EM>. And if I use order by <STRONG>ecm:parentId</STRONG> the order is random.</P> <P>We need something like <STRONG>ecm:parentPath</STRONG> in Nuxeo <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> <P>Regards.</P> Mon, 03 Apr 2023 09:47:00 GMT Ghazi_HAKIM 2023-04-03T09:47:00Z https://connect.hyland.com/t5/nuxeo-forum/order-by-parent-path/m-p/327905#M14906 <P>Hello,</P> <P>Using NXQL, I can't order documents by parent path. If I use <STRONG>order by ecm:path</STRONG> I will get <EM>/folder/a_folder/doc.pdf</EM> before <EM>/folder/b-doc.pdf</EM>. And if I use order by <STRONG>ecm:parentId</STRONG> the order is random.</P> <P>We need something like <STRONG>ecm:parentPath</STRONG> in Nuxeo <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> <P>Regards.</P> Mon, 03 Apr 2023 09:47:00 GMT https://connect.hyland.com/t5/nuxeo-forum/order-by-parent-path/m-p/327905#M14906 Ghazi_HAKIM 2023-04-03T09:47:00Z