Search results

State Persistence in Blazor Pivot Table component

State persistence allows user to maintain the current state of the component along with its report bounded in the browser local storage (cookie). Even if the browser is refreshed or if you move to the next page within the browser, components state will be persisted. State persistence stores the Pivot Table object in the local storage when EnablePersistence property in SfPivotView class is set to true.

Note: The state of the pivot table is retained during page refresh and navigation based on its ID set. Make sure to set unique ID for each pivot table to store its state in browser. On duplication of ID, the state maintained will be overridden.

    @using Syncfusion.Blazor.PivotView


    <SfPivotView ID="pivot" TValue="ProductDetails" @ref="pivot" EnablePersistence="true">
        <PivotViewDataSourceSettings DataSource="@data" EnableSorting=true>
            <PivotViewColumns>
                <PivotViewColumn Name="Year"></PivotViewColumn>
                <PivotViewColumn Name="Quarter"></PivotViewColumn>
            </PivotViewColumns>
            <PivotViewRows>
                <PivotViewRow Name="Country"></PivotViewRow>
                <PivotViewRow Name="Products"></PivotViewRow>
            </PivotViewRows>
            <PivotViewValues>
                <PivotViewValue Name="Sold" Caption="Units Sold"></PivotViewValue>
                <PivotViewValue Name="Amount" Caption="@caption"></PivotViewValue>
            </PivotViewValues>
            <PivotViewFormatSettings>
                <PivotViewFormatSetting Name="Amount" Format="C0" UseGrouping=true></PivotViewFormatSetting>
            </PivotViewFormatSettings>
        </PivotViewDataSourceSettings>
        <PivotViewGridSettings ColumnWidth="140"></PivotViewGridSettings>
    </SfPivotView>

    @code{
        public List<ProductDetails> data { get; set; }
        protected override void OnInitialized()
        {
            this.data = ProductDetails.GetProductData().ToList();
           //Bind the data source collection here. Refer "Assigning sample data to the pivot table" section in getting started for more details.
        }
    }

Save and Load Pivot Layout

You can save the current layout of the pivot table by using GetPersistData in string format. The saved layout can be loaded to pivot table any time by passing the saved data as a parameter to LoadPersistData method in the SfPivotView.

    @using Syncfusion.Blazor.PivotView
    @using Syncfusion.Blazor.Buttons

    <SfButton OnClick="savedata">Save Layout</SfButton>
    <SfButton OnClick="loaddata">Load Layout</SfButton>

    <SfPivotView TValue="ProductDetails" @ref="pivot">
        <PivotViewDataSourceSettings DataSource="@data" EnableSorting=true>
            <PivotViewColumns>
                <PivotViewColumn Name="Year"></PivotViewColumn>
                <PivotViewColumn Name="Quarter"></PivotViewColumn>
            </PivotViewColumns>
            <PivotViewRows>
                <PivotViewRow Name="Country"></PivotViewRow>
                <PivotViewRow Name="Products"></PivotViewRow>
            </PivotViewRows>
            <PivotViewValues>
                <PivotViewValue Name="Sold" Caption="Units Sold"></PivotViewValue>
                <PivotViewValue Name="Amount" Caption="@caption"></PivotViewValue>
            </PivotViewValues>
            <PivotViewFormatSettings>
                <PivotViewFormatSetting Name="Amount" Format="C0" UseGrouping=true></PivotViewFormatSetting>
            </PivotViewFormatSettings>
        </PivotViewDataSourceSettings>
        <PivotViewGridSettings ColumnWidth="140"></PivotViewGridSettings>
    </SfPivotView>

    @code{
        public List<ProductDetails> data { get; set; }
        protected override void OnInitialized()
        {
            this.data = ProductDetails.GetProductData().ToList();
           //Bind the data source collection here. Refer "Assigning sample data to the pivot table" section in getting started for more details.
        }
        public string persistData;
        public async void savedata(Microsoft.AspNetCore.Components.Web.MouseEventArgs e)
        {
            persistData = await this.pivot.GetPersistData();
        }
        public async void loaddata(Microsoft.AspNetCore.Components.Web.MouseEventArgs e)
        {
            this.pivot.LoadPersistData(persistData);
        }
    }