RadGrid Filter Case Sensitive?

[Cyrus]

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?

[Shinu]

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.

[Matthew]

I'd like to propose Shinu's response as an answer for this thread.

[Morten]

This works for me:

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

[bryan paslay]

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.

[Mark]

Bryan & Morten, Thanks, worked for me too.

[whidbey boy]

Hi,

Using the

<

 

GroupingSettings CaseSensitive="false" />

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

Please advise.

 

[Veli]

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

[whidbey boy]

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" />

 

[Veli]

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

[David Thompson]

This does not seem to work with OpenAccessDataSource.  Is that correct?

[Veli]

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

[David Thompson]

Veli,

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

David

[Veli]

This particular functionality is not planned for the moment.

Veli
the Telerik team

[Stevoh]

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

[misha]

Morten and Bryan .. thanks for the specifics.. It worked for me too

[Sait]

Çok teşekkürler .... :)

[muhammed salim]

It worked for me.

[Javier]

Thanks guys,

 The groupingsettings works wonderful.

 

Regards

[Ivo]

Hello everybody,

I had followed Morten´s suggestion 
[quote]<telerik:RadGrid ID="rg" runat="server" AllowFilteringByColumn="True" AllowFiltering="True">
  <GroupingSettings CaseSensitive="false" />[/quote]

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??

[Viktor Tachev]

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