# Filter Table Based on Data in different DB source

**URL:** <https://forum.inductiveautomation.com/t/filter-table-based-on-data-in-different-db-source/97229>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [October 14, 2024, 4:09pm UTC](https://forum.inductiveautomation.com/t/filter-table-based-on-data-in-different-db-source/97229 "2024-10-14T16:09:40Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [October 14, 2024, 4:57pm UTC](https://forum.inductiveautomation.com/t/filter-table-based-on-data-in-different-db-source/97229/3 "2024-10-14T16:57:34Z")

</div>

> [@nate\_macs](#):
>
> How can I filter or otherwise reference property 3 while using a table bound to a query referencing DB1?

You will have to do the join and filter manually in a script. Or if you are able to, use @pturmel's

> [@Automation Professionals' Integration Toolkit Module](https://forum.inductiveautomation.com/t/automation-professionals-integration-toolkit-module/74934):
>
> Automation Professionals is pleased to announce the immediately availability of a major upgrade to its free Simulation Aids Integration Toolkit module. The new feature justifying the "major upgrade" language is the implementation of eleven thirty-one new expression functions which use iteration to accomplish complex transforms of datasets and lists, to or from other datasets and lists, applying filtering, ordering, and computed new columns along the way. While there are certain operations that…

to do it in an expression.

---

_[View the full topic](https://forum.inductiveautomation.com/t/filter-table-based-on-data-in-different-db-source/97229)._