Pivot: Validation Message on Count Exceed

Hi,

Facing one issue, in a case when the column selection made is too huge for example: Selected Product (1000) and within it Country. application get hang.

Do we have any workaround or can we show some message to restrict user from doing such huge selection.

Kindly reply

It possible to estimate the complexity of the result set and block operations if the result is too big. Check samples\05_customization\06_estimate_complexity.html

To block rendering, code needs to return false from the onbeforeapply event handler.

We are considering adding some kind of watchdog timer as well, which will interrupt rendering if it takes too much time. Please inform if such feature will be helpful in your case.

Yes… can you please provide sample code to implement block rendering through alert popup and i am facing same issue while generate export to excel it will really helpful if you provide sample code.

In the oncoming Pivot 4.3, you will be able to use a code like next

{
container:"testA",
id:"pivot", view:"pivot",

ping:function(start){
	var now = (new Date()).valueOf();
	//break if processing is longer than 3 seconds 
	if (now - start > 3*1000){
		alert("Too complex parameters, aborting");
		throw new Error("Aborting...");
	}
},

It will work for me thank you so much is any other feature coming in pivot 4.3?

its really helpful for me if you provide sample code.

please implement here
http://webix.com/snippet/5b0f903d

kindly reply

Check http://docs.webix.com/samples/61_pivot/08_performance/02_abort_long.html

At my end it is not working its really helpful if you implement in below link

http://webix.com/snippet/5b0f903d