Case-insensitive search function support for Table

[lethach]

Case-insensitive search function support for Table. Thanks

[ArgoZhang]

@lethach hi. The Table component has no business logic. what's mean Case-insensitive

[mozahr]

Steps to reproduce

On table definition add ShowSearch = true
Define a column as searchable.
If this column contains text value "SIMBA" and you try to search for "simba" no result will be returned.
But when i export, the data for simba is there...

[ArgoZhang]

@mozahr If a repro-project is not provided, this problem will be solved forever. Because I need to see how your code runs. display data provided by the user

[densen2014]

I don’t understand where the problem in Case-insensitive

[mozahr]

Hello,
you can go to you exemple
https://www.blazor.zone/table/search
2nd table Auto-generate search function table

Thank you

[ArgoZhang]

@lethach @mozahr it fixed release version 8.3.2-beta03

[mozahr]

Ok thanks ! Will wait for full release then.

[mozahr]

Hello,
Tested the beta, and get this error
System.InvalidOperationException: The LINQ expression 'DbSet<Item>() .Where(i => i.CodeBarre != null && i.CodeBarre.Contains( value: "simba", comparisonType: OrdinalIgnoreCase) || i.Title != null && i.Title.Contains( value: "simba", comparisonType: OrdinalIgnoreCase) || i.NomFournisseur != null && i.NomFournisseur.Contains( value: "simba", comparisonType: OrdinalIgnoreCase))' could not be translated. Additional information: Translation of method 'string.Contains' failed. If this method can be mapped to your custom function, see https://go.microsoft.com/fwlink/?linkid=2132413 for more information.

Basically it cannot translate to SQL query.

Thanks

[ArgoZhang]

link issue #3401

[ArgoZhang]

@mozahr please take a look at this.

https://learn.microsoft.com/en-us/ef/core/miscellaneous/collations-and-case-sensitivity

case-sensitivity dependent on database

later I will roll back this fix and remove the StringComparison parameter. the normal string.Contains will be translated to InStr SQL function.

[mozahr]

Hello

Did not work actually ...
Dont think the issue is related to the collation or StringComparaison...

Here is more info
if you check the result here,

you can see that the pagination is showing, but the result shows 0

Also if i inspect the result from the code, we can see all the items are listed

Same result when we use capital letter.

Here is the code itemService

 public async Task<QueryData<Item>> OnQueryAsync(QueryPageOptions options, bool IsPaginated = true)
 {
     var _db = await _dbFactory.CreateDbContextAsync();
     var user = await _userService.GetCurrentUser();


     var query = _db.Set<Item>().Include(c => c.SousFamille).Include(c => c.Marque).Include("Images").AsNoTracking();

     if (user.Roles.Contains("ChefDeRayon"))
     {
         var sousFamilles = await _db.AspNetUserSousFamilles.Where(c => c.AspNetUserId == user.Id).Select(c => c.CodeSousFamille).ToListAsync();
         query = query.Where(c => sousFamilles.Contains((int)c.CodeSousFamille));
     }

     query = query
         .Where(options.Searchs.GetFilterLambda<Item>(FilterLogic.Or), options.Searchs.Any())
         .Where(options.Filters.GetFilterLambda<Item>(), options.Filters.Any())
         .Sort(options.SortName!, options.SortOrder, !string.IsNullOrEmpty(options.SortName))
         .Count(out var count);



     if (IsPaginated)
         query = query.Page((options.PageIndex - 1) * options.PageItems, options.PageItems);


     var ret = new QueryData<Item>()
     {
         TotalCount = count,
         Items = query,
         IsSorted = true,
         IsFiltered = true
     };
     return await Task.FromResult(ret);
 }

code from item razor page

 private async Task<QueryData<Item>> OnQueryAsync(QueryPageOptions options)
 {

     currentOptions = options;
     var result =  await _itemService.OnQueryAsync(options);
     return result;
 }

Also when we use the column filter,

it works perfectly.

So in conclusion, it seems that when the data is passed to your table, pagination is well handled but somehow the data are not display.

Thank you..

[ArgoZhang]

var ret = new QueryData<Item>()
 {
     TotalCount = count,
     Items = query,
     IsSorted = true,
     IsFiltered = true
 };

missing code

IsSearch = true

so why hasn't the code been provided? With the code, we know where the problem is.

[mozahr]

Unbeleivable..

Thanks so much.