Filter Expression

[priya]

i am using 2013.3.1114.35  telerik version .  AllowFilteringByColumn="True" Means It allow value to filter in Radgrid for a column .

In  my  radgrid contains Name ,Dept Column with many rows .If i want to filter the particular Name in grid So i enter as Text  eg: '      Hema' and select startwith  (because this only save in my table)  to filter particular name .
but when i using  rdGrdReport.MasterTableView.FilterExpression  means it allowslike this           (name Lilke 'Hema%')  to back End so i not able to filter the value.

Issues is when we using Filter expression  with  [allow space before value to '    Hema' search in filter text box means it consider like 'Hema%'   ].not taking space before the value.

[Konstantin Dikov]

Hello,

After some testing I may confirm the behavior that you are describing and it seems that the same trimming could be replicated with other filter functions as well.

Since currently I am not able to elaborate if this is made that way by design or if it is a bug (or limitation). I will have to contact our developers team and get back to you with additional information on this query.



Regards,
Konstantin Dikov
Telerik

 

 

[Konstantin Dikov]

Hello again,

After consulting with our developers team, with the current filtering implementation it would not be possible to have a workaround, which could allow the persisting of white spaces at the begging and at the end of the input, but I have created an item in our Ideas & Feedback Portal for exposing a property to RadGrid, which could enable such behavior. 

You could follow the progress of the item in the following link:

• ADD: RadGrid - Expose a property, which could enable the persisting of white spaces (at the beggining and at the end of the input) when filtering with Contains, StartsWith, EndsWith and DoesNotContains filter functions

Please excuse us for any inconvenience caused by this.


Regards,
Konstantin Dikov
Telerik

 

 

[G]

I have used AllowFilteringByColumn in the radgrid and the normal filtering is working ok. Now, one of the column of the grid is FirstName and the data type is string and normal filtering is working. When a firstname contains Leading Space and the filter criteria is 'Equal To' then no result shows  but when the criteria is 'contains' then it shows result. I want to show the show the 'Equal To' criteria result also.
So, how to handle leading space in the filter criteria is 'Equal To'.
Pl, help.
Thanks,
G.Sen

[Konstantin Dikov]

Hello,

Generally, non of the filter functions should return any results when you have leading spaces. The leading spaces should be part of the expression, so one should expect not to get any results. 

Nevertheless, with our current implementation for the Contains filter function, the searched string is trimmed and that is the reason for getting results with that function, but it is debatable if this is correct behavior or not.

As for your current scenario, the only things that I could suggest is that you trim your leading spaces from your database, inform the user that a leading spaces must be included when using EqualTo or to remove EqualTo from your filter options and leave only Contains.

Hope this helps.


Regards,
Konstantin Dikov
Telerik