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.v23.2.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap

Declaration

C#

[Browsable(false)]
public GroupingInfoList Grouping { get; }

VB.NET

<Browsable(False)>
Public ReadOnly Property Grouping As GroupingInfoList

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.