Sorting/order by in related records defined by has_many

[fireproofsocks]

Thank you! I actually figured out the syntax and posted it in this related post:

Preload with order

Thanks… it’s closer, but now it’s a runtime error (instead of a compile-time error): ** (UndefinedFunctionError) function nil.related/0 is undefined or private Sorry to be such a noob… once I get this figured out and stare at it for a while it’ll probably make sense, but for now I’m just bumbling through this unfamiliar stuff.

For preloading 2 levels deep, the structure looked like this:

Repo.get_by!(Menuitem, slug: slug, parent_id: 0)
    |> Repo.preload([{:children, from(m in Menuitem, order_by: m.order)}, children: [children: from(m in Menuitem, order_by: m.order)]])

The syntax you provided is incredibly useful as a point of comparison. Thanks again.