RedBase Documentation

Welcome to the RedBase documentation portal. Browse the API reference, explore code examples, and learn how to build with REDB.

Quick Start Examples

API Reference

Browse the REDB API documentation. Select a namespace or type from the tree on the left, or click on items below.

Search results for: GroupBy Clear search
C E128_GroupBySimple redb.Examples.Examples
C E129_GroupByFiltered redb.Examples.Examples
C E130_GroupByMultiKey redb.Examples.Examples
C E131_GroupByRedb redb.Examples.Examples
C E142_GroupByArray redb.Examples.Examples
C E173_TreeQueryGroupBy redb.Examples.Examples
C E175_TreeQueryGroupByWindow redb.Examples.Examples
C E195_GroupByWindowFiltered redb.Examples.Examples
I IRedbQueryable<TProps> redb.Core.Query
M GroupBy<TKey>(Expression<Func<TProps, TKey>>) Group by field with subsequent aggregation.
M GroupByArray<TItem, TKey>(Expression<Func<TProps, IEnumerable<TItem>>>, Expression<Func<TItem, TKey>>) Group by array elements (Items[].Property).
M GroupByRedb<TKey>(Expression<Func<IRedbObject, TKey>>) Group by IRedbObject base fields (id, scheme_id, parent_id, etc.).
I ITreeQueryProvider redb.Core.Query
M GetTreeGroupBySqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) Get SQL preview for tree GROUP BY query (for debugging).
C ProQueryableProvider redb.Postgres.Pro.Providers
M GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?) Get SQL preview for GroupBy aggregation (for diagnostics).
C ProQueryProvider redb.MSSql.Pro.Query
M GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, FilterExpression?) Pro: SQL Preview for GroupBy with FilterExpression (preferred).
M GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?) Pro: SQL Preview for GroupBy with filterJson (legacy compatibility).
C ProQueryProvider redb.Postgres.Pro.Query
M GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, FilterExpression?) Pro: SQL Preview for GroupBy with FilterExpression (preferred).
M GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?) Pro: SQL Preview for GroupBy with filterJson (legacy compatibility).
C ProTreeQueryProvider redb.MSSql.Pro.Query
M ExecuteTreeGroupByAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) Execute GROUP BY on tree with CTE.
M GetTreeGroupBySqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) SQL Preview for Tree GroupBy (DRY - same SQL as Execute)
C ProTreeQueryProvider redb.Postgres.Pro.Query
M ExecuteTreeGroupByAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) Execute GROUP BY on tree with CTE.
M GetGroupBySqlPreviewAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?) Returns SQL preview for GroupBy query with tree constraints.
M GetTreeGroupBySqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) SQL Preview for Tree GroupBy (DRY - same SQL as Execute)
C RedbQueryable<TProps> redb.Core.Query
M GroupBy<TKey>(Expression<Func<TProps, TKey>>) Grouping with aggregations.
M GroupByArray<TItem, TKey>(Expression<Func<TProps, IEnumerable<TItem>>>, Expression<Func<TItem, TKey>>) Grouping by array elements
M GroupByRedb<TKey>(Expression<Func<IRedbObject, TKey>>) Grouping by base IRedbObject fields (id, scheme_id, parent_id, etc.)
C TreeQueryableBase<TProps> redb.Core.Query.Base
M GroupBy<TKey>(Expression<Func<TProps, TKey>>) Override GroupBy to respect tree context (rootObjectId, maxDepth, ParentIds).
M GroupByRedb<TKey>(Expression<Func<IRedbObject, TKey>>) Override GroupByRedb to respect tree context.
C TreeQueryProviderBase redb.Core.Query.Base
M GetTreeGroupBySqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) Get SQL preview for tree GROUP BY query.