Types
AggregationRtQuery
Inheritance: System-2.0.9/Entity-1 ➔ System-2.0.9/PersistentQuery-1 ➔ System-2.0.9/AggregationRtQuery-1
Query type for performing aggregation operations (Count, Min, Max, Avg, Sum) on entity data without grouping.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/AggregationQueryColumns | False | ||
| System-2/Query.FieldFilter | True | ||
| System-2/Query.TextSearchFilter | True | ||
| System-2/Query.AttributeSearchFilter | True |
AggregationSdQuery
Inheritance: System-2.0.9/Entity-1 ➔ System-2.0.9/PersistentQuery-1 ➔ System-2.0.9/StreamDataQuery-1 ➔ System-2.0.9/AggregationSdQuery-1
Persistent stream-data query that performs aggregation operations (Count, Min, Max, Avg, Sum) on time-series data without grouping.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/AggregationQueryColumns | False |
AutoIncrement
Inheritance: System-2.0.9/Entity-1 ➔ System-2.0.9/AutoIncrement-1
Manages auto-incrementing sequences for generating unique identifiers with configurable format and range.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/AutoIncrement.End | False | ||
| System-2/AutoIncrement.Format | True | ||
| System-2/AutoIncrement.CurrentValue | False |
Configuration
Inheritance: System-2.0.9/Entity-1 ➔ System-2.0.9/Configuration-1
Base type for all configuration types
DownsamplingSdQuery
Inheritance: System-2.0.9/Entity-1 ➔ System-2.0.9/PersistentQuery-1 ➔ System-2.0.9/StreamDataQuery-1 ➔ System-2.0.9/DownsamplingSdQuery-1
Persistent stream-data query that downsamples time-series data using DATE_BIN bucketing with per-column aggregation (AVG, MIN, MAX). From, To, and Limit (bucket count) are required at the API level even though the schema marks them optional on the base.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/AggregationQueryColumns | False |
Entity
Inheritance: System-2.0.9/Entity-1
Abstract base type for all entities in the system. Provides common indexing and association capabilities.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/RtBlueprintSource | True | ||
| System-2/RtBlueprintLocked | True | ||
| System-2/RtBlueprintAppliedAt | True |
Outbound Associations
| Outbound Name | Outbound Multiplicity | CkRoleId | TargetCKTypeId | Target Attributes |
|---|---|---|---|---|
| RelatesTo | N | System-2/Related | System-2/Entity |
Inbound Associations
| Inbound Name | Inbound Multiplicity | CkRoleId | TargetCKTypeId | Target Attributes |
|---|---|---|---|---|
| RelatesFrom | N | System-2/Related | System-2/Entity |
GroupingAggregationRtQuery
Inheritance: System-2.0.9/Entity-1 ➔ System-2.0.9/PersistentQuery-1 ➔ System-2.0.9/GroupingAggregationRtQuery-1
Query type for performing grouped aggregation operations with GROUP BY functionality on entity data.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/Query.GroupByColumns | False | ||
| System-2/AggregationQueryColumns | False | ||
| System-2/Query.FieldFilter | True | ||
| System-2/Query.TextSearchFilter | True | ||
| System-2/Query.AttributeSearchFilter | True |
GroupingAggregationSdQuery
Inheritance: System-2.0.9/Entity-1 ➔ System-2.0.9/PersistentQuery-1 ➔ System-2.0.9/StreamDataQuery-1 ➔ System-2.0.9/GroupingAggregationSdQuery-1
Persistent stream-data query that performs grouped aggregation with GROUP BY functionality on time-series data.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/Query.GroupByColumns | False | ||
| System-2/AggregationQueryColumns | False |
MigrationHistory
Inheritance: System-2.0.9/Entity-1 ➔ System-2.0.9/MigrationHistory-1
Records executed CK model migrations per tenant. Each instance represents one migration execution from a source version to a target version.
PersistentQuery
Inheritance: System-2.0.9/Entity-1 ➔ System-2.0.9/PersistentQuery-1
Abstract base type for all query types. Defines common query properties like name, description, and target type.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/Name | False | ||
| System-2/Description | True | ||
| System-2/Query.CkTypeId | False | ||
| System-2/Query.NavigationFilterMode | True |
SimpleRtQuery
Inheritance: System-2.0.9/Entity-1 ➔ System-2.0.9/PersistentQuery-1 ➔ System-2.0.9/SimpleRtQuery-1
Query type for retrieving rows/tuples from entities with support for column selection, sorting, and filtering.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/Query.Columns | False | ||
| System-2/Query.Sorting | True | ||
| System-2/Query.FieldFilter | True | ||
| System-2/Query.TextSearchFilter | True | ||
| System-2/Query.AttributeSearchFilter | True |
SimpleSdQuery
Inheritance: System-2.0.9/Entity-1 ➔ System-2.0.9/PersistentQuery-1 ➔ System-2.0.9/StreamDataQuery-1 ➔ System-2.0.9/SimpleSdQuery-1
Persistent stream-data query that retrieves time-series rows for a given CK type with optional column projection, sorting, and field filters.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/StreamDataQuery.Columns | False | ||
| System-2/Query.Sorting | True |
StreamDataQuery
Inheritance: System-2.0.9/Entity-1 ➔ System-2.0.9/PersistentQuery-1 ➔ System-2.0.9/StreamDataQuery-1
Abstract base for stream-data query types. Carries the common time-range, limit, rtId scope, and field-filter attributes shared by all concrete SdQuery subtypes.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/StreamDataQuery.RtIds | True | ||
| System-2/StreamDataQuery.From | True | ||
| System-2/StreamDataQuery.To | True | ||
| System-2/StreamDataQuery.Limit | True | ||
| System-2/Query.FieldFilter | True |
Tenant
Inheritance: System-2.0.9/Entity-1 ➔ System-2.0.9/Tenant-1
Represents a tenant in the multi-tenant system with its unique identifier, parent relationship, and database mapping.
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/TenantId | False | ||
| System-2/ParentTenantId | True | ||
| System-2/DatabaseName | False |
TenantConfiguration
Inheritance: System-2.0.9/Entity-1 ➔ System-2.0.9/Configuration-1 ➔ System-2.0.9/TenantConfiguration-1
Configuration for a tenant regarding data version of schema or identity data
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/ConfigurationValue | True |
TenantModeConfiguration
Inheritance: System-2.0.9/Entity-1 ➔ System-2.0.9/Configuration-1 ➔ System-2.0.9/TenantModeConfiguration-1
Configuration for a tenant if the tenant is in a specific mode, e.g. test mode or maintenance mode
| ID | Auto Complete Values | Auto Increment Reference | Is Optional |
|---|---|---|---|
| System-2/EnvironmentMode | False | ||
| System-2/MaintenanceLevel | False |