Filter Dataset Based on Column Value

[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…