Filter Expression

5 posts, 0 answers
  1. priya
    priya avatar
    3 posts
    Member since:
    Aug 2014

    Posted 12 Aug 2014 Link to this post

    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.
  2. Konstantin Dikov
    Admin
    Konstantin Dikov avatar
    1793 posts

    Posted 15 Aug 2014 Link to this post

    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
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Konstantin Dikov
    Admin
    Konstantin Dikov avatar
    1793 posts

    Posted 18 Aug 2014 Link to this post

    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:
    Please excuse us for any inconvenience caused by this.


    Regards,
    Konstantin Dikov
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  5. G
    G avatar
    7 posts
    Member since:
    Jul 2013

    Posted 04 Sep 2014 Link to this post

    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


  6. Konstantin Dikov
    Admin
    Konstantin Dikov avatar
    1793 posts

    Posted 08 Sep 2014 Link to this post

    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
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017