Algebra supported in Expressions/Filtering

[StephenH]

I need to do a <> or != operation, what is the most effecient way to accomplish this in the grouping grid?

Thanks in advance

[Administrator]

In the Essential Grouping User Guide, there is a page on this topic, Algebra supported in Expressions/Filtering. Using an expressing like

"[col1] <> 18" would be the simplest way to check if column "col1" was not the integer 18 in a filter. The parsing is only done once per column.
            

[StephenH]

The manual did not have <> or != in it so I wondered.

>In the Essential Grouping User Guide, there is a page on this topic, Algebra supported in Expressions/Filtering. Using an expressing like
>

>"[col1] <> 18" would be the simplest way to check if column "col1" was not the integer 18 in a filter. The parsing is only done once per column.
            

[Administrator]

<> not being listed there is an oversight that we will correct.

[StephenH]

Is there a reason this would not work ?

GridConditionalFormatDescriptor fd = new GridConditionalFormatDescriptor("colstocompare");
fd.Expression = "[col1] <> [col2]";
fd.Appearance.AnyCell.BackColor = Color.Red;
fd.Appearance.AnyCell.TextColor = Color.Yellow;
grd.TableDescriptor.ConditionalFormats.Add(fd);

><> not being listed there is an oversight that we will correct.

[Administrator]

If these are string columns, then you would have to use the LIKE operator, and since there is no NOT operator currently, you would test the expression = 0 to test for not equal.

fd.Expression = "([col1] LIKE [col2]) = 0";

[StephenH]

THANKS, that did it :)

>If these are string columns, then you would have to use the LIKE operator, and since there is no NOT operator currently, you would test the expression = 0 to test for not equal.
>

>fd.Expression = "([col1] LIKE [col2]) = 0";
>

[vijay.sagar]

Could you please point me to the page on Algebra supported in Expressions/Filtering in your user guide. I am looking at http://www.syncfusion.com/library/

I can''t find it.

Thanks for your help

Vijay

>In the Essential Grouping User Guide, there is a page on this topic, Algebra supported in Expressions/Filtering. Using an expressing like
>

>"[col1] <> 18" would be the simplest way to check if column "col1" was not the integer 18 in a filter. The parsing is only done once per column.
            

[Administrator]

Look under the Essential Grouping User Guide. There is a page entitled "Algebra Supported in Expressions/Filters" there.

[Administrator]

After pulling up http://www.syncfusion.com/library/,
click these nodes to open them and you should see this page listed.

Essential Studio
Essential Grouping
Base

Under Base will be the topic.

[vijay.sagar]

Thanks Clay.

I did not find a answer to what I was looking for in the guide; Perhaps you can help:

I need to do a filter such as:

NOT LIKE ''*TEST*''

to find all rows which do not contain the "TEST" string.

I tried the above expression and it doesn''t work. Is there any other way?

Thanks

Vijay

>Look under the Essential Grouping User Guide. There is a page entitled "Algebra Supported in Expressions/Filters" there.

[Administrator]

Try something like:

( [Col1] LIKE ''*TEST*'' ) = 0

[vijay.sagar]

Thanks, It works

Vijay

>Try something like:
>

>( [Col1] LIKE ''*TEST*'' ) = 0
>

>