# Filter JSON objects between tables

**URL:** <https://community.glideapps.com/t/filter-json-objects-between-tables/64455>\
**Category:** Ask for Help\
**Created:** [July 28, 2023, 12:01pm UTC](https://community.glideapps.com/t/filter-json-objects-between-tables/64455 "2023-07-28T12:01:11Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Isaac\_Nichols](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/isaac_nichols/32/74662_2.png) [@Isaac\_Nichols](https://community.glideapps.com/u/Isaac_Nichols)\
**Post date:** [July 28, 2023, 12:01pm UTC](https://community.glideapps.com/t/filter-json-objects-between-tables/64455/1 "2023-07-28T12:01:11Z")

</div>

![687FB1CF-76AA-476E-A009-20DE8DED9D06](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/0/10a257184e0db09fe86805ef966c8ce4af57b478.jpeg)  
 ![B672985C-C055-400D-94FE-D4F9940E57F7](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/d/3d547960f52e49908d592a685f9db8eea25a94fa.jpeg)  
 ![F0818DE3-FCBB-4FD3-A54C-4B7F04A0AC44](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/5/557ee1d0ba9e354957622080083195e5431da932.jpeg)  
 ![81D78359-0E9C-495F-892C-EE058D9C66E7](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/9/795f329cf746236d45ac11ff7a78e0c860292db0.jpeg)

I’m working on a project using tables ‘products’ that go into ‘orders’. I’m creating a work around to automate a PDF of the details of the order using DocsAutomater and thus have created JSON objects of the products but when i make a joined list of the products in the corresponding order in the ‘orders’ table, it makes a joined list of all of the products rather than the ones just in that order. Any suggestions?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [July 28, 2023, 12:03pm UTC](https://community.glideapps.com/t/filter-json-objects-between-tables/64455/2 "2023-07-28T12:03:48Z")

</div>

Is your joined list using the relation or the table?

---

<div class="post-metadata">

**Author:** ![Isaac\_Nichols](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/isaac_nichols/32/74662_2.png) [@Isaac\_Nichols](https://community.glideapps.com/u/Isaac_Nichols)\
**Post date:** [July 28, 2023, 12:58pm UTC](https://community.glideapps.com/t/filter-json-objects-between-tables/64455/3 "2023-07-28T12:58:20Z")

</div>

Not sure I understand what you mean, could you expand?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 28, 2023, 1:57pm UTC](https://community.glideapps.com/t/filter-json-objects-between-tables/64455/4 "2023-07-28T13:57:31Z")

</div>

Show us a screen shot of the configuration of your Joined List column.

---

<div class="post-metadata">

**Author:** ![Isaac\_Nichols](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/isaac_nichols/32/74662_2.png) [@Isaac\_Nichols](https://community.glideapps.com/u/Isaac_Nichols)\
**Post date:** [July 29, 2023, 6:35am UTC](https://community.glideapps.com/t/filter-json-objects-between-tables/64455/5 "2023-07-29T06:35:05Z")

</div>

![BDA922B0-36D6-4CCA-A1D5-26C6F78C4717.jpeg](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/c/4c2f638a5627b206da75fcbff080b057a6c04579.jpeg)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 29, 2023, 7:35am UTC](https://community.glideapps.com/t/filter-json-objects-between-tables/64455/6 "2023-07-29T07:35:53Z")

</div>

Yes, that’s your problem. You’re joining every row in the Products table.  
You should have a multiple relation between your Orders table and your Products table (Products per Order), and then create the Joined List via that relation.