Page History

...

padding	0px
width	80px

...

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Method Summary

...

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

...

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

...

Returns the table name.

...

Table Cell (td)
String

...

Returns the Servoy server name.

...

Table Cell (td)
Boolean

...

id

HTML Table
Returns whether table was flagged as metadata table.

...

servoy sDetail

function

class

Colgroup Tag

Column

padding	0px
width	100%

Table Row (tr)

style

Table Row (tr)

id	name

Table Cell (td)
getColumn

Table Row (tr)

id	sig

Table Cell (td)

Span

style	margin-right: 5px;

JSColumn

Span

style	font-weight: bold;

getColumn

Span

2100%

height:30px

;

Table Head (th)

colspan	1

Method Details

Table Body (tbody)

id	getColumn-String

id

2

Methods Details

getColumn

name

getColumn(name)

Table Row (tr)

des

Table Cell (td) Divclass

sIndent

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

Table Row (tr)idtd

prsclassParameters DivsIndent{String} name – The name of the column to return the value from. Table Row (tr)idret Table Cell (td)
Returns DivclassJSColumn – sIndentid JSColumn column.clients Table Row (tr)
Supported Clients
sIndentSmartClient,WebClient,NGClientsam Table Cell (td) Table Row (tr)
class lastDetailRow
 Table Cell (td) Table Body (tbody)id getColumnNames
 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.
 Table Row (tr)
id ret
 Table Cell (td)
Returns
 Div
class sIndent
String[] – String array of column names.
 Table Row (tr)
id sam
 Table Cell (td)
Sample
 Div
class sIndent
 Code Block
language javascript

var jsTable = databaseManager.getTable('udm', 'campaigns')
var columnNames = jsTable.getColumnNames()
 Table Row (tr)class lastDetailRow
 Table Cell (td) Table Body (tbody)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()
 Table Row (tr)class lastDetailRow
 Table Cell (td) Table Body (tbody)id getQuotedSQLName
 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.
 Table Row (tr)id ret
 Table Cell (td)Returns
 Divclass sIndent
String – String Sample Div
class sIndent
 Code Block
language javascript

var jsTable = databaseManager.getTable('udm', 'campaigns')
var jsColumn = jsTable.getColumn('campaign_name')
idsIdentjavascriptlastDetailRowgetColumnNamesnamegetColumnNames()dessIndentReturns an array containing the names of all table columns.
If the table is in mem, then the internal rowid column name is not returned.retReturns
sIndent String array of column names.clientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowgetDataSourcenamegetDataSource()dessIndentReturns the table data source uri.retReturns
sIndent String datasource uri.clientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowgetQuotedSQLNamenamegetQuotedSQLName()dessIndentReturns a quoted version of the table name, if necessary, as defined by the actual database used.retReturns
sIndent String table name, quoted if needed.clients Table Row (tr)
Supported Clients
sIndentSmartClient,WebClient,NGClientsam Table Cell (td) Table Row (tr)
class lastDetailRow
 Table Cell (td) Table Body (tbody)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).
 Table Row (tr)id ret
 Table Cell (td)Returns
 Divclass sIndent
String[] – String 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()
plugins.rawSQL.executeSQL('udm',  quotedTableName,  'select * from ' + quotedTableName + ' where is_active = ?', [1])
 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()
 Table Row (tr)class lastDetailRow
tdsIdentjavascriptlastDetailRowgetRowIdentifierColumnNamesnamegetRowIdentifierColumnNames()dessIndentReturns 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.retReturns
sIndent String array of row identifier column names.clients
 Table Row (tr)
id sam
 Table Cell (td)
Sample
 Div
class sIndent
 Code Block
language javascript

var jsTable = databaseManager.getTable('udm', 'campaigns')
var identifierColumnNames = jsTable.getRowIdentifierColumnNames()
 Table Row (tr)class lastDetailRow
 Table Cell (td) Table Body (tbody)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()
 Table Row (tr)class lastDetailRow
 Table Cell (td) Table Body (tbody)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()
 Table Row (tr)class lastDetailRow
 Table Cell (td) Table Body (tbody)id isMetadataTable
Supported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowgetSQLNamenamegetSQLName()dessIndentReturns the table name.retReturns
sIndent String table name.clientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowgetServerNamenamegetServerName()dessIndentReturns the Servoy server name.retReturns
sIndent String server name.clientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRowisMetadataTablenameisMetadataTable()dessIndentReturns whether table was flagged as metadata table.retReturns
sIndent boolean is metadataclientsSupported Clients
sIndentSmartClient,WebClient,NGClientsamSample
sIdentjavascriptlastDetailRow

Child pages

Versions Compared

Old Version 20

New Version Current

Key

getColumn

getColumn(name)

getColumnNames

getDataSource

getQuotedSQLName

getColumnNames()

getDataSource()

getQuotedSQLName()

getRowIdentifierColumnNames

isMetadataTable

getRowIdentifierColumnNames()

getSQLName

getServerName

getSQLName()

getServerName()

isMetadataTable()