TableQuery.Grouping Property
Provides access to grouping settings used to group the result set of the current TableQuery by the specified column(s) into a set of summary rows.
Namespace: DevExpress.DataAccess.Sql
Assembly: DevExpress.DataAccess.v24.2.dll
Declaration
Property Value
Type | Description |
---|---|
GroupingInfoList | A GroupingInfoList object providing access to the collection of GroupingInfo objects that specify grouping settings. |
Remarks
Grouping is used in conjunction with the aggregate functions to group the result set by one or more columns. Therefore, you should apply grouping/aggregation either to all columns or to none of them.
To group the result set by the specified column, create the GroupingInfo object, specify its settings and add this object to the Grouping collection.
To aggregate values of the specified column, use the ColumnInfo.Aggregation property of the required column. Note that aggregated columns should have an alias, which can be specified using the ColumnInfo.Alias property.
Note
To access columns selected in the current TableQuery, do the following.
- Access the required table using the TableQuery.Tables property that contains TableInfo objects.
- Obtain columns of the specified table using the TableInfo.SelectedColumns property.