I have an odd problem with the grid filters.
If I select a single value to filter, then the filter works fine, if I select 2 out of say 6 values to filter, the grid shows no results, but if I select 4 out of 6 (mor than half the available values), the results magically appear again.
Sample code:
@page "/"
@using Syncfusion.EJ2.Blazor.Grids
<h1>Grid</h1>
<EjsGrid TValue="GridListItem" AllowFiltering="true" AllowPaging="true" DataSource="@GridList">
<GridPageSettings PageSize="5"></GridPageSettings>
<GridFilterSettings Type="FilterType.Excel"></GridFilterSettings>
<GridColumns>
<GridColumn Field=@nameof(GridListItem.value1) HeaderText="Value 1" AutoFit="true"></GridColumn>
<GridColumn Field=@nameof(GridListItem.value2) HeaderText="Value 2" AutoFit="true"></GridColumn>
<GridColumn Field=@nameof(GridListItem.value3) HeaderText="Value 3" AutoFit="true"></GridColumn>
<GridColumn Field=@nameof(GridListItem.value4) HeaderText="Value 4" AutoFit="true"></GridColumn>
<GridColumn Field=@nameof(GridListItem.value5) HeaderText="Value 5" AutoFit="true"></GridColumn>
<GridColumn Field=@nameof(GridListItem.value6) HeaderText="Value 6" AutoFit="true"></GridColumn>
<GridColumn Field=@nameof(GridListItem.value7) HeaderText="Value 7" AutoFit="true"></GridColumn>
<GridColumn></GridColumn>
</GridColumns>
</EjsGrid>
@code {
public List<GridListItem> GridList = new List<GridListItem>()
{
new GridListItem(){ value1 = "row 1", value2 = "row 1", value3 = "row 1", value4 = "row 1", value5 = "row 1", value6 = "row 1", value7 = "row 1"},
new GridListItem(){ value1 = "row 2", value2 = "row 2", value3 = "row 2", value4 = "row 2", value5 = "row 2", value6 = "row 2", value7 = "row 2"},
new GridListItem(){ value1 = "row 3", value2 = "row 3", value3 = "row 3", value4 = "row 3", value5 = "row 3", value6 = "row 3", value7 = "row 3"},
new GridListItem(){ value1 = "row 4", value2 = "row 4", value3 = "row 4", value4 = "row 4", value5 = "row 4", value6 = "row 4", value7 = "row 4"},
new GridListItem(){ value1 = "row 5", value2 = "row 5", value3 = "row 5", value4 = "row 5", value5 = "row 5", value6 = "row 5", value7 = "row 5"},
new GridListItem(){ value1 = "row 6", value2 = "row 6", value3 = "row 6", value4 = "row 6", value5 = "row 6", value6 = "row 6", value7 = "row 6"},
new GridListItem(){ value1 = "row 7", value2 = "row 7", value3 = "row 7", value4 = "row 7", value5 = "row 7", value6 = "row 7", value7 = "row 7"},
new GridListItem(){ value1 = "row 8", value2 = "row 8", value3 = "row 8", value4 = "row 8", value5 = "row 8", value6 = "row 8", value7 = "row 8"},
new GridListItem(){ value1 = "row 9", value2 = "row 9", value3 = "row 9", value4 = "row 9", value5 = "row 9", value6 = "row 9", value7 = "row 9"},
new GridListItem(){ value1 = "row 10", value2 = "row 10", value3 = "row 10", value4 = "row 10", value5 = "row 10", value6 = "row 10", value7 = "row 10"},
};
public class GridListItem
{
public string value1 { get; set; }
public string value2 { get; set; }
public string value3 { get; set; }
public string value4 { get; set; }
public string value5 { get; set; }
public string value6 { get; set; }
public string value7 { get; set; }
}
}
=======
So running this we get the following:
Next I will filter a single option on value 1:
Which results in this:
All correct. Now I will add another option to the value 1 filter:
And I get this:
I can add a third, fourth and fifth option and still get "No Results, when I add the sixth option:
Then the results are shown:
Either I am doing something stupidly wrong, or there is a bit of a bug in the grid filtering somewhere. Can you please check and let me know.
Many Thanks
