Page History

Hidden

DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY, UNLESS YOU KNOW WHAT YOU'RE DOING.
		THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO EXTRACT CHANGES FROM THE PAGE AND MERGE THEM BACK INTO SERVOY SOURCE

HTML Table

class	servoy sSummary

Colgroup Tag

Column

padding	0px
width	80px

Column

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Constants Summary

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)
#DATETIME Constant used when setting or getting the type of columns.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)
#INTEGER Constant used when setting or getting the type of columns.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)
#MEDIA Constant used when setting or getting the type of columns.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)
#NUMBER Constant used when setting or getting the type of columns.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)
#TEXT Constant used when setting or getting the type of columns.

HTML Table

class	servoy sSummary

Colgroup Tag

Column

padding	0px
width	80px

Column

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Method Summary

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Boolean

Table Cell (td)
#getAllowNull() Get the allow-null flag of the column.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#getDataProviderID() Get the data provider id (name) for this column.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#getDescription() Get the description property of the column.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#getForeignType() Get the foreign type of the column.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)
#getLength() Get the length of the column as reported by the JDBC driver.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#getQualifiedName() Get the qualified name (including table name) of the column as known by the database.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#getQuotedSQLName() Returns a quoted version of the column name, if necessary, as defined by the actual database used.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#getSQLName() Get the name of the column as known by the database.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)
#getScale() Get the scale of the column as reported by the JDBC driver.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#getTitle() Get the title property of the column.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Number

Table Cell (td)
#getType() Get the JDBC type of the column.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#getTypeAsString() Get the name JDBC type of the column.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Boolean

Table Cell (td)
#isRowIdentifier() Is this column one of the row identifiers for its table.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
Boolean

Table Cell (td)
#isUUID() Is this column marked as UUID column.

HTML Table

id	constant
class	servoy sDetail

Colgroup Tag

Column

padding	0px
width	100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

Constants Details

Table Body (tbody)

id	DATETIME
class	node

Table Row (tr)

id	name

Table Cell (td)
DATETIME

Table Row (tr)

id	des

Table Cell (td)
Constant used when setting or getting the type of columns.

Table Row (tr)

id	ret

Table Cell (td)
Returns Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
switch (column.getType())
{
case JSColumn.TEXT:
	// handle text column
break;

case JSColumn.NUMBER:
case JSColumn.INTEGER:
	// handle numerical column
break;
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	INTEGER
class	node

Table Row (tr)

id	name

Table Cell (td)
INTEGER

Table Row (tr)

id	des

Table Cell (td)
Constant used when setting or getting the type of columns.

Table Row (tr)

id	ret

Table Cell (td)
Returns Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
switch (column.getType())
{
case JSColumn.TEXT:
	// handle text column
break;

case JSColumn.NUMBER:
case JSColumn.INTEGER:
	// handle numerical column
break;
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	MEDIA
class	node

Table Row (tr)

id	name

Table Cell (td)
MEDIA

Table Row (tr)

id	des

Table Cell (td)
Constant used when setting or getting the type of columns.

Table Row (tr)

id	ret

Table Cell (td)
Returns Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
switch (column.getType())
{
case JSColumn.TEXT:
	// handle text column
break;

case JSColumn.NUMBER:
case JSColumn.INTEGER:
	// handle numerical column
break;
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	NUMBER
class	node

Table Row (tr)

id	name

Table Cell (td)
NUMBER

Table Row (tr)

id	des

Table Cell (td)
Constant used when setting or getting the type of columns.

Table Row (tr)

id	ret

Table Cell (td)
Returns Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
switch (column.getType())
{
case JSColumn.TEXT:
	// handle text column
break;

case JSColumn.NUMBER:
case JSColumn.INTEGER:
	// handle numerical column
break;
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	TEXT
class	node

Table Row (tr)

id	name

Table Cell (td)
TEXT

Table Row (tr)

id	des

Table Cell (td)
Constant used when setting or getting the type of columns.

Table Row (tr)

id	ret

Table Cell (td)
Returns Number

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
switch (column.getType())
{
case JSColumn.TEXT:
	// handle text column
break;

case JSColumn.NUMBER:
case JSColumn.INTEGER:
	// handle numerical column
break;
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

HTML Table

id	function
class	servoy sDetail

Colgroup Tag

Column

padding	0px
width	100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

Method Details

Table Body (tbody)

id	getAllowNull
class	node

Table Row (tr)

id	name

Table Cell (td)
getAllowNull

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

Boolean

Span

style	float: left; font-weight: bold;
id	iets

getAllowNull

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

Table Cell (td)
Get the allow-null flag of the column.

Table Row (tr)

id	ret

Table Cell (td)
Returns Boolean – boolean allow-null flag.

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
if (!column.getAllowNull())
{
	 // column cannot be null
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getDataProviderID
class	node

Table Row (tr)

id	name

Table Cell (td)
getDataProviderID

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

getDataProviderID

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

Table Cell (td)
Get the data provider id (name) for this column.

Table Row (tr)

id	ret

Table Cell (td)
Returns String – String dataprovider id.

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
var dataProviderId = column.getDataProviderID()

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getDescription
class	node

Table Row (tr)

id	name

Table Cell (td)
getDescription

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

getDescription

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

Table Cell (td)
Get the description property of the column.

Table Row (tr)

id	ret

Table Cell (td)
Returns String – String column description.

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customername')
var desc = column.getDescription()

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getForeignType
class	node

Table Row (tr)

id	name

Table Cell (td)
getForeignType

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

getForeignType

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

Table Cell (td)
Get the foreign type of the column. The foreign type can be defined design time as a foreign key reference to another table.

Table Row (tr)

id	ret

Table Cell (td)
Returns String – String foreign type.

Table Row (tr)

id	see

Table Cell (td)

Also see

Div

class	sIndent

databaseManager.mergeRecords

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
var foreignType = column.getForeignType()
if (foreignType != null)
{
	var fkTable = databaseManager.getTable('example_data', foreignType)
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getLength
class	node

Table Row (tr)

id	name

Table Cell (td)
getLength

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

Number

Span

style	float: left; font-weight: bold;
id	iets

getLength

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

Table Cell (td)
Get the length of the column as reported by the JDBC driver.

Table Row (tr)

id	ret

Table Cell (td)
Returns Number – int column length.

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customername')
if (column.getLength() < 10)
{
	 // handle short column
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getQualifiedName
class	node

Table Row (tr)

id	name

Table Cell (td)
getQualifiedName

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

getQualifiedName

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

Table Cell (td)
Get the qualified name (including table name) of the column as known by the database. The name is quoted, if necessary, as defined by the actual database used.

Table Row (tr)

id	ret

Table Cell (td)
Returns String – String qualified column name.

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
var qualifiedSqlName = column.getQualifiedName()

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getQuotedSQLName
class	node

Table Row (tr)

id	name

Table Cell (td)
getQuotedSQLName

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

getQuotedSQLName

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

Table Cell (td)
Returns a quoted version of the column name, if necessary, as defined by the actual database used.

Table Row (tr)

id	ret

Table Cell (td)
Returns String – column name, quoted if needed.

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

//use with the raw SQL plugin:
//if the table name contains characters that are illegal in sql, the table name will be quoted
var jsTable = databaseManager.getTable('udm', 'campaigns')
var quotedTableName = jsTable.getQuotedSQLName()
var jsColumn = jsTable.getColumn('active')
var quotedColumnName = jsColumn.getQuotedSQLName()
plugins.rawSQL.executeSQL('udm',  quotedTableName,  'select * from ' + quotedTableName + ' where ' + quotedColumnName + ' = ?', [1])

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getSQLName
class	node

Table Row (tr)

id	name

Table Cell (td)
getSQLName

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

getSQLName

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

Table Cell (td)
Get the name of the column as known by the database.

Table Row (tr)

id	ret

Table Cell (td)
Returns String – String sql name

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
var sqlName = column.getSQLName()

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getScale
class	node

Table Row (tr)

id	name

Table Cell (td)
getScale

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

Number

Span

style	float: left; font-weight: bold;
id	iets

getScale

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

Table Cell (td)
Get the scale of the column as reported by the JDBC driver.

Table Row (tr)

id	ret

Table Cell (td)
Returns Number – int column scale.

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customername')
var scale = column.getScale()

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getTitle
class	node

Table Row (tr)

id	name

Table Cell (td)
getTitle

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

getTitle

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

Table Cell (td)
Get the title property of the column.

Table Row (tr)

id	ret

Table Cell (td)
Returns String – String column title.

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customername')
var title = column.getTitle()

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getType
class	node

Table Row (tr)

id	name

Table Cell (td)
getType

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

Number

Span

style	float: left; font-weight: bold;
id	iets

getType

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

Table Cell (td)
Get the JDBC type of the column. The type reported by the JDBC driver will be mapped to one of: - JSColumn.DATETIME - JSColumn.TEXT - JSColumn.NUMBER - JSColumn.INTEGER - JSColumn.MEDIA

Table Row (tr)

id	ret

Table Cell (td)
Returns Number – int sql type.

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
switch (column.getType())
{
case JSColumn.TEXT:
	// handle text column
break;

case JSColumn.NUMBER:
case JSColumn.INTEGER:
	// handle numerical column
break;
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	getTypeAsString
class	node

Table Row (tr)

id	name

Table Cell (td)
getTypeAsString

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

String

Span

style	float: left; font-weight: bold;
id	iets

getTypeAsString

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

Table Cell (td)
Get the name JDBC type of the column. The same mapping as defined in JSColumn.getType() is applied.

Table Row (tr)

id	ret

Table Cell (td)
Returns String – String sql name.

Table Row (tr)

id	see

Table Cell (td)

Also see

Div

class	sIndent

.getType

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
var typeName = column.getTypeAsString()

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	isRowIdentifier
class	node

Table Row (tr)

id	name

Table Cell (td)
isRowIdentifier

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

Boolean

Span

style	float: left; font-weight: bold;
id	iets

isRowIdentifier

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

Table Cell (td)
Is this column one of the row identifiers for its table.

Table Row (tr)

id	ret

Table Cell (td)
Returns Boolean – boolean true if is row identifier else false.

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('orderid')
if (column.isRowIdentifier())
{
	 // handle pk column
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	isUUID
class	node

Table Row (tr)

id	name

Table Cell (td)
isUUID

Table Row (tr)

id	sig

Table Cell (td)

Span

style	float: left; margin-right: 5px;

Boolean

Span

style	float: left; font-weight: bold;
id	iets

isUUID

Span

style	float: left;
id	iets

()

Table Row (tr)

id	des

Table Cell (td)
Is this column marked as UUID column.

Table Row (tr)

id	ret

Table Cell (td)
Returns Boolean – boolean true if is marked as UUID columns else false.

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('orderid')
if (column.isUUID())
{
	 // handle UUID column
}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Child pages

Versions Compared

Old Version 15

New Version Current

Key

DATETIME

INTEGER

MEDIA

NUMBER

TEXT

getAllowNull

getDataProviderID

getDescription

getForeignType

getLength

getQualifiedName

getQuotedSQLName

getSQLName

getScale

getTitle

getType

getTypeAsString

isRowIdentifier

isUUID