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