@syncfusion/ej2-data

DataManager

The DataManager feature allows you to manage and manipulate data collections. In this example, a DataManager instance is created with a sample data array, and a query is executed to filter out records where the age is greater than 28.

const { DataManager, Query } = require('@syncfusion/ej2-data');

const data = [
  { id: 1, name: 'John', age: 30 },
  { id: 2, name: 'Jane', age: 25 },
  { id: 3, name: 'Doe', age: 35 }
];

const dataManager = new DataManager(data);
const query = new Query().where('age', 'greaterThan', 28);
const result = dataManager.executeLocal(query);
console.log(result);

Sorting

The Sorting feature allows you to sort data collections based on specified fields. In this example, the data is sorted by the 'name' field in ascending order.

const { DataManager, Query } = require('@syncfusion/ej2-data');

const data = [
  { id: 1, name: 'John', age: 30 },
  { id: 2, name: 'Jane', age: 25 },
  { id: 3, name: 'Doe', age: 35 }
];

const dataManager = new DataManager(data);
const query = new Query().sortBy('name', 'ascending');
const result = dataManager.executeLocal(query);
console.log(result);

Grouping

The Grouping feature allows you to group data collections based on specified fields. In this example, the data is grouped by the 'group' field.

const { DataManager, Query } = require('@syncfusion/ej2-data');

const data = [
  { id: 1, name: 'John', age: 30, group: 'A' },
  { id: 2, name: 'Jane', age: 25, group: 'B' },
  { id: 3, name: 'Doe', age: 35, group: 'A' }
];

const dataManager = new DataManager(data);
const query = new Query().group('group');
const result = dataManager.executeLocal(query);
console.log(result);

Aggregates

The Aggregates feature allows you to perform aggregate operations like sum, average, min, and max on data collections. In this example, the sum of the 'age' field is calculated.

const { DataManager, Query, DataUtil } = require('@syncfusion/ej2-data');

const data = [
  { id: 1, name: 'John', age: 30 },
  { id: 2, name: 'Jane', age: 25 },
  { id: 3, name: 'Doe', age: 35 }
];

const dataManager = new DataManager(data);
const query = new Query().select(['age']);
const result = dataManager.executeLocal(query);
const totalAge = DataUtil.aggregates.sum(result, 'age');
console.log(totalAge);