Preload inside subquery

[kokolegorille]

There was a similar question here…

Ecto query order for preload

Hey, I have this query: recording_query = from( r in Recording, order_by: [desc: r.id], where: r.user_id == ^user.id, preload: [:user, comment: [:user]], select: r ) Repo.all(recording_query) How can I order the preloaded data? the comments here?

more or less, You would do

sub = from(c in Capture, order_by: [desc: :id], limit: 1)
...
|> preload(pages: [captures: ^sub])