Results are not sorted with query builder about phpcr-odm HOT 4 CLOSED

I understand, thank you for your help.

from phpcr-odm.

the sort order is only used when accessing nodes / documents in tree navigation. for queries, there is no defined sort order unless you use a order by. (but afaik there is no order by child-order).

the preferred mode of interacting with phpcr is by using the tree structures. doing a query like in your example is porting the SQL patterns to phpcr. in a relational database, this is how you have to do it. but with phpcr, you can have a document Category and then do something like:

$category = $dm->find('/cms/simple/products/fauteuil-de-bureau');
foreach ($category->getProducts() as $product) {...

getProducts can use the @Children mapping to map all children. if you have a mixed tree, getProducts can do instanceof checks to filter out non-product children.

from phpcr-odm.

I see, but is there a way to get the sort_order value in the results?
And why the results order doesn't reflect the mysql query? (Just for my understanding)

from phpcr-odm.

the order is only meaningful within the children of a specific node. query are usually on whole ranges and not children of a single parent. if i have a tree like this

               A
            /    \  
          B        C
        /   \     /  \
      D      E   F    G

and my query finds B and F, the "sort order" has no meaning. sort order is relevant for B, C and for D, E and for F, G but as soon as you leave the context of a single parent, the sort order does not mean anything.

from phpcr-odm.