GGC->RecordFilters and disjunction

[Administrator]

Hi!

I have a GGC and I want to set 2 RecordFilters. But the filters should work as a disjunction;

data: filter[col1] OR filter[col2]


Is there a way to manage this?


Regards
Falk

[Administrator]

Hi Falk,

You can try this code.

RecordFilterDescriptor rf1 = new RecordFilterDescriptor("Col3", FilterLogicalOperator.Or,new FilterCondition[] { new FilterCondition(FilterCompareOperator.Like , "Column3CellValue")});
RecordFilterDescriptor rf2 = new RecordFilterDescriptor("Col4", FilterLogicalOperator.Or,new FilterCondition[] { new FilterCondition(FilterCompareOperator.Like, "Column4CellValue")});

this.gridGroupingControl1.TableDescriptor.RecordFilters.Add(rf1);
this.gridGroupingControl1.TableDescriptor.RecordFilters.LogicalOperator = FilterLogicalOperator.Or;
this.gridGroupingControl1.TableDescriptor.RecordFilters.Add(rf2);

Best regards,
Haneef

[Administrator]

Ok, this woks.
But what, if I want this:

data: (filter[col1] OR filter[col2]) AND filter[col3] AND filter[col4]


Regards
Falk

[Administrator]

Hi Falk,

To add a filter condition, add a RecordFilterDescriptor to the Engine.TableDescriptor.RecordFilters collection. The constructor on the RecordFilterDescription takes an expression data like (filter[col1] OR filter[col2]) AND filter[col3] AND filter[col4]. Here is a code snippet to show this.

RecordFilterDescriptor rf1 = new RecordFilterDescriptor("[Col1] Like 'Column1' OR [Col2] Like 'Column2'");
RecordFilterDescriptor rf2 = new RecordFilterDescriptor("[Col3] = '5'");
RecordFilterDescriptor rf3 = new RecordFilterDescriptor("[Col4] > '7'");

this.gridGroupingControl1.TableDescriptor.RecordFilters.Add(rf1);
this.gridGroupingControl1.TableDescriptor.RecordFilters.Add(rf2);
this.gridGroupingControl1.TableDescriptor.RecordFilters.Add(rf3);

Best regards,
Haneef