# Process Helpers for Bulk Operations

The Data Query provides functions that help you handle bulk data operations such as [sorting](https://www.telerik.com/kendo-angular-ui/components/data-query/bulk-operations#sorting), [filtering](https://www.telerik.com/kendo-angular-ui/components/data-query/bulk-operations#filtering), [grouping](https://www.telerik.com/kendo-angular-ui/components/data-query/bulk-operations#grouping), and [aggregates](https://www.telerik.com/kendo-angular-ui/components/data-query/bulk-operations#aggregates).

The following example demonstrates how to group, sort, and filter data by using a single helper function.

```js
import { process } from '@progress/kendo-data-query';

const data = [
    { "productName": "Chai", "unitPrice": 18, "unitsInStock": 39, "discontinued": false,
      "category": { "categoryName": "Beverages" }
    },
    { "productName": "Chang", "unitPrice": 19, "unitsInStock": 17, "discontinued": false,
      "category": { "categoryName": "Beverages" }
    },
    { "productName": "Aniseed Syrup", "unitPrice": 10, "unitsInStock": 13, "discontinued": false,
      "category": { "categoryName": "Condiments" }
    },
    { "productName": "Cajun Seasoning", "unitPrice": 22, "unitsInStock": 53, "discontinued": false,
      "category": { "categoryName": "Condiments" }
    },
    { "productName": "Gumbo Mix", "unitPrice": 21.35, "unitsInStock": 0, "discontinued": true,
      "category": { "categoryName": "Condiments" }
    }
];

const result = process(data, {
    group: [{
        field: 'category.categoryName',
        aggregates: [
            { aggregate: "sum", field: "unitPrice" },
            { aggregate: "sum", field: "unitsInStock" }
        ]
    }],
    sort: [{ field: 'productName', dir: 'desc' }],
    filter: {
        logic: "or",
        filters: [
            { field: "discontinued", operator: "eq", value: true },
            { field: "unitPrice", operator: "lt", value: 22 }
        ]
    }
});

/* output
{
  "data": [
    { "aggregates": {
        "unitPrice": { "sum": 53.35 },
        "unitsInStock": { "sum": 66 }
      },
      "field": "category.categoryName",
      "items": [
        { "productName": "Gumbo Mix", "unitPrice": 21.35, "unitsInStock": 0, "discontinued": true,
          "category": { "categoryName": "Condiments" }
        },
        { "productName": "Aniseed Syrup", "unitPrice": 10, "unitsInStock": 13, "discontinued": false,
          "category": { "categoryName": "Condiments" }
        }
      ],
      "value": "Condiments"
    },
    {
      "aggregates": {
        "unitPrice": { "sum": 37 },
        "unitsInStock": { "sum": 56 }
      },
      "field": "category.categoryName",
      "items": [
        { "productName": "Chang", "unitPrice": 19, "unitsInStock": 17, "discontinued": false,
          "category": { "categoryName": "Beverages" }
        },
        { "productName": "Chai", "unitPrice": 18, "unitsInStock": 39, "discontinued": false,
          "category": { "categoryName": "Beverages" }
        }
      ],
      "value": "Beverages"
    }
  ],
  "total": 4
}
*/
```

## Sorting

To sort an array of objects based on a field and direction, use the `orderBy` helper function. The method accepts a data array and one or more [SortDescriptors](https://www.telerik.com/kendo-angular-ui/components/data-query/api/sortdescriptor).

```js
import { orderBy } from '@progress/kendo-data-query';

const data = [
  { name: "Pork", category: "Food", subcategory: "Meat" },
  { name: "Pepper", category: "Food", subcategory: "Vegetables" },
  { name: "Beef", category: "Food", subcategory: "Meat" }
];

const result = orderBy(data, [{ field: "name", dir: "asc" }]);

console.log(result);

/* output
[
  { "name": "Beef", "category": "Food", "subcategory": "Meat" },
  { "name": "Pepper", "category": "Food", "subcategory": "Vegetables" },
  { "name": "Pork", "category": "Food", "subcategory": "Meat" }
]
*/
```

The [`SortDescriptor`](https://www.telerik.com/kendo-angular-ui/components/data-query/api/sortdescriptor) has a `compare` property that allows you to define a function with custom sorting logic.

```js
import { orderBy, SortDescriptor } from '@progress/kendo-data-query';

const data = [{ foo: 100 }, { foo: 1 }, { foo: 10 }, {  foo: 5 }];

const sortDescriptor: SortDescriptor[] = [{ 
     field: 'foo',
     compare: (a, b) => (a.foo === b.foo) ? 0 : (a.foo > b.foo ? 1 : -1)
}];

const result = orderBy(data, sortDescriptor);

console.log(result);
// [{ foo: 1 }, { foo: 5 }, { foo: 10 }, {  foo: 100 }
```

## Filtering

To filter an array of objects, use the `filterBy` helper function. The method accepts a data array and one or more [FilterDescriptors](https://www.telerik.com/kendo-angular-ui/components/data-query/api/filterdescriptor).

```js
import { filterBy } from '@progress/kendo-data-query';

const data = [
    { name: "Pork", category: "Food", subcategory: "Meat" },
    { name: "Pepper", category: "Food", subcategory: "Vegetables" },
    { name: "Beef", category: "Food", subcategory: "Meat" }
];

const result = filterBy(data, {
    logic: 'and',
    filters: [
        { field: "name", operator: "startswith", value: "p", ignoreCase: true },
        { field: "subcategory", operator: "eq", value: "Meat" },
    ]
});

console.log(JSON.stringify(result, null, 2));
/* output
[
    { "name": "Pork", "category": "Food", "subcategory": "Meat" }
]
*/
```

## Grouping

To split the data array into sets, use the `groupBy` helper function. The method accepts a data array and one or more [GroupDescriptors](https://www.telerik.com/kendo-angular-ui/components/data-query/api/groupdescriptor).

```js
import { groupBy } from '@progress/kendo-data-query';

const data = [
    { name: "Pork", category: "Food", subcategory: "Meat" },
    { name: "Pepper", category: "Food", subcategory: "Vegetables" },
    { name: "Beef", category: "Food", subcategory: "Meat" }
];

const result = groupBy(data, [{ field: "category" }, { field: "subcategory", dir: "desc" }]);

console.log(JSON.stringify(result, null, 2));
/* output
[
  { "aggregates": {},  "field": "category",
    "items": [
        {"aggregates": {}, "field": "subcategory",
        "items": [
            { "name": "Pork", "category": "Food", "subcategory": "Meat" },
            { "name": "Beef", "category": "Food", "subcategory": "Meat" }
        ],
        "value": "Meat"
      },
      { "aggregates": {}, "field": "subcategory",
        "items": [
            {"name": "Pepper", "category": "Food", "subcategory": "Vegetables"}
        ],
        "value": "Vegetables"
      }
    ],
    "value": "Food"
  }
]
*/
```

> Note: the `groupBy` function does not apply the direction, specified in the [GroupDescriptors](https://www.telerik.com/kendo-angular-ui/components/data-query/api/groupdescriptor).

Use the [process](https://www.telerik.com/kendo-angular-ui/components/data-query/api/process) method instead:

```ts

process(initialData, {group: [group descriptors]}).data
```

## Aggregates

To aggregate data based on the [AggregateDescriptor](https://www.telerik.com/kendo-angular-ui/components/data-query/api/aggregatedescriptor), use the `aggregateBy` helper function.

```js
import { aggregateBy } from '@progress/kendo-data-query';

const data = [
    { "productName": "Chai", "unitPrice": 18, "unitsInStock": 39 },
    { "productName": "Chang", "unitPrice": 19, "unitsInStock": 17 },
    { "productName": "Aniseed Syrup", "unitPrice": 10, "unitsInStock": 13 }
];

const result = aggregateBy(data, [
      { field: 'productName', aggregate: 'count' },
      { field: 'unitPrice', aggregate: 'sum' },
      { field: 'unitPrice', aggregate: 'average' },
      { field: 'unitsInStock', aggregate: 'min' },
      { field: 'unitsInStock', aggregate: 'max' },
]);


console.log(JSON.stringify(result, null, 2));
/* output
{
    "productName": { "count": 3 },
    "unitPrice": { "sum": 47, "average": 15.666666666666666 },
    "unitsInStock": { "min": 13, "max": 39 }
}
*/
```

## Suggested Links

* [Data Query API Index](https://www.telerik.com/kendo-angular-ui/components/data-query/api)
* [SortDescriptor](https://www.telerik.com/kendo-angular-ui/components/data-query/api/sortdescriptor)
* [FilterDescriptor](https://www.telerik.com/kendo-angular-ui/components/data-query/api/filterdescriptor)
* [GroupDescriptor](https://www.telerik.com/kendo-angular-ui/components/data-query/api/groupdescriptor)
* [AggregateDescriptor](https://www.telerik.com/kendo-angular-ui/components/data-query/api/aggregatedescriptor)
