Filter Dataset Based on Column Value

[Wesley_Waters1]

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,

[ryan.white]

The module is now referred to as Integrations Toolkit. Same module, more appropriate name.

[pturmel]

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

[lrose]

@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

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…

[Chris_Bingham]

@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.