--- title: "CHGResultOfViewStatements" url: "https://developer.tesma.com/apis/logistics-api-26/versions/484d1e1b-3201-4f8b-800b-867280d5b6a4/schemas/CHGResultOfViewStatements" --- > Full API specification: https://developer.tesma.com/apis/logistics-api-26/versions/484d1e1b-3201-4f8b-800b-867280d5b6a4.md # CHGResultOfViewStatements ## OpenAPI definition ```yaml openapi: 3.1.1 info: title: " API v1" version: 26.13.0.0 components: schemas: CHGMessage: anyOf: - $ref: "#/components/schemas/CHGMessageTextMessage" - $ref: "#/components/schemas/CHGMessageExternalMessage" - $ref: "#/components/schemas/CHGMessageCHGExceptionMessage" - $ref: "#/components/schemas/CHGMessageBase" type: object ViewStatements: properties: statementTables: items: $ref: "#/components/schemas/StatementTable" type: - "null" - array viewId: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string type: object CHGMessageTextMessage: properties: $type: enum: - CHG.iCLASSFW.Base.Foundation.TextMessage, CHG.iCLASSFW.Base.Foundation type: string _additionalInfos: type: - "null" - string _message: type: - "null" - string _messageLogId: type: - "null" - string _messageType: $ref: "#/components/schemas/MessageType" _traceId: type: - "null" - string errorCategory: type: - "null" - string errorCode: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string formatArguments: type: - "null" - array messageKey: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string messageLogId: type: - "null" - string source: type: - "null" - string sourceObjectIdentifier: $ref: "#/components/schemas/ObjectInstanceIdentifier" traceId: type: - "null" - string required: - $type - _messageType CHGMessageExternalMessage: properties: $type: enum: - CHG.iCLASSFW.Base.Foundation.ExternalMessage, CHG.iCLASSFW.Base.Foundation type: string _additionalInfos: type: - "null" - string _message: type: - "null" - string _messageLogId: type: - "null" - string _messageType: $ref: "#/components/schemas/MessageType" _traceId: type: - "null" - string errorCategory: type: - "null" - string errorCode: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string formatArguments: type: - "null" - array messageKey: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string messageLogId: type: - "null" - string source: type: - "null" - string sourceObjectIdentifier: $ref: "#/components/schemas/ObjectInstanceIdentifier" traceId: type: - "null" - string required: - $type - _messageType CHGMessageCHGExceptionMessage: properties: $type: enum: - CHG.iCLASSFW.Base.Foundation.CHGExceptionMessage, CHG.iCLASSFW.Base.Foundation type: string _additionalInfos: type: - "null" - string _messageLogId: type: - "null" - string _messageType: $ref: "#/components/schemas/MessageType" _traceId: type: - "null" - string additionalInfos: type: - "null" - string errorCategory: type: - "null" - string errorCode: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string formatArguments: type: - "null" - array message: type: - "null" - string messageKey: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string messageLogId: type: - "null" - string source: type: - "null" - string sourceObjectIdentifier: $ref: "#/components/schemas/ObjectInstanceIdentifier" traceId: type: - "null" - string required: - $type - _messageType CHGMessageBase: properties: _additionalInfos: type: - "null" - string _messageLogId: type: - "null" - string _messageType: $ref: "#/components/schemas/MessageType" _traceId: type: - "null" - string errorCategory: type: - "null" - string errorCode: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string formatArguments: type: - "null" - array messageKey: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string messageLogId: type: - "null" - string source: type: - "null" - string sourceObjectIdentifier: $ref: "#/components/schemas/ObjectInstanceIdentifier" traceId: type: - "null" - string required: - _messageType StatementTable: properties: _changedProperties: type: - "null" - object _changedPropertyNames: items: type: string type: - "null" - array _internalReferenceID: type: - "null" - string additionalProperties: type: - "null" - object childTables: items: $ref: "#/components/schemas/StatementTable" type: - "null" - array condition: type: - "null" - string dataState: $ref: "#/components/schemas/BusinessObjectState" joinType: $ref: "#/components/schemas/SqlJoinTypes" joins: items: $ref: "#/components/schemas/StatementJoin" type: - "null" - array level: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string parentTable: $ref: "#/components/schemas/StatementTable" parentTableID: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string sortIndex: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string tableID: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string tableName: type: - "null" - string viewID: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string type: object MessageType: type: integer ObjectInstanceIdentifier: properties: keyValues: type: - "null" - object referenceID: type: - "null" - string typeName: type: - "null" - string type: object BusinessObjectState: type: integer SqlJoinTypes: type: integer StatementJoin: properties: _changedProperties: type: - "null" - object _changedPropertyNames: items: type: string type: - "null" - array _internalReferenceID: type: - "null" - string additionalProperties: type: - "null" - object childField: $ref: "#/components/schemas/Field" childFieldID: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string childTableID: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string dataState: $ref: "#/components/schemas/BusinessObjectState" parentField: $ref: "#/components/schemas/Field" parentFieldID: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string viewID: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string type: object Field: properties: businessObjectID: type: - "null" - string canBeSelected: type: boolean canBeUpdated: type: boolean caption: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string contentType: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string databaseAccessMode: $ref: "#/components/schemas/DatabaseAccessMode" decimalPlaces: format: int16 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string format: type: - "null" - string fullName: type: - "null" - string id: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string ignoreForChangeLog: type: boolean internalSchemaDataType: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - "null" - integer - string isClonable: type: boolean isPartOfPrimaryKey: type: boolean isRequired: type: boolean length: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string lookupID: type: - "null" - string maxValue: format: int64 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string metaDataType: $ref: "#/components/schemas/MetaDataType" minValue: format: int64 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string name: type: - "null" - string nextNumName: type: - "null" - string propertyName: type: - "null" - string schemaCharacterLength: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - "null" - integer - string schemaDataType: $ref: "#/components/schemas/SqlServerTypeId" schemaIsNullable: type: boolean schemaPrecision: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - "null" - integer - string schemaScale: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - "null" - integer - string securityFieldID: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string tableName: type: - "null" - string tooltip: format: int32 pattern: ^-?(?:0|[1-9]\d*)$ type: - integer - string type: $ref: "#/components/schemas/SqlDataType" type: object DatabaseAccessMode: type: integer MetaDataType: type: integer SqlServerTypeId: type: integer SqlDataType: type: integer CHGResultOfViewStatements: properties: messages: items: $ref: "#/components/schemas/CHGMessage" type: - "null" - array response: $ref: "#/components/schemas/ViewStatements" type: object ```