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.
For complex filters at run time you may consider using UltraGridFilterUIProvider.
You can also refer to this post discussing about the filtering over multiple column : https://www.infragistics.com/community/forums/f/ultimate-ui-for-windows-forms/46580/filter-multiple-columns-using-customrowfiltersdialog