RadGrid Filter Case Sensitive?

21 posts, 1 answers
  1. Cyrus
    Cyrus avatar
    52 posts
    Member since:
    Apr 2008

    Posted 03 Dec 2008 Link to this post

    Hey how do I make the filter on a RadGrid so that it isn't case sensitive?  Why would you have this enabled by default?  Who would want a case sensitve filter anyway?
  2. Answer
    Shinu
    Shinu avatar
    17764 posts
    Member since:
    Mar 2007

    Posted 03 Dec 2008 Link to this post

    Hi Cyrus,

    I found the following forum links which discusses a similar scenario. Go through it and see if it helps.

    Filtering - case insensitive?
    Case Insensitive Grid Filtering

    Shinu.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Matthew
    Matthew avatar
    33 posts
    Member since:
    Aug 2008

    Posted 16 Jun 2009 Link to this post

    I'd like to propose Shinu's response as an answer for this thread.
  5. Morten
    Morten avatar
    267 posts
    Member since:
    Jul 2012

    Posted 07 Oct 2009 Link to this post

    This works for me:

    <telerik:RadGrid ID="rg" runat="server" AllowFilteringByColumn="True" AllowFiltering="True">
      <GroupingSettings CaseSensitive="false" />
  6. bryan paslay
    bryan paslay avatar
    1 posts
    Member since:
    Jan 2010

    Posted 12 Jan 2010 Link to this post

    The location of the GroupSettings tag determines whether or not setting the caseSensitive attribute to false works.  If you place the tag directly below the RadGrid tag it works.  If you place it below the MasterTable tag it fails.  
     

    Hope this helps.
  7. Mark
    Mark avatar
    15 posts
    Member since:
    Jan 2009

    Posted 15 Apr 2010 Link to this post

    Bryan & Morten, Thanks, worked for me too.
  8. whidbey boy
    whidbey boy avatar
    10 posts
    Member since:
    Jun 2010

    Posted 24 Jun 2010 Link to this post

    Hi,

    Using the

    <

     

    GroupingSettings CaseSensitive="false" />

    works when I select filter setting "Contains". But when I select EqualTo, no records are returned.

    Please advise.

     

  9. Veli
    Admin
    Veli avatar
    2002 posts

    Posted 24 Jun 2010 Link to this post

    Hi,

    @bryan: Property GroupingSettings (which is configured by the <GroupingSettings> tag in the RadGrid markup) belongs to the RadGrid, not the GridTableView (the MasterTableView). Therefore, it should always be:

    <telerik:RadGrid>
        <GroupingSettings />
    </telerik:RadGrid>


    @whidbey: Consider upgrading to the latest official version of Telerik RadControls for ASP.NET AJAX. If the problem persists, try to give us some more information on how to reproduce this issue.

    Sincerely yours,
    Veli
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  10. whidbey boy
    whidbey boy avatar
    10 posts
    Member since:
    Jun 2010

    Posted 24 Jun 2010 Link to this post

    Hi Veli,

    I installed RadControls_for_ASP.NET_AJAX_2010_1_519_trial.msi

    I have placed the <GroupSettings> tag below the <telerik:RadGrid>

    <

     

    telerik:RadGrid>

     

    <GroupingSettings CaseSensitive="false" />

    ......
    </telerik:RadGrid>

    Applying caseSensitive="False" is working when I select any filter, other than EqualTo. I did not do anything fancy except to bind the RadGrid to a datasource and apply filtering with <GroupSettings CaseSensitive="false" />

     

  11. Veli
    Admin
    Veli avatar
    2002 posts

    Posted 25 Jun 2010 Link to this post

    Hi whidbey boy,

    Testing the same RadGrid version with custom objects, DataTable and DataSource control databinding. In all scenarios, case insensitive filtering seems to work with any filter functions.

    What is your RadGrid's data source? Can you post some sample RadGrid markup with details on databinding, so that we can try to reproduce this issue.

    Kind regards,
    Veli
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  12. David Thompson
    David Thompson avatar
    29 posts
    Member since:
    Feb 2010

    Posted 10 Mar 2011 Link to this post

    This does not seem to work with OpenAccessDataSource.  Is that correct?
  13. Veli
    Admin
    Veli avatar
    2002 posts

    Posted 11 Mar 2011 Link to this post

    Hi David,

    The OpenAccessDataSource control does not automatically support case-insensitive filtering. If setting GroupingSettings.CaseSensitive = false does not work,  try using databinding with RadGrid's NeedDataSource event instead of DataSourceID. In the event handler, pass the OpenAccessDataSource control instance to the RadGrid.DataSource property. Try case insensitive filtering with this setup.
    Veli
    the Telerik team
    Registration for Q1 2011 What’s New Webinar Week is now open. Mark your calendar for the week starting March 21st and book your seat for a walk through all the exciting stuff we ship with the new release!
  14. David Thompson
    David Thompson avatar
    29 posts
    Member since:
    Feb 2010

    Posted 11 Mar 2011 Link to this post

    Veli,

    Is there a plan to put that into the OpenAccess implementation of the filter?

    David
  15. Veli
    Admin
    Veli avatar
    2002 posts

    Posted 14 Mar 2011 Link to this post

    This particular functionality is not planned for the moment.

    Veli
    the Telerik team
    Registration for Q1 2011 What’s New Webinar Week is now open. Mark your calendar for the week starting March 21st and book your seat for a walk through all the exciting stuff we ship with the new release!
  16. Stevoh
    Stevoh avatar
    1 posts
    Member since:
    May 2012

    Posted 19 Jun 2012 Link to this post

    Hi,
    If your data source is a DataTable, set its CaseSensitive property to false (myDataTable.CaseSensitive=false;)
    then also set GroupingSettings CaseSensitive to false for the radgrid (myRadGrid.GroupingSettings.CaseSensitive = false;)
    This combination worked for me, try it.

    Marcus
  17. misha
    misha avatar
    2 posts
    Member since:
    Feb 2014

    Posted 27 Feb 2014 Link to this post

    Morten and Bryan .. thanks for the specifics.. It worked for me too
  18. Sait
    Sait avatar
    1 posts
    Member since:
    Jul 2014

    Posted 08 Jul 2014 Link to this post

    Çok teşekkürler .... :)
  19. muhammed salim
    muhammed salim avatar
    1 posts
    Member since:
    Oct 2014

    Posted 09 Oct 2014 in reply to Morten Link to this post

    It worked for me.
  20. Javier
    Javier avatar
    16 posts
    Member since:
    Feb 2015

    Posted 22 May 2015 Link to this post

    Thanks guys,

     The groupingsettings works wonderful.

     

    Regards

  21. Ivo
    Ivo avatar
    2 posts
    Member since:
    Aug 2016

    Posted 01 Aug Link to this post

    Hello everybody,

    I had followed Morten´s suggestion 

    <telerik:RadGrid ID="rg" runat="server" AllowFilteringByColumn="True" AllowFiltering="True">
      <GroupingSettings CaseSensitive="false" />

    It partially works at my scenario. Let´s say I have 20 records, I am filtering with the EmployeeName column. 

    If I write "ce" the filter works fine and it retrieves just one record "Bruce Wayne" (see filter_ce.jpg) BUT

    If I write "ca" the filter doesn´t work and it retrieves all records at the DataSource (see filter_ca.jpg).

    Any ideas?? how can I correct this behavior??

  22. Viktor Tachev
    Admin
    Viktor Tachev avatar
    1488 posts

    Posted 03 Aug Link to this post

    Hello Ivo,

    Would you open a support ticket and send us a small runnable sample where the behavior you are observing is replicated? This will enable us to examine the behavior and look for its cause.

    Regards,
    Viktor Tachev
    Telerik by Progress
    Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017