We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Algebra supported in Expressions/Filtering

Thread ID:

Created:

Updated:

Platform:

Replies:

36997 Nov 14,2005 01:33 PM Dec 14,2005 09:34 AM Windows Forms 12
loading
Tags: GridControl
StephenH
Asked On November 14, 2005 01:33 PM

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

Administrator [Syncfusion]
Replied On November 14, 2005 01:44 PM

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
Replied On November 14, 2005 02:18 PM

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 [Syncfusion]
Replied On November 14, 2005 02:31 PM

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

StephenH
Replied On November 14, 2005 05:56 PM

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 [Syncfusion]
Replied On November 14, 2005 06:12 PM

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
Replied On November 14, 2005 06:21 PM

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
Replied On December 14, 2005 08:06 AM

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 [Syncfusion]
Replied On December 14, 2005 08:21 AM

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

Administrator [Syncfusion]
Replied On December 14, 2005 08:27 AM

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
Replied On December 14, 2005 08:32 AM

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 [Syncfusion]
Replied On December 14, 2005 08:46 AM

Try something like: ( [Col1] LIKE ''*TEST*'' ) = 0

vijay.sagar
Replied On December 14, 2005 09:34 AM

Thanks, It works Vijay >Try something like: > >( [Col1] LIKE ''*TEST*'' ) = 0 > >

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;