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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

GGC (Expression Filter and comparison to NULL)

Thread ID:





71070 Jan 14,2008 03:44 PM UTC Jan 23,2008 06:47 PM UTC WinForms 1
Tags: GridControl
Alexander Schlicht
Asked On January 14, 2008 03:44 PM UTC

Hello Syncfusion team!

I have a question to Expression Filters in a GridGroupingControl.

I want to filter records if they are Empty (DBNull) not with Conditions like "Equals (null)" but with the Expression Filter.

I try expressions like "[BookingDate] equals (null)" or "[BookingDate] equals '(null)'" etc. with no effect, any ideas?

Best regards

Vinoth Kumar K [Syncfusion]
Replied On January 23, 2008 06:47 PM UTC

Hi Alexander,

Thanks for using Syncfusion products.

You can filter records if they are Empty/Null by using the code snippet given below.

RecordFilterDescriptor recFilter = new Syncfusion.Grouping.RecordFilterDescriptor();
recFilter.Name = "someName";
recFilter.Expression = "[col1] = ' '"; // this is two single quotes followed by the closing double quote to indicate an empty/Null string in the column whose mapping name is colName.

Please refer to the sample given below which illustrates the above:

Please let me know if you have any questions.



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.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon 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.Close Icon