Page History

...

Table Cell (td)
JSColumn

...

DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY (EXCEPT INSIDE THE DIV BELOW WITH ID=DESCRIPTION), UNLESS YOU KNOW WHAT YOU'RE DOING.
THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO AUTO UPDATE THE CONTENT THROUGH THE DOC GENERATOR.
Enter additional information related to this 'class' inside the {div} macro with 'id=description'

Divcache

styleindex	display:none

...

id	description

...

padding	0px
width	80px

...

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Method Summary

true
refresh	100d
showRefresh	true
id	doc
title	Refresh page
showDate	true
retry	Enable

servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClient

servoy sSummary12%30%58%height: 30px;3Methods SummaryReturns a JSColumn for the named column (or column dataproviderID).

...

Table Cell (td)
String[]

...

Returns an array containing the names of all table columns.

...

Table Cell (td)
String

...

Returns the table data source uri.

...

Table Cell (td)
String

...

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

...

Table Cell (td)
String[]

...

Returns an array containing the names of the identifier (PK) column(s).

...

Table Cell (td)
String

...

Table Cell (td)
String

...

Returns the table name.

...

Returns the Servoy server name.

...

Table Cell (td)
Boolean

Returns whether table was flagged as metadata table.

...

function

...

servoy sDetail

...

padding	0px
width	100%

...

2100%

height:30px

...

Table Head (th)

colspan	1

Method Details

...

id	getColumn-String

Table Row (tr)

id	name

Table Cell (td)
getColumn

...

id	sig

...

Span

style	margin-right: 5px;

JSColumn

Span

style	font-weight: bold;

getColumn

...

2

Methods Details

getColumn

name

getColumn(name)

...

des

...

sIndent

Returns a JSColumn for the named column (or column dataproviderID).

...

prs

...

Parameters

...

sIndent

...

name

...

The name of the column to return the value from.

...

ret

...

Returns

...

sIndent

...

Table Row (tr)

id	name

Table Cell (td)
getColumnNames

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

String[]

Span

style	font-weight: bold;

getColumnNames

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Returns an array containing the names of all table columns.

...

id	ret

...

class	sIndent

...

JSColumn column.

clients

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var jsTable = databaseManager.getTable('udm', 'campaigns')
var jsColumn = jsTable.getColumn('campaign_name')

...

class	lastDetailRow

...

id	getColumnNames

...

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

getColumnNames

name

getColumnNames()

des

sIndent

Returns an array containing the names of all table columns.
If the table is in mem, then the internal rowid column name is not returned.

ret

Returns

sIndent

String array of column names.

clients

...

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

...

Table Row (tr)

id	name

Table Cell (td)
getQuotedSQLName

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

String

Span

style	font-weight: bold;

getQuotedSQLName

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

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

...

id	ret

...

class	sIndent

...

Sample

...

class	sIndent

...

Code Block

language	javascript

var jsTable = databaseManager.getTable('udm', 'campaigns')
var columnNames = jsTable.getColumnNames()

...

class	lastDetailRow

...

id	getDataSource

Table Row (tr)

id	name

Table Cell (td)
getDataSource

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

String

Span

style	font-weight: bold;

getDataSource

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Returns the table data source uri.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String - String datasource uri.

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var jsTable = databaseManager.getTable('udm', 'campaigns')
var dataSource = jsTable.getDataSource()

...

class	lastDetailRow

...

id	getQuotedSQLName

...

sIdent

javascript

lastDetailRow

getDataSource

name

getDataSource()

des

sIndent

Returns the table data source uri.

ret

Returns

sIndent

String datasource uri.

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

getQuotedSQLName

name

getQuotedSQLName()

des

sIndent

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

ret

Returns

sIndent

String table name, quoted if needed.

clients

...

id	sam

...

class	lastDetailRow

...

id	getRowIdentifierColumnNames

Table Row (tr)

id	name

Table Cell (td)
getRowIdentifierColumnNames

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

String[]

Span

style	font-weight: bold;

getRowIdentifierColumnNames

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Returns an array containing the names of the identifier (PK) column(s).

...

id	ret

...

class	sIndent

...

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

...

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()
plugins.rawSQL.executeSQL('udm',  quotedTableName,  'select * from ' + quotedTableName + ' where is_active = ?', [1])

...

sIdent

javascript

lastDetailRow

getRowIdentifierColumnNames

name

getRowIdentifierColumnNames()

des

sIndent

Returns an array containing the names of the identifier (PK) column(s).
 Please note that if the table is in mem, then the internal rowid column name is also returned.

ret

Returns

sIndent

String array of row identifier column names.

clients

...

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

...

class	lastDetailRow

...

id	getServerName

Table Row (tr)

id	name

Table Cell (td)
getServerName

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

String

Span

style	font-weight: bold;

getServerName

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Returns the Servoy server name.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String - String server name.

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var jsTable = databaseManager.getTable('udm', 'campaigns')
var serverName = jsTable.getServerName()

...

class	lastDetailRow

...

id	isMetadataTable

Table Row (tr)

id	name

Table Cell (td)
isMetadataTable

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

Boolean

Span

style	font-weight: bold;

isMetadataTable

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Returns whether table was flagged as metadata table.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

Boolean - boolean is metadata

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var jsTable = databaseManager.getTable('udm', 'campaigns')
var isMetaDataTable = jsTable.isMetadataTable()

...

class	lastDetailRow

...

Sample

...

class	sIndent

...

Code Block

language	javascript

var jsTable = databaseManager.getTable('udm', 'campaigns')
var identifierColumnNames = jsTable.getRowIdentifierColumnNames()

...

class	lastDetailRow

...

id	getSQLName

Table Row (tr)

id	name

Table Cell (td)
getSQLName

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

String

Span

style	font-weight: bold;

getSQLName

Span
()

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Returns the table name.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String - String table name.

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

var jsTable = databaseManager.getTable('udm', 'campaigns')
var tableNameForDisplay = jsTable.getSQLName()

sIdent

javascript

lastDetailRow

getSQLName

name

getSQLName()

des

sIndent

Returns the table name.

ret

Returns

sIndent

String table name.

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

getServerName

name

getServerName()

des

sIndent

Returns the Servoy server name.

ret

Returns

sIndent

String server name.

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

isMetadataTable

name

isMetadataTable()

des

sIndent

Returns whether table was flagged as metadata table.

ret

Returns

sIndent

boolean is metadata

clients

Supported Clients

sIndent

SmartClient,WebClient,NGClient

sam

Sample

sIdent

javascript

lastDetailRow

Child pages

Versions Compared

Old Version 21

New Version Current

Key

getColumn

getColumn(name)

getColumnNames

getColumnNames()

getQuotedSQLName

getDataSource

getDataSource()

getQuotedSQLName()

getRowIdentifierColumnNames

getRowIdentifierColumnNames()

getServerName

isMetadataTable

getSQLName

getSQLName()

getServerName()

isMetadataTable()