API Reference
Обзор документации REDB API. Выберите пространство имён или тип в дереве слева, или кликните по элементам ниже.
Результаты поиска: GroupBy
Очистить
ArrayGroupModuleJson
redb.Core.Query.Grouping
E128_GroupBySimple
redb.Examples.Examples
E128_GroupBySimple_ef
redb.Examples.ExamplesEf
E129_GroupByFiltered
redb.Examples.Examples
E129_GroupByFiltered_ef
redb.Examples.ExamplesEf
E130_GroupByListItem
redb.Examples.Examples
E130_GroupByMultiKey
redb.Examples.Examples
E130_GroupByMultiKey_ef
redb.Examples.ExamplesEf
E131_GroupByRedb
redb.Examples.Examples
E131_GroupByRedb_ef
redb.Examples.ExamplesEf
E142_GroupByArray
redb.Examples.Examples
E142_GroupByArray_ef
redb.Examples.ExamplesEf
E173_TreeQueryGroupBy
redb.Examples.Examples
E173_TreeQueryGroupBy_ef
redb.Examples.ExamplesEf
E175_TreeQueryGroupByWindow
redb.Examples.Examples
E175_TreeQueryGroupByWindow_ef
redb.Examples.ExamplesEf
E195_GroupByWindowFiltered
redb.Examples.Examples
E195_GroupByWindowFiltered_ef
redb.Examples.ExamplesEf
IRedbQueryable<TProps>
redb.Core.Query
GroupBy<TKey>(Expression<Func<TProps, TKey>>)
Group by field with subsequent aggregation.
GroupByArray<TItem, TKey>(Expression<Func<TProps, IEnumerable<TItem>>>, Expression<Func<TItem, TKey>>)
Group by the elements of an array. The array is a chain of fields (x => x.Items,
GroupByRedb<TKey>(Expression<Func<IRedbObject, TKey>>)
Group by IRedbObject base fields (id, scheme_id, parent_id, etc.).
IRedbQueryProvider
redb.Core.Query
ITreeQueryProvider
redb.Core.Query
GetTreeGroupBySqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?, CancellationToken)
Get SQL preview for tree GROUP BY query (for debugging).
GetTreeGroupBySqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>)
Get SQL preview for tree GROUP BY query (for debugging).
MssqlQueryProvider
redb.MSSql.Query
GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, FilterExpression?, string?, CancellationToken)
FilterExpression overload of
GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?, string?, CancellationToken)
Returns the inner SELECT compiled by dbo.pvt_build_groupby_sql for
PostgresQueryProvider
redb.Postgres.Query
GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, FilterExpression?, string?, CancellationToken)
FilterExpression overload of GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumer...
GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?, string?, CancellationToken)
Returns the inner SELECT compiled by pvt_build_groupby_sql for the
ProQueryableProvider
redb.Postgres.Pro.Providers
GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?, CancellationToken)
Get SQL preview for GroupBy aggregation (for diagnostics).
GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?)
Get SQL preview for GroupBy aggregation (for diagnostics).
ProQueryProvider
redb.MSSql.Pro.Query
GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, FilterExpression?, string?, CancellationToken)
Pro: SQL Preview for GroupBy with FilterExpression (preferred).
GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, FilterExpression?)
Pro: SQL Preview for GroupBy with FilterExpression (preferred).
GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?, string?, CancellationToken)
Pro: SQL Preview for GroupBy with filterJson (legacy compatibility).
GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?)
Pro: SQL Preview for GroupBy with filterJson (legacy compatibility).
ProQueryProvider
redb.Postgres.Pro.Query
GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, FilterExpression?, string?, CancellationToken)
Pro: SQL Preview for GroupBy with FilterExpression (preferred).
GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, FilterExpression?)
Pro: SQL Preview for GroupBy with FilterExpression (preferred).
GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?, string?, CancellationToken)
Pro: SQL Preview for GroupBy with filterJson (legacy compatibility).
GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?)
Pro: SQL Preview for GroupBy with filterJson (legacy compatibility).
ProTreeQueryProvider
redb.MSSql.Pro.Query
ExecuteTreeGroupByAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, CancellationToken)
Execute GROUP BY on tree with CTE.
ExecuteTreeGroupByAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>)
Execute GROUP BY on tree with CTE.
GetTreeGroupBySqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?, CancellationToken)
SQL Preview for Tree GroupBy (DRY - same SQL as Execute)
GetTreeGroupBySqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>)
SQL Preview for Tree GroupBy (DRY - same SQL as Execute)
ProTreeQueryProvider
redb.Postgres.Pro.Query
ExecuteTreeGroupByAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, CancellationToken)
Execute GROUP BY on tree with CTE.
ExecuteTreeGroupByAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>)
Execute GROUP BY on tree with CTE.
GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?, string?, CancellationToken)
Returns SQL preview for GroupBy query with tree constraints.
GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?)
Returns SQL preview for GroupBy query with tree constraints.
GetTreeGroupBySqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?, CancellationToken)
SQL Preview for Tree GroupBy (DRY - same SQL as Execute)
GetTreeGroupBySqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>)
SQL Preview for Tree GroupBy (DRY - same SQL as Execute)
QueryProviderBase
redb.Core.Query.Base
GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, FilterExpression?, string?, CancellationToken)
SQL preview of a GroupBy with FilterExpression. Free fallback: converts FilterExpression to facet-JS...
GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?, string?, CancellationToken)
SQL preview of a GroupBy. A provider that supports it overrides this; one that does not refuses with...
RedbQueryable<TProps>
redb.Core.Query
GroupBy<TKey>(Expression<Func<TProps, TKey>>)
Grouping with aggregations.
GroupByArray<TItem, TKey>(Expression<Func<TProps, IEnumerable<TItem>>>, Expression<Func<TItem, TKey>>)
Grouping by array elements
GroupByRedb<TKey>(Expression<Func<IRedbObject, TKey>>)
Grouping by base IRedbObject fields (id, scheme_id, parent_id, etc.)
TreeQueryableBase<TProps>
redb.Core.Query.Base
GroupBy<TKey>(Expression<Func<TProps, TKey>>)
Override GroupBy to respect tree context (rootObjectId, maxDepth, ParentIds).
GroupByArray<TItem, TKey>(Expression<Func<TProps, IEnumerable<TItem>>>, Expression<Func<TItem, TKey>>)
Override GroupByArray to respect tree context: only the elements of the objects of the subtree are g...
GroupByRedb<TKey>(Expression<Func<IRedbObject, TKey>>)
Override GroupByRedb to respect tree context.
TreeQueryProviderBase
redb.Core.Query.Base
GetTreeGroupBySqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?, CancellationToken)
Get SQL preview for tree GROUP BY query.
GetTreeGroupBySqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>)
Get SQL preview for tree GROUP BY query.