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)
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?
COCostaApril 4, 2019 05:01 AM
Nevertheless, I am waiting for an answer to the main question - the wrong work of the EJ2.DataGrid.clearFiltering.
HJHariharan J V Syncfusion Team April 4, 2019 06:49 AM
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.
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.
COCostaApril 4, 2019 08:06 AM
HJHariharan J V Syncfusion Team April 5, 2019 01:39 AM
We will update the fix on the promised date. Until then we appreciate your patience.
HJHariharan J V Syncfusion Team May 3, 2019 06:47 AM
Thanks for your patience.
COCostaJuly 3, 2019 05:33 AM
Thanks It works.
HJHariharan J V Syncfusion Team July 4, 2019 12:06 AM
Thanks for your update.
We are happy to hear that the reported issue has been resolved.