JSColumn

Overview

The JSColumn is a scripting object that represents a column in a data source, accessible through root objects like datasources and databaseManager. It provides methods for retrieving and managing metadata, properties, and flags associated with the column.

The object allows developers to interact with column-specific attributes such as data provider IDs, SQL names, types, lengths, and sequence configurations. It supports checking column flags, including primary key (PK_COLUMN), UUID, or tenant-specific columns, and retrieving the column’s row identifier type. Additionally, it provides access to design-time configurations like default formats, foreign key references, titles, and descriptions.

By enabling advanced operations such as quoting SQL identifiers and retrieving raw JDBC types, JSColumn ensures integration with the underlying database schema while maintaining scripting simplicity within the Servoy environment.

Constants Summarized

Type	Name	Summary
Number	DATABASE_IDENTITY	Constant used when setting or getting the sequence type of columns.
Number	DATABASE_SEQUENCE	Constant used when setting or getting the sequence type of columns.
Number	DATETIME	Constant used when setting or getting the type of columns.
Number	EXCLUDED_COLUMN	Constant used when setting or getting the flags of columns.
Number	INTEGER	Constant used when setting or getting the type of columns.
Number	MEDIA	Constant used when setting or getting the type of columns.
Number	NATIVE_COLUMN	Constant used when setting or getting the flags of columns.
Number	NONE	Constant for column information indicating unset values.
Number	NO_DATA_LOG_COLUMN	Constant used when setting or getting the flags of columns.
Number	NUMBER	Constant used when setting or getting the type of columns.
Number	PK_COLUMN	Constant used when setting or getting the row identifier type of columns.
Number	ROWID_COLUMN	Constant used when setting or getting the row identifier type of columns.
Number	TENANT_COLUMN	Constant used when setting or getting the flags of columns.
Number	TEXT	Constant used when setting or getting the type of columns.
Number	UUID_COLUMN	Constant used when setting or getting the flags of columns.
Number	UUID_GENERATOR	Constant used when setting or getting the sequence type of columns.

Methods Summarized

Type	Name	Summary
Boolean	getAllowNull()	Get the allow-null flag of the column.
String	getDataProviderID()	Get the data provider id for this column (which is the same as name if not explicitly defined otherwise).
String	getDefaultFormat()	Get the default format of the column.
String	getDescription()	Get the description property of the column.
String	getForeignType()	Get the foreign type of the column.
Number	getLength()	Get the length of the column as reported by the JDBC driver.
String	getName()	Get the name of the column as used by Servoy.
String	getQualifiedName()	Get the qualified name (including table name) of the column as known by the database.
String	getQuotedSQLName()	Returns a quoted version of the column name, if necessary, as defined by the actual database used.
String	getRawTitle()	Get the raw title property of the column.
Number	getRowIdentifierType()	Get the row identifier type of the column.
String	getSQLName()	Get the name of the column as known by the database.
Number	getSQLType()	Get the raw JDBC type of the column, which allows to check database specific types, like sting/byte column type variations.
Number	getScale()	Get the scale of the column as reported by the JDBC driver.
Number	getSequenceType()	Get the sequence type of the column.
JSTable	getTable()	Get the JSTable of this column.
String	getTitle()	Get the title property of the column.
Number	getType()	Get the JDBC type of the column.
String	getTypeAsString()	Get the name JDBC type of the column.
Boolean	hasFlag(flag)	Check a flag of the column.

Constants Detailed

DATABASE_IDENTITY

Constant used when setting or getting the sequence type of columns.

Type Number

Sample

var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
switch (column.getSequenceType())
{
case JSColumn.NONE:
	// handle column with no sequence
break;

case JSColumn.UUID_GENERATOR:
	// handle uuid generated column
break;
}

DATABASE_SEQUENCE

Constant used when setting or getting the sequence type of columns.

Type Number

Sample

var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
switch (column.getSequenceType())
{
case JSColumn.NONE:
	// handle column with no sequence
break;

case JSColumn.UUID_GENERATOR:
	// handle uuid generated column
break;
}

DATETIME

Constant used when setting or getting the type of columns.

Type Number

Sample

var table = databaseManager.getTable('db:/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;
}

EXCLUDED_COLUMN

Constant used when setting or getting the flags of columns. This flag identifies columns that are skipped in the sql.

Type Number

Sample

var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
if (column.hasFlag(JSColumn.UUID_COLUMN))
{
	// handle uuid column
}

INTEGER

Constant used when setting or getting the type of columns.

Type Number

Sample

var table = databaseManager.getTable('db:/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;
}

MEDIA

Constant used when setting or getting the type of columns.

Type Number

Sample

var table = databaseManager.getTable('db:/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;
}

NATIVE_COLUMN

Constant used when setting or getting the flags of columns. This flag identifies columns that are marked as a native type column (for example uniqueidentifier).

Type Number

Sample

var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
if (column.hasFlag(JSColumn.UUID_COLUMN))
{
	// handle uuid column
}

NONE

Constant for column information indicating unset values.

Type Number

Sample

var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
switch (column.getSequenceType())
{
case JSColumn.NONE:
	// handle column with no sequence
break;

case JSColumn.UUID_GENERATOR:
	// handle uuid generated column
break;
}

NO_DATA_LOG_COLUMN

Constant used when setting or getting the flags of columns. This flag indicates columns whose data is not stored in the log table.

Type Number

Sample

var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
if (column.hasFlag(JSColumn.UUID_COLUMN))
{
	// handle uuid column
}

