# Select fields from nested preload query

**URL:** <https://forum.elixirforum.com/t/select-fields-from-nested-preload-query/47494>\
**Category:** Questions\
**Tags:** ecto, phoenix\
**Created:** [April 29, 2022, 6:01am UTC](https://forum.elixirforum.com/t/select-fields-from-nested-preload-query/47494 "2022-04-29T06:01:54Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![seanyutah](https://forum.elixirforum.com/user_avatar/forum.elixirforum.com/seanyutah/32/23703_2.png) [@seanyutah](https://forum.elixirforum.com/u/seanyutah)\
**Post date:** [April 29, 2022, 9:37pm UTC](https://forum.elixirforum.com/t/select-fields-from-nested-preload-query/47494/5 "2022-04-29T21:37:58Z")

</div>

Yea it makes sense that using @derive isn’t a best practice. I’m seeing the limitations first-hand. I looked into Phoenix views and didn’t see anything that would allow me to get what I want without nested loops. Do you know of anything? Can you agree that it would be nice to specify/select the children for the top level and omit it from the nested comments, therefore avoiding the need to loop?

---

_[View the full topic](https://forum.elixirforum.com/t/select-fields-from-nested-preload-query/47494)._