I've got 6 boolean columns that are displayed as check boxes. (plus a bunch of other columns too)
What I'd like to be able to do is filter on col1=true or col2 is true or col5 is true.
Filtering on "AND" works just fine. But I need an OR filtering. Any chance to get this to work?
Otherwise, I'm stuck with a really complex sql statment to make it work.
Filtering is currently not designed to work like this out of the box. You should submit a feature request. You can still use our UI, but you'll have to do custom data binding. Basically, get the RowFilter that we supply in the event, transform it to an 'Or' where filter that you give to the data source and then give that source to us.
Thanks. I'll set it up to filter the datasource. That works, but not as smoothly as your controls do.