# Nested items in Ecto, sorting

**URL:** <https://forum.elixirforum.com/t/nested-items-in-ecto-sorting/13785>\
**Category:** Questions\
**Tags:** ecto, phoenix, sort, repo\
**Created:** [April 21, 2018, 6:36am UTC](https://forum.elixirforum.com/t/nested-items-in-ecto-sorting/13785 "2018-04-21T06:36:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Darim](https://forum.elixirforum.com/letter_avatar_proxy/v4/letter/d/ac91a4/32.png) [@Darim](https://forum.elixirforum.com/u/Darim)\
**Post date:** [April 21, 2018, 6:36am UTC](https://forum.elixirforum.com/t/nested-items-in-ecto-sorting/13785/1 "2018-04-21T06:36:02Z")

</div>

I have Category and it has many articles. I want to load a Category from a db and sort Articles in it based on “inserted\_at” date of an Article.

```
    ctg = Repo.get(Category, 123)
    |> Repo.preload([article: :mmedia_entity])

    # how? ????
    # |> order_by(asc: :article.inserted_at)

```

How to do that?

---

<div class="post-metadata">

**Author:** ![idi527](https://forum.elixirforum.com/letter_avatar_proxy/v4/letter/i/85e7bf/32.png) [@idi527](https://forum.elixirforum.com/u/idi527)\
**Post date:** [April 21, 2018, 7:28am UTC](https://forum.elixirforum.com/t/nested-items-in-ecto-sorting/13785/2 "2018-04-21T07:28:15Z")

</div>

Maybe

```elixir
import Ecto.Query

ctg =
  Category 
  |> Repo.get(123)
  |> Repo.preload([articles: {from(a in Article, order_by: a.inserted_at), :mmedia_entity}]

```

See more examples at [Ecto.Repo — Ecto v3.14.0](https://hexdocs.pm/ecto/Ecto.Repo.html#c:preload/3).