Sort/Order by nested

How would I run a query similar to: sort({'embedded.field': -1})?

I have tried order_by(desc: "embedded.field") and order_by(fragment("embedded.field")) doesn't work.

I was trying to get a similar query to work, and after some trial and error I think I found something that works:

from(c in SomeEctoSchema,
  # ...
  order_by: [desc: c."embedded.field"],
  # ...
)
|> MyApp.Repo.all()

The logs print:

{"$orderby", ["embedded.field": -1]}

And I get apparently correct results.

Navigation Menu