We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

IGNORE-NOW FIXED in 17.4.0.43 Filtering Issue - Filter Type Excel

Thread ID:

Created:

Updated:

Platform:

Replies:

150638 Jan 14,2020 10:52 AM UTC Jan 15,2020 01:13 AM UTC Blazor 2
loading
Tags: Grid
Matthew
Asked On January 14, 2020 11:01 AM UTC

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

Matthew
Replied On January 14, 2020 05:24 PM UTC

Hi Guys,

Please Ignore : This is now fixed in the latest release from today.

Vignesh Natarajan [Syncfusion]
Replied On January 15, 2020 01:13 AM UTC

Hi Matthew,  
 
Greetings from Syncfusion support.  
 
We are glad to hear that you query has been resolved.  
 
Kindly get back to us if you have further queries. 
 
Regards, 
Vignesh Natarajan.  


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon