Документация RedBase

Добро пожаловать в документацию RedBase. Обзор API, примеры кода и руководства по работе с REDB.

API Reference

Обзор документации REDB API. Выберите пространство имён или тип в дереве слева, или кликните по элементам ниже.

Результаты поиска: Select Очистить
C ArrayGroupSqlBuilder.Result redb.Core.Pro.Query.ArrayGroupSqlBuilder
C E075_Select redb.Examples.Examples
C E075_Select_ef redb.Examples.ExamplesEf
C E149_SelectProjection redb.Examples.Examples
C E149_SelectProjection_ef redb.Examples.ExamplesEf
C EffectivePermissionResult redb.Core.Models.Permissions
P CanSelect Read permission
C GroupedWindowedQueryable<TKey, TProps> redb.Core.Query.Grouping
M SelectAsync<TResult>(Expression<Func<IRedbGrouping<TKey, TProps>, TResult>>, CancellationToken) Execute query and materialize results with window functions applied to groups.
M SelectAsync<TResult>(Expression<Func<IRedbGrouping<TKey, TProps>, TResult>>) Execute query and materialize results with window functions applied to groups.
C GroupedWindowSelect redb.Core.Query.Grouping
I IGroupedWindowedQueryable<TKey, TProps> redb.Core.Query.Grouping
M SelectAsync<TResult>(Expression<Func<IRedbGrouping<TKey, TProps>, TResult>>, CancellationToken) Execute query and materialize results with window functions applied to groups.
M SelectAsync<TResult>(Expression<Func<IRedbGrouping<TKey, TProps>, TResult>>) Execute query and materialize results with window functions applied to groups.
I IPermissionProvider redb.Core.Providers
M CanUserSelectObject(IRedbObject, CancellationToken) Check if current user can read object.
M CanUserSelectObject(IRedbObject, IRedbUser) Check if user can read object.
M CanUserSelectObject(IRedbObject) Check if current user can read object.
M CanUserSelectObject(RedbObject, CancellationToken) Check if current user can read object.
M CanUserSelectObject(RedbObject, IRedbUser) Check if user can read object.
M CanUserSelectObject(RedbObject) Check if current user can read object.
M GetSelectableObjectIdsAsync(IReadOnlyCollection<long>, long, CancellationToken) The objects of objectIds the user may read, by the rule of
I IRedbGroupedQueryable<TKey, TProps> redb.Core.Query.Grouping
I IRedbPermission redb.Core.Models.Contracts
P Select Read permission (SELECT)
I IRedbQueryable<TProps> redb.Core.Query
M Select<TResult>(Expression<Func<RedbObject<TProps>, TResult>>) Project fields - return only selected properties.
I ISqlDialect redb.Core.Query
M LazyLoader_SelectObjectBase() Get object base fields (without Props). Params: $1=objectId
M LazyLoader_SelectObjectHash() Get object hash for cache validation. Params: $1=objectId
M ListItems_SelectById() SELECT list item by ID. Params: $1=itemId
M ListItems_SelectByIds() SELECT list items by their ids. Params: $1=itemIds (long[])
M ListItems_SelectByListId() SELECT list items by list ID. Params: $1=listId
M ListItems_SelectByListIdAndValue() SELECT list item by list ID and value. Params: $1=listId, $2=value
M ListItems_SelectByObjectId() SELECT list items by object reference. Params: $1=objectId
M Lists_SelectAll() SELECT all lists ordered by name.
M Lists_SelectById() SELECT list by ID. Params: $1=listId
M Lists_SelectByName() SELECT list by name. Params: $1=name
M Maintenance_SelectIndexStats() Index statistics of user tables, normalized to the alias contract above.
M Maintenance_SelectIndexStatsNoSize() Fallback form for engines where the full form may be unavailable: SQLite without the dbstat
M Maintenance_SelectStatisticsWindow() The window the usage counters cover: aliases CountersSince and IsReplica, both null where
M Maintenance_SelectTableExists() Does the table exist? Params: table name, then schema (null = the engine's default).
M Maintenance_SelectTableStats() Table statistics, normalized to the TableStatistics alias contract: Schema, Table,
M Maintenance_SelectTableStatsForms() The table-stats forms in decreasing capability, tried in order until one runs. SQLite needs
M ObjectStorage_SelectAllTypes() SELECT all types (for cache preload). No params.
M ObjectStorage_SelectExistingCreateDates() SELECT id + stored creation date of existing objects. Params: $1=objectIds (array).
M ObjectStorage_SelectExistingIds() SELECT existing object IDs from array. Params: $1=objectIds (array)
M ObjectStorage_SelectIdBySchemeValueUnique() SELECT _id of the object holding a unique key in a scheme. Params: $1=schemeId, $2=valueUnique.
M ObjectStorage_SelectIdHash() SELECT only Id and Hash for object. Params: $1=objectId
M ObjectStorage_SelectIdHashPairs() SELECT id + persisted content hash of existing objects. Params: $1=objectIds (array).
M ObjectStorage_SelectIdHashScheme() SELECT Id, Hash, IdScheme for cache check. Params: $1=objectId
M ObjectStorage_SelectObjectById() SELECT all base fields for object by ID. Params: $1=objectId
M ObjectStorage_SelectObjectsByIds() SELECT all base fields for objects by IDs. Params: $1=objectIds (array)
M ObjectStorage_SelectSchemeById() SELECT scheme by ID. Params: $1=schemeId
M ObjectStorage_SelectSchemeIdByObjectId() SELECT scheme ID for object. Params: $1=objectId
M ObjectStorage_SelectSchemeIdsForObjects() SELECT scheme IDs for objects. Params: $1=objectIds (array)
M ObjectStorage_SelectSchemesByIds() SELECT schemes by IDs. Params: $1=schemeIds (array)
M ObjectStorage_SelectStructuresWithMetadata() SELECT structure metadata by scheme ID. Params: $1=schemeId
M ObjectStorage_SelectStructureTypes() SELECT structure types by IDs. Params: $1=structureIds (array)
M ObjectStorage_SelectTypeById() SELECT type info by ID. Params: $1=typeId
M ObjectStorage_SelectValueById() SELECT single value by ID. Params: $1=valueId
M ObjectStorage_SelectValuesForObjects() SELECT all values for object IDs (ChangeTracking). Params: $1=objectIds (array)
M ObjectStorage_SelectValuesWithTypes() SELECT existing values with types. Params: $1=objectId, $2=structureIds (array)
M Permissions_SelectAllColumns() SELECT all permission columns FROM _permissions (no WHERE). Used for dynamic queries.
M Permissions_SelectById() SELECT permission by ID. Params: $1=permissionId
M Permissions_SelectByObject() SELECT permissions by object. Params: $1=objectId
M Permissions_SelectByRole() SELECT permissions by role. Params: $1=roleId
M Permissions_SelectByUser() SELECT permissions by user. Params: $1=userId
M Permissions_SelectByUserRoleObject() SELECT permission by user/role/object. Params: $1=userId, $2=roleId, $3=objectId
M Permissions_SelectReadableObjectIds() SELECT readable object IDs for user. Params: $1=userId
M Permissions_SelectUserRoleIds() SELECT user's role IDs. Params: $1=userId
M Roles_SelectAll() SELECT all roles ordered by name. Returns: Id, Name, IdConfiguration
M Roles_SelectById() SELECT role by ID. Returns: Id, Name, IdConfiguration
M Roles_SelectByName() SELECT role by name. Returns: Id, Name, IdConfiguration
M Roles_SelectConfigurationId() SELECT role configuration ID. Params: $1=roleId
M Roles_SelectIdByName() SELECT role by name. Params: $1=roleName
M Schemes_SelectAll() SELECT all schemes.
M Schemes_SelectById() SELECT scheme by ID. Params: $1=schemeId
M Schemes_SelectByName() SELECT scheme by name. Params: $1=name
M Schemes_SelectHashById() SELECT scheme hash by ID. Params: $1=schemeId
M Schemes_SelectObjectByName() SELECT Object scheme by name and type. Params: $1=name, $2=type
M SoftDelete_SelectLiveReferrersOfTrash() SQL query listing the objects of a trash container that live objects (scheme other than -10)
M Structures_SelectById() SELECT one structure by id (same columns as Structures_SelectByScheme). Params: $1=id
M Structures_SelectByScheme() SELECT full structures by scheme. Params: $1=schemeId
M Structures_SelectBySchemeCacheable() SELECT structures with cache fields by scheme. Params: $1=schemeId
M Structures_SelectBySchemeShort() SELECT structures short fields by scheme. Params: $1=schemeId
M Structures_SelectRootDuplicates() SELECT the root structures whose (_id_scheme, _name) occurs more than once, as structure rows
M Tree_SelectAncestorRows() An object and its ancestors in one statement, as rows (Id, IdParent, IdScheme, Depth; the object its...
M Tree_SelectChildrenBase() SELECT all children base fields by parent (Pro PVT polymorphic mode).
M Tree_SelectChildrenBySchemeBase() SELECT children base fields by parent and scheme (Pro PVT mode).
M Tree_SelectChildrenIds() SELECT direct child object ids only (no JSON materialization). Params: $1=parentId.
M Tree_SelectChildrenJson() SELECT children with JSON by parent and scheme. Params: $1=parentId, $2=schemeId
M Tree_SelectIdsWithAncestors() The ids of the given objects and of all their ancestors, each once, in one statement (ToTreeListAsyn...
M Tree_SelectParentId() SELECT parent_id by object ID. Params: $1=objectId
M Tree_SelectPolymorphicChildren() SELECT polymorphic children with scheme. Params: $1=parentId
M Tree_SelectSchemeAndJson() SELECT scheme and JSON for object. Params: $1=objectId
M Tree_SelectSubtreeRows() The subtree under an object in one statement: every descendant down to a depth, as rows
M Types_SelectAll() SELECT all types. Returns: _id, _name, _db_type, _type
M Types_SelectByName() SELECT type by name. Params: $1=name
M Users_SelectAllColumns() SELECT all user columns FROM _users (no WHERE). Used for dynamic search queries.
M Users_SelectByEmail() SELECT all user fields by email (case-insensitive, first match, active only).
M Users_SelectById() SELECT all user fields by ID. Params: $1=userId
M Users_SelectByIds() SELECT all user fields by IDs (batch). Params: $1=userIds (array/csv)
M Users_SelectByLogin() SELECT all user fields by login. Params: $1=login
M Users_SelectConfigurationId() SELECT user configuration ID. Params: $1=userId
M Users_SelectIdByLogin() SELECT user by login. Params: $1=login. Returns: Id
M UsersRoles_SelectRolesByUser() SELECT roles for user. Params: $1=userId. Returns: Id, Name, IdConfiguration
M UsersRoles_SelectUsersByRole() SELECT users for role. Params: $1=roleId. Returns user fields
M Validation_SelectAllTypes() SELECT all types for validation.
M Validation_SelectSchemeByName() SELECT scheme by name. Params: $1=schemeName
M Validation_SelectStructuresBySchemeId() SELECT structures by scheme ID. Params: $1=schemeId
M Values_SelectByStructure() SELECT every row of a structure (base and array-element rows alike) with RedbValue aliases.
M Values_SelectElementRowsByStructure() SELECT the ELEMENT rows of a collection structure — array index present — with their
M Values_SelectObjectIdByUnique() SELECT _id_object of the root scalar row holding a key. Params: $1=structureId, $2=unique (Guid).
M Values_SelectRootScalarsByStructure() SELECT the root scalar rows of a structure — no array parent, no array index — with their
I ISqlDialectPro redb.Core.Pro.Query
M Materialization_SelectListItemsByIds() Bulk select list items by IDs.
M Materialization_SelectObjectById() Select object by ID with all base fields.
M Materialization_SelectObjectsByIds() Bulk select objects by IDs (for nested objects).
M Materialization_SelectValuesByObjectAndStructureIds() Bulk select values by object IDs and structure IDs.
M Materialization_SelectValuesByObjectIds() Bulk select values by object IDs.
M Migration_SelectExisting() Check if migration exists.
M Migration_SelectExpressionHash() Get expression hash for migration.
M SchemeResolver_SelectChildField() Select field metadata by scheme, name, and parent structure.
M SchemeResolver_SelectRootField() Select field metadata by scheme, name, and no parent (root field).
M SchemeResolver_SelectRootFieldsIn(int) Select multiple root fields by names (IN clause).
C MsSqlDialect redb.MSSql.Sql
M LazyLoader_SelectObjectBase() Get object base fields (without Props). Params: $1=objectId
M LazyLoader_SelectObjectHash() Get object hash for cache validation. Params: $1=objectId
M ListItems_SelectById() SELECT list item by ID. Params: $1=itemId
M ListItems_SelectByIds() SELECT list items by their ids. Params: $1=itemIds (long[])
M ListItems_SelectByListId() SELECT list items by list ID. Params: $1=listId
M ListItems_SelectByListIdAndValue() SELECT list item by list ID and value. Params: $1=listId, $2=value
M ListItems_SelectByObjectId() SELECT list items by object reference. Params: $1=objectId
M Lists_SelectAll() SELECT all lists ordered by name.
M Lists_SelectById() SELECT list by ID. Params: $1=listId
M Lists_SelectByName() SELECT list by name. Params: $1=name
M Maintenance_SelectIndexStats() Index statistics of user tables, normalized to the alias contract above.
M Maintenance_SelectIndexStatsNoSize() Fallback form for engines where the full form may be unavailable: SQLite without the dbstat
M Maintenance_SelectStatisticsWindow() The window the usage counters cover: aliases CountersSince and IsReplica, both null where
M Maintenance_SelectTableExists() Does the table exist? Params: table name, then schema (null = the engine's default).
M Maintenance_SelectTableStats() Table statistics, normalized to the TableStatistics alias contract: Schema, Table,
M Maintenance_SelectTableStatsForms() The table-stats forms in decreasing capability, tried in order until one runs. SQLite needs
M ObjectStorage_SelectAllTypes() SELECT all types (for cache preload). No params.
M ObjectStorage_SelectExistingCreateDates() SELECT id + stored creation date of existing objects. Params: $1=objectIds (array).
M ObjectStorage_SelectExistingIds() SELECT existing object IDs from array. Params: $1=objectIds (array)
M ObjectStorage_SelectIdBySchemeValueUnique() SELECT _id of the object holding a unique key in a scheme. Params: $1=schemeId, $2=valueUnique.
M ObjectStorage_SelectIdHash() SELECT only Id and Hash for object. Params: $1=objectId
M ObjectStorage_SelectIdHashPairs() SELECT id + persisted content hash of existing objects. Params: $1=objectIds (array).
M ObjectStorage_SelectIdHashScheme() SELECT Id, Hash, IdScheme for cache check. Params: $1=objectId
M ObjectStorage_SelectObjectById() SELECT all base fields for object by ID. Params: $1=objectId
M ObjectStorage_SelectObjectsByIds() SELECT all base fields for objects by IDs. Params: $1=objectIds (array)
M ObjectStorage_SelectSchemeById() SELECT scheme by ID. Params: $1=schemeId
M ObjectStorage_SelectSchemeIdByObjectId() SELECT scheme ID for object. Params: $1=objectId
M ObjectStorage_SelectSchemeIdsForObjects() SELECT scheme IDs for objects. Params: $1=objectIds (array)
M ObjectStorage_SelectSchemesByIds() SELECT schemes by IDs. Params: $1=schemeIds (array)
M ObjectStorage_SelectStructuresWithMetadata() SELECT structure metadata by scheme ID. Params: $1=schemeId
M ObjectStorage_SelectStructureTypes() SELECT structure types by IDs. Params: $1=structureIds (array)
M ObjectStorage_SelectTypeById() SELECT type info by ID. Params: $1=typeId
M ObjectStorage_SelectValueById() SELECT single value by ID. Params: $1=valueId
M ObjectStorage_SelectValuesForObjects() SELECT all values for object IDs (ChangeTracking). Params: $1=objectIds (array)
M ObjectStorage_SelectValuesWithTypes() SELECT existing values with types. Params: $1=objectId, $2=structureIds (array)
M Permissions_SelectAllColumns() SELECT all permission columns FROM _permissions (no WHERE). Used for dynamic queries.
M Permissions_SelectById() SELECT permission by ID. Params: $1=permissionId
M Permissions_SelectByObject() SELECT permissions by object. Params: $1=objectId
M Permissions_SelectByRole() SELECT permissions by role. Params: $1=roleId
M Permissions_SelectByUser() SELECT permissions by user. Params: $1=userId
M Permissions_SelectByUserRoleObject() MSSQL equivalent of IS NOT DISTINCT FROM.
M Permissions_SelectReadableObjectIds() SELECT readable object IDs for user. Params: $1=userId
M Permissions_SelectUserRoleIds() SELECT user's role IDs. Params: $1=userId
M Roles_SelectAll() SELECT all roles ordered by name. Returns: Id, Name, IdConfiguration
M Roles_SelectById() SELECT role by ID. Returns: Id, Name, IdConfiguration
M Roles_SelectByName() SELECT role by name. Returns: Id, Name, IdConfiguration
M Roles_SelectConfigurationId() SELECT role configuration ID. Params: $1=roleId
M Roles_SelectIdByName() SELECT role by name. Params: $1=roleName
M Schemes_SelectAll() SELECT all schemes.
M Schemes_SelectById() SELECT scheme by ID. Params: $1=schemeId
M Schemes_SelectByName() SELECT scheme by name. Params: $1=name
M Schemes_SelectHashById() SELECT scheme hash by ID. Params: $1=schemeId
M Schemes_SelectObjectByName() SELECT Object scheme by name and type. Params: $1=name, $2=type
M SoftDelete_SelectLiveReferrersOfTrash() Objects of a trash container referenced by live objects, with the referencing objects.
M Structures_SelectById() SELECT one structure by id (same columns as Structures_SelectByScheme). Params: $1=id
M Structures_SelectByScheme() SELECT full structures by scheme. Params: $1=schemeId
M Structures_SelectBySchemeCacheable() SELECT structures with cache fields by scheme. Params: $1=schemeId
M Structures_SelectBySchemeShort() SELECT structures short fields by scheme. Params: $1=schemeId
M Structures_SelectRootDuplicates() SELECT the root structures whose (_id_scheme, _name) occurs more than once, as structure rows
M Tree_SelectAncestorRows() An object and its ancestors in one statement, as rows (Id, IdParent, IdScheme, Depth; the object its...
M Tree_SelectChildrenBase() SELECT all children base fields by parent (Pro PVT polymorphic mode).
M Tree_SelectChildrenBySchemeBase() SELECT children base fields by parent and scheme (Pro PVT mode).
M Tree_SelectChildrenIds() SELECT direct child object ids only (no JSON materialization). Params: $1=parentId.
M Tree_SelectChildrenJson() SELECT children with JSON by parent and scheme. Params: $1=parentId, $2=schemeId
M Tree_SelectIdsWithAncestors() The ids of the given objects and of all their ancestors, each once, in one statement (ToTreeListAsyn...
M Tree_SelectParentId() SELECT parent_id by object ID. Params: $1=objectId
M Tree_SelectPolymorphicChildren() SELECT polymorphic children with scheme. Params: $1=parentId
M Tree_SelectSchemeAndJson() SELECT scheme and JSON for object. Params: $1=objectId
M Tree_SelectSubtreeRows() The subtree under an object in one statement: every descendant down to a depth, as rows
M Types_SelectAll() SELECT all types. Returns: _id, _name, _db_type, _type
M Types_SelectByName() SELECT type by name. Params: $1=name
M Users_SelectAllColumns() SELECT all user columns FROM _users (no WHERE). Used for dynamic search queries.
M Users_SelectByEmail() SELECT all user fields by email (case-insensitive, first match, active only).
M Users_SelectById() SELECT all user fields by ID. Params: $1=userId
M Users_SelectByIds() SELECT all user fields by IDs (batch). Params: $1=userIds (array/csv)
M Users_SelectByLogin() SELECT all user fields by login. Params: $1=login
M Users_SelectConfigurationId() SELECT user configuration ID. Params: $1=userId
M Users_SelectIdByLogin() SELECT user by login. Params: $1=login. Returns: Id
M UsersRoles_SelectRolesByUser() SELECT roles for user. Params: $1=userId. Returns: Id, Name, IdConfiguration
M UsersRoles_SelectUsersByRole() SELECT users for role. Params: $1=roleId. Returns user fields
M Validation_SelectAllTypes() SELECT all types for validation.
M Validation_SelectSchemeByName() SELECT scheme by name. Params: $1=schemeName
M Validation_SelectStructuresBySchemeId() SELECT structures by scheme ID. Params: $1=schemeId
M Values_SelectByStructure() SELECT every row of a structure (base and array-element rows alike) with RedbValue aliases.
M Values_SelectElementRowsByStructure() SELECT the ELEMENT rows of a collection structure — array index present — with their
M Values_SelectObjectIdByUnique() SELECT _id_object of the root scalar row holding a key. Params: $1=structureId, $2=unique (Guid).
M Values_SelectRootScalarsByStructure() SELECT the root scalar rows of a structure — no array parent, no array index — with their
C ObjectStorageProviderBase redb.Core.Providers.Base
M SelectExistingAndTakeCreateDatesAsync(List<IRedbObject>, CancellationToken) Ids of the objects that exist in the database. Each existing object takes its stored
E PermissionAction redb.Core.Models.Enums
T Select Read permission
E PermissionFlags redb.Core.Models.Permissions
T Select Read permission (SELECT)
C PermissionFlagsExtensions redb.Core.Models.Permissions
M CanSelect(PermissionFlags) Check if has read permission
C PermissionProviderBase redb.Core.Providers.Base
M CanUserSelectObject(IRedbObject, CancellationToken) Check if current user can read object.
M CanUserSelectObject(IRedbObject, IRedbUser) Check if user can read object.
M CanUserSelectObject(IRedbObject) Check if current user can read object.
M CanUserSelectObject(RedbObject, CancellationToken) Check if current user can read object.
M CanUserSelectObject(RedbObject, IRedbUser) Check if user can read object.
M CanUserSelectObject(RedbObject) Check if current user can read object.
M GetSelectableObjectIdsAsync(IReadOnlyCollection<long>, long, CancellationToken) The objects of objectIds the user may read, by the rule of
C PermissionRecord redb.Export.Models
P Select SELECT permission flag.
C PermissionRequest redb.Core.Models.Permissions
P CanSelect Read permission
C PostgreSqlDialect redb.Postgres.Sql
M LazyLoader_SelectObjectBase() Get object base fields (without Props). Params: $1=objectId
M LazyLoader_SelectObjectHash() Get object hash for cache validation. Params: $1=objectId
M ListItems_SelectById() SELECT list item by ID. Params: $1=itemId
M ListItems_SelectByIds() SELECT list items by their ids. Params: $1=itemIds (long[])
M ListItems_SelectByListId() SELECT list items by list ID. Params: $1=listId
M ListItems_SelectByListIdAndValue() SELECT list item by list ID and value. Params: $1=listId, $2=value
M ListItems_SelectByObjectId() SELECT list items by object reference. Params: $1=objectId
M Lists_SelectAll() SELECT all lists ordered by name.
M Lists_SelectById() SELECT list by ID. Params: $1=listId
M Lists_SelectByName() SELECT list by name. Params: $1=name
M Maintenance_SelectIndexStats() Index statistics of user tables, normalized to the alias contract above.
M Maintenance_SelectIndexStatsNoSize() Fallback form for engines where the full form may be unavailable: SQLite without the dbstat
M Maintenance_SelectStatisticsWindow() The window the usage counters cover: aliases CountersSince and IsReplica, both null where
M Maintenance_SelectTableExists() Does the table exist? Params: table name, then schema (null = the engine's default).
M Maintenance_SelectTableStats() Table statistics, normalized to the TableStatistics alias contract: Schema, Table,
M Maintenance_SelectTableStatsForms() The table-stats forms in decreasing capability, tried in order until one runs. SQLite needs
M ObjectStorage_SelectAllTypes() SELECT all types (for cache preload). No params.
M ObjectStorage_SelectExistingCreateDates() SELECT id + stored creation date of existing objects. Params: $1=objectIds (array).
M ObjectStorage_SelectExistingIds() SELECT existing object IDs from array. Params: $1=objectIds (array)
M ObjectStorage_SelectIdBySchemeValueUnique() SELECT _id of the object holding a unique key in a scheme. Params: $1=schemeId, $2=valueUnique.
M ObjectStorage_SelectIdHash() SELECT only Id and Hash for object. Params: $1=objectId
M ObjectStorage_SelectIdHashPairs() SELECT id + persisted content hash of existing objects. Params: $1=objectIds (array).
M ObjectStorage_SelectIdHashScheme() SELECT Id, Hash, IdScheme for cache check. Params: $1=objectId
M ObjectStorage_SelectObjectById() SELECT all base fields for object by ID. Params: $1=objectId
M ObjectStorage_SelectObjectsByIds() SELECT all base fields for objects by IDs. Params: $1=objectIds (array)
M ObjectStorage_SelectSchemeById() SELECT scheme by ID. Params: $1=schemeId
M ObjectStorage_SelectSchemeIdByObjectId() SELECT scheme ID for object. Params: $1=objectId
M ObjectStorage_SelectSchemeIdsForObjects() SELECT scheme IDs for objects. Params: $1=objectIds (array)
M ObjectStorage_SelectSchemesByIds() SELECT schemes by IDs. Params: $1=schemeIds (array)
M ObjectStorage_SelectStructuresWithMetadata() SELECT structure metadata by scheme ID. Params: $1=schemeId
M ObjectStorage_SelectStructureTypes() SELECT structure types by IDs. Params: $1=structureIds (array)
M ObjectStorage_SelectTypeById() SELECT type info by ID. Params: $1=typeId
M ObjectStorage_SelectValueById() SELECT single value by ID. Params: $1=valueId
M ObjectStorage_SelectValuesForObjects() SELECT all values for object IDs (ChangeTracking). Params: $1=objectIds (array)
M ObjectStorage_SelectValuesWithTypes() SELECT existing values with types. Params: $1=objectId, $2=structureIds (array)
M Permissions_SelectAllColumns() SELECT all permission columns FROM _permissions (no WHERE). Used for dynamic queries.
M Permissions_SelectById() SELECT permission by ID. Params: $1=permissionId
M Permissions_SelectByObject() SELECT permissions by object. Params: $1=objectId
M Permissions_SelectByRole() SELECT permissions by role. Params: $1=roleId
M Permissions_SelectByUser() SELECT permissions by user. Params: $1=userId
M Permissions_SelectByUserRoleObject() SELECT permission by user/role/object. Params: $1=userId, $2=roleId, $3=objectId
M Permissions_SelectReadableObjectIds() SELECT readable object IDs for user. Params: $1=userId
M Permissions_SelectUserRoleIds() SELECT user's role IDs. Params: $1=userId
M Roles_SelectAll() SELECT all roles ordered by name. Returns: Id, Name, IdConfiguration
M Roles_SelectById() SELECT role by ID. Returns: Id, Name, IdConfiguration
M Roles_SelectByName() SELECT role by name. Returns: Id, Name, IdConfiguration
M Roles_SelectConfigurationId() SELECT role configuration ID. Params: $1=roleId
M Roles_SelectIdByName() SELECT role by name. Params: $1=roleName
M Schemes_SelectAll() SELECT all schemes.
M Schemes_SelectById() SELECT scheme by ID. Params: $1=schemeId
M Schemes_SelectByName() SELECT scheme by name. Params: $1=name
M Schemes_SelectHashById() SELECT scheme hash by ID. Params: $1=schemeId
M Schemes_SelectObjectByName() SELECT Object scheme by name and type. Params: $1=name, $2=type
M SoftDelete_SelectLiveReferrersOfTrash() Objects of a trash container referenced by live objects, with the referencing objects.
M Structures_SelectById() SELECT one structure by id (same columns as Structures_SelectByScheme). Params: $1=id
M Structures_SelectByScheme() SELECT full structures by scheme. Params: $1=schemeId
M Structures_SelectBySchemeCacheable() SELECT structures with cache fields by scheme. Params: $1=schemeId
M Structures_SelectBySchemeShort() SELECT structures short fields by scheme. Params: $1=schemeId
M Structures_SelectRootDuplicates() SELECT the root structures whose (_id_scheme, _name) occurs more than once, as structure rows
M Tree_SelectAncestorRows() An object and its ancestors in one statement, as rows (Id, IdParent, IdScheme, Depth; the object its...
M Tree_SelectChildrenBase() SELECT all children base fields by parent (Pro PVT polymorphic mode).
M Tree_SelectChildrenBySchemeBase() SELECT children base fields by parent and scheme (Pro PVT mode).
M Tree_SelectChildrenIds() SELECT direct child object ids only (no JSON materialization). Params: $1=parentId.
M Tree_SelectChildrenJson() SELECT children with JSON by parent and scheme. Params: $1=parentId, $2=schemeId
M Tree_SelectIdsWithAncestors() The ids of the given objects and of all their ancestors, each once, in one statement (ToTreeListAsyn...
M Tree_SelectParentId() SELECT parent_id by object ID. Params: $1=objectId
M Tree_SelectPolymorphicChildren() SELECT polymorphic children with scheme. Params: $1=parentId
M Tree_SelectSchemeAndJson() SELECT scheme and JSON for object. Params: $1=objectId
M Tree_SelectSubtreeRows() The subtree under an object in one statement: every descendant down to a depth, as rows
M Types_SelectAll() SELECT all types. Returns: _id, _name, _db_type, _type
M Types_SelectByName() SELECT type by name. Params: $1=name
M Users_SelectAllColumns() SELECT all user columns FROM _users (no WHERE). Used for dynamic search queries.
M Users_SelectByEmail() SELECT all user fields by email (case-insensitive, first match, active only).
M Users_SelectById() SELECT all user fields by ID. Params: $1=userId
M Users_SelectByIds() SELECT all user fields by IDs (batch). Params: $1=userIds (array/csv)
M Users_SelectByLogin() SELECT all user fields by login. Params: $1=login
M Users_SelectConfigurationId() SELECT user configuration ID. Params: $1=userId
M Users_SelectIdByLogin() SELECT user by login. Params: $1=login. Returns: Id
M UsersRoles_SelectRolesByUser() SELECT roles for user. Params: $1=userId. Returns: Id, Name, IdConfiguration
M UsersRoles_SelectUsersByRole() SELECT users for role. Params: $1=roleId. Returns user fields
M Validation_SelectAllTypes() SELECT all types for validation.
M Validation_SelectSchemeByName() SELECT scheme by name. Params: $1=schemeName
M Validation_SelectStructuresBySchemeId() SELECT structures by scheme ID. Params: $1=schemeId
M Values_SelectByStructure() SELECT every row of a structure (base and array-element rows alike) with RedbValue aliases.
M Values_SelectElementRowsByStructure() SELECT the ELEMENT rows of a collection structure — array index present — with their
M Values_SelectObjectIdByUnique() SELECT _id_object of the root scalar row holding a key. Params: $1=structureId, $2=unique (Guid).
M Values_SelectRootScalarsByStructure() SELECT the root scalar rows of a structure — no array parent, no array index — with their
C ProMsSqlDialect redb.MSSql.Pro.Sql
M Materialization_SelectListItemsByIds() Bulk select list items by IDs.
M Materialization_SelectObjectById() Select object by ID with all base fields.
M Materialization_SelectObjectsByIds() Bulk select objects by IDs (for nested objects).
M Materialization_SelectValuesByObjectAndStructureIds() Bulk select values by object IDs and structure IDs.
M Materialization_SelectValuesByObjectIds() Bulk select values by object IDs.
M Migration_SelectExisting() Check if migration exists.
M Migration_SelectExpressionHash() Get expression hash for migration.
M SchemeResolver_SelectChildField() Select field metadata by scheme, name, and parent structure.
M SchemeResolver_SelectRootField() Select field metadata by scheme, name, and no parent (root field).
M SchemeResolver_SelectRootFieldsIn(int) Select multiple root fields by names (IN clause).
C ProPostgreSqlDialect redb.Postgres.Pro.Sql
M Materialization_SelectListItemsByIds() Bulk select list items by IDs.
M Materialization_SelectObjectById() Select object by ID with all base fields.
M Materialization_SelectObjectsByIds() Bulk select objects by IDs (for nested objects).
M Materialization_SelectValuesByObjectAndStructureIds() Bulk select values by object IDs and structure IDs.
M Materialization_SelectValuesByObjectIds() Bulk select values by object IDs.
M Migration_SelectExisting() Check if migration exists.
M Migration_SelectExpressionHash() Get expression hash for migration.
M SchemeResolver_SelectChildField() Select field metadata by scheme, name, and parent structure.
M SchemeResolver_SelectRootField() Select field metadata by scheme, name, and no parent (root field).
M SchemeResolver_SelectRootFieldsIn(int) Select multiple root fields by names (IN clause).
C PvtSqlGenerator redb.MSSql.Pro.Query
M GenerateDrivenStreamsSelect(IReadOnlyList<FieldInfo>, string, string, string) The bare SELECT of the streams source driven by the rows of an open CTE that exposes the object id a...
M GeneratePvtSelect(IReadOnlyList<FieldInfo>, string) Generates PVT subquery for SELECT (data retrieval) - T-SQL syntax.
M GenerateTreeStreamsSelect(IReadOnlyList<FieldInfo>, string, string?, IReadOnlyCollection<string>?, bool, string) The bare SELECT of the streams source over an open tree CTE, for a caller that writes
C PvtSqlGenerator redb.Postgres.Pro.Query
M GenerateDrivenStreamsSelect(IReadOnlyList<FieldInfo>, string, string, string) The bare SELECT of the streams source driven by the rows of an open CTE that exposes the object id a...
M GeneratePvtSelect(IReadOnlyList<FieldInfo>, string) Generates PVT subquery for SELECT (data retrieval).
M GenerateTreeStreamsSelect(IReadOnlyList<FieldInfo>, string, string?, IReadOnlyCollection<string>?, string) The bare SELECT of the streams source over an open tree CTE, for a caller that writes
C RedbGroupedQueryable<TKey, TProps> redb.Core.Query.Grouping
C RedbPermission redb.Core.Models.Entities
P Select SELECT (read) permission.
C RedbQueryable<TProps> redb.Core.Query
M Select<TResult>(Expression<Func<RedbObject<TProps>, TResult>>) Project fields - return only selected properties.
C RedbServiceBase redb.Core
M CanUserSelectObject(IRedbObject, CancellationToken) Check if current user can read object.
M CanUserSelectObject(IRedbObject, IRedbUser) Check if user can read object.
M CanUserSelectObject(IRedbObject) Check if current user can read object.
M CanUserSelectObject(RedbObject, CancellationToken) Check if current user can read object.
M CanUserSelectObject(RedbObject, IRedbUser) Check if user can read object.
M CanUserSelectObject(RedbObject) Check if current user can read object.
C SchemeBrowser redb.PropsEditor.Components
P OnSchemeSelected Called when a scheme is selected.
C TreeGroupedQueryable<TKey, TProps> redb.Core.Query.Grouping
M SelectAsync<TResult>(Expression<Func<IRedbGrouping<TKey, TProps>, TResult>>) Execute query and materialize results with window functions applied to groups.
C TreeWindowedQueryable<TProps> redb.Core.Query.Window
M SelectAsync<TResult>(Expression<Func<RedbObject<TProps>, TResult>>, CancellationToken) Execute window query with tree context and materialize results.
M SelectAsync<TResult>(Expression<Func<RedbObject<TProps>, TResult>>) Execute window query with tree context and materialize results.
C UserPermissionResult redb.Core.Models.Permissions
C VUserPermission redb.Core.Models.Permissions