1. Home
  2. Forum
  3. Blazor
  4. Filter does not work when EnableVirtualization=true

Filter does not work when EnableVirtualization=true

Hi,

I use SfPivotView to display aggregated data. The problem that I am facing is that when EnableVirtualization=true, filtering does not work. When it's set to false, the filtering does work.

In the sample project please use "Counterparty" filter.



Whereas the Syncfusion Sample works with   EnableVirtualization=true.

I can't see the difference between the two.

Can you please suggest?

Man Thanks,

Yi


7 Replies
YH Yi Han April 17, 2022 08:22 AM UTC

with the code.


Attachment: blazor_pivot_EnableVirtualization_true_cba29a8d.zip

AP AngelinFaithSheeba PaulvannanRajadurai Syncfusion Team April 18, 2022 01:12 PM UTC

Hi Yi Han,


We have considered this as a bug “Pivot table not updated properly while filtering with virtualization enabled”. And the fix will be available in our upcoming first weekly release after 2022, Volume 1 SP release, which is estimated to be rolled out at the end of May 2022. You can keep track of the bug from the below feedback link.


Feedback Link :  https://www.syncfusion.com/feedback/34235/pivot-table-not-updated-properly-while-filtering-with-virtualization-enabled


Regards,

Angelin Faith Sheeba


AP AngelinFaithSheeba PaulvannanRajadurai Syncfusion Team June 1, 2022 01:57 PM UTC

Hi Yi Han,


The reported issue has been resolved, and we are now testing with other feature combinations. However, this fix will be available in our upcoming weekly release, which is scheduled to be released at June 7, 2022.


Please let us know if you have any concerns.


Regards,

Angelin Faith Sheeba.



AP AngelinFaithSheeba PaulvannanRajadurai Syncfusion Team June 7, 2022 11:05 AM UTC

Hi Yi Han,


We are glad to announce that our Essential Studio weekly release V20.1.58 is rolled out and fix for the issue “Pivot table not updated properly while filtering with virtualization enabled” has been included in this release. Please refer to the following sample.


Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/PivotTable-1028196054


Release notes: https://blazor.syncfusion.com/documentation/release-notes/20.1.57?type=all#pivot-table


We thank you for your support and appreciate your patience in waiting for this release. Please contact us if you require any further assistance.


Regards,

Angelin Faith Sheeba


AB Andreas Beck June 7, 2022 11:13 AM UTC

Thank you for the sample link  Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/PivotTable-1028196054




LP Lorenzo Pierini May 25, 2023 06:35 AM UTC

Hi, to date, filters still do not work with virtualization enabled.


RG Rajeshkannah G Syncfusion Team May 26, 2023 02:03 PM UTC

Hi Lorenzo,


We believe your reported issue is that the filtering for date type fields doesn't work properly when virtual scrolling is enabled. If this is the case, we checked the reported issue with the most recent NuGet version 21.2.6, and filtering works properly for both date and other type fields in the pivot table's row and column when virtual scrolling is enabled. We have attached the sample that we tested in the attachment below for your reference.


Output screenshot:



If the problem persists, please reproduce it in the provided sample and revert to us (or) send your sample with the data source that replicates the problem. This would allow us to investigate the reported problem at our end and provide a solution as soon as possible.


Regards,

Rajeshkannah G


Attachment: PivotTable_446959b5.zip

Loader.
Up arrow icon