Defer Update

IMPORTANT

This feature is applicable for Relational datasource only at Server Mode.

Defer Update support allows you to refresh the control only on-demand and not during every UI interaction.

  • cshtml
  • @Html.EJ().Pivot().PivotGrid("PivotGrid1").Url(Url.Content("/RelationalService")).ClientSideEvents(events => events.AfterServiceInvoke("OnAfterServiceInvoke"))
    
    @Html.EJ().Pivot().PivotSchemaDesigner("PivotSchemaDesigner").Layout(PivotSchemaDesignerLayout.Excel)
    
    <script type="text/javascript">
        OnAfterServiceInvoke = function(evt) {
            if (evt.action == "initialize") {
                var PivotSchemaDesigner = $("#PivotSchemaDesigner").data('ejPivotSchemaDesigner');
                if (PivotSchemaDesigner.model.pivotControl == null) {
                    PivotSchemaDesigner.model.pivotControl = this;
                    PivotSchemaDesigner.model.enableWrapper = true;
                    PivotSchemaDesigner.model.layout = "excel";
                    PivotSchemaDesigner._load();
                }
            }
        }
    </script>

    Defer update support in ASP NET MVC pivot grid control