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
@autoIncrement `xs:boolean` Optional Set to ‘true’ if this column is an auto incrementing column - only applies to numeric types .
@name `xs:string` Required The name of the column.
@nullable `xs:boolean` Optional Set to ‘true’ if this column can be null.
@precision `xs:unsignedShort` Optional The precision of the number, applies to DECIMAL, FLOAT and REAL.
@primaryKey `xs:boolean` Optional Set to ‘true’ if this column is part of the primary key of the table.
@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.
@scale `xs:unsignedShort` Optional The scale of the number, applies to DECIMAL.
@size columnSizeType Optional The size of the column, this only applies to VARCHAR.
@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.
@type columnDataType Required Describes the data type of the column.
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.
contentFormat xs:string Optional Allows you to define a format to apply to the data entered into this column, Currently only xml is supported.
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.
description xs:string Optional Provides a description as to the purpose of the column.
displayName xs:string Optional Allows you to define a human-friendly name for 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.
In This Document