Dropdowndatagrid calulated field is case-sensitive in filter

[Heinz]

Hello,

I have add a calulated field using VS and C# code :

Property:

public partial class Baugruppe
{
public string ArtikelnrBezeichnung { get; set; }
}

Partial class:

public partial class BaugruppesController
{ 
	partial void OnBaugruppesRead(ref IQueryable<Models.Rootserver.Baugruppe> items)
	{
		foreach (Models.Rootserver.Baugruppe item in items)
		{
			//conate Artikelnr and Bezeichnung
			item.ArtikelnrBezeichnung = item.Artikelnr + "-" + item.Bezeichnung;
		}
	}
}

I can display this field (ArtikelnrBezeichnung) in a dropdowndatagrid when I set the Textproperty to this calulated field.

But now when I use the filter in the dropdowndatagrid the filter works case-sensitive, so upper and lower case is important for search results.

So my question is:
How to filter a calculated field in a dropdowndatagrid without case-sensitive?

[enchev]

You can try the solution from this thread:

Calculated fields on the server side

Can you try the following: Change the property definition to: public string FullName { get; set; } Create a new partial file for the controller of that entity e.g. EmployeeController with the following method: public partial class EmployeesController { partial void OnEmployeesRead(ref IQueryable<Employee> items) { items = items.Select(item => new Employee{ EmployeeID = item.EmployeeID, Fir…

[Heinz]

the solution in this link does not work for me, when I click on the datadropdowngrid it says "no records to display"
(but there are records)

And when I try to search for something nothing happens and I just see the "wait-mousepointer":

What I have done now as a workaround is that I set the calculated field to lower-case:

//conate Artikelnr and Bezeichnung
item.ArtikelnrBezeichnung = (item.Artikelnr + "-" + item.Bezeichnung).ToLower() ;

So at least now filtering is possible but it does not look nice for the user.