# Filter embedded table with linked record field **URL:** \ **Category:** Product Suggestions\ **Created:** [December 21, 2020, 10:11am UTC](https://community.tulip.co/t/filter-embedded-table-with-linked-record-field/1486 "2020-12-21T10:11:34Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![pte](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/pte/32/444_2.png) [@pte](https://community.tulip.co/u/pte)\ **Post date:** [December 21, 2020, 10:11am UTC](https://community.tulip.co/t/filter-embedded-table-with-linked-record-field/1486/1 "2020-12-21T10:11:35Z")
Hello Tulip team, I’m facing a lot of use cases where I would like to **add a filter on a embedded table based on a linked record field.** However at the moment I’m not allowed to select this type of field. _Ex of typical use case - Link type One to Many : First step user selects work order/testing and second step user wants to select in embedded table a sub-assignment/sub-test_ Patxi ---
**Author:** ![yotambentov](https://avatars.discourse-cdn.com/v4/letter/y/3ec8ea/32.png) [@yotambentov](https://community.tulip.co/u/yotambentov)\ **Post date:** [December 21, 2020, 5:32pm UTC](https://community.tulip.co/t/filter-embedded-table-with-linked-record-field/1486/2 "2020-12-21T17:32:51Z")
Hey Patxi, Yotam with Tulip Engineering here. I don’t think we currently have the feature set you’re looking for directly. However, what you could do is pull the “linking record”, parse out the ID (using the field itself or the expression editor) and then load the “linked record”. This might give you similar functionality. ---
**Author:** ![pte](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/pte/32/444_2.png) [@pte](https://community.tulip.co/u/pte)\ **Post date:** [February 16, 2021, 11:19am UTC](https://community.tulip.co/t/filter-embedded-table-with-linked-record-field/1486/3 "2021-02-16T11:19:54Z")
Hello Yotam, this topic is still an issue in my daily app building activities. I’m doing this horrible workaround every time I use linked records. : One field to use filters and one to link the table (see below). I even try to use the table API to create and display an object rather than embedded table but I cannot output the linked fields 😅 If you have more ideas you’re welcome 🙂 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/8/826048bfc50a70615c379f5e811c25f480a3c03a.png) ---
**Author:** ![Ethan](https://avatars.discourse-cdn.com/v4/letter/e/8dc957/32.png) [@Ethan](https://community.tulip.co/u/Ethan)\ **Post date:** [February 26, 2021, 9:32pm UTC](https://community.tulip.co/t/filter-embedded-table-with-linked-record-field/1486/4 "2021-02-26T21:32:17Z")
I’d just like to throw in my two cents here that this would be an enormously useful feature. Just about every table link I have is copied over to a another column. I have a moderately complex data structure with 7 tables, all with linked columns, and all having dynamic linking within the app. I’m trying to avoid using a connector at this stage as I need interactive table sorting for future reporting. ---
**Author:** ![kevin.kononenko](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/kevin.kononenko/32/32_2.png) [@kevin.kononenko](https://community.tulip.co/u/kevin.kononenko)\ **Post date:** [April 1, 2021, 8:38pm UTC](https://community.tulip.co/t/filter-embedded-table-with-linked-record-field/1486/5 "2021-04-01T20:38:03Z")
@CPS_Chris_Winters I know you are interested in this as well! Will update this thread when we add the functionality. Once we release it, it will work on both queries defined in apps AND the Table Queries feature. ---
**Author:** ![Ethan](https://avatars.discourse-cdn.com/v4/letter/e/8dc957/32.png) [@Ethan](https://community.tulip.co/u/Ethan)\ **Post date:** [November 8, 2021, 8:49pm UTC](https://community.tulip.co/t/filter-embedded-table-with-linked-record-field/1486/6 "2021-11-08T20:49:56Z")
Is this still being worked on or are there any new workarounds that effectively provide the functionality? ---
**Author:** ![freedman](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/freedman/32/107_2.png) [@freedman](https://community.tulip.co/u/freedman)\ **Post date:** [November 8, 2021, 10:51pm UTC](https://community.tulip.co/t/filter-embedded-table-with-linked-record-field/1486/7 "2021-11-08T22:51:21Z")
Hey there! You can definitely use linked records to filter embedded tables. The trick is to recognize that linked records are actually arrays (even if there is only one). Since it is an array you can use the “is in” filter. Does this work for you? ---
**Author:** ![Ethan](https://avatars.discourse-cdn.com/v4/letter/e/8dc957/32.png) [@Ethan](https://community.tulip.co/u/Ethan)\ **Post date:** [November 9, 2021, 8:09pm UTC](https://community.tulip.co/t/filter-embedded-table-with-linked-record-field/1486/8 "2021-11-09T20:09:00Z")
Hi Mark, I think I’m missing something. When I try to select an interactive table I don’t see any. You can see in the screenshot below I have a linked column “Associated Procedure” but only my text column clone "Associated Procedure [Non-Linked] is showing up. ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/8/849df821644fd740f80a0a5208ea9ae12992d519.png) ---
**Author:** ![freedman](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/freedman/32/107_2.png) [@freedman](https://community.tulip.co/u/freedman)\ **Post date:** [November 9, 2021, 9:13pm UTC](https://community.tulip.co/t/filter-embedded-table-with-linked-record-field/1486/9 "2021-11-09T21:13:15Z")
@Ethan check out this video [![](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/4/45358851570a68e67c070d9788a88e40b0f59aa5.jpeg "Quick tips - Linking records") ](https://www.youtube.com/watch?v=riWw8J43Ygo) I think what you are trying to do is over at 7:20 Hope this helps ---
**Author:** ![Ethan](https://avatars.discourse-cdn.com/v4/letter/e/8dc957/32.png) [@Ethan](https://community.tulip.co/u/Ethan)\ **Post date:** [November 11, 2021, 5:04pm UTC](https://community.tulip.co/t/filter-embedded-table-with-linked-record-field/1486/10 "2021-11-11T17:04:54Z")
Ah! Very interesting. I had to watch that a few times to wrap my head around what was happening for some reason, but I think that will work. I just tested it out with some of my tables and had success. I’ll update this thread if I run into issues. Thanks!