Search results

How To

21 Oct 2021 / 1 minute to read

Member Editor

Load limited data in Member Editor

In the filter dialog, user can set the limit to display field values while loading the large data. Based on this limit, the initial loading will complete quickly without any performance constraint. And user can use search option to refining the field values from exceeded limit. You can refine the data further by using search option and a message with the remaining data count will be displayed in member editor. The data limit can be set in the property maxNodeLimitInEditor.

By default, the property holds the value 1000.

The property is available in both Pivot Grid and Field List components.

Copied to clipboard
@using Syncfusion.EJ2.PivotView

@Html.EJS().PivotView("PivotGrid").Height(300).Width(800).MaxNodeLimitInEditor(100).DataSource(dataSource => dataSource.Data((IEnumerable<object>)ViewBag.Data).ExpandAll(true)
.Rows(rows =>
    rows.Name("Country").Add(); rows.Name("Products").Add();
}).Columns(columns =>
    columns.Name("Year").Caption("Production Year").Add(); columns.Name("Quarter").Add();
}).Values(values =>
    values.Name("Sold").Caption("Units Sold").Add(); values.Name("Amount").Caption("Sold Amount").Add();
Copied to clipboard
public ActionResult Index()
    var data = GetPivotData(); = data;
    return View();