RedBase Documentation

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

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: Select Clear search
C E075_Select redb.Examples.Examples
C E149_SelectProjection redb.Examples.Examples
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>>) Execute query and materialize results with window functions applied to groups.
I IGroupedWindowedQueryable<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.
I IPermissionProvider redb.Core.Providers
M CanUserSelectObject(IRedbObject, IRedbUser) Check if user can read object.
M CanUserSelectObject(IRedbObject) 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.
I IRedbGroupedQueryable<TKey, TProps> redb.Core.Query.Grouping
M SelectAsync<TResult>(Expression<Func<IRedbGrouping<TKey, TProps>, TResult>>) Executes projection with aggregations for each group.
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_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 ObjectStorage_SelectAllTypes() SELECT all types (for cache preload). No params.
M ObjectStorage_SelectExistingIds() SELECT existing object IDs from array. Params: $1=objectIds (array)
M ObjectStorage_SelectIdHash() SELECT only Id and Hash for object. Params: $1=objectId
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_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 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 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_SelectChildrenJson() SELECT children with JSON by parent and scheme. Params: $1=parentId, $2=schemeId
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 Types_SelectAll() SELECT all types. Returns: _id, _name, _db_type, _type
M Types_SelectByName() SELECT type by name. Params: $1=name
M Users_SelectById() SELECT all user fields by ID. Params: $1=userId
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
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_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 ObjectStorage_SelectAllTypes() SELECT all types (for cache preload). No params.
M ObjectStorage_SelectExistingIds() SELECT existing object IDs from array. Params: $1=objectIds (array)
M ObjectStorage_SelectIdHash() SELECT only Id and Hash for object. Params: $1=objectId
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_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 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 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_SelectChildrenJson() SELECT children with JSON by parent and scheme. Params: $1=parentId, $2=schemeId
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 Types_SelectAll() SELECT all types. Returns: _id, _name, _db_type, _type
M Types_SelectByName() SELECT type by name. Params: $1=name
M Users_SelectById() SELECT all user fields by ID. Params: $1=userId
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
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, IRedbUser) Check if user can read object.
M CanUserSelectObject(IRedbObject) 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 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_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 ObjectStorage_SelectAllTypes() SELECT all types (for cache preload). No params.
M ObjectStorage_SelectExistingIds() SELECT existing object IDs from array. Params: $1=objectIds (array)
M ObjectStorage_SelectIdHash() SELECT only Id and Hash for object. Params: $1=objectId
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_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 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 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_SelectChildrenJson() SELECT children with JSON by parent and scheme. Params: $1=parentId, $2=schemeId
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 Types_SelectAll() SELECT all types. Returns: _id, _name, _db_type, _type
M Types_SelectByName() SELECT type by name. Params: $1=name
M Users_SelectById() SELECT all user fields by ID. Params: $1=userId
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
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 GeneratePvtSelect(IReadOnlyList<FieldInfo>, string) Generates PVT subquery for SELECT (data retrieval) - T-SQL syntax.
C PvtSqlGenerator redb.Postgres.Pro.Query
M GeneratePvtSelect(IReadOnlyList<FieldInfo>, string) Generates PVT subquery for SELECT (data retrieval).
M SelectAsync<TResult>(Expression<Func<IRedbGrouping<TKey, TItem>, TResult>>) Executes projection with aggregations for each group.
C RedbGroupedQueryable<TKey, TProps> redb.Core.Query.Grouping
M SelectAsync<TResult>(Expression<Func<IRedbGrouping<TKey, TProps>, TResult>>) Executes projection with aggregations for each group.
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, IRedbUser) Check if user can read object.
M CanUserSelectObject(IRedbObject) 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 TreeGroupedQueryable<TKey, TProps> redb.Core.Query.Grouping
M SelectAsync<TResult>(Expression<Func<IRedbGrouping<TKey, TProps>, TResult>>) Executes projection with aggregations for each group.
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>>) Execute window query with tree context and materialize results.
C UserPermissionResult redb.Core.Models.Permissions
C VUserPermission redb.Core.Models.Permissions