I have this:
query =
from b in Brand,
where: b.id == ^brand_id,
preload: [
:pages,
default_menu: [
menu_items:
^from(
mi in MenuItem,
order_by: [asc: mi.sort_order],
preload: [:page]
)
]
]
Repo.one!(query)
However, in the debug log I see this getting executed:
SELECT ...
FROM "menu_items" AS m0
WHERE (m0."menu_id" = $1)
ORDER BY m0."menu_id", m0."sort_order"
How do I prevent menu_items
from being sorted by primary key and only sort by sort_order
?