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: TreeQuery Clear search
C E096_TreeQuery redb.Examples.Examples
C E097_TreeQueryRoots redb.Examples.Examples
C E098_TreeQueryLeaves redb.Examples.Examples
C E099_TreeQueryLevel redb.Examples.Examples
C E105_TreeQueryWithRoot redb.Examples.Examples
C E106_TreeQueryChildrenOf redb.Examples.Examples
C E107_TreeQueryMultiRoot redb.Examples.Examples
C E160_TreeQueryExpressions redb.Examples.Examples
C E173_TreeQueryGroupBy redb.Examples.Examples
C E174_TreeQueryWindow redb.Examples.Examples
C E175_TreeQueryGroupByWindow redb.Examples.Examples
I IQueryableProvider redb.Core.Providers
M TreeQuery<TProps>() Create type-safe tree query by type (synchronous).
M TreeQuery<TProps>(IEnumerable<IRedbObject>, int?) Create tree query limited to subtrees of object list (synchronous).
M TreeQuery<TProps>(IEnumerable<IRedbObject>, IRedbUser, int?) Create tree query limited to subtrees of object list with specified user (synchronous).
M TreeQuery<TProps>(IEnumerable<long>, int?) Create tree query limited to subtrees by ID list (synchronous).
M TreeQuery<TProps>(IEnumerable<long>, IRedbUser, int?) Create tree query limited to subtrees by ID list with specified user (synchronous).
M TreeQuery<TProps>(IRedbObject?, int?) Create tree query limited to subtree (synchronous).
M TreeQuery<TProps>(IRedbObject?, IRedbUser, int?) Create tree query limited to subtree with specified user (synchronous).
M TreeQuery<TProps>(IRedbUser) Create type-safe tree query by type with specified user (synchronous).
M TreeQuery<TProps>(long, int?) Create tree query limited to subtree (synchronous, by ID).
M TreeQuery<TProps>(long, IRedbUser, int?) Create tree query limited to subtree with specified user (synchronous, by ID).
I ITreeQueryProvider redb.Core.Query
M CreateTreeQuery<TProps>(long, long?, bool, long?, int?) Create tree query with hierarchical constraint support.
M ExecuteTreeGroupedAggregateAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) Execute GROUP BY aggregation with tree context (CTE for tree traversal).
M ExecuteTreeGroupedWindowQueryAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>) Execute GroupBy + Window Functions with tree context.
M ExecuteTreeWindowQueryAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?) Execute Window Functions query with tree context (CTE for tree traversal).
M GetTreeGroupBySqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) Get SQL preview for tree GROUP BY query (for debugging).
M GetTreeGroupedWindowSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>) Get SQL preview for tree GroupBy + Window query.
M GetTreeWindowSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?) Get SQL preview for tree window query (for debugging).
C MssqlQueryableProvider redb.MSSql.Providers
M CreateEmptyTreeQuery<TProps>(long, long?, bool) Create empty tree query (for null rootObject case).
M CreateMultiRootTreeQuery<TProps>(long, long?, bool, List<IRedbObject>, int?) Create tree query for multiple root objects.
M CreateMultiRootTreeQueryByIds<TProps>(long, long?, bool, IEnumerable<long>, int?) Create tree query for multiple root object IDs.
M CreateTreeQuery<TProps>(long, long?, bool, long?, int?) Create DB-specific query provider for tree queries.
C MssqlTreeQueryable<TProps> redb.MSSql.Query
M CreateInstance(TreeQueryContext<TProps>) Creates a new instance with the specified context.
T MssqlTreeQueryable(ITreeQueryProvider, TreeQueryContext<TProps>, IFilterExpressionParser, IOrderingExpressionParser)
C MssqlTreeQueryProvider redb.MSSql.Query
M CreateTreeQueryable<TProps>(TreeQueryContext<TProps>) Creates tree queryable instance.
T MssqlTreeQueryProvider(IRedbContext, IRedbObjectSerializer, ILazyPropsLoader?, RedbServiceConfiguration?, ILogger?, ISqlDialect?, string?, ISchemeSyncProvider?)
C PostgresQueryableProvider redb.Postgres.Providers
M CreateEmptyTreeQuery<TProps>(long, long?, bool) Create empty tree query (for null rootObject case).
M CreateMultiRootTreeQuery<TProps>(long, long?, bool, List<IRedbObject>, int?) Create tree query for multiple root objects.
M CreateMultiRootTreeQueryByIds<TProps>(long, long?, bool, IEnumerable<long>, int?) Create tree query for multiple root object IDs.
M CreateTreeQuery<TProps>(long, long?, bool, long?, int?) Create DB-specific query provider for tree queries.
C PostgresTreeQueryable<TProps> redb.Postgres.Query
M CreateInstance(TreeQueryContext<TProps>) Creates a new instance with the specified context.
T PostgresTreeQueryable(ITreeQueryProvider, TreeQueryContext<TProps>, IFilterExpressionParser, IOrderingExpressionParser)
C PostgresTreeQueryProvider redb.Postgres.Query
M CreateTreeQueryable<TProps>(TreeQueryContext<TProps>) Creates tree queryable instance.
T PostgresTreeQueryProvider(IRedbContext, IRedbObjectSerializer, ILazyPropsLoader?, RedbServiceConfiguration?, ILogger?, ISqlDialect?, string?, ISchemeSyncProvider?)
C ProQueryableProvider redb.MSSql.Pro.Providers
M CreateMultiRootTreeQuery<TProps>(long, long?, bool, List<IRedbObject>, int?) Override: MultiRoot TreeQuery also uses ProTreeQueryProvider.
M CreateMultiRootTreeQueryByIds<TProps>(long, long?, bool, IEnumerable<long>, int?) Override: MultiRoot TreeQuery by IDs also uses ProTreeQueryProvider.
M CreateTreeQuery<TProps>(long, long?, bool, long?, int?) Override: Uses ProTreeQueryProvider instead of MSSqlTreeQueryProvider.
C ProQueryableProvider redb.Postgres.Pro.Providers
M CreateMultiRootTreeQuery<TProps>(long, long?, bool, List<IRedbObject>, int?) Override: MultiRoot TreeQuery also uses ProTreeQueryProvider.
M CreateMultiRootTreeQueryByIds<TProps>(long, long?, bool, IEnumerable<long>, int?) Override: MultiRoot TreeQuery by IDs also uses ProTreeQueryProvider.
M CreateTreeQuery<TProps>(long, long?, bool, long?, int?) Override: Uses ProTreeQueryProvider instead of PostgresTreeQueryProvider.
C ProTreeQueryProvider redb.MSSql.Pro.Query
M ExecuteTreeAggregateAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<AggregateRequest>) Execute tree aggregation with CTE.
M ExecuteTreeCountAsync<TProps>(TreeQueryContext<TProps>) ⚡ Pro Override: Tree Count via CTE + pvt.
M ExecuteTreeGroupByAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) Execute GROUP BY on tree with CTE.
M ExecuteTreeGroupedAggregateAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) ITreeQueryProvider implementation: Execute GROUP BY with tree context.
M ExecuteTreeGroupedWindowQueryAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>) Execute GroupBy + Window with tree context.
M ExecuteTreeToListAsync<TProps>(TreeQueryContext<TProps>) ⚡ Pro Override: Tree ToList via CTE + pvt.
M ExecuteTreeWindowAsync<TProps>(TreeQueryContext<TProps>, string, string, string, string, string?) Execute Window Functions on tree with CTE (legacy JSON version).
M ExecuteTreeWindowQueryAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?) Execute Window Functions on tree with CTE (interface implementation).
M GetSqlPreviewAsync<TProps>(TreeQueryContext<TProps>) Pro: Tree SQL Preview (DRY - uses BuildTreeQuerySqlAsync)
M GetTreeAggregateSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<AggregateRequest>) SQL Preview for Tree Aggregate (DRY - same SQL as Execute)
M GetTreeGroupBySqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) SQL Preview for Tree GroupBy (DRY - same SQL as Execute)
M GetTreeGroupedWindowSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>) Get SQL preview for tree GroupBy + Window.
M GetTreeWindowSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?) SQL Preview for Tree Window (typed interface version).
M GetTreeWindowSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, string, string, string, string, string?) SQL Preview for Tree Window (DRY - same SQL as Execute)
T ProTreeQueryProvider(IRedbContext, IRedbObjectSerializer, ILazyPropsLoader?, RedbServiceConfiguration?, ILogger?, ISqlDialect?, string?, ISchemeSyncProvider?)
C ProTreeQueryProvider redb.Postgres.Pro.Query
M ExecuteTreeAggregateAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<AggregateRequest>) Execute tree aggregation with CTE.
M ExecuteTreeCountAsync<TProps>(TreeQueryContext<TProps>) ⚡ Pro Override: Tree Count via CTE + PVT.
M ExecuteTreeGroupByAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) Execute GROUP BY on tree with CTE.
M ExecuteTreeGroupedAggregateAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) ITreeQueryProvider implementation: Execute GROUP BY with tree context.
M ExecuteTreeGroupedWindowQueryAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>) Execute Tree GroupBy + Window query.
M ExecuteTreeToListAsync<TProps>(TreeQueryContext<TProps>) ⚡ Pro Override: Tree ToList via CTE + PVT.
M ExecuteTreeWindowAsync<TProps>(TreeQueryContext<TProps>, string, string, string, string, string?) Execute Window Functions on tree with CTE (legacy JSON version).
M ExecuteTreeWindowQueryAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?) Execute Window Functions on tree with CTE (interface implementation).
M GetSqlPreviewAsync<TProps>(TreeQueryContext<TProps>) Pro: Tree SQL Preview (DRY - uses BuildTreeQuerySqlAsync)
M GetTreeAggregateSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<AggregateRequest>) SQL Preview for Tree Aggregate (DRY - same SQL as Execute)
M GetTreeGroupBySqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) SQL Preview for Tree GroupBy (DRY - same SQL as Execute)
M GetTreeGroupedWindowSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>) SQL preview for Tree GroupBy + Window.
M GetTreeWindowSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?) SQL Preview for Tree Window (typed interface version).
M GetTreeWindowSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, string, string, string, string, string?) SQL Preview for Tree Window (DRY - same SQL as Execute)
T ProTreeQueryProvider(IRedbContext, IRedbObjectSerializer, ILazyPropsLoader?, RedbServiceConfiguration?, ILogger?, ISqlDialect?, string?, ISchemeSyncProvider?)
C QueryableProviderBase redb.Core.Providers.Base
M CreateEmptyTreeQuery<TProps>(long, long?, bool) Create empty tree query (for null rootObject case).
M CreateMultiRootTreeQuery<TProps>(long, long?, bool, List<IRedbObject>, int?) Create tree query for multiple root objects.
M CreateMultiRootTreeQueryByIds<TProps>(long, long?, bool, IEnumerable<long>, int?) Create tree query for multiple root object IDs.
M CreateTreeQuery<TProps>(long, long?, bool, long?, int?) Create DB-specific query provider for tree queries.
M TreeQuery<TProps>() Create type-safe tree query by type (synchronous).
M TreeQuery<TProps>(IEnumerable<IRedbObject>, int?) Create tree query limited to subtrees of object list (synchronous).
M TreeQuery<TProps>(IEnumerable<IRedbObject>, IRedbUser, int?) Create tree query limited to subtrees of object list with specified user (synchronous).
M TreeQuery<TProps>(IEnumerable<long>, int?) Create tree query limited to subtrees by ID list (synchronous).
M TreeQuery<TProps>(IEnumerable<long>, IRedbUser, int?) Create tree query limited to subtrees by ID list with specified user (synchronous).
M TreeQuery<TProps>(IRedbObject?, int?) Create tree query limited to subtree (synchronous).
M TreeQuery<TProps>(IRedbObject?, IRedbUser, int?) Create tree query limited to subtree with specified user (synchronous).
M TreeQuery<TProps>(IRedbUser) Create type-safe tree query by type with specified user (synchronous).
M TreeQuery<TProps>(long, int?) Create tree query limited to subtree (synchronous, by ID).
M TreeQuery<TProps>(long, IRedbUser, int?) Create tree query limited to subtree with specified user (synchronous, by ID).
C RedbServiceBase redb.Core
M TreeQuery<TProps>() Create type-safe tree query by type (synchronous).
M TreeQuery<TProps>(IEnumerable<IRedbObject>, int?) Create tree query limited to subtrees of object list (synchronous).
M TreeQuery<TProps>(IEnumerable<IRedbObject>, IRedbUser, int?) Create tree query limited to subtrees of object list with specified user (synchronous).
M TreeQuery<TProps>(IEnumerable<long>, int?) Create tree query limited to subtrees by ID list (synchronous).
M TreeQuery<TProps>(IEnumerable<long>, IRedbUser, int?) Create tree query limited to subtrees by ID list with specified user (synchronous).
M TreeQuery<TProps>(IRedbObject?, int?) Create tree query limited to subtree (synchronous).
M TreeQuery<TProps>(IRedbObject?, IRedbUser, int?) Create tree query limited to subtree with specified user (synchronous).
M TreeQuery<TProps>(IRedbUser) Create type-safe tree query by type with specified user (synchronous).
M TreeQuery<TProps>(long, int?) Create tree query limited to subtree (synchronous, by ID).
M TreeQuery<TProps>(long, IRedbUser, int?) Create tree query limited to subtree with specified user (synchronous, by ID).
C TreeGroupedQueryable<TKey, TProps> redb.Core.Query.Grouping
T TreeGroupedQueryable(ITreeQueryProvider, TreeQueryContext<TProps>, Expression, string?, bool)
C TreeGroupedWindowedQueryable<TKey, TProps> redb.Core.Query.Grouping
T TreeGroupedWindowedQueryable(ITreeQueryProvider, TreeQueryContext<TProps>, Expression, GroupedWindowSpec<TKey, TProps>)
C TreeQueryableBase<TProps> redb.Core.Query.Base
M CreateInstance(TreeQueryContext<TProps>) Creates a new instance with the specified context. Override in derived classes.
T TreeQueryableBase(ITreeQueryProvider, TreeQueryContext<TProps>, IFilterExpressionParser, IOrderingExpressionParser, IFacetFilterBuilder?)
C TreeQueryContext<TProps> redb.Core.Query.Base
T TreeQueryContext(long, long?, bool, long?, int?)
C TreeQueryProviderBase redb.Core.Query.Base
M CreateTreeQuery<TProps>(long, long?, bool, long?, int?) Create tree query with hierarchical constraint support.
M CreateTreeQueryable<TProps>(TreeQueryContext<TProps>) Creates tree queryable instance. Override in derived classes.
M ExecuteOptimizedWhereHasAncestor<TProps>(TreeQueryContext<TProps>, TreeFilter) Optimized execution of WhereHasAncestor through logic inversion:
M ExecuteOptimizedWhereHasDescendant<TProps>(TreeQueryContext<TProps>, TreeFilter) Optimized execution of WhereHasDescendant through logic inversion:
M ExecuteTreeCountAsync<TProps>(TreeQueryContext<TProps>) Execute COUNT for tree query through search_tree_objects_with_facets
M ExecuteTreeGroupedAggregateAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) Execute GROUP BY with tree context (CTE for tree traversal).
M ExecuteTreeGroupedWindowQueryAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>) Execute GroupBy + Window with tree context.
M ExecuteTreeToListAsync<TProps>(TreeQueryContext<TProps>) Execute ToList for tree query through search_tree_objects_with_facets
M ExecuteTreeWindowQueryAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?) Execute Window Functions with tree context.
M GetOptimizableHasAncestorFilter<TProps>(TreeQueryContext<TProps>) Determines if WhereHasAncestor can be optimized through logic inversion
M GetOptimizableHasDescendantFilter<TProps>(TreeQueryContext<TProps>) Determines if WhereHasDescendant can be optimized through logic inversion
M GetSqlPreviewAsync<TProps>(TreeQueryContext<TProps>) Returns SQL query for tree search that will be executed (for debugging)
M GetTreeGroupBySqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) Get SQL preview for tree GROUP BY query.
M GetTreeGroupedWindowSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>) Get SQL preview for tree GroupBy + Window.
M GetTreeWindowSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?) Get SQL preview for tree window query.
M ShouldUseLazyLoading<TProps>(TreeQueryContext<TProps>) Determines if lazy loading should be used for tree query.
T TreeQueryProviderBase(IRedbContext, IRedbObjectSerializer, ISqlDialect, string?, ILazyPropsLoader?, RedbServiceConfiguration?, ILogger?, ISchemeSyncProvider?)
C TreeQuerySqlResult redb.MSSql.Pro.Query
T TreeQuerySqlResult(string, SqlParameterCollector, string?) Result of SQL generation for Tree Query
C TreeQuerySqlResult redb.Postgres.Pro.Query
T TreeQuerySqlResult(string, SqlParameterCollector, string?) Result of SQL generation for Tree Query
C TreeWindowedQueryable<TProps> redb.Core.Query.Window
T TreeWindowedQueryable(ITreeQueryProvider, TreeQueryContext<TProps>, string?, WindowSpec<TProps>) Creates tree-aware windowed queryable.