Checkbox filter DataGrid behaviour change operator to "not Equal" when I have more items no selected than selected
Checkbox filter inside column DataGrid: The behaviour change the operator to "not Equal" when I have more items selected than no selected and only provide the items not selected (I think that it does by performance).
I only need to have the operatot "not equal" for the scennario where just one checkbox is remaining to be checked and also provide that value in that case for the other scennarios where I have more than one checkbox checked
I just want to use the equal operator and the checked values names for my payload.
This is my code where I'm returning the data and where I found the issue, debugging I can see that the - DataManagerRequest dm is the parameter that it's returning this values wrong inside.
-------------------------
PagingAndSorting(Syncfusion.Blazor.DataManagerRequest dm)
{
List<FieldFilter> filters = new();
if (dm.Where != null && dm.Where.Any(d => d != null && d.predicates.Any(p => p != null && (p?.value != null || p.predicates.Count > 0))))
{
filters = dm.Where.Where(p => p != null)
.SelectMany(x => x.predicates)
.Where( p => p != null && p.value != null || p.predicates.Count > 0)
.Select(f =>
{
var val = f.value;
FieldFilter? fieldFilterX = new FieldFilter();
if (f.value == null)
{
List<FilterByColumnInfo> filterBy2 = new List<FilterByColumnInfo>();
foreach (var item in f.predicates)
{
val = item.value;
if (val is LocalizedString localizedString)
{
val = localizedString.Neutral;
}
if (val is GenericLocalizedReference localizedReference)
{
val = localizedReference.DisplayName.Neutral;
}
if (val is DateTime dateTime)
{
val = new DateTime(dateTime.Year, dateTime.Month, dateTime.Day, 0, 0, 0).ToString("yyyy-MM-dd HH:mm:ss");
}
filterBy2.Add(
new FilterByColumnInfo
{
Value = ValueTrimmer(val),
Operator = (FilterOperator)Enum.Parse(typeof(FilterOperator), item.Operator, true)
});
fieldFilterX = new FieldFilter()
{
Field = item.Field, //f.Field,
FilterBy = filterBy2
};
}
return fieldFilterX;
}
return new FieldFilter()
{
Field = f.Field,
FilterBy = new List<FilterByColumnInfo>()
{
new()
{
Value = ValueTrimmer(val),
Operator = (FilterOperator)Enum.Parse(typeof(FilterOperator), f.Operator, true)
}
}
};
}).ToList();
}
--------------------------------------------------------------------
This is the code where the checkbox is enabled:
<DataGrid @[email protected]
TItem="TestModel"
AllowSelection=true
AllowPaging=true
ShowColumnChooser=true
AllowResizing=true
AllowFiltering=true
EnablePersistence=true
GridFilterType=FilterType.Menu
SearchAsync=@((x) => BindingContext.ResultsPagingAndSortingChanged(x))
ContextMenuCallback=@((x) => BindingContext.OnContextMenuClickCallback((ContextMenuClickEventArgs<TestModel>)x))>
<DataGridColumns>
<GridEvents [email protected]
ContextMenuItemClicked="BindingContext.OnContextMenuClickCallback"
TValue="TestModel"></GridEvents>
<DataGridColumn Field=@nameof(TestModel.status)
FilterSettings=@(new Syncfusion.Blazor.Grids.FilterSettings() { Type = Syncfusion.Blazor.Grids.FilterType.CheckBox })>
<Template>
@if (context is TestModel operation)
{
<div class="text-center" style="cursor: pointer" @onclick="@(() => BindingContext.OpenDetail(operation))">
</div>
}
</Template>
</DataGridColumn>
</DataGridColumns>
</DataGrid>
This is the payload that I'm expecting to have in the scennario just where only one item is remaining to check
This is the payload that I'm having currently (bad) when I have 2 items remaining to check.
In this case I need all the items checked in the Payload with the Operator: 2 (Equal) not the operator : 8 (notequal)
Regards.
