Documentation

{{docApp.title}}

{{docApp.description}}

How can we help?

{{docApp.searchError}}
{{product.name}}

Searching in {{docApp.searchFilterBySpecificBookTitle}}

{{docApp.searchResultFilteredItems.length}} results for: {{docApp.currentResultsSearchText}} in {{docApp.searchFilterBySpecificBookTitle}}
Search results have been limited. There are a total of {{docApp.searchResponse.totalResultsAvailable}} matches.

You have an odd number of " characters in your search terms - each one needs closing with a matching " character!

{{docApp.libraryHomeViewProduct.title || docApp.libraryHomeViewProduct.id}}

{{docApp.libraryHomeViewProduct.description}}

  1. {{book.title}}

{{group.title || group.id}}

{{group.description}}

  1. {{book.title}}

{{group.title}}

Complex Types - databaseColumnType

Description

Information about extended meta data settings available for each column.

Properties

Name Type Occurrence Description
@reportExclude xs:boolean Optional Set this to “true” if you want to exclude this column from general reporting. The purpose of this option is to reduce the column selections available to users not using the advanced mode.
@sysExclude xs:boolean Optional Set this to ‘true’ if you want to exclude this column from the application settings. This will be ignored if the “sysRequired” property is set to ‘true’.
@sysRequired xs:boolean Optional Set to yes if the column is required by the system. Marking a column required means it can not be hidded through application schema or soft (administrative) settings.
@primaryKey xs:boolean Optional Set to ‘true’ if this column is part of the primary key of the table.
@nullable xs:boolean Optional Set to ‘true’ if this column can be null.
@autoIncrement xs:boolean Optional Set to ‘true’ if this column is an auto incrementing column - only applies to numeric types .
@scale xs:unsignedShort Optional The scale of the number, applies to DECIMAL.
@precision xs:unsignedShort Optional The precision of the number, applies to DECIMAL, FLOAT and REAL.
@size columnSizeType Optional The size of the column, this only applies to VARCHAR.
@type columnDataType Required Describes the data type of the column.
@name xs:string Required The name of the column.
displayName xs:string Optional Allows you to define a human-friendly name for the column.
description xs:string Optional Provides a description as to the purpose of the column.
formatter xs:string Optional Allows you to define a specific formatter to apply to the value held in this column when displaying the value in a list or report or on a form.
contentFormat xs:string Optional Allows you to define a format to apply to the data entered into this column, Currently only xml is supported.
autoValInsert xs:string Optional If you need to generate a sequence number for a column when inserting a new record, you can assign a system or custom defined auto value to it by setting this value.
autoValUpdate xs:string Optional If you need to generate a auto value for a column when updating and existing record, you can assign a system or custom defined auto value to it by setting this value.
defaultValue xs:string Optional The value that is applied to this column when creating a new record and no value for this column was specified by the application.
In This Document