GGC Filter NotLike Operator

[Myles Kelman]

How can I create a filter condition on the GGC that is equivalent to [myColumnName] NOT LIKE '*myValue*'

[Jisha Joy]

Hi

[Jisha Joy]

Hi,

You could refer the following code for performing not Like filtering action. see the code

            this.gridGroupingControl1.DataSource = myDataTable;
            string filter = "[Item] <>  'item 1'";

           RecordFilterDescriptor rfd = new RecordFilterDescriptor(filter);

            gridGroupingControl1.TableDescriptor.RecordFilters.Add(rfd);

-Jisha

[Myles Kelman]

I figured it out for anyone who cares...

Use a FilterCondition with a regular expression.

FilterCondition f = new FilterCondition();
f.CompareOperator = FilterCompareOperator.Match;
f.CompareValue = "^((?!myValue).)*$";

filterDescriptor.Conditions.Add(f);

[Jisha Joy]

Hi Myles,

Thanks you for your update.

Regards,
Jisha