# Filter Dataset Based on Column Value

**URL:** <https://forum.inductiveautomation.com/t/filter-dataset-based-on-column-value/65356>\
**Category:** Ignition\
**Tags:** scripting\
**Created:** [October 18, 2022, 7:09pm UTC](https://forum.inductiveautomation.com/t/filter-dataset-based-on-column-value/65356 "2022-10-18T19:09:29Z")\
**Posts on this page:** 5\
**Page:** 2

<div class="post-metadata">

**Author:** ![Wesley\_Waters1](https://avatars.discourse-cdn.com/v4/letter/w/4bbf92/32.png) [@Wesley\_Waters1](https://forum.inductiveautomation.com/u/Wesley_Waters1)\
**Post date:** [January 23, 2026, 7:25pm UTC](https://forum.inductiveautomation.com/t/filter-dataset-based-on-column-value/65356/21 "2026-01-23T19:25:34Z")

</div>

I am not seeing the Simulation Aids Module. Is that no longer available? Is there another way that people have been solving this?

Thank You,

---

<div class="post-metadata">

**Author:** ![ryan.white](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.white/32/73193_2.png) [@ryan.white](https://forum.inductiveautomation.com/u/ryan.white)\
**Post date:** [January 23, 2026, 7:27pm UTC](https://forum.inductiveautomation.com/t/filter-dataset-based-on-column-value/65356/22 "2026-01-23T19:27:29Z")

</div>

The module is now referred to as [Integrations Toolkit](https://forum.inductiveautomation.com/t/automation-professionals-integration-toolkit-module/74934). Same module, more appropriate name.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [January 23, 2026, 7:30pm UTC](https://forum.inductiveautomation.com/t/filter-dataset-based-on-column-value/65356/23 "2026-01-23T19:30:05Z")

</div>

As noted in the docs, I kept the original module ID "com.automation\_pros.simaids" so that upgrades are seamless.

---

<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:** [January 23, 2026, 8:54pm UTC](https://forum.inductiveautomation.com/t/filter-dataset-based-on-column-value/65356/24 "2026-01-23T20:54:50Z")

</div>

> [@Wesley\_Waters1](#):
>
> Is there another way that people have been solving this?

Although the `view()` expression still exists, Phil has since developed more expressions in this module that may make this process a bit more accessible.

See:

> [@Integration Toolkit Solutions Wiki](https://forum.inductiveautomation.com/t/integration-toolkit-solutions-wiki/105080/6):
>
> Filtering datasets and emulating the IN operator Many times you want to filter a dataset where a columns value is equal to one of any item in a list. In SQL this is possible by utilizing the 'IN' operator. However, outside of using a QueryString parameter, due to the way that Named Query parameters work you can not supply a List of values. If you create a custom property to hold the raw data set from the named query, then you can use a simple expression binding to filter the dataset further i…

---

<div class="post-metadata">

**Author:** ![Chris\_Bingham](https://avatars.discourse-cdn.com/v4/letter/c/e5b9ba/32.png) [@Chris\_Bingham](https://forum.inductiveautomation.com/u/Chris_Bingham)\
**Post date:** [January 24, 2026, 4:59am UTC](https://forum.inductiveautomation.com/t/filter-dataset-based-on-column-value/65356/25 "2026-01-24T04:59:34Z")

</div>

> [@Wesley\_Waters1](#):
>
> Is there another way that people have been solving this?

Have you checked out the post marked as a solution to this thread? If you can’t utilize a 3rd party module, I believe @paul-griffith’s post uses Ignition native scripting.

[Previous page](https://forum.inductiveautomation.com/t/filter-dataset-based-on-column-value/65356.md?page=1)