NUMBER

Constant used when setting or getting the type of columns.

Type Number

Sample

var table = databaseManager.getTable('db:/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;
}

PK_COLUMN

Constant used when setting or getting the row identifier type of columns. This value identifies columns that are defined as primary key in the database.

Type Number

Sample

var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
switch (column.getRowIdentifierType())
{
case JSColumn.NONE:
	// handle normal column
break;

case JSColumn.PK_COLUMN:
	// handle database pk column
break;

case JSColumn.ROWID_COLUMN:
	// handle developer defined pk column
break;
}

ROWID_COLUMN

Constant used when setting or getting the row identifier type of columns. This value identifies columns that are defined as primary key by the developer (but not in the database).

Type Number

Sample

var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
switch (column.getRowIdentifierType())
{
case JSColumn.NONE:
	// handle normal column
break;

case JSColumn.PK_COLUMN:
	// handle database pk column
break;

case JSColumn.ROWID_COLUMN:
	// handle developer defined pk column
break;
}

TENANT_COLUMN

Constant used when setting or getting the flags of columns. This flag identifies columns that are marked as a tenant column.

Type Number

Sample

var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
if (column.hasFlag(JSColumn.UUID_COLUMN))
{
	// handle uuid column
}

TEXT

Constant used when setting or getting the type of columns.

Type Number

Sample

var table = databaseManager.getTable('db:/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;
}

UUID_COLUMN

Constant used when setting or getting the flags of columns. This flag identifies columns whose values are treated as UUID.

Type Number

Sample

var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
if (column.hasFlag(JSColumn.UUID_COLUMN))
{
	// handle uuid column
}

UUID_GENERATOR

Constant used when setting or getting the sequence type of columns.

Type Number

Sample

var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
switch (column.getSequenceType())
{
case JSColumn.NONE:
	// handle column with no sequence
break;

case JSColumn.UUID_GENERATOR:
	// handle uuid generated column
break;
}

Methods Detailed

getAllowNull()

Get the allow-null flag of the column.

Returns: Boolean boolean allow-null flag.

Sample

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

getDataProviderID()

Get the data provider id for this column (which is the same as name if not explicitly defined otherwise).

Returns: String String dataprovider id.

Sample

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

getDefaultFormat()

Get the default format of the column.

Returns: String String column default format.

Sample

var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
var format = column.getDefaultFormat()

getDescription()

Get the description property of the column.

Returns: String String column description.

Sample

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

getForeignType()

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

Returns: String String foreign type.

Sample

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

getLength()

Get the length of the column as reported by the JDBC driver.

Returns: Number int column length.

Sample

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

getName()

Get the name of the column as used by Servoy.

Returns: String String column name

Sample

var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
var colName = column.getName()

getQualifiedName()

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.

Returns: String String qualified column name.

Sample

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

getQuotedSQLName()

Returns a quoted version of the column name, if necessary, as defined by the actual database used.

Returns: String column name, quoted if needed.

Sample

//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])

getRawTitle()

Get the raw title property of the column.

Returns: String String column title.

Sample

var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customername')
var title = column.getRawTitle()

getRowIdentifierType()

Get the row identifier type of the column. The sequence type is one of: - JSColumn.PK_COLUMN - JSColumn.ROWID_COLUMN - JSColumn.NONE

Returns: Number int row identifier type.

Sample

var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
switch (column.getRowIdentifierType())
{
case JSColumn.NONE:
	// handle normal column
break;

case JSColumn.PK_COLUMN:
	// handle database pk column
break;

case JSColumn.ROWID_COLUMN:
	// handle developer defined pk column
break;
}

getSQLName()

Get the name of the column as known by the database.

Returns: String String sql name

Sample

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

getSQLType()

Get the raw JDBC type of the column, which allows to check database specific types, like sting/byte column type variations.

Returns: Number int sql type.

Sample

var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
var sqlType = column.getSQLType();

getScale()

Get the scale of the column as reported by the JDBC driver.

Returns: Number int column scale.

Sample

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

getSequenceType()

Get the sequence type of the column. The sequence type is one of: - JSColumn.NONE - JSColumn.SERVOY_SEQUENCE - JSColumn.DATABASE_SEQUENCE - JSColumn.DATABASE_IDENTITY - JSColumn.UUID_GENERATOR;

Returns: Number int sequence type.

Sample

var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
switch (column.getSequenceType())
{
case JSColumn.NONE:
	// handle column with no sequence
break;

case JSColumn.UUID_GENERATOR:
	// handle uuid generated column
break;
}

getTable()

Get the JSTable of this column.

Returns: JSTable table The JSTable of this column.

getTitle()

Get the title property of the column. If title is null will return column name.

Returns: String String column title.

Sample

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

getType()

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

Returns: Number int sql type.

Sample

var table = databaseManager.getTable('db:/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;
}

getTypeAsString()

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

Returns: String String sql name.

Sample

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

hasFlag(flag)

Check a flag of the column. The flags are a bit pattern consisting of 1 or more of the following bits: - JSColumn.UUID_COLUMN - JSColumn.EXCLUDED_COLUMN - JSColumn.TENANT_COLUMN - JSColumn.NATIVE_COLUMN

Parameters

• Number flag ;

Returns: Boolean boolean whether flag is set.

Sample

var table = databaseManager.getTable('db:/example_data/orders')
var column = table.getColumn('customerid')
if (column.hasFlag(JSColumn.UUID_COLUMN))
{
	// handle uuid column
}

---