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: AggregateAsync Clear search
C E127_AggregateAsync redb.Examples.Examples
I IRedbQueryable<TProps> redb.Core.Query
M AggregateAsync<TResult>(Expression<Func<RedbObject<TProps>, TResult>>) Flexible aggregation - choose what to aggregate via Agg.Sum/Avg/Min/Max/Count.
I IRedbQueryProvider redb.Core.Query
M ExecuteAggregateAsync(long, string, AggregateFunction, FilterExpression?) Execute single-field aggregation with FilterExpression (Pro version).
M ExecuteAggregateAsync(long, string, AggregateFunction, string?) Execute aggregation on EAV field (SQL strategy for simple fields).
M ExecuteArrayGroupedAggregateAsync(long, string, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?) Execute GroupBy aggregation on array (SQL function aggregate_array_grouped).
M ExecuteGroupedAggregateAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, FilterExpression?) Execute GroupBy aggregation with FilterExpression (Pro version).
M ExecuteGroupedAggregateAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?) Execute GroupBy aggregation (SQL function aggregate_grouped).
I ITreeQueryProvider redb.Core.Query
M ExecuteTreeGroupedAggregateAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) Execute GROUP BY aggregation with tree context (CTE for tree traversal).
C ProQueryProvider redb.MSSql.Pro.Query
M ExecuteAggregateAsync(long, string, AggregateFunction, FilterExpression?) ⚡ Pro: Single field aggregation with FilterExpression (preferred).
M ExecuteAggregateAsync(long, string, AggregateFunction, string?) ⚡ Pro: Single field aggregation with filterJson (legacy).
M ExecuteGroupedAggregateAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, FilterExpression?) ⚡ Pro Override: GroupBy via PVT with FilterExpression (preferred).
M ExecuteGroupedAggregateAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?) ⚡ Pro Override: GroupBy via PVT with filterJson (legacy compatibility).
C ProQueryProvider redb.Postgres.Pro.Query
M ExecuteAggregateAsync(long, string, AggregateFunction, FilterExpression?) ⚡ Pro: Single field aggregation with FilterExpression (preferred).
M ExecuteAggregateAsync(long, string, AggregateFunction, string?) ⚡ Pro: Single field aggregation with filterJson (legacy).
M ExecuteGroupedAggregateAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, FilterExpression?) ⚡ Pro Override: GroupBy via PVT with FilterExpression (preferred).
M ExecuteGroupedAggregateAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?) ⚡ Pro Override: GroupBy via PVT with filterJson (legacy compatibility).
C ProTreeQueryProvider redb.MSSql.Pro.Query
M ExecuteAggregateAsync(long, string, AggregateFunction, string?) Execute aggregation on EAV field (SQL strategy for simple fields).
M ExecuteArrayGroupedAggregateAsync(long, string, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?) Execute GroupBy aggregation on array (SQL function aggregate_array_grouped).
M ExecuteGroupedAggregateAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?) Execute GroupBy aggregation (SQL function aggregate_grouped).
M ExecuteTreeAggregateAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<AggregateRequest>) Execute tree aggregation with CTE.
M ExecuteTreeGroupedAggregateAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) ITreeQueryProvider implementation: Execute GROUP BY with tree context.
C ProTreeQueryProvider redb.Postgres.Pro.Query
M ExecuteAggregateAsync(long, string, AggregateFunction, string?) Execute aggregation on EAV field (SQL strategy for simple fields).
M ExecuteArrayGroupedAggregateAsync(long, string, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?) Execute GroupBy aggregation on array (SQL function aggregate_array_grouped).
M ExecuteGroupedAggregateAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?) Execute GroupBy aggregation (SQL function aggregate_grouped).
M ExecuteTreeAggregateAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<AggregateRequest>) Execute tree aggregation with CTE.
M ExecuteTreeGroupedAggregateAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) ITreeQueryProvider implementation: Execute GROUP BY with tree context.
C QueryProviderBase redb.Core.Query.Base
M ExecuteAggregateAsync(long, string, AggregateFunction, FilterExpression?) Execute single-field aggregation with FilterExpression (Pro version).
M ExecuteAggregateAsync(long, string, AggregateFunction, string?) Perform aggregation on EAV field (SQL strategy)
M ExecuteArrayGroupedAggregateAsync(long, string, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?) Performs GroupBy aggregation on an array via the aggregate_array_grouped SQL function
M ExecuteGroupedAggregateAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, FilterExpression?) Performs GroupBy aggregation with FilterExpression (Pro version).
M ExecuteGroupedAggregateAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?) Performs GroupBy aggregation via the aggregate_grouped SQL function
C RedbQueryable<TProps> redb.Core.Query
M AggregateAsync<TResult>(Expression<Func<RedbObject<TProps>, TResult>>) Flexible aggregation - choose what to aggregate via Agg.Sum/Avg/Min/Max/Count
C TreeQueryProviderBase redb.Core.Query.Base
M ExecuteAggregateAsync(long, string, AggregateFunction, FilterExpression?) Execute single-field aggregation with FilterExpression (Pro version).
M ExecuteAggregateAsync(long, string, AggregateFunction, string?) Execute aggregation on EAV field (SQL strategy for simple fields).
M ExecuteArrayGroupedAggregateAsync(long, string, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?) Execute GroupBy aggregation on array (SQL function aggregate_array_grouped).
M ExecuteGroupedAggregateAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, FilterExpression?) Execute GroupBy aggregation with FilterExpression (Pro version).
M ExecuteGroupedAggregateAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, string?) Execute GroupBy aggregation (SQL function aggregate_grouped).
M ExecuteTreeGroupedAggregateAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) Execute GROUP BY with tree context (CTE for tree traversal).