Page History

Wiki Markup
{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{hidden}
{sub-section:description|text=}{sub-section}\\ 

{table:class=servoy sSummery}{colgroup}{column:width=80px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Constants Summary{th}{tr}{tbody}{tr}{td}[Number]{td}{td}[#DATETIME]
Constant used when setting or getting the type of columns.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#INTEGER]
Constant used when setting or getting the type of columns.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#MEDIA]
Constant used when setting or getting the type of columns.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#NUMBER]
Constant used when setting or getting the type of columns.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#TEXT]
Constant used when setting or getting the type of columns.{td}{tr}{tbody}{table}\\ 

{table:class=servoy sSummery}{colgroup}{column:width=80px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Method Summary{th}{tr}{tbody}{tr}{td}[Boolean]{td}{td}[#getAllowNull]\()
Get the allow-null flag of the column.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#getDataProviderID]\()
Get the data provider id (name) for this column.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#getDescription]\()
Get the description property of the column.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#getForeignType]\()
Get the foreign type of the column.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#getLength]\()
Get the length of the column as reported by the JDBC driver.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#getQualifiedName]\()
Get the qualified name (including table name) of the column as known by the database.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#getQuotedSQLName]\()
Returns a quoted version of the column name, if necessary, as defined by the actual database used.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#getSQLName]\()
Get the name of the column as known by the database.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#getScale]\()
Get the scale of the column as reported by the JDBC driver.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#getTitle]\()
Get the title property of the column.{td}{tr}{tbody}{tbody}{tr}{td}[Number]{td}{td}[#getType]\()
Get the JDBC type of the column.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#getTypeAsString]\()
Get the name JDBC type of the column.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#isRowIdentifier]\()
Is this column one of the row identifiers for its table.{td}{tr}{tbody}{tbody}{tr}{td}[Boolean]{td}{td}[#isUUID]\()
Is this column marked as UUID column.{td}{tr}{tbody}{table}\\ 

{table:class=servoy sDetail}{colgroup}{column:width=100%}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Constants Details{th}{tr}{tbody:id=C08173B2E9B9C95C-F5874CE8-41854EAB-AEDD842A-5CD9D1C72BFA3DF0EC722E9A}{tr:id=name}{td}h6.DATETIME{td}{tr}{tr:id=des}{td}{sub-section:C08173B2E9B9C95C-F5874CE8-41854EAB-AEDD842A-5CD9D1C72BFA3DF0EC722E9A_des|text=|trigger=button}{sub-section}{sub-section:C08173B2E9B9C95C-F5874CE8-41854EAB-AEDD842A-5CD9D1C72BFA3DF0EC722E9A_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=prs}{td}*Parameters*\\{sub-section:C08173B2E9B9C95C-F5874CE8-41854EAB-AEDD842A-5CD9D1C72BFA3DF0EC722E9A_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:C08173B2E9B9C95C-F5874CE8-41854EAB-AEDD842A-5CD9D1C72BFA3DF0EC722E9A_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:C08173B2E9B9C95C-F5874CE8-41854EAB-AEDD842A-5CD9D1C72BFA3DF0EC722E9A_ret|text=|trigger=button}{sub-section}{sub-section:C08173B2E9B9C95C-F5874CE8-41854EAB-AEDD842A-5CD9D1C72BFA3DF0EC722E9A_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:C08173B2E9B9C95C-F5874CE8-41854EAB-AEDD842A-5CD9D1C72BFA3DF0EC722E9A_see|text=|trigger=button}{sub-section}{sub-section:C08173B2E9B9C95C-F5874CE8-41854EAB-AEDD842A-5CD9D1C72BFA3DF0EC722E9A_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:C08173B2E9B9C95C-F5874CE8-41854EAB-AEDD842A-5CD9D1C72BFA3DF0EC722E9A_see|text=|trigger=button}{sub-section}{sub-section:C08173B2E9B9C95C-F5874CE8-41854EAB-AEDD842A-5CD9D1C72BFA3DF0EC722E9A_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:C08173B2E9B9C95C-F5874CE8-41854EAB-AEDD842A-5CD9D1C72BFA3DF0EC722E9A_sam|text=|trigger=button}{sub-section}{sub-section:C08173B2E9B9C95C-F5874CE8-41854EAB-AEDD842A-5CD9D1C72BFA3DF0EC722E9A_sam|class=sIndent|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}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=60DC8AD7F209C3DD-662DFCD7-46C24A4D-818784F0-57EBE3D96FB32E2BFA1232B9}{tr:id=name}{td}h6.INTEGER{td}{tr}{tr:id=des}{td}{sub-section:60DC8AD7F209C3DD-662DFCD7-46C24A4D-818784F0-57EBE3D96FB32E2BFA1232B9_des|text=|trigger=button}{sub-section}{sub-section:60DC8AD7F209C3DD-662DFCD7-46C24A4D-818784F0-57EBE3D96FB32E2BFA1232B9_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=prs}{td}*Parameters*\\{sub-section:60DC8AD7F209C3DD-662DFCD7-46C24A4D-818784F0-57EBE3D96FB32E2BFA1232B9_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:60DC8AD7F209C3DD-662DFCD7-46C24A4D-818784F0-57EBE3D96FB32E2BFA1232B9_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:60DC8AD7F209C3DD-662DFCD7-46C24A4D-818784F0-57EBE3D96FB32E2BFA1232B9_ret|text=|trigger=button}{sub-section}{sub-section:60DC8AD7F209C3DD-662DFCD7-46C24A4D-818784F0-57EBE3D96FB32E2BFA1232B9_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:60DC8AD7F209C3DD-662DFCD7-46C24A4D-818784F0-57EBE3D96FB32E2BFA1232B9_see|text=|trigger=button}{sub-section}{sub-section:60DC8AD7F209C3DD-662DFCD7-46C24A4D-818784F0-57EBE3D96FB32E2BFA1232B9_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:60DC8AD7F209C3DD-662DFCD7-46C24A4D-818784F0-57EBE3D96FB32E2BFA1232B9_see|text=|trigger=button}{sub-section}{sub-section:60DC8AD7F209C3DD-662DFCD7-46C24A4D-818784F0-57EBE3D96FB32E2BFA1232B9_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:60DC8AD7F209C3DD-662DFCD7-46C24A4D-818784F0-57EBE3D96FB32E2BFA1232B9_sam|text=|trigger=button}{sub-section}{sub-section:60DC8AD7F209C3DD-662DFCD7-46C24A4D-818784F0-57EBE3D96FB32E2BFA1232B9_sam|class=sIndent|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}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=56EED3630D9B0AAE-22986C56-43BC4F36-95609CE7-6FB70714E828EEBD35DBF841}{tr:id=name}{td}h6.MEDIA{td}{tr}{tr:id=des}{td}{sub-section:56EED3630D9B0AAE-22986C56-43BC4F36-95609CE7-6FB70714E828EEBD35DBF841_des|text=|trigger=button}{sub-section}{sub-section:56EED3630D9B0AAE-22986C56-43BC4F36-95609CE7-6FB70714E828EEBD35DBF841_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=prs}{td}*Parameters*\\{sub-section:56EED3630D9B0AAE-22986C56-43BC4F36-95609CE7-6FB70714E828EEBD35DBF841_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:56EED3630D9B0AAE-22986C56-43BC4F36-95609CE7-6FB70714E828EEBD35DBF841_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:56EED3630D9B0AAE-22986C56-43BC4F36-95609CE7-6FB70714E828EEBD35DBF841_ret|text=|trigger=button}{sub-section}{sub-section:56EED3630D9B0AAE-22986C56-43BC4F36-95609CE7-6FB70714E828EEBD35DBF841_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:56EED3630D9B0AAE-22986C56-43BC4F36-95609CE7-6FB70714E828EEBD35DBF841_see|text=|trigger=button}{sub-section}{sub-section:56EED3630D9B0AAE-22986C56-43BC4F36-95609CE7-6FB70714E828EEBD35DBF841_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:56EED3630D9B0AAE-22986C56-43BC4F36-95609CE7-6FB70714E828EEBD35DBF841_see|text=|trigger=button}{sub-section}{sub-section:56EED3630D9B0AAE-22986C56-43BC4F36-95609CE7-6FB70714E828EEBD35DBF841_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:56EED3630D9B0AAE-22986C56-43BC4F36-95609CE7-6FB70714E828EEBD35DBF841_sam|text=|trigger=button}{sub-section}{sub-section:56EED3630D9B0AAE-22986C56-43BC4F36-95609CE7-6FB70714E828EEBD35DBF841_sam|class=sIndent|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}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=B487198487049E2D-83B18665-40A5404E-AAC28E3C-36E198EB49139F171BD81CAD}{tr:id=name}{td}h6.NUMBER{td}{tr}{tr:id=des}{td}{sub-section:B487198487049E2D-83B18665-40A5404E-AAC28E3C-36E198EB49139F171BD81CAD_des|text=|trigger=button}{sub-section}{sub-section:B487198487049E2D-83B18665-40A5404E-AAC28E3C-36E198EB49139F171BD81CAD_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=prs}{td}*Parameters*\\{sub-section:B487198487049E2D-83B18665-40A5404E-AAC28E3C-36E198EB49139F171BD81CAD_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:B487198487049E2D-83B18665-40A5404E-AAC28E3C-36E198EB49139F171BD81CAD_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:B487198487049E2D-83B18665-40A5404E-AAC28E3C-36E198EB49139F171BD81CAD_ret|text=|trigger=button}{sub-section}{sub-section:B487198487049E2D-83B18665-40A5404E-AAC28E3C-36E198EB49139F171BD81CAD_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:B487198487049E2D-83B18665-40A5404E-AAC28E3C-36E198EB49139F171BD81CAD_see|text=|trigger=button}{sub-section}{sub-section:B487198487049E2D-83B18665-40A5404E-AAC28E3C-36E198EB49139F171BD81CAD_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:B487198487049E2D-83B18665-40A5404E-AAC28E3C-36E198EB49139F171BD81CAD_see|text=|trigger=button}{sub-section}{sub-section:B487198487049E2D-83B18665-40A5404E-AAC28E3C-36E198EB49139F171BD81CAD_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:B487198487049E2D-83B18665-40A5404E-AAC28E3C-36E198EB49139F171BD81CAD_sam|text=|trigger=button}{sub-section}{sub-section:B487198487049E2D-83B18665-40A5404E-AAC28E3C-36E198EB49139F171BD81CAD_sam|class=sIndent|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}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=10B27A923F6A422B-DD18816C-4B2640F6-B7A1BEA5-031EC5F4806C659B00195207}{tr:id=name}{td}h6.TEXT{td}{tr}{tr:id=des}{td}{sub-section:10B27A923F6A422B-DD18816C-4B2640F6-B7A1BEA5-031EC5F4806C659B00195207_des|text=|trigger=button}{sub-section}{sub-section:10B27A923F6A422B-DD18816C-4B2640F6-B7A1BEA5-031EC5F4806C659B00195207_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=prs}{td}*Parameters*\\{sub-section:10B27A923F6A422B-DD18816C-4B2640F6-B7A1BEA5-031EC5F4806C659B00195207_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:10B27A923F6A422B-DD18816C-4B2640F6-B7A1BEA5-031EC5F4806C659B00195207_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:10B27A923F6A422B-DD18816C-4B2640F6-B7A1BEA5-031EC5F4806C659B00195207_ret|text=|trigger=button}{sub-section}{sub-section:10B27A923F6A422B-DD18816C-4B2640F6-B7A1BEA5-031EC5F4806C659B00195207_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:10B27A923F6A422B-DD18816C-4B2640F6-B7A1BEA5-031EC5F4806C659B00195207_see|text=|trigger=button}{sub-section}{sub-section:10B27A923F6A422B-DD18816C-4B2640F6-B7A1BEA5-031EC5F4806C659B00195207_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:10B27A923F6A422B-DD18816C-4B2640F6-B7A1BEA5-031EC5F4806C659B00195207_see|text=|trigger=button}{sub-section}{sub-section:10B27A923F6A422B-DD18816C-4B2640F6-B7A1BEA5-031EC5F4806C659B00195207_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:10B27A923F6A422B-DD18816C-4B2640F6-B7A1BEA5-031EC5F4806C659B00195207_sam|text=|trigger=button}{sub-section}{sub-section:10B27A923F6A422B-DD18816C-4B2640F6-B7A1BEA5-031EC5F4806C659B00195207_sam|class=sIndent|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}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}\\ 

{table:class=servoy sDetail}{colgroup}{column:width=100%}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Method Details{th}{tr}{tbody:id=CC25F433787195ED-38B21C03-467A464C-BC9A811F-42D4A46CB29BCC89EE1CBA65}{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:CC25F433787195ED-38B21C03-467A464C-BC9A811F-42D4A46CB29BCC89EE1CBA65_des|text=|trigger=button}{sub-section}{sub-section:CC25F433787195ED-38B21C03-467A464C-BC9A811F-42D4A46CB29BCC89EE1CBA65_des|trigger=none|class=sIndent}Get the allow-null flag of the column.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:CC25F433787195ED-38B21C03-467A464C-BC9A811F-42D4A46CB29BCC89EE1CBA65_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:CC25F433787195ED-38B21C03-467A464C-BC9A811F-42D4A46CB29BCC89EE1CBA65_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:CC25F433787195ED-38B21C03-467A464C-BC9A811F-42D4A46CB29BCC89EE1CBA65_ret|text=|trigger=button}{sub-section}{sub-section:CC25F433787195ED-38B21C03-467A464C-BC9A811F-42D4A46CB29BCC89EE1CBA65_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:CC25F433787195ED-38B21C03-467A464C-BC9A811F-42D4A46CB29BCC89EE1CBA65_see|text=|trigger=button}{sub-section}{sub-section:CC25F433787195ED-38B21C03-467A464C-BC9A811F-42D4A46CB29BCC89EE1CBA65_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:CC25F433787195ED-38B21C03-467A464C-BC9A811F-42D4A46CB29BCC89EE1CBA65_see|text=|trigger=button}{sub-section}{sub-section:CC25F433787195ED-38B21C03-467A464C-BC9A811F-42D4A46CB29BCC89EE1CBA65_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:CC25F433787195ED-38B21C03-467A464C-BC9A811F-42D4A46CB29BCC89EE1CBA65_sam|text=|trigger=button}{sub-section}{sub-section:CC25F433787195ED-38B21C03-467A464C-BC9A811F-42D4A46CB29BCC89EE1CBA65_sam|class=sIndent|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}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=043F463687674324-CEBF96D7-4CDB4D56-8E2BAE37-DBF3910B5438E27E5BBAA711}{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:043F463687674324-CEBF96D7-4CDB4D56-8E2BAE37-DBF3910B5438E27E5BBAA711_des|text=|trigger=button}{sub-section}{sub-section:043F463687674324-CEBF96D7-4CDB4D56-8E2BAE37-DBF3910B5438E27E5BBAA711_des|trigger=none|class=sIndent}Get the data provider id (name) for this column.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:043F463687674324-CEBF96D7-4CDB4D56-8E2BAE37-DBF3910B5438E27E5BBAA711_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:043F463687674324-CEBF96D7-4CDB4D56-8E2BAE37-DBF3910B5438E27E5BBAA711_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:043F463687674324-CEBF96D7-4CDB4D56-8E2BAE37-DBF3910B5438E27E5BBAA711_ret|text=|trigger=button}{sub-section}{sub-section:043F463687674324-CEBF96D7-4CDB4D56-8E2BAE37-DBF3910B5438E27E5BBAA711_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:043F463687674324-CEBF96D7-4CDB4D56-8E2BAE37-DBF3910B5438E27E5BBAA711_see|text=|trigger=button}{sub-section}{sub-section:043F463687674324-CEBF96D7-4CDB4D56-8E2BAE37-DBF3910B5438E27E5BBAA711_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:043F463687674324-CEBF96D7-4CDB4D56-8E2BAE37-DBF3910B5438E27E5BBAA711_see|text=|trigger=button}{sub-section}{sub-section:043F463687674324-CEBF96D7-4CDB4D56-8E2BAE37-DBF3910B5438E27E5BBAA711_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:043F463687674324-CEBF96D7-4CDB4D56-8E2BAE37-DBF3910B5438E27E5BBAA711_sam|text=|trigger=button}{sub-section}{sub-section:043F463687674324-CEBF96D7-4CDB4D56-8E2BAE37-DBF3910B5438E27E5BBAA711_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
var dataProviderId = column.getDataProviderID()
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=097635F886135BCF-1F7F2A0F-42524260-BF1F87AF-3ADD44E577E85DB5353A1EDF}{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:097635F886135BCF-1F7F2A0F-42524260-BF1F87AF-3ADD44E577E85DB5353A1EDF_des|text=|trigger=button}{sub-section}{sub-section:097635F886135BCF-1F7F2A0F-42524260-BF1F87AF-3ADD44E577E85DB5353A1EDF_des|trigger=none|class=sIndent}Get the description property of the column.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:097635F886135BCF-1F7F2A0F-42524260-BF1F87AF-3ADD44E577E85DB5353A1EDF_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:097635F886135BCF-1F7F2A0F-42524260-BF1F87AF-3ADD44E577E85DB5353A1EDF_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:097635F886135BCF-1F7F2A0F-42524260-BF1F87AF-3ADD44E577E85DB5353A1EDF_ret|text=|trigger=button}{sub-section}{sub-section:097635F886135BCF-1F7F2A0F-42524260-BF1F87AF-3ADD44E577E85DB5353A1EDF_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:097635F886135BCF-1F7F2A0F-42524260-BF1F87AF-3ADD44E577E85DB5353A1EDF_see|text=|trigger=button}{sub-section}{sub-section:097635F886135BCF-1F7F2A0F-42524260-BF1F87AF-3ADD44E577E85DB5353A1EDF_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:097635F886135BCF-1F7F2A0F-42524260-BF1F87AF-3ADD44E577E85DB5353A1EDF_see|text=|trigger=button}{sub-section}{sub-section:097635F886135BCF-1F7F2A0F-42524260-BF1F87AF-3ADD44E577E85DB5353A1EDF_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:097635F886135BCF-1F7F2A0F-42524260-BF1F87AF-3ADD44E577E85DB5353A1EDF_sam|text=|trigger=button}{sub-section}{sub-section:097635F886135BCF-1F7F2A0F-42524260-BF1F87AF-3ADD44E577E85DB5353A1EDF_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customername')
var desc = column.getDescription()
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=0D1DEFECC9DC2C5A-2089F032-4DA84E01-BF79AAEA-4CC8824BC3EEB84A37FE0CCF}{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:0D1DEFECC9DC2C5A-2089F032-4DA84E01-BF79AAEA-4CC8824BC3EEB84A37FE0CCF_des|text=|trigger=button}{sub-section}{sub-section:0D1DEFECC9DC2C5A-2089F032-4DA84E01-BF79AAEA-4CC8824BC3EEB84A37FE0CCF_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=prs}{td}*Parameters*\\{sub-section:0D1DEFECC9DC2C5A-2089F032-4DA84E01-BF79AAEA-4CC8824BC3EEB84A37FE0CCF_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:0D1DEFECC9DC2C5A-2089F032-4DA84E01-BF79AAEA-4CC8824BC3EEB84A37FE0CCF_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:0D1DEFECC9DC2C5A-2089F032-4DA84E01-BF79AAEA-4CC8824BC3EEB84A37FE0CCF_ret|text=|trigger=button}{sub-section}{sub-section:0D1DEFECC9DC2C5A-2089F032-4DA84E01-BF79AAEA-4CC8824BC3EEB84A37FE0CCF_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:0D1DEFECC9DC2C5A-2089F032-4DA84E01-BF79AAEA-4CC8824BC3EEB84A37FE0CCF_see|text=|trigger=button}{sub-section}{sub-section:0D1DEFECC9DC2C5A-2089F032-4DA84E01-BF79AAEA-4CC8824BC3EEB84A37FE0CCF_see|class=sIndent|trigger=none}[databaseManager.mergeRecords|Database Manager#mergeRecords]\\{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:0D1DEFECC9DC2C5A-2089F032-4DA84E01-BF79AAEA-4CC8824BC3EEB84A37FE0CCF_see|text=|trigger=button}{sub-section}{sub-section:0D1DEFECC9DC2C5A-2089F032-4DA84E01-BF79AAEA-4CC8824BC3EEB84A37FE0CCF_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:0D1DEFECC9DC2C5A-2089F032-4DA84E01-BF79AAEA-4CC8824BC3EEB84A37FE0CCF_sam|text=|trigger=button}{sub-section}{sub-section:0D1DEFECC9DC2C5A-2089F032-4DA84E01-BF79AAEA-4CC8824BC3EEB84A37FE0CCF_sam|class=sIndent|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}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=67621E1D02AE4C58-162C24A8-4B3F4975-9247A0CA-7136E55F6023971F6479AC19}{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:67621E1D02AE4C58-162C24A8-4B3F4975-9247A0CA-7136E55F6023971F6479AC19_des|text=|trigger=button}{sub-section}{sub-section:67621E1D02AE4C58-162C24A8-4B3F4975-9247A0CA-7136E55F6023971F6479AC19_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=prs}{td}*Parameters*\\{sub-section:67621E1D02AE4C58-162C24A8-4B3F4975-9247A0CA-7136E55F6023971F6479AC19_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:67621E1D02AE4C58-162C24A8-4B3F4975-9247A0CA-7136E55F6023971F6479AC19_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:67621E1D02AE4C58-162C24A8-4B3F4975-9247A0CA-7136E55F6023971F6479AC19_ret|text=|trigger=button}{sub-section}{sub-section:67621E1D02AE4C58-162C24A8-4B3F4975-9247A0CA-7136E55F6023971F6479AC19_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:67621E1D02AE4C58-162C24A8-4B3F4975-9247A0CA-7136E55F6023971F6479AC19_see|text=|trigger=button}{sub-section}{sub-section:67621E1D02AE4C58-162C24A8-4B3F4975-9247A0CA-7136E55F6023971F6479AC19_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:67621E1D02AE4C58-162C24A8-4B3F4975-9247A0CA-7136E55F6023971F6479AC19_see|text=|trigger=button}{sub-section}{sub-section:67621E1D02AE4C58-162C24A8-4B3F4975-9247A0CA-7136E55F6023971F6479AC19_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:67621E1D02AE4C58-162C24A8-4B3F4975-9247A0CA-7136E55F6023971F6479AC19_sam|text=|trigger=button}{sub-section}{sub-section:67621E1D02AE4C58-162C24A8-4B3F4975-9247A0CA-7136E55F6023971F6479AC19_sam|class=sIndent|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}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=585364A5821DB8B6-A1BB1BED-419A433F-9206A596-62957030EC5D2605C58D9302}{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:585364A5821DB8B6-A1BB1BED-419A433F-9206A596-62957030EC5D2605C58D9302_des|text=|trigger=button}{sub-section}{sub-section:585364A5821DB8B6-A1BB1BED-419A433F-9206A596-62957030EC5D2605C58D9302_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=prs}{td}*Parameters*\\{sub-section:585364A5821DB8B6-A1BB1BED-419A433F-9206A596-62957030EC5D2605C58D9302_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:585364A5821DB8B6-A1BB1BED-419A433F-9206A596-62957030EC5D2605C58D9302_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:585364A5821DB8B6-A1BB1BED-419A433F-9206A596-62957030EC5D2605C58D9302_ret|text=|trigger=button}{sub-section}{sub-section:585364A5821DB8B6-A1BB1BED-419A433F-9206A596-62957030EC5D2605C58D9302_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:585364A5821DB8B6-A1BB1BED-419A433F-9206A596-62957030EC5D2605C58D9302_see|text=|trigger=button}{sub-section}{sub-section:585364A5821DB8B6-A1BB1BED-419A433F-9206A596-62957030EC5D2605C58D9302_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:585364A5821DB8B6-A1BB1BED-419A433F-9206A596-62957030EC5D2605C58D9302_see|text=|trigger=button}{sub-section}{sub-section:585364A5821DB8B6-A1BB1BED-419A433F-9206A596-62957030EC5D2605C58D9302_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:585364A5821DB8B6-A1BB1BED-419A433F-9206A596-62957030EC5D2605C58D9302_sam|text=|trigger=button}{sub-section}{sub-section:585364A5821DB8B6-A1BB1BED-419A433F-9206A596-62957030EC5D2605C58D9302_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
var qualifiedSqlName = column.getQualifiedName()
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=DFC0C114AA7BD5CD-FEE83EE5-49AC479F-AE93B6D8-44AE65917FD4FCA31E5C266D}{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:DFC0C114AA7BD5CD-FEE83EE5-49AC479F-AE93B6D8-44AE65917FD4FCA31E5C266D_des|text=|trigger=button}{sub-section}{sub-section:DFC0C114AA7BD5CD-FEE83EE5-49AC479F-AE93B6D8-44AE65917FD4FCA31E5C266D_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=prs}{td}*Parameters*\\{sub-section:DFC0C114AA7BD5CD-FEE83EE5-49AC479F-AE93B6D8-44AE65917FD4FCA31E5C266D_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:DFC0C114AA7BD5CD-FEE83EE5-49AC479F-AE93B6D8-44AE65917FD4FCA31E5C266D_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:DFC0C114AA7BD5CD-FEE83EE5-49AC479F-AE93B6D8-44AE65917FD4FCA31E5C266D_ret|text=|trigger=button}{sub-section}{sub-section:DFC0C114AA7BD5CD-FEE83EE5-49AC479F-AE93B6D8-44AE65917FD4FCA31E5C266D_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:DFC0C114AA7BD5CD-FEE83EE5-49AC479F-AE93B6D8-44AE65917FD4FCA31E5C266D_see|text=|trigger=button}{sub-section}{sub-section:DFC0C114AA7BD5CD-FEE83EE5-49AC479F-AE93B6D8-44AE65917FD4FCA31E5C266D_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:DFC0C114AA7BD5CD-FEE83EE5-49AC479F-AE93B6D8-44AE65917FD4FCA31E5C266D_see|text=|trigger=button}{sub-section}{sub-section:DFC0C114AA7BD5CD-FEE83EE5-49AC479F-AE93B6D8-44AE65917FD4FCA31E5C266D_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:DFC0C114AA7BD5CD-FEE83EE5-49AC479F-AE93B6D8-44AE65917FD4FCA31E5C266D_sam|text=|trigger=button}{sub-section}{sub-section:DFC0C114AA7BD5CD-FEE83EE5-49AC479F-AE93B6D8-44AE65917FD4FCA31E5C266D_sam|class=sIndent|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}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=8FA727B83A0F019E-33A31D3A-49554B65-80CC8562-32E1A9DC02CF9354A8AE4A0C}{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:8FA727B83A0F019E-33A31D3A-49554B65-80CC8562-32E1A9DC02CF9354A8AE4A0C_des|text=|trigger=button}{sub-section}{sub-section:8FA727B83A0F019E-33A31D3A-49554B65-80CC8562-32E1A9DC02CF9354A8AE4A0C_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=prs}{td}*Parameters*\\{sub-section:8FA727B83A0F019E-33A31D3A-49554B65-80CC8562-32E1A9DC02CF9354A8AE4A0C_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:8FA727B83A0F019E-33A31D3A-49554B65-80CC8562-32E1A9DC02CF9354A8AE4A0C_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:8FA727B83A0F019E-33A31D3A-49554B65-80CC8562-32E1A9DC02CF9354A8AE4A0C_ret|text=|trigger=button}{sub-section}{sub-section:8FA727B83A0F019E-33A31D3A-49554B65-80CC8562-32E1A9DC02CF9354A8AE4A0C_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:8FA727B83A0F019E-33A31D3A-49554B65-80CC8562-32E1A9DC02CF9354A8AE4A0C_see|text=|trigger=button}{sub-section}{sub-section:8FA727B83A0F019E-33A31D3A-49554B65-80CC8562-32E1A9DC02CF9354A8AE4A0C_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:8FA727B83A0F019E-33A31D3A-49554B65-80CC8562-32E1A9DC02CF9354A8AE4A0C_see|text=|trigger=button}{sub-section}{sub-section:8FA727B83A0F019E-33A31D3A-49554B65-80CC8562-32E1A9DC02CF9354A8AE4A0C_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:8FA727B83A0F019E-33A31D3A-49554B65-80CC8562-32E1A9DC02CF9354A8AE4A0C_sam|text=|trigger=button}{sub-section}{sub-section:8FA727B83A0F019E-33A31D3A-49554B65-80CC8562-32E1A9DC02CF9354A8AE4A0C_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
var sqlName = column.getSQLName()
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=54D1E86E0317D23B-B4846419-4C6C4428-91EAA54C-E1E99A7E95010748D5653246}{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:54D1E86E0317D23B-B4846419-4C6C4428-91EAA54C-E1E99A7E95010748D5653246_des|text=|trigger=button}{sub-section}{sub-section:54D1E86E0317D23B-B4846419-4C6C4428-91EAA54C-E1E99A7E95010748D5653246_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=prs}{td}*Parameters*\\{sub-section:54D1E86E0317D23B-B4846419-4C6C4428-91EAA54C-E1E99A7E95010748D5653246_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:54D1E86E0317D23B-B4846419-4C6C4428-91EAA54C-E1E99A7E95010748D5653246_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:54D1E86E0317D23B-B4846419-4C6C4428-91EAA54C-E1E99A7E95010748D5653246_ret|text=|trigger=button}{sub-section}{sub-section:54D1E86E0317D23B-B4846419-4C6C4428-91EAA54C-E1E99A7E95010748D5653246_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:54D1E86E0317D23B-B4846419-4C6C4428-91EAA54C-E1E99A7E95010748D5653246_see|text=|trigger=button}{sub-section}{sub-section:54D1E86E0317D23B-B4846419-4C6C4428-91EAA54C-E1E99A7E95010748D5653246_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:54D1E86E0317D23B-B4846419-4C6C4428-91EAA54C-E1E99A7E95010748D5653246_see|text=|trigger=button}{sub-section}{sub-section:54D1E86E0317D23B-B4846419-4C6C4428-91EAA54C-E1E99A7E95010748D5653246_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:54D1E86E0317D23B-B4846419-4C6C4428-91EAA54C-E1E99A7E95010748D5653246_sam|text=|trigger=button}{sub-section}{sub-section:54D1E86E0317D23B-B4846419-4C6C4428-91EAA54C-E1E99A7E95010748D5653246_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customername')
var scale = column.getScale()
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=1EA72B82E989115E-F19F5986-4BEC4A0B-B05580AD-AE34AF1A027E6CA049A5B2A7}{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:1EA72B82E989115E-F19F5986-4BEC4A0B-B05580AD-AE34AF1A027E6CA049A5B2A7_des|text=|trigger=button}{sub-section}{sub-section:1EA72B82E989115E-F19F5986-4BEC4A0B-B05580AD-AE34AF1A027E6CA049A5B2A7_des|trigger=none|class=sIndent}Get the title property of the column.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:1EA72B82E989115E-F19F5986-4BEC4A0B-B05580AD-AE34AF1A027E6CA049A5B2A7_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:1EA72B82E989115E-F19F5986-4BEC4A0B-B05580AD-AE34AF1A027E6CA049A5B2A7_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:1EA72B82E989115E-F19F5986-4BEC4A0B-B05580AD-AE34AF1A027E6CA049A5B2A7_ret|text=|trigger=button}{sub-section}{sub-section:1EA72B82E989115E-F19F5986-4BEC4A0B-B05580AD-AE34AF1A027E6CA049A5B2A7_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:1EA72B82E989115E-F19F5986-4BEC4A0B-B05580AD-AE34AF1A027E6CA049A5B2A7_see|text=|trigger=button}{sub-section}{sub-section:1EA72B82E989115E-F19F5986-4BEC4A0B-B05580AD-AE34AF1A027E6CA049A5B2A7_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:1EA72B82E989115E-F19F5986-4BEC4A0B-B05580AD-AE34AF1A027E6CA049A5B2A7_see|text=|trigger=button}{sub-section}{sub-section:1EA72B82E989115E-F19F5986-4BEC4A0B-B05580AD-AE34AF1A027E6CA049A5B2A7_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:1EA72B82E989115E-F19F5986-4BEC4A0B-B05580AD-AE34AF1A027E6CA049A5B2A7_sam|text=|trigger=button}{sub-section}{sub-section:1EA72B82E989115E-F19F5986-4BEC4A0B-B05580AD-AE34AF1A027E6CA049A5B2A7_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customername')
var title = column.getTitle()
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=F5F8F9D50EEA096E-56DAD6F6-43684A10-80E3AC87-F8F374D7FA1A2FF58830B10B}{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:F5F8F9D50EEA096E-56DAD6F6-43684A10-80E3AC87-F8F374D7FA1A2FF58830B10B_des|text=|trigger=button}{sub-section}{sub-section:F5F8F9D50EEA096E-56DAD6F6-43684A10-80E3AC87-F8F374D7FA1A2FF58830B10B_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=prs}{td}*Parameters*\\{sub-section:F5F8F9D50EEA096E-56DAD6F6-43684A10-80E3AC87-F8F374D7FA1A2FF58830B10B_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:F5F8F9D50EEA096E-56DAD6F6-43684A10-80E3AC87-F8F374D7FA1A2FF58830B10B_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:F5F8F9D50EEA096E-56DAD6F6-43684A10-80E3AC87-F8F374D7FA1A2FF58830B10B_ret|text=|trigger=button}{sub-section}{sub-section:F5F8F9D50EEA096E-56DAD6F6-43684A10-80E3AC87-F8F374D7FA1A2FF58830B10B_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:F5F8F9D50EEA096E-56DAD6F6-43684A10-80E3AC87-F8F374D7FA1A2FF58830B10B_see|text=|trigger=button}{sub-section}{sub-section:F5F8F9D50EEA096E-56DAD6F6-43684A10-80E3AC87-F8F374D7FA1A2FF58830B10B_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:F5F8F9D50EEA096E-56DAD6F6-43684A10-80E3AC87-F8F374D7FA1A2FF58830B10B_see|text=|trigger=button}{sub-section}{sub-section:F5F8F9D50EEA096E-56DAD6F6-43684A10-80E3AC87-F8F374D7FA1A2FF58830B10B_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:F5F8F9D50EEA096E-56DAD6F6-43684A10-80E3AC87-F8F374D7FA1A2FF58830B10B_sam|text=|trigger=button}{sub-section}{sub-section:F5F8F9D50EEA096E-56DAD6F6-43684A10-80E3AC87-F8F374D7FA1A2FF58830B10B_sam|class=sIndent|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}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=F064400B7C649E86-68888198-4CCB41BD-AAFF8470-7ABD486BCB4F248C954C613B}{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:F064400B7C649E86-68888198-4CCB41BD-AAFF8470-7ABD486BCB4F248C954C613B_des|text=|trigger=button}{sub-section}{sub-section:F064400B7C649E86-68888198-4CCB41BD-AAFF8470-7ABD486BCB4F248C954C613B_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=prs}{td}*Parameters*\\{sub-section:F064400B7C649E86-68888198-4CCB41BD-AAFF8470-7ABD486BCB4F248C954C613B_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:F064400B7C649E86-68888198-4CCB41BD-AAFF8470-7ABD486BCB4F248C954C613B_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:F064400B7C649E86-68888198-4CCB41BD-AAFF8470-7ABD486BCB4F248C954C613B_ret|text=|trigger=button}{sub-section}{sub-section:F064400B7C649E86-68888198-4CCB41BD-AAFF8470-7ABD486BCB4F248C954C613B_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:F064400B7C649E86-68888198-4CCB41BD-AAFF8470-7ABD486BCB4F248C954C613B_see|text=|trigger=button}{sub-section}{sub-section:F064400B7C649E86-68888198-4CCB41BD-AAFF8470-7ABD486BCB4F248C954C613B_see|class=sIndent|trigger=none}[.getType|JSColumn#getType]\\{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:F064400B7C649E86-68888198-4CCB41BD-AAFF8470-7ABD486BCB4F248C954C613B_see|text=|trigger=button}{sub-section}{sub-section:F064400B7C649E86-68888198-4CCB41BD-AAFF8470-7ABD486BCB4F248C954C613B_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:F064400B7C649E86-68888198-4CCB41BD-AAFF8470-7ABD486BCB4F248C954C613B_sam|text=|trigger=button}{sub-section}{sub-section:F064400B7C649E86-68888198-4CCB41BD-AAFF8470-7ABD486BCB4F248C954C613B_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('customerid')
var typeName = column.getTypeAsString()
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=2338152E49355F4B-2DC4AD0B-492849D6-A036AF05-A1C741E46E5954BDF9706F0A}{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:2338152E49355F4B-2DC4AD0B-492849D6-A036AF05-A1C741E46E5954BDF9706F0A_des|text=|trigger=button}{sub-section}{sub-section:2338152E49355F4B-2DC4AD0B-492849D6-A036AF05-A1C741E46E5954BDF9706F0A_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=prs}{td}*Parameters*\\{sub-section:2338152E49355F4B-2DC4AD0B-492849D6-A036AF05-A1C741E46E5954BDF9706F0A_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:2338152E49355F4B-2DC4AD0B-492849D6-A036AF05-A1C741E46E5954BDF9706F0A_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:2338152E49355F4B-2DC4AD0B-492849D6-A036AF05-A1C741E46E5954BDF9706F0A_ret|text=|trigger=button}{sub-section}{sub-section:2338152E49355F4B-2DC4AD0B-492849D6-A036AF05-A1C741E46E5954BDF9706F0A_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:2338152E49355F4B-2DC4AD0B-492849D6-A036AF05-A1C741E46E5954BDF9706F0A_see|text=|trigger=button}{sub-section}{sub-section:2338152E49355F4B-2DC4AD0B-492849D6-A036AF05-A1C741E46E5954BDF9706F0A_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:2338152E49355F4B-2DC4AD0B-492849D6-A036AF05-A1C741E46E5954BDF9706F0A_see|text=|trigger=button}{sub-section}{sub-section:2338152E49355F4B-2DC4AD0B-492849D6-A036AF05-A1C741E46E5954BDF9706F0A_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:2338152E49355F4B-2DC4AD0B-492849D6-A036AF05-A1C741E46E5954BDF9706F0A_sam|text=|trigger=button}{sub-section}{sub-section:2338152E49355F4B-2DC4AD0B-492849D6-A036AF05-A1C741E46E5954BDF9706F0A_sam|class=sIndent|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}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=C8AEC726AFD330F9-B806BDC9-4DA947FA-9441975E-12324F7F5DABE8A74E36281B}{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:C8AEC726AFD330F9-B806BDC9-4DA947FA-9441975E-12324F7F5DABE8A74E36281B_des|text=|trigger=button}{sub-section}{sub-section:C8AEC726AFD330F9-B806BDC9-4DA947FA-9441975E-12324F7F5DABE8A74E36281B_des|trigger=none|class=sIndent}Is this column marked as UUID column.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:C8AEC726AFD330F9-B806BDC9-4DA947FA-9441975E-12324F7F5DABE8A74E36281B_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:C8AEC726AFD330F9-B806BDC9-4DA947FA-9441975E-12324F7F5DABE8A74E36281B_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:C8AEC726AFD330F9-B806BDC9-4DA947FA-9441975E-12324F7F5DABE8A74E36281B_ret|text=|trigger=button}{sub-section}{sub-section:C8AEC726AFD330F9-B806BDC9-4DA947FA-9441975E-12324F7F5DABE8A74E36281B_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:C8AEC726AFD330F9-B806BDC9-4DA947FA-9441975E-12324F7F5DABE8A74E36281B_see|text=|trigger=button}{sub-section}{sub-section:C8AEC726AFD330F9-B806BDC9-4DA947FA-9441975E-12324F7F5DABE8A74E36281B_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:C8AEC726AFD330F9-B806BDC9-4DA947FA-9441975E-12324F7F5DABE8A74E36281B_see|text=|trigger=button}{sub-section}{sub-section:C8AEC726AFD330F9-B806BDC9-4DA947FA-9441975E-12324F7F5DABE8A74E36281B_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:C8AEC726AFD330F9-B806BDC9-4DA947FA-9441975E-12324F7F5DABE8A74E36281B_sam|text=|trigger=button}{sub-section}{sub-section:C8AEC726AFD330F9-B806BDC9-4DA947FA-9441975E-12324F7F5DABE8A74E36281B_sam|class=sIndent|trigger=none}{code:language=javascript}
var table = databaseManager.getTable('example_data', 'orders')
var column = table.getColumn('orderid')
if (column.isUUID())
{
	 // handle UUID column
}
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}
Child pages

Versions Compared

Old Version 5

New Version 6

Key
