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.

GGC (Expression Filter and comparison to NULL)

Thread ID:

Created:

Updated:

Platform:

Replies:

71070 Jan 14,2008 10:44 AM Jan 23,2008 01:47 PM Windows Forms 1
loading
Tags: GridControl
Alexander Schlicht
Asked On January 14, 2008 10:44 AM

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
Alexander




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

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.
this.gridGroupingControl1.TableDescriptor.RecordFilters.Add(recFilter);


Please refer to the sample given below which illustrates the above:
http://websamples.syncfusion.com/samples/Grid.Windows/F71070main.htm

Please let me know if you have any questions.

Regards,
Vinoth



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.

;