Pivot Save State & Bug with Date Groupings
You can view a simple sample project for issues 1 and 2 here: http://www.tgmt-systems.com/syncFusion/
Issue #1 - Persist State with no Data Source Performance
See this thread:
The problem with their current method is it goes to a string... if I have 94k records, it means the code in getPersistData will first convert the 94k json records to a string. Then the code to get state without data will parse the 94k records from the string back to json...
var dataSource = JSON.parse(this.pivotObj.getPersistData()).dataSourceSettings;
We need a method like getPersistData, which returns JSON not a string so we can easily save the full state WITHOUT the dataSource. I hacked one in my version by adding this method in the pivot code itself (had to do that so methods G, V, etc. are in the proper namespace). The different is that this new method returns the JSON instead of the stringified version.
,t.prototype.addOnPersist2=function(e){for(var t=this,i={},n=0,r=e;nreturn i;}
,t.prototype.addOnPersist2=function(e){for(var t=this,i={},n=0,r=e;n
and then by adding another getter that uses it
ej.pivotview.PivotView.prototype.getPersistData2 = function( )
{
var e = this.gridSettings.columnRender, t = this.chartSettings.load;
this.gridSettings.columnRender = void 0, this.chartSettings.tooltipRender = void 0, this.chartSettings.load = void 0;
var i = this.addOnPersist2(
[
"dataSourceSettings",
"pivotValues",
"gridSettings",
"chartSettings",
"displayOption"
] );
return i;
};
{
var e = this.gridSettings.columnRender, t = this.chartSettings.load;
this.gridSettings.columnRender = void 0, this.chartSettings.tooltipRender = void 0, this.chartSettings.load = void 0;
var i = this.addOnPersist2(
[
"dataSourceSettings",
"pivotValues",
"gridSettings",
"chartSettings",
"displayOption"
] );
return i;
};
Issue #2 - Date field with grouping not in columns or rows
In sync project index.js comment out the columns as shown below so all fields appear at the top of the pivot. The "virtual fields" for the month and year groupings are broken as shown below.
/*,columns :
[
{
name : 'Date',
caption : "My Date"
}
]*/
[
{
name : 'Date',
caption : "My Date"
}
]*/
Issue #3 - Persist State has a bug with Groupings on Date fields.
Re-add the columns definition and load the page.
The pivot displays correctly:
1. Move the Years (My Date) field to the top of the pivot.
2. Click on the Test Persist link. It will execute the testPersist function below. When the state is reloaded after 100 ms, the Years field is on top but broken.
function testPersist( )
{
var persist = pivotObj.getPersistData();
setTimeout( function( )
{
pivotObj.loadPersistData( persist );
}, 100 );
}
{
var persist = pivotObj.getPersistData();
setTimeout( function( )
{
pivotObj.loadPersistData( persist );
}, 100 );
}
SIGN IN To post a reply.
6 Replies
Issue 2 Image:
Issue 3 Image:
SIGN IN To post a reply.
