EJ2 DataGrid clearFiltering

[Costa]

Hi. ClearFiltering function does not work correctly. The number of records in the data set is 2000.

1) Select A in the Class column (by the way, note that if the Class value is null in the first row of the dataset, the text filter is not displayed and not available. This is another error).

2) Select Action in the Genre column. Data filtered out as expected.

3) After clicking the Clear Filters button, the number of records does not return to the original count (2000)

The number of records returns to the original after the page navigation, but this is not the behavior that was expected. Sample project in the attachment. (The number of filtered records may vary, because the list is formed dynamically)

Attachment: AspNetCore3_EJ2_829c61af.zip

[Costa]

I already understood about the first null value, it is necessary to manually specify the data type of the column. By the way, isn't it possible to “teach” a grid to determine the data type of columns not by the first record, but on the basis of a model?

[Costa]

Nevertheless, I am waiting for an answer to the main question - the wrong work of the EJ2.DataGrid.clearFiltering.

[Hariharan J V]

Hi Costa, 

Thanks for contacting us. 

Query #1: ClearFiltering function does not work correctly. 

We can able to reproduce the reported issue when we call clearFiltering method to clear the filtering from more than one column. We have logged a defect report for “clearFiltering method will send multiple posts in excel filter” this issue. The fix for this issue will be included in our upcoming April 17, 2019 patch release. 

 

You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link. 

 

https://www.syncfusion.com/feedback/5592 

Query #2: By the way, isn't it possible to “teach” a grid to determine the data type of columns not by the first record, but on the basis of a model? 

By default Grid will set the data type to the column based on the first cell value. When the first cell has null value, you must need to set the date type to that column by manually. This is default behavior of Grid. 

Regards, 

Hariharan 

[Costa]

Thanks.

[Hariharan J V]

Hi Costa, 

We will update the fix on the promised date. Until then we appreciate your patience.  

Regards, 

Hariharan 

[Hariharan J V]

Hi Costa, 

 

Thanks for your patience. 

We are sorry for the delay. We are glad to announce that our Essential JavaScript 2 patch release (17.1.43) has been rolled out successfully and in that release, we have added the fix for an issue “clearFiltering method will send multiple posts in excel filter”. 

  

Regards, 

Hariharan 

[Costa]

Thanks It works.

[Hariharan J V]

Hi Costa, 

  

Thanks for your update. 

  

We are happy to hear that the reported issue has been resolved. 

  

Regards, 

Hariharan