filter using wildcards

[Ralph]

hi

I need filter expressions like "hi%there" with function "contains" in the grid. Having EnableLinqExpression = true makes a FilterExpression like "....contains(hi%there)", but finds no records.
Having EnableLinqExpression = false makes "LIKE '%hi%there%'" and returns all records, if there where no filter at all.

Any Ideas?

Ralph

[Yavor]

Hello Ralph,

Depending on whether the control is using Linq expressions or not, the filter expressions will be different. More information on this is available in the following article:

http://www.telerik.com/help/aspnet-ajax/grdoperatewithfilterexpression.html

Whenever you need to alter the filter expression, you can cancel out the filter command, and re-fire the command with the altered value(s):

http://www.telerik.com/help/aspnet-ajax/grdfirecommandeventfromcode.html

I hope that this information gets you started properly.

Best wishes,
Yavor
the Telerik team

[Ralph]

Hello Yavor,

just back from holiday...

I know the links in your answer. What I need is a little bit different: The examples for "contains" are in the form of "([CustomerID] LIKE '%ALFKI%')"
What I would need is "([CustomerID] LIKE '%A%I%')"  but that leads to the troubles I described in my posting.

thanks
Ralph

[Maria Ilieva]

Hello Ralph,

Using '%A%I% is not support SQL syntaxes in RadGrid. You could use just one condition and not the both in one wildcard. Please review the following help topic:

http://www.telerik.com/help/aspnet-ajax/grdoperatewithfilterexpression.html



Regards,
Maria Ilieva
the Telerik team