SelectQueryFluentBuilder.GroupFilter(String) Method
Specifies the filter criteria to add to the current query containing grouped/aggregated columns.
Namespace: DevExpress.DataAccess.Sql
Assembly: DevExpress.DataAccess.v24.1.dll
NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap
Declaration
Parameters
Name | Type | Description |
---|---|---|
groupFilterString | String | A String value, specifying the filter criteria. |
Returns
Type | Description |
---|---|
SelectQueryFluentBuilder | A SelectQueryFluentBuilder object. |
Remarks
Note
The filter string parameter uses case-sensitive table/column names.
In the following example, a query uses an inner join to select columns from separate data tables sharing a common column key.
using DevExpress.DataAccess.ConnectionParameters;
using DevExpress.DataAccess.Sql;
using DevExpress.Xpo.DB;
// ...
private SqlDataSource BindToData() {
// Create a data source with the required connection parameters.
Access97ConnectionParameters connectionParameters =
new Access97ConnectionParameters("../../Data/nwind.mdb", "", "");
SqlDataSource ds = new SqlDataSource(connectionParameters);
// Join the Categories and Products table by the CategoryID column.
// Return the list of categories and the number of products in each category.
// Sort the categories by the number of products in them.
// The included categories must contain a specific number of products.
SelectQuery query = SelectQueryFluentBuilder
.AddTable("Categories")
.SelectColumn("CategoryName")
.GroupBy("CategoryName")
.Join("Products", "CategoryID")
.SelectColumn("ProductName", AggregationType.Count, "ProductCount")
.SortBy("ProductName", AggregationType.Count, System.ComponentModel.ListSortDirection.Descending)
.GroupFilter("[ProductCount] > 7")
.Build("MyQuery");
// Add the query to the collection and return the data source.
ds.Queries.Add(query);
return ds;
}
See Also