Be able to sort datagrid Column as case-insensitive

[Matias Paco Viscarra]

I'm facing an issue with the sorting action inside a column in the Grid. The current behavior of the sorting shows the records without taking into account the lowercase characters instead of showing the records in a case-insensitive order, it displays them this way (Images attached). 

Do you have any idea how I can fix this? My expected result is to have the records ordered without considering whether the characters are uppercase or lowercase.

<SFDataGrid @[email protected]

               TItem="TestModel"

               [email protected]

               AllowPaging=true>

    <DataGridColumns>

        <DataGridColumn IconClass="fas fa-user-alt"

                             Action=@((userAccess) => BindingContext.OpenDetail(userAccess ?? new()))

                             Field=@nameof(TestModel.DisplayName) />

        <DataGridColumn Field=@nameof(AccessProfileModel.Description) />

    </DataGridColumns>

</SFDataGrid>

Kind Regards.

[Prathap Senthil]

Hi Matias Paco Viscarra,

Based on the reported issue, it appears that you have used DataGrid columns, but you have defined different class names for some columns compared to the first column. If you use different classes, it may lead to misleading issues. Please ensure that the same class name is used across all grid columns. If you need to render complex columns, kindly refer to the document for more information.

<DataGridColumn IconClass="fas fa-user-alt"

                             Action=@((userAccess) => BindingContext.OpenDetail(userAccess ?? new()))

                             Field=@nameof(TestModel.DisplayName) />

        <DataGridColumn Field=@nameof(AccessProfileModel.Description) />

 

Reference: https://blazor.syncfusion.com/documentation/datagrid/column-rendering#complex-data-generation

If the issue persists, we will need additional clarification to proceed with resolving the problem. Please provide the details below so that we can assist you further.

• Could you please share with us the version of the NuGet package you have used?
• To analyze the reported issue, could you please share a simple and reproducible sample that demonstrates the problem? Or Kindly share your attempts to replicate the issue using the attached simple sample.

Above-requested details will be very helpful in validating the reported query at our end and providing a solution as early as possible. Thanks for your understanding.

Regards,
Prathap Senthil

Attachment: BlazorApp_selection_f0d7685c.zip