Documentation

    {{docApp.userSession.userId}}
    {{docApp.userSession.userName}}
    {{docApp.userSession.email}}
    Issuer : {{docApp.userSession.issuerInstance}}
    Expires : {{new Date(docApp.userSession.validUntil).toLocaleDateString()}}

{{docApp.title}}

{{docApp.description}}

Connect an AI assistant

Your AI assistant can read this documentation directly, so it answers from the current content instead of guessing. Add one of the servers below to your client — they use the Model Context Protocol (MCP). Each one covers a different body of content, so add the one you need.

The catalog did not load. Refresh the page to try again.

Loading…

How can we help?

{{docApp.searchError}}

Searching in {{docApp.searchFilterBySpecificBookTitle}}

 {{docApp.currentResultsSearchText}}  in {{docApp.searchFilterBySpecificBookTitle}}
Found {{docApp.searchResponse.totalResultsAvailable}} matches. Showing the top {{docApp.searchResponse.results ? docApp.searchResponse.results.length : 0}}. Use a more specific search to further narrow down the results.
No documentation pages match this search, so all content types are shown. Most matches are in {{docApp.searchDocTypeRescue.best.name}}.
There is no book with the ID "{{docApp.searchBookRescue.bid}}", so the book filter from this link was ignored and results from all books are shown.

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

  • {{resultItem.title}} {{resultItem.matchedBy === 'semantic' ? 'semantic' : (resultItem.matchedBy === 'both' ? 'keyword + semantic' : 'keyword')}}

    {{resultItem.url}}

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

{{docApp.libraryHomeViewProduct.description}}

  1. {{book.title}}

Complex Types - databaseColumnType

  • Article
  • 2 minutes to read

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.
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document