{{docApp.title}}

{{docApp.description}}

Filter

Clear All

Books

All
{{book.title}}
{{book.foundCount}} 0

Products

{{product.name}} {{docApp.searchFilteredProducts[product.id].returnedCount}}

{{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!

{{resultItem.title}}

{{resultItem.url}}

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

{{docApp.libraryHomeViewProduct.description}}

{{book.title}}

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

{{group.description}}

{{book.title}}

{{group.title}}

{{book.title}}

More...

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

{{tocItem.eleText}}