# Selecting related objects is totally confusing

**URL:** https://forum.codewithmosh.com/t/selecting-related-objects-is-totally-confusing/9450
**Category:** Django
**Created:** [December 27, 2021, 12:37am UTC](https://forum.codewithmosh.com/t/selecting-related-objects-is-totally-confusing/9450 "2021-12-27T00:37:10Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Yazan](https://avatars.discourse-cdn.com/v4/letter/y/c89c15/32.png) [@Yazan](https://forum.codewithmosh.com/u/Yazan)
#### Post date: [December 27, 2021, 12:37am UTC](https://forum.codewithmosh.com/t/selecting-related-objects-is-totally-confusing/9450/1 "2021-12-27T00:37:10Z")

</div>

can any1 simplify or summarize the topic with example please?

---

<div class="post-metadata">

### Author: ![convurtapp](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.codewithmosh.com/convurtapp/32/2875_2.png) [@convurtapp](https://forum.codewithmosh.com/u/convurtapp)
#### Post date: [February 10, 2022, 12:26am UTC](https://forum.codewithmosh.com/t/selecting-related-objects-is-totally-confusing/9450/2 "2022-02-10T00:26:14Z")

</div>

Same here. Where I am confused, we are showing how to prefetch\_related(‘promotions’) , but are never shown how to actually display the results. I can see it in the SQL panel, but how do I actually show the results on the page? That is a key piece of missing information. I’ve been trying to figure it out all day.

---

<div class="post-metadata">

### Author: ![Amitabh](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.codewithmosh.com/amitabh/32/3315_2.png) [@Amitabh](https://forum.codewithmosh.com/u/Amitabh)
#### Post date: [February 17, 2022, 3:36am UTC](https://forum.codewithmosh.com/t/selecting-related-objects-is-totally-confusing/9450/3 "2022-02-17T03:36:58Z")

</div>

Hey, just see if this helps you. After prefetching the data, use the Iterator\*\*. **\<class\_name\>**.\*\*\<the\_value\> that you want to print.

{{ prod.title }} – Colection {{ prod.collection.title }} – Promotion {{ prod.promotion.discount }}
