Page 1 of 1

Wildcard on Filter Expression on Data from Other Data Source

Posted: Wed Jun 24, 2015 8:58 am
by bhodgson
Please tell me how I can use a wildcard expression when creating an expression as part of a filter on a data source (data source is a "data from other data source".

This particular filter is part of a sequence of filters with various AND/OR branches therefore I need to use an expression.

As an example, lets say I need to filter to any names containing the words John, and would expect the following name to be included by my filter: "Robert John Smith"

Thanks,
Ben

Re: Wildcard on Filter Expression on Data from Other Data So

Posted: Wed Jun 24, 2015 12:23 pm
by Alex K.
Hello, Ben

You can set the "Expression" type for the filter and use the necessary expression. In this case Contains() function:
DataSourceName.ColumnName.Contains("John")

Thank you.