I have a grid where I need to create custom filtering, but I am not sure exactly how or where to modify the MasterTableView.FilterExpression.
The grid has multiple columns - each of which can be filtered. The final column is a status column controlled by a DropDownList that is dependent on several of my object properties. I need to add one of the following to the filter expression: (Property1 == null), (Property2 == null) or (Property1 != null && Property2 != null). I can add the proper filtering text to the FilterExpression in response to the DropDownList's OnSelectedIndexChanged and the filtering works fine.However, when I change the filtering for one of the other columns, my custom filter expression is lost.
First, is there a way of setting just the additional filter expression to let the grid include it in the FilterExpression?
If not, what event should I be using to make sure the custom part of the filter expression is included when another column's filtering changes?
The grid has multiple columns - each of which can be filtered. The final column is a status column controlled by a DropDownList that is dependent on several of my object properties. I need to add one of the following to the filter expression: (Property1 == null), (Property2 == null) or (Property1 != null && Property2 != null). I can add the proper filtering text to the FilterExpression in response to the DropDownList's OnSelectedIndexChanged and the filtering works fine.However, when I change the filtering for one of the other columns, my custom filter expression is lost.
First, is there a way of setting just the additional filter expression to let the grid include it in the FilterExpression?
If not, what event should I be using to make sure the custom part of the filter expression is included when another column's filtering changes?