How to do order_by by multiple columns in Ecto?

Phoenix Forum Questions / Help
,
1

This won’t compile:


items = order_by(MyModel, [desc: :inserted_at, :published_at])
|> Repo.all()

This won’t either:


items = order_by(MyModel, [desc: [:inserted_at, :published_at]])
|> Repo.all()

How?

2 
 order_by(MyModel, [desc: :inserted_at, desc: :published_at])

https://hexdocs.pm/ecto/Ecto.Query.html#order_by/3-keywords-examples

7 Likes