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 : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

custom filter control

Thread ID:

Created:

Updated:

Platform:

Replies:

76150 Aug 25,2008 08:11 PM UTC Sep 5,2008 06:01 AM UTC ASP.NET Web Forms (Classic) 3
loading
Tags: GridGroupingControl
Richard Slauenwhite
Asked On August 25, 2008 08:11 PM UTC

I tried the Essential Grid Filter Combo. I must not understand the syntax for 'Like' as I couldn't get it to work.

I tried entering a 'Match' for 'B' and got Berlin and Brandenburg.

I tried 'Like' for 'B' and/or 'b' and got nothing returned.

Am I missing something in the syntax.


Rajarajeswari S [Syncfusion]
Replied On August 29, 2008 04:32 AM UTC

Hi Richard,

Thanks for using Syncfusion products.

The “Like” operator is used for creating Expressions.

Description for the “Like” operator:

It checks for the field, that starts exactly as specified in the right-hand argument. For example, “ [Name] like 'Bruch' “ returns 1 for the particular records whose “Name” field value is exactly ‘Bruch’. We can use an asterisk as a wildcard character.

For example,

“ [Name] like 'Br*' - returns 1 for the records whose “Name” field starts with ‘Br’.
“ [Name] like '*br' - returns 1 for the records whose “Name” field ends with ‘br’.

Please refer the below code snippet with ‘Like’ operator:

GridExpressionFieldDescriptor efd = new GridExpressionFieldDescriptor();
efd.Expression = " [Name]like 'Br*'";
efd.Name = "Exp Field";
// Adding Expression fields to the collection
this.GridGroupingControl1.TableDescriptor.ExpressionFields.Add(efd);


Please refer the sample from the below link, which illustrates this:

http://www.syncfusion.com/support/user/uploads/Expression_cad64795.zip


Please let us know, if this helps you out.

Regards,
Raji



Richard Slauenwhite
Replied On August 29, 2008 07:28 PM UTC

I tried it against this sample. Am I missing something?


http://www2.syncfusion.com/infrastructure/web/grid.grouping.web/samples/2.0/Filtering/ComboBoxTextCell/CS/FilterBarDemo.aspx

>Hi Richard,

Thanks for using Syncfusion products.

The “Like” operator is used for creating Expressions.

Description for the “Like” operator:

It checks for the field, that starts exactly as specified in the right-hand argument. For example, “ [Name] like 'Bruch' “ returns 1 for the particular records whose “Name” field value is exactly ‘Bruch’. We can use an asterisk as a wildcard character.

For example,

“ [Name] like 'Br*' - returns 1 for the records whose “Name” field starts with ‘Br’.
“ [Name] like '*br' - returns 1 for the records whose “Name” field ends with ‘br’.

Please refer the below code snippet with ‘Like’ operator:

GridExpressionFieldDescriptor efd = new GridExpressionFieldDescriptor();
efd.Expression = " [Name]like 'Br*'";
efd.Name = "Exp Field";
// Adding Expression fields to the collection
this.GridGroupingControl1.TableDescriptor.ExpressionFields.Add(efd);


Please refer the sample from the below link, which illustrates this:

http://www.syncfusion.com/support/user/uploads/Expression_cad64795.zip


Please let us know, if this helps you out.

Regards,
Raji





Rajarajeswari S [Syncfusion]
Replied On September 5, 2008 06:01 AM UTC


Hi Richard,

Sorry for the delay in getting back to you.

Please refer the video clip from the below link, which illustrates the, use of ‘Like’ operator with FilterBarTextCell:

http://www.syncfusion.com/support/user/uploads/like_490fc696.zip

Please have a look at the above, and let me know if this helps you out.

Regards,
Raji



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.

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

;