# Allow Table Queries to Filter Over Linked Record Fields

**URL:** <https://community.tulip.co/t/allow-table-queries-to-filter-over-linked-record-fields/6253>\
**Category:** Product Suggestions\
**Created:** [September 1, 2022, 2:58pm UTC](https://community.tulip.co/t/allow-table-queries-to-filter-over-linked-record-fields/6253 "2022-09-01T14:58:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![John](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/john/32/4971_2.png) [@John](https://community.tulip.co/u/John)\
**Post date:** [September 1, 2022, 2:58pm UTC](https://community.tulip.co/t/allow-table-queries-to-filter-over-linked-record-fields/6253/1 "2022-09-01T14:58:19Z")

</div>

I’m creating a demo application that heavily uses linked records (screenshot below). In this example, I want to be able to create a table query that filters the procedures based on the recipe they’re used in, and then use an aggregation to sum the procedure times into a full cycle time. In theory, this table will be used to contain every procedure used in this baking operation. I would like to be able to filter by recipe (using a “contains” → app input operation) on the app end.

 ![Screen Shot 2022-09-01 at 10.56.24 AM](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/7/7cdc5afea7dd05b638e075f4768509157e778ed5.png)

Right now, I can only apply table records to non-linked fields (see second screenshot).

 ![Screen Shot 2022-09-01 at 10.53.18 AM](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/2/21402ab7fa69d09bd7eaf149434c4ef220e77df1.png)

---

<div class="post-metadata">

**Author:** ![jboyle](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/jboyle/32/7279_2.png) [@jboyle](https://community.tulip.co/u/jboyle)\
**Post date:** [September 1, 2022, 7:46pm UTC](https://community.tulip.co/t/allow-table-queries-to-filter-over-linked-record-fields/6253/2 "2022-09-01T19:46:41Z")

</div>

I just recently came across a similar situation. I was dealing with fewer linked columns and ended up duplicating the information in the link in an adjacent column to allow for the aggregation.

---

<div class="post-metadata">

**Author:** ![John](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/john/32/4971_2.png) [@John](https://community.tulip.co/u/John)\
**Post date:** [September 1, 2022, 8:11pm UTC](https://community.tulip.co/t/allow-table-queries-to-filter-over-linked-record-fields/6253/3 "2022-09-01T20:11:48Z")

</div>

@jboyle, that’s what I ended up doing, too.