Updating data source in pivot view

[Rainer]

Hi support,

I am updating the underlying data source of a pivotview control.

Initially I have my dataSourceSettings like this

     

     this.data = this.getsomeJsonData();

     this.dataSourceSettings = {

        dataSource: this.data,

        expandAll: false,

        rows: [{ name: 'pol' },{ name: 'pod' }, { name: 'weightGroup' }],

        columns: [{ name: 'isoType' }],

        formatSettings: [],

        values: [{ name: 'weight', type: 'Count', caption:'Containers' }],

        filters: [],

        showSubTotals: false,

        showGrandTotals: true,

        conditionalFormatSettings: []

       };

      this.pivotGridObj.gridSettings.allowSelection = true;

      this.pivotGridObj.gridSettings.selectionSettings =

        { mode: 'Cell', cellSelectionMode: 'Flow', type: 'Multiple' }

In the App there are button , once clicked that modify the underlying data source

    this.data = this.processData(args.item.id);

    this.pivotGridObj.refresh();

This works ok, but is there any way not to create the pivotview again and again , since it it a rather flickering experience. ?

Only very few cells are changed at a time

best regards

Rainer

[Manikandan Murugesan]

Hi Rainer, 

You can update the pivot table with a new data source by simply assigning data to the pivot table instance as shown in the following code snippet. 

Code Snippet: 

 

document.getElementById('refresh').onclick = () => { 

    this.pivotObj.dataSourceSettings.dataSource = Pivot_Data2; 

}; 

 

Sample: https://stackblitz.com/edit/angular-qd5fwf?file=app.component.ts 

Please let us know if you need any further assistance on this. 

Thanks, 

Manikandan.  

[Rainer]

Hi Manikandan,

this does not work in my solution.

I tried with an empty array :

  this.dataSourceSettings.dataSource = [];

still the old data is shown in the pivot;

best

Rainer

[Manikandan Murugesan]

Hi Rainer, 

 

Thanks for the reply. 

 

As we mentioned in our previous update, you need to assign the new data source to the pivot table instance. 

 

Code Snippet: 

 

document.getElementById('refresh').onclick = () => { 

    this.pivotObj.dataSourceSettings.dataSource = Pivot_Data2; 

}; 

 

 

Sample: https://stackblitz.com/edit/angular-qd5fwf?file=app.component.ts 

If this doesn’t resolve your problem, then kindly reproduce the problem in the provided sample and revert us (or) send your sample that replicating the problem. This would be a very helpful for us to investigate the reported problem at our end and provide the solution at earliest. 

 

Thanks, 

Manikandan. 

[Rainer]

Sorry, it only works if you assign a new this.dataSourceSettings object with the new data source. set.

Best regards

Rainer

[Sivamathi Natarajan]

Hi Rainer, 

 

We are unable to understand your exact requirement in your last update. So, could you please provide us more information about the same with code example/images/video (if possible). This would be helpful for us to proceed further. 

 

Regards, 

Sivamathi. 

[Rainer]

Hi support,

I found a workaround, you can close the issue.

Thanks

Rainer

[Sivamathi Natarajan]

Hi Rainer, 

 

Thanks for the response. Please get in touch with us if you would require any further assistance. 

 

Regards, 

Sivamathi. 

[Muhammad Khizar]

Hi support,

I found a workaround, you can close the issue.

Thanks

Rainer

sir i also facing this issue kindly send me solution. Thanks

[Sivamathi Natarajan]

Hi Muhammad Khizar, 

 

We would like to assist you, so could you please provide us more information about the reported problem with code example/images/video (if possible). This would be helpful for us to proceed further.  

  

Regards,  

Sivamathi.