Pivot Field List not clearing fields when data source changed to have no data

I am using a PivotView along with a PivotFieldList that I am using in conjunction together similar to the demo application on this site. The main difference is that I have a dynamic set of data that the user can select, and so I am changing the dataSource in the dataSourceSettings that is shared between the two controls. This generally works fine when switching between data sets with data in them, however there are scenarios where the user may pick no data source, or select a data source that contains no rows. When this happens, the pivot grid does clear and shows "No records to display"; however, the field list still maintains and shows the fields from the previous data source. I would like to be able to clear the field list in this scenario. While researching, I found that the enginePopulated event of the PivotView does not fire when the data source is empty. In general, is there a way to reset the field list back to a default state, or at least clear the list of fields? I have tried calling the refresh() method on the PivotFieldListComponent as well as setting the engineModule.fields = [] on the PivotViewComponent, to no effect.

9 Replies 1 reply marked as answer

SN Sivamathi Natarajan Syncfusion Team August 26, 2020 02:28 PM UTC

Hi Michael Evans, 
  
Thanks for contacting Syncfusion support. 
  
We are validating the reported problem at our end. Meanwhile, could you please confirm whether you are using popup or static field list ? 
  
Please let us know if you have concern. 
  
Regards, 
Sivamathi. 



ME Michael Evans August 26, 2020 02:40 PM UTC

Hi,

I am using renderMode="Fixed". The fields are populated automatically when the data set is assigned. This works great for the most part, except when the data set is empty.

Thanks,
Michael


SN Sivamathi Natarajan Syncfusion Team August 27, 2020 10:46 AM UTC

 
We considered “Issue in Field list refresh with empty data source” as a bug and logged a defect report in our data base. And, the fix will be available in our weekly patch release which is estimated to be rolled out on 9th September, 2020. You can track  
the task in the following link. 
 
 
We appreciate your patience until then. 
 
Regards, 
Sivamathi. 



SN Sivamathi Natarajan Syncfusion Team September 10, 2020 03:11 PM UTC

Hi Michael, 
 
Due to code complexity we are unable to complete the bug fixing and include in weekly release. But we will surely include this in our upcoming weekly release, which is estimated to be rolled out on September 16th, 2020. 
 
We appreciate your patience until then.  
 
Regards,
Sivamathi.
 



ME Michael Evans September 10, 2020 04:00 PM UTC

No problem, we appreciate your working on this as quickly as you are. Thanks!


SN Sivamathi Natarajan Syncfusion Team September 11, 2020 08:06 AM UTC

Hi Michael, 
 
Thanks for the reply. 
 
Regards, 
Sivamathi. 



SN Sivamathi Natarajan Syncfusion Team September 16, 2020 02:25 PM UTC

Hi Michael, 
 
Thanks for the patience. 

The reported issue – “Issue in Field list refresh with empty data source” has been fixed in the weekly release (v18.2.0.58) and it is available in nuget.org (https://www.nuget.org/). Meanwhile, we have prepared a sample for your reference. 
 

Please let us know if you have concern. 
 
Regards, 
Sivamathi. 


Marked as answer

ME Michael Evans September 17, 2020 06:49 PM UTC

Thank you, I have confirmed the field list behaves as expected now when the data set is cleared. Appreciate your quick response!


SN Sivamathi Natarajan Syncfusion Team September 18, 2020 07:24 AM UTC

Hi Michael Evans, 
 
Thanks for the reply. 
 
Regards, 
Sivamathi. 


Loader.
Up arrow icon