Table Row (tr) |
---|
| Table Head (th) |
---|
| Method Details |
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getAllowNull |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Boolean |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getAllowNull |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Get the allow-null flag of the column. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Boolean – boolean allow-null flag. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
|
|
|
|
| switchgetTypecase JSColumn.TEXT:
handle textbreak;case JSColumn.NUMBER:
case JSColumn.INTEGER:
// handle numerical column
break;
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=MEDIA|class=node}{tr:id=name}{td}h6.MEDIA{td}{tr}{tr:id=des}{td}{sub-section:MEDIA_des|text=|trigger=button}{sub-section}{sub-section:MEDIA_des|trigger=none|class=sIndent}Constant used when setting or getting the type of columns.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:MEDIA_snc|text=|trigger=button}{sub-section}{sub-section:MEDIA_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:MEDIA_prs|text=|trigger=button}{sub-section}{sub-section:MEDIA_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:MEDIA_ret|text=|trigger=button}{sub-section}{sub-section:MEDIA_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:MEDIA_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:MEDIA_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:MEDIA_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:MEDIA_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:MEDIA_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:MEDIA_sam|trigger=none}{code:language=javascript} Table Body (tbody) |
---|
id | getDataProviderID |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getDataProviderID |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| String |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getDataProviderID |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Get the data provider id (name) for this column. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns String – String dataprovider id. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
var dataProviderId = column.getDataProviderID()
|
|
|
|
|
Table Body (tbody) |
---|
id | getDescription |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getDescription |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| String |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getDescription |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Get the description property of the column. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns String – String column description. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customername')
var desc = column.getDescription()
|
|
|
|
|
Table Body (tbody) |
---|
id | getForeignType |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getForeignType |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| String |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getForeignType |
|
|
Table Row (tr) |
---|
| 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) |
---|
| Table Cell (td) |
---|
Returns String – String foreign type. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
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 Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Number |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getLength |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Get the length of the column as reported by the JDBC driver. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Number – int column length. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn(' |
|
|
|
| customeridswitchgetTypecase JSColumn.TEXT:
textbreak;
case JSColumn.NUMBER:
case JSColumn.INTEGER:
// handle numerical column
break;
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=NUMBER|class=node}{tr:id=name}{td}h6.NUMBER{td}{tr}{tr:id=des}{td}{sub-section:NUMBER_des|text=|trigger=button}{sub-section}{sub-section:NUMBER_des|trigger=none|class=sIndent}Constant used when setting or getting the type of columns.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:NUMBER_snc|text=|trigger=button}{sub-section}{sub-section:NUMBER_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:NUMBER_prs|text=|trigger=button}{sub-section}{sub-section:NUMBER_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:NUMBER_ret|text=|trigger=button}{sub-section}{sub-section:NUMBER_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:NUMBER_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:NUMBER_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:NUMBER_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:NUMBER_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:NUMBER_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:NUMBER_sam|trigger=none}{code: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;
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TEXT|class=node}{tr:id=name}{td}h6.TEXT{td}{tr}{tr:id=des}{td}{sub-section:TEXT_des|text=|trigger=button}{sub-section}{sub-section:TEXT_des|trigger=none|class=sIndent}Constant used when setting or getting the type of columns.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:TEXT_snc|text=|trigger=button}{sub-section}{sub-section:TEXT_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:TEXT_prs|text=|trigger=button}{sub-section}{sub-section:TEXT_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:TEXT_ret|text=|trigger=button}{sub-section}{sub-section:TEXT_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:TEXT_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:TEXT_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:TEXT_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:TEXT_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:TEXT_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:TEXT_sam|trigger=none}{code: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;
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}\\
{table:id=function|class=servoy sDetail}{colgroup}{column:padding=0px|width=100%}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Method Details{th}{tr}{tbody:id=getAllowNull|class=node}{tr:id=name}{td}h6.getAllowNull{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}getAllowNull{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getAllowNull_des|text=|trigger=button}{sub-section}{sub-section:getAllowNull_des|trigger=none|class=sIndent}Get the allow\-null flag of the column.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getAllowNull_snc|text=|trigger=button}{sub-section}{sub-section:getAllowNull_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getAllowNull_prs|text=|trigger=button}{sub-section}{sub-section:getAllowNull_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getAllowNull_ret|text=|trigger=button}{sub-section}{sub-section:getAllowNull_ret|trigger=none|class=sIndent}[Boolean] -- boolean allow-null flag.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getAllowNull_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getAllowNull_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getAllowNull_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getAllowNull_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getAllowNull_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getAllowNull_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
if (!column.getAllowNull())
{
// column cannot be null
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getDataProviderID|class=node}{tr:id=name}{td}h6.getDataProviderID{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[String]{span}{span:id=iets|style=float: left; font-weight: bold;}getDataProviderID{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getDataProviderID_des|text=|trigger=button}{sub-section}{sub-section:getDataProviderID_des|trigger=none|class=sIndent}Get the data provider id (name) for this column.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getDataProviderID_snc|text=|trigger=button}{sub-section}{sub-section:getDataProviderID_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getDataProviderID_prs|text=|trigger=button}{sub-section}{sub-section:getDataProviderID_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getDataProviderID_ret|text=|trigger=button}{sub-section}{sub-section:getDataProviderID_ret|trigger=none|class=sIndent}[String] -- String dataprovider id.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getDataProviderID_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getDataProviderID_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getDataProviderID_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getDataProviderID_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getDataProviderID_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getDataProviderID_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
var dataProviderId = column.getDataProviderID()
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getDescription|class=node}{tr:id=name}{td}h6.getDescription{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[String]{span}{span:id=iets|style=float: left; font-weight: bold;}getDescription{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getDescription_des|text=|trigger=button}{sub-section}{sub-section:getDescription_des|trigger=none|class=sIndent}Get the description property of the column.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getDescription_snc|text=|trigger=button}{sub-section}{sub-section:getDescription_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getDescription_prs|text=|trigger=button}{sub-section}{sub-section:getDescription_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getDescription_ret|text=|trigger=button}{sub-section}{sub-section:getDescription_ret|trigger=none|class=sIndent}[String] -- String column description.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getDescription_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getDescription_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getDescription_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getDescription_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getDescription_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getDescription_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customername')
var desc = column.getDescription()
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getForeignType|class=node}{tr:id=name}{td}h6.getForeignType{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[String]{span}{span:id=iets|style=float: left; font-weight: bold;}getForeignType{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getForeignType_des|text=|trigger=button}{sub-section}{sub-section:getForeignType_des|trigger=none|class=sIndent}Get the foreign type of the column.
The foreign type can be defined design time as a foreign key reference to another table.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getForeignType_snc|text=|trigger=button}{sub-section}{sub-section:getForeignType_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getForeignType_prs|text=|trigger=button}{sub-section}{sub-section:getForeignType_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getForeignType_ret|text=|trigger=button}{sub-section}{sub-section:getForeignType_ret|trigger=none|class=sIndent}[String] -- String foreign type.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getForeignType_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getForeignType_see|trigger=none}[databaseManager.mergeRecords|Database Manager#mergeRecords]\\ {sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getForeignType_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getForeignType_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getForeignType_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getForeignType_sam|trigger=none}{code: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)
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getLength|class=node}{tr:id=name}{td}h6.getLength{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}getLength{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getLength_des|text=|trigger=button}{sub-section}{sub-section:getLength_des|trigger=none|class=sIndent}Get the length of the column as reported by the JDBC driver.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getLength_snc|text=|trigger=button}{sub-section}{sub-section:getLength_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getLength_prs|text=|trigger=button}{sub-section}{sub-section:getLength_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getLength_ret|text=|trigger=button}{sub-section}{sub-section:getLength_ret|trigger=none|class=sIndent}[Number] -- int column length.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getLength_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getLength_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getLength_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getLength_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getLength_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getLength_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customername')
if (column.getLength() < 10)
{
// handle short column
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getQualifiedName|class=node}{tr:id=name}{td}h6.getQualifiedName{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[String]{span}{span:id=iets|style=float: left; font-weight: bold;}getQualifiedName{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getQualifiedName_des|text=|trigger=button}{sub-section}{sub-section:getQualifiedName_des|trigger=none|class=sIndent}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.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getQualifiedName_snc|text=|trigger=button}{sub-section}{sub-section:getQualifiedName_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getQualifiedName_prs|text=|trigger=button}{sub-section}{sub-section:getQualifiedName_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getQualifiedName_ret|text=|trigger=button}{sub-section}{sub-section:getQualifiedName_ret|trigger=none|class=sIndent}[String] -- String qualified column name.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getQualifiedName_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getQualifiedName_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getQualifiedName_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getQualifiedName_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getQualifiedName_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getQualifiedName_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
var qualifiedSqlName = column.getQualifiedName()
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getQuotedSQLName|class=node}{tr:id=name}{td}h6.getQuotedSQLName{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[String]{span}{span:id=iets|style=float: left; font-weight: bold;}getQuotedSQLName{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getQuotedSQLName_des|text=|trigger=button}{sub-section}{sub-section:getQuotedSQLName_des|trigger=none|class=sIndent}Returns a quoted version of the column name, if necessary, as defined by the actual database used.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getQuotedSQLName_snc|text=|trigger=button}{sub-section}{sub-section:getQuotedSQLName_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getQuotedSQLName_prs|text=|trigger=button}{sub-section}{sub-section:getQuotedSQLName_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getQuotedSQLName_ret|text=|trigger=button}{sub-section}{sub-section:getQuotedSQLName_ret|trigger=none|class=sIndent}[String] -- column name, quoted if needed.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getQuotedSQLName_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getQuotedSQLName_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getQuotedSQLName_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getQuotedSQLName_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getQuotedSQLName_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getQuotedSQLName_sam|trigger=none}{code: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])
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getSQLName|class=node}{tr:id=name}{td}h6.getSQLName{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[String]{span}{span:id=iets|style=float: left; font-weight: bold;}getSQLName{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getSQLName_des|text=|trigger=button}{sub-section}{sub-section:getSQLName_des|trigger=none|class=sIndent}Get the name of the column as known by the database.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getSQLName_snc|text=|trigger=button}{sub-section}{sub-section:getSQLName_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getSQLName_prs|text=|trigger=button}{sub-section}{sub-section:getSQLName_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getSQLName_ret|text=|trigger=button}{sub-section}{sub-section:getSQLName_ret|trigger=none|class=sIndent}[String] -- String sql name{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getSQLName_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getSQLName_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getSQLName_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getSQLName_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getSQLName_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getSQLName_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
var sqlName = column.getSQLName()
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getScale|class=node}{tr:id=name}{td}h6.getScale{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}getScale{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getScale_des|text=|trigger=button}{sub-section}{sub-section:getScale_des|trigger=none|class=sIndent}Get the scale of the column as reported by the JDBC driver.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getScale_snc|text=|trigger=button}{sub-section}{sub-section:getScale_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getScale_prs|text=|trigger=button}{sub-section}{sub-section:getScale_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getScale_ret|text=|trigger=button}{sub-section}{sub-section:getScale_ret|trigger=none|class=sIndent}[Number] -- int column scale.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getScale_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getScale_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getScale_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getScale_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getScale_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getScale_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customername')
var scale = column.getScale()
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getTitle|class=node}{tr:id=name}{td}h6.getTitle{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[String]{span}{span:id=iets|style=float: left; font-weight: bold;}getTitle{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getTitle_des|text=|trigger=button}{sub-section}{sub-section:getTitle_des|trigger=none|class=sIndent}Get the title property of the column.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getTitle_snc|text=|trigger=button}{sub-section}{sub-section:getTitle_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getTitle_prs|text=|trigger=button}{sub-section}{sub-section:getTitle_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getTitle_ret|text=|trigger=button}{sub-section}{sub-section:getTitle_ret|trigger=none|class=sIndent}[String] -- String column title.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getTitle_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getTitle_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getTitle_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getTitle_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getTitle_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getTitle_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customername')
var title = column.getTitle()
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getType|class=node}{tr:id=name}{td}h6.getType{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Number]{span}{span:id=iets|style=float: left; font-weight: bold;}getType{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getType_des|text=|trigger=button}{sub-section}{sub-section:getType_des|trigger=none|class=sIndent}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{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getType_snc|text=|trigger=button}{sub-section}{sub-section:getType_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getType_prs|text=|trigger=button}{sub-section}{sub-section:getType_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getType_ret|text=|trigger=button}{sub-section}{sub-section:getType_ret|trigger=none|class=sIndent}[Number] -- int sql type.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getType_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getType_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getType_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getType_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getType_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getType_sam|trigger=none}{code: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;
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getTypeAsString|class=node}{tr:id=name}{td}h6.getTypeAsString{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[String]{span}{span:id=iets|style=float: left; font-weight: bold;}getTypeAsString{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:getTypeAsString_des|text=|trigger=button}{sub-section}{sub-section:getTypeAsString_des|trigger=none|class=sIndent}Get the name JDBC type of the column.
The same mapping as defined in JSColumn.getType() is applied.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getTypeAsString_snc|text=|trigger=button}{sub-section}{sub-section:getTypeAsString_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:getTypeAsString_prs|text=|trigger=button}{sub-section}{sub-section:getTypeAsString_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getTypeAsString_ret|text=|trigger=button}{sub-section}{sub-section:getTypeAsString_ret|trigger=none|class=sIndent}[String] -- String sql name.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getTypeAsString_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getTypeAsString_see|trigger=none}[.getType|JSColumn#getType]\\ {sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getTypeAsString_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getTypeAsString_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getTypeAsString_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:getTypeAsString_sam|trigger=none}{code:language=javascript} Table Body (tbody) |
---|
id | getQualifiedName |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getQualifiedName |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| String |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getQualifiedName |
|
|
Table Row (tr) |
---|
| 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) |
---|
| Table Cell (td) |
---|
Returns String – String qualified column name. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
var qualifiedSqlName = column.getQualifiedName()
|
|
|
|
|
Table Body (tbody) |
---|
id | getQuotedSQLName |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getQuotedSQLName |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| String |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getQuotedSQLName |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns a quoted version of the column name, if necessary, as defined by the actual database used. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns String – column name, quoted if needed. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
//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 Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getSQLName |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| String |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getSQLName |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Get the name of the column as known by the database. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns String – String sql name |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
var sqlName = column.getSQLName()
|
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Number |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getScale |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Get the scale of the column as reported by the JDBC driver. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Number – int column scale. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn(' |
|
|
|
| customeridtypeNamegetTypeAsString{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=isRowIdentifier|class=node}{tr:id=name}{td}h6.isRowIdentifier{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}isRowIdentifier{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:isRowIdentifier_des|text=|trigger=button}{sub-section}{sub-section:isRowIdentifier_des|trigger=none|class=sIndent}Is this column one of the row identifiers for its table.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:isRowIdentifier_snc|text=|trigger=button}{sub-section}{sub-section:isRowIdentifier_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:isRowIdentifier_prs|text=|trigger=button}{sub-section}{sub-section:isRowIdentifier_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:isRowIdentifier_ret|text=|trigger=button}{sub-section}{sub-section:isRowIdentifier_ret|trigger=none|class=sIndent}[Boolean] -- boolean true if is row identifier else false.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:isRowIdentifier_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:isRowIdentifier_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:isRowIdentifier_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:isRowIdentifier_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:isRowIdentifier_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:isRowIdentifier_sam|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('orderid')
if (column.isRowIdentifier())
{
// handle pk column
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=isUUID|class=node}{tr:id=name}{td}h6.isUUID{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}isUUID{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:isUUID_des|text=|trigger=button}{sub-section}{sub-section:isUUID_des|trigger=none|class=sIndent}Is this column marked as UUID column.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:isUUID_snc|text=|trigger=button}{sub-section}{sub-section:isUUID_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:isUUID_prs|text=|trigger=button}{sub-section}{sub-section:isUUID_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:isUUID_ret|text=|trigger=button}{sub-section}{sub-section:isUUID_ret|trigger=none|class=sIndent}[Boolean] -- boolean true if is marked as UUID columns else false.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:isUUID_see|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:isUUID_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:isUUID_link|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:isUUID_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:isUUID_sam|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:isUUID_sam|trigger=none}{code:language=javascript} Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| String |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getTitle |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Get the title property of the column. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns String – String column title. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customername')
var title = column.getTitle()
|
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Number |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getType |
|
|
Table Row (tr) |
---|
| 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) |
---|
| Table Cell (td) |
---|
Returns Number – int sql type. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
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 Body (tbody) |
---|
id | getTypeAsString |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
getTypeAsString |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| String |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| getTypeAsString |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Get the name JDBC type of the column. The same mapping as defined in JSColumn.getType() is applied. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns String – String sql name. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
var typeName = column.getTypeAsString()
|
|
|
|
|
Table Body (tbody) |
---|
id | isRowIdentifier |
---|
class | node |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
isRowIdentifier |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Boolean |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| isRowIdentifier |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Is this column one of the row identifiers for its table. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Boolean – boolean true if is row identifier else false. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('orderid')
if (column.isRowIdentifier())
{
// handle pk column
}
|
|
|
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Span |
---|
style | float: left; margin-right: 5px; |
---|
| Boolean |
Span |
---|
style | float: left; font-weight: bold; |
---|
id | iets |
---|
| isUUID |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Is this column marked as UUID column. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Boolean – boolean true if is marked as UUID columns else false. |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample
Div |
---|
| Code Block |
---|
|
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('orderid')
if (column.isUUID())
{
// handle UUID column
}
|
|
|
|
| {code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table} |