Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
4165
What is the best way to do Complex Filtering when Datasource is Enumerated List
posted

Hello,

We are changing all of our datasources to be enumerated lists. 

We used to use a dataview on the datatable to create complex filtering.

Say I have a Contact

FirstName

LastName

ID

DateCreated

DateUpdated

I want to apply a filter programmatically where LasName Like '%something%' AND id > 10 OR Datcreated < '01/01/1999'.

We found a way to set the ColumnFilters at band level logic but I don't see how we could have multiple logic tied together.

What is the best practice to achieve this? I want avoid resetting the datasource so that it does not run the Initalize Layout and Row Events .

Thanks,

M.