# Filter Dataset Based on Column Value **URL:** \ **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:** 1\ **Showing post:** 24
**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")
> [@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… --- _[View the full topic](https://forum.inductiveautomation.com/t/filter-dataset-based-on-column-value/65356)._