Traversals and ordering example of official documentation seems not to work

[christianholland]

Expected Behavior (Mandatory)

Based on the Traversals and ordering chapter we expect to be able to order based on a relationship property

Actual Behavior (Mandatory)

from neomodel import  StructuredNode, StructuredRel, DateTimeProperty, StringProperty, IntegerProperty, RelationshipFrom
from datetime import datetime

class SupplierRel(StructuredRel):
    since = DateTimeProperty(default=datetime.now)


class Supplier(StructuredNode):
    name = StringProperty()
    delivery_cost = IntegerProperty()


class Coffee(StructuredNode):
    name = StringProperty(unique_index=True)
    price = IntegerProperty()
    suppliers = RelationshipFrom(Supplier, 'SUPPLIES', model=SupplierRel)

r = Coffee.nodes.order_by(
    '-suppliers__delivery_cost',
    'suppliers|since',
)
r.all()

# no  sorting
query:  MATCH (coffee:Coffee) RETURN coffee
params: {}
took: 0.053s

Currently used versions

Versions

• OS: Linux
• Library: 5.5.0
• Neo4j: 5.25.0

[tonioo]

@christianholland Does it work if you add an explicit call to traverse() before?

[christianholland]

Dear @tonioo,

indeed using traverse was the key, thank you! I think the documentation should be updated accordingly

r = Coffee.nodes.traverse("suppliers").order_by(
    '-suppliers__delivery_cost',
    'suppliers|since',
)
r.all()

query:  MATCH (coffee:Coffee)<-[r1:`SUPPLIES`]-(supplier_suppliers1:Supplier) RETURN coffee, supplier_suppliers1, r1 ORDER BY supplier_suppliers1.delivery_cost DESC, r1.since
params: {}
took: 0.047s