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=932252B4F3452D22-94CBCF34-446644FD-AEAA9BA7-8C0C780FF8EAA7367AF88FE2}{tr:id=name}{td}h6.DATETIME{td}{tr}{tr:id=des}{td}{sub-section:932252B4F3452D22-94CBCF34-446644FD-AEAA9BA7-8C0C780FF8EAA7367AF88FE2_des|text=|trigger=button}{sub-section}{sub-section:932252B4F3452D22-94CBCF34-446644FD-AEAA9BA7-8C0C780FF8EAA7367AF88FE2_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:932252B4F3452D22-94CBCF34-446644FD-AEAA9BA7-8C0C780FF8EAA7367AF88FE2_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:932252B4F3452D22-94CBCF34-446644FD-AEAA9BA7-8C0C780FF8EAA7367AF88FE2_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:932252B4F3452D22-94CBCF34-446644FD-AEAA9BA7-8C0C780FF8EAA7367AF88FE2_ret|text=|trigger=button}{sub-section}{sub-section:932252B4F3452D22-94CBCF34-446644FD-AEAA9BA7-8C0C780FF8EAA7367AF88FE2_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:932252B4F3452D22-94CBCF34-446644FD-AEAA9BA7-8C0C780FF8EAA7367AF88FE2_see|text=|trigger=button}{sub-section}{sub-section:932252B4F3452D22-94CBCF34-446644FD-AEAA9BA7-8C0C780FF8EAA7367AF88FE2_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:932252B4F3452D22-94CBCF34-446644FD-AEAA9BA7-8C0C780FF8EAA7367AF88FE2_see|text=|trigger=button}{sub-section}{sub-section:932252B4F3452D22-94CBCF34-446644FD-AEAA9BA7-8C0C780FF8EAA7367AF88FE2_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:932252B4F3452D22-94CBCF34-446644FD-AEAA9BA7-8C0C780FF8EAA7367AF88FE2_sam|text=|trigger=button}{sub-section}{sub-section:932252B4F3452D22-94CBCF34-446644FD-AEAA9BA7-8C0C780FF8EAA7367AF88FE2_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=F290AB88E8412829-D9F267A6-40574046-8BC2A427-C86D1DC81F377E02027DAAA7}{tr:id=name}{td}h6.INTEGER{td}{tr}{tr:id=des}{td}{sub-section:F290AB88E8412829-D9F267A6-40574046-8BC2A427-C86D1DC81F377E02027DAAA7_des|text=|trigger=button}{sub-section}{sub-section:F290AB88E8412829-D9F267A6-40574046-8BC2A427-C86D1DC81F377E02027DAAA7_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:F290AB88E8412829-D9F267A6-40574046-8BC2A427-C86D1DC81F377E02027DAAA7_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:F290AB88E8412829-D9F267A6-40574046-8BC2A427-C86D1DC81F377E02027DAAA7_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:F290AB88E8412829-D9F267A6-40574046-8BC2A427-C86D1DC81F377E02027DAAA7_ret|text=|trigger=button}{sub-section}{sub-section:F290AB88E8412829-D9F267A6-40574046-8BC2A427-C86D1DC81F377E02027DAAA7_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:F290AB88E8412829-D9F267A6-40574046-8BC2A427-C86D1DC81F377E02027DAAA7_see|text=|trigger=button}{sub-section}{sub-section:F290AB88E8412829-D9F267A6-40574046-8BC2A427-C86D1DC81F377E02027DAAA7_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:F290AB88E8412829-D9F267A6-40574046-8BC2A427-C86D1DC81F377E02027DAAA7_see|text=|trigger=button}{sub-section}{sub-section:F290AB88E8412829-D9F267A6-40574046-8BC2A427-C86D1DC81F377E02027DAAA7_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:F290AB88E8412829-D9F267A6-40574046-8BC2A427-C86D1DC81F377E02027DAAA7_sam|text=|trigger=button}{sub-section}{sub-section:F290AB88E8412829-D9F267A6-40574046-8BC2A427-C86D1DC81F377E02027DAAA7_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=89E30A85F4A8352D-78FA61A3-4F174956-976BB2F8-432A2E93B388B93E7AFCCB99}{tr:id=name}{td}h6.MEDIA{td}{tr}{tr:id=des}{td}{sub-section:89E30A85F4A8352D-78FA61A3-4F174956-976BB2F8-432A2E93B388B93E7AFCCB99_des|text=|trigger=button}{sub-section}{sub-section:89E30A85F4A8352D-78FA61A3-4F174956-976BB2F8-432A2E93B388B93E7AFCCB99_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:89E30A85F4A8352D-78FA61A3-4F174956-976BB2F8-432A2E93B388B93E7AFCCB99_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:89E30A85F4A8352D-78FA61A3-4F174956-976BB2F8-432A2E93B388B93E7AFCCB99_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:89E30A85F4A8352D-78FA61A3-4F174956-976BB2F8-432A2E93B388B93E7AFCCB99_ret|text=|trigger=button}{sub-section}{sub-section:89E30A85F4A8352D-78FA61A3-4F174956-976BB2F8-432A2E93B388B93E7AFCCB99_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:89E30A85F4A8352D-78FA61A3-4F174956-976BB2F8-432A2E93B388B93E7AFCCB99_see|text=|trigger=button}{sub-section}{sub-section:89E30A85F4A8352D-78FA61A3-4F174956-976BB2F8-432A2E93B388B93E7AFCCB99_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:89E30A85F4A8352D-78FA61A3-4F174956-976BB2F8-432A2E93B388B93E7AFCCB99_see|text=|trigger=button}{sub-section}{sub-section:89E30A85F4A8352D-78FA61A3-4F174956-976BB2F8-432A2E93B388B93E7AFCCB99_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:89E30A85F4A8352D-78FA61A3-4F174956-976BB2F8-432A2E93B388B93E7AFCCB99_sam|text=|trigger=button}{sub-section}{sub-section:89E30A85F4A8352D-78FA61A3-4F174956-976BB2F8-432A2E93B388B93E7AFCCB99_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=FB258252F3514CAF-BCC99D36-43A04E16-872D8C14-39506D50F96599348765A3D2}{tr:id=name}{td}h6.NUMBER{td}{tr}{tr:id=des}{td}{sub-section:FB258252F3514CAF-BCC99D36-43A04E16-872D8C14-39506D50F96599348765A3D2_des|text=|trigger=button}{sub-section}{sub-section:FB258252F3514CAF-BCC99D36-43A04E16-872D8C14-39506D50F96599348765A3D2_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:FB258252F3514CAF-BCC99D36-43A04E16-872D8C14-39506D50F96599348765A3D2_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:FB258252F3514CAF-BCC99D36-43A04E16-872D8C14-39506D50F96599348765A3D2_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:FB258252F3514CAF-BCC99D36-43A04E16-872D8C14-39506D50F96599348765A3D2_ret|text=|trigger=button}{sub-section}{sub-section:FB258252F3514CAF-BCC99D36-43A04E16-872D8C14-39506D50F96599348765A3D2_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:FB258252F3514CAF-BCC99D36-43A04E16-872D8C14-39506D50F96599348765A3D2_see|text=|trigger=button}{sub-section}{sub-section:FB258252F3514CAF-BCC99D36-43A04E16-872D8C14-39506D50F96599348765A3D2_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:FB258252F3514CAF-BCC99D36-43A04E16-872D8C14-39506D50F96599348765A3D2_see|text=|trigger=button}{sub-section}{sub-section:FB258252F3514CAF-BCC99D36-43A04E16-872D8C14-39506D50F96599348765A3D2_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:FB258252F3514CAF-BCC99D36-43A04E16-872D8C14-39506D50F96599348765A3D2_sam|text=|trigger=button}{sub-section}{sub-section:FB258252F3514CAF-BCC99D36-43A04E16-872D8C14-39506D50F96599348765A3D2_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=B26E25C5C6FB8DE3-4C69211C-4B104BC2-B4DD8F38-A0F121F34DCEE1634818FA32}{tr:id=name}{td}h6.TEXT{td}{tr}{tr:id=des}{td}{sub-section:B26E25C5C6FB8DE3-4C69211C-4B104BC2-B4DD8F38-A0F121F34DCEE1634818FA32_des|text=|trigger=button}{sub-section}{sub-section:B26E25C5C6FB8DE3-4C69211C-4B104BC2-B4DD8F38-A0F121F34DCEE1634818FA32_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:B26E25C5C6FB8DE3-4C69211C-4B104BC2-B4DD8F38-A0F121F34DCEE1634818FA32_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:B26E25C5C6FB8DE3-4C69211C-4B104BC2-B4DD8F38-A0F121F34DCEE1634818FA32_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:B26E25C5C6FB8DE3-4C69211C-4B104BC2-B4DD8F38-A0F121F34DCEE1634818FA32_ret|text=|trigger=button}{sub-section}{sub-section:B26E25C5C6FB8DE3-4C69211C-4B104BC2-B4DD8F38-A0F121F34DCEE1634818FA32_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:B26E25C5C6FB8DE3-4C69211C-4B104BC2-B4DD8F38-A0F121F34DCEE1634818FA32_see|text=|trigger=button}{sub-section}{sub-section:B26E25C5C6FB8DE3-4C69211C-4B104BC2-B4DD8F38-A0F121F34DCEE1634818FA32_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:B26E25C5C6FB8DE3-4C69211C-4B104BC2-B4DD8F38-A0F121F34DCEE1634818FA32_see|text=|trigger=button}{sub-section}{sub-section:B26E25C5C6FB8DE3-4C69211C-4B104BC2-B4DD8F38-A0F121F34DCEE1634818FA32_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:B26E25C5C6FB8DE3-4C69211C-4B104BC2-B4DD8F38-A0F121F34DCEE1634818FA32_sam|text=|trigger=button}{sub-section}{sub-section:B26E25C5C6FB8DE3-4C69211C-4B104BC2-B4DD8F38-A0F121F34DCEE1634818FA32_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=24AE586A3EDEBE61-5178E809-40214F93-9156A665-EC4C86D221B61748A7A5D901}{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:24AE586A3EDEBE61-5178E809-40214F93-9156A665-EC4C86D221B61748A7A5D901_des|text=|trigger=button}{sub-section}{sub-section:24AE586A3EDEBE61-5178E809-40214F93-9156A665-EC4C86D221B61748A7A5D901_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:24AE586A3EDEBE61-5178E809-40214F93-9156A665-EC4C86D221B61748A7A5D901_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:24AE586A3EDEBE61-5178E809-40214F93-9156A665-EC4C86D221B61748A7A5D901_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:24AE586A3EDEBE61-5178E809-40214F93-9156A665-EC4C86D221B61748A7A5D901_ret|text=|trigger=button}{sub-section}{sub-section:24AE586A3EDEBE61-5178E809-40214F93-9156A665-EC4C86D221B61748A7A5D901_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:24AE586A3EDEBE61-5178E809-40214F93-9156A665-EC4C86D221B61748A7A5D901_see|text=|trigger=button}{sub-section}{sub-section:24AE586A3EDEBE61-5178E809-40214F93-9156A665-EC4C86D221B61748A7A5D901_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:24AE586A3EDEBE61-5178E809-40214F93-9156A665-EC4C86D221B61748A7A5D901_see|text=|trigger=button}{sub-section}{sub-section:24AE586A3EDEBE61-5178E809-40214F93-9156A665-EC4C86D221B61748A7A5D901_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:24AE586A3EDEBE61-5178E809-40214F93-9156A665-EC4C86D221B61748A7A5D901_sam|text=|trigger=button}{sub-section}{sub-section:24AE586A3EDEBE61-5178E809-40214F93-9156A665-EC4C86D221B61748A7A5D901_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=4424D707E0A7244C-3C999C6F-4D4C46DD-8A7E807F-F144D67B9A91E7326D910563}{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:4424D707E0A7244C-3C999C6F-4D4C46DD-8A7E807F-F144D67B9A91E7326D910563_des|text=|trigger=button}{sub-section}{sub-section:4424D707E0A7244C-3C999C6F-4D4C46DD-8A7E807F-F144D67B9A91E7326D910563_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:4424D707E0A7244C-3C999C6F-4D4C46DD-8A7E807F-F144D67B9A91E7326D910563_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:4424D707E0A7244C-3C999C6F-4D4C46DD-8A7E807F-F144D67B9A91E7326D910563_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:4424D707E0A7244C-3C999C6F-4D4C46DD-8A7E807F-F144D67B9A91E7326D910563_ret|text=|trigger=button}{sub-section}{sub-section:4424D707E0A7244C-3C999C6F-4D4C46DD-8A7E807F-F144D67B9A91E7326D910563_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:4424D707E0A7244C-3C999C6F-4D4C46DD-8A7E807F-F144D67B9A91E7326D910563_see|text=|trigger=button}{sub-section}{sub-section:4424D707E0A7244C-3C999C6F-4D4C46DD-8A7E807F-F144D67B9A91E7326D910563_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:4424D707E0A7244C-3C999C6F-4D4C46DD-8A7E807F-F144D67B9A91E7326D910563_see|text=|trigger=button}{sub-section}{sub-section:4424D707E0A7244C-3C999C6F-4D4C46DD-8A7E807F-F144D67B9A91E7326D910563_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:4424D707E0A7244C-3C999C6F-4D4C46DD-8A7E807F-F144D67B9A91E7326D910563_sam|text=|trigger=button}{sub-section}{sub-section:4424D707E0A7244C-3C999C6F-4D4C46DD-8A7E807F-F144D67B9A91E7326D910563_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=17685712FC3B4E1F-CE117D02-4483480A-85CB8463-F20A9B8786DC0B8B810B7252}{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:17685712FC3B4E1F-CE117D02-4483480A-85CB8463-F20A9B8786DC0B8B810B7252_des|text=|trigger=button}{sub-section}{sub-section:17685712FC3B4E1F-CE117D02-4483480A-85CB8463-F20A9B8786DC0B8B810B7252_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:17685712FC3B4E1F-CE117D02-4483480A-85CB8463-F20A9B8786DC0B8B810B7252_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:17685712FC3B4E1F-CE117D02-4483480A-85CB8463-F20A9B8786DC0B8B810B7252_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:17685712FC3B4E1F-CE117D02-4483480A-85CB8463-F20A9B8786DC0B8B810B7252_ret|text=|trigger=button}{sub-section}{sub-section:17685712FC3B4E1F-CE117D02-4483480A-85CB8463-F20A9B8786DC0B8B810B7252_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:17685712FC3B4E1F-CE117D02-4483480A-85CB8463-F20A9B8786DC0B8B810B7252_see|text=|trigger=button}{sub-section}{sub-section:17685712FC3B4E1F-CE117D02-4483480A-85CB8463-F20A9B8786DC0B8B810B7252_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:17685712FC3B4E1F-CE117D02-4483480A-85CB8463-F20A9B8786DC0B8B810B7252_see|text=|trigger=button}{sub-section}{sub-section:17685712FC3B4E1F-CE117D02-4483480A-85CB8463-F20A9B8786DC0B8B810B7252_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:17685712FC3B4E1F-CE117D02-4483480A-85CB8463-F20A9B8786DC0B8B810B7252_sam|text=|trigger=button}{sub-section}{sub-section:17685712FC3B4E1F-CE117D02-4483480A-85CB8463-F20A9B8786DC0B8B810B7252_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=F59D855B5ADF4AAF-E2C98811-4FDB4BBB-B2F7AF2E-4AACF74F792459C1A5037405}{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:F59D855B5ADF4AAF-E2C98811-4FDB4BBB-B2F7AF2E-4AACF74F792459C1A5037405_des|text=|trigger=button}{sub-section}{sub-section:F59D855B5ADF4AAF-E2C98811-4FDB4BBB-B2F7AF2E-4AACF74F792459C1A5037405_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:F59D855B5ADF4AAF-E2C98811-4FDB4BBB-B2F7AF2E-4AACF74F792459C1A5037405_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:F59D855B5ADF4AAF-E2C98811-4FDB4BBB-B2F7AF2E-4AACF74F792459C1A5037405_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:F59D855B5ADF4AAF-E2C98811-4FDB4BBB-B2F7AF2E-4AACF74F792459C1A5037405_ret|text=|trigger=button}{sub-section}{sub-section:F59D855B5ADF4AAF-E2C98811-4FDB4BBB-B2F7AF2E-4AACF74F792459C1A5037405_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:F59D855B5ADF4AAF-E2C98811-4FDB4BBB-B2F7AF2E-4AACF74F792459C1A5037405_see|text=|trigger=button}{sub-section}{sub-section:F59D855B5ADF4AAF-E2C98811-4FDB4BBB-B2F7AF2E-4AACF74F792459C1A5037405_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:F59D855B5ADF4AAF-E2C98811-4FDB4BBB-B2F7AF2E-4AACF74F792459C1A5037405_see|text=|trigger=button}{sub-section}{sub-section:F59D855B5ADF4AAF-E2C98811-4FDB4BBB-B2F7AF2E-4AACF74F792459C1A5037405_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:F59D855B5ADF4AAF-E2C98811-4FDB4BBB-B2F7AF2E-4AACF74F792459C1A5037405_sam|text=|trigger=button}{sub-section}{sub-section:F59D855B5ADF4AAF-E2C98811-4FDB4BBB-B2F7AF2E-4AACF74F792459C1A5037405_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=6018588924609BC3-198BAEEF-4E644615-81E591AA-DB7B47E74D8211BC5E2723C6}{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:6018588924609BC3-198BAEEF-4E644615-81E591AA-DB7B47E74D8211BC5E2723C6_des|text=|trigger=button}{sub-section}{sub-section:6018588924609BC3-198BAEEF-4E644615-81E591AA-DB7B47E74D8211BC5E2723C6_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:6018588924609BC3-198BAEEF-4E644615-81E591AA-DB7B47E74D8211BC5E2723C6_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:6018588924609BC3-198BAEEF-4E644615-81E591AA-DB7B47E74D8211BC5E2723C6_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:6018588924609BC3-198BAEEF-4E644615-81E591AA-DB7B47E74D8211BC5E2723C6_ret|text=|trigger=button}{sub-section}{sub-section:6018588924609BC3-198BAEEF-4E644615-81E591AA-DB7B47E74D8211BC5E2723C6_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:6018588924609BC3-198BAEEF-4E644615-81E591AA-DB7B47E74D8211BC5E2723C6_see|text=|trigger=button}{sub-section}{sub-section:6018588924609BC3-198BAEEF-4E644615-81E591AA-DB7B47E74D8211BC5E2723C6_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:6018588924609BC3-198BAEEF-4E644615-81E591AA-DB7B47E74D8211BC5E2723C6_see|text=|trigger=button}{sub-section}{sub-section:6018588924609BC3-198BAEEF-4E644615-81E591AA-DB7B47E74D8211BC5E2723C6_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:6018588924609BC3-198BAEEF-4E644615-81E591AA-DB7B47E74D8211BC5E2723C6_sam|text=|trigger=button}{sub-section}{sub-section:6018588924609BC3-198BAEEF-4E644615-81E591AA-DB7B47E74D8211BC5E2723C6_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=F9E9D13314CBC64E-855BA5AE-4B74413A-96CBB897-D046E5DCC63ACDDF5238564E}{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:F9E9D13314CBC64E-855BA5AE-4B74413A-96CBB897-D046E5DCC63ACDDF5238564E_des|text=|trigger=button}{sub-section}{sub-section:F9E9D13314CBC64E-855BA5AE-4B74413A-96CBB897-D046E5DCC63ACDDF5238564E_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:F9E9D13314CBC64E-855BA5AE-4B74413A-96CBB897-D046E5DCC63ACDDF5238564E_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:F9E9D13314CBC64E-855BA5AE-4B74413A-96CBB897-D046E5DCC63ACDDF5238564E_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:F9E9D13314CBC64E-855BA5AE-4B74413A-96CBB897-D046E5DCC63ACDDF5238564E_ret|text=|trigger=button}{sub-section}{sub-section:F9E9D13314CBC64E-855BA5AE-4B74413A-96CBB897-D046E5DCC63ACDDF5238564E_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:F9E9D13314CBC64E-855BA5AE-4B74413A-96CBB897-D046E5DCC63ACDDF5238564E_see|text=|trigger=button}{sub-section}{sub-section:F9E9D13314CBC64E-855BA5AE-4B74413A-96CBB897-D046E5DCC63ACDDF5238564E_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:F9E9D13314CBC64E-855BA5AE-4B74413A-96CBB897-D046E5DCC63ACDDF5238564E_see|text=|trigger=button}{sub-section}{sub-section:F9E9D13314CBC64E-855BA5AE-4B74413A-96CBB897-D046E5DCC63ACDDF5238564E_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:F9E9D13314CBC64E-855BA5AE-4B74413A-96CBB897-D046E5DCC63ACDDF5238564E_sam|text=|trigger=button}{sub-section}{sub-section:F9E9D13314CBC64E-855BA5AE-4B74413A-96CBB897-D046E5DCC63ACDDF5238564E_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=D29C2AF198D38A96-55CAE220-4F2D40AF-AA54A0B7-8F9F0DAAAC651D4420410688}{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:D29C2AF198D38A96-55CAE220-4F2D40AF-AA54A0B7-8F9F0DAAAC651D4420410688_des|text=|trigger=button}{sub-section}{sub-section:D29C2AF198D38A96-55CAE220-4F2D40AF-AA54A0B7-8F9F0DAAAC651D4420410688_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:D29C2AF198D38A96-55CAE220-4F2D40AF-AA54A0B7-8F9F0DAAAC651D4420410688_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:D29C2AF198D38A96-55CAE220-4F2D40AF-AA54A0B7-8F9F0DAAAC651D4420410688_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:D29C2AF198D38A96-55CAE220-4F2D40AF-AA54A0B7-8F9F0DAAAC651D4420410688_ret|text=|trigger=button}{sub-section}{sub-section:D29C2AF198D38A96-55CAE220-4F2D40AF-AA54A0B7-8F9F0DAAAC651D4420410688_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:D29C2AF198D38A96-55CAE220-4F2D40AF-AA54A0B7-8F9F0DAAAC651D4420410688_see|text=|trigger=button}{sub-section}{sub-section:D29C2AF198D38A96-55CAE220-4F2D40AF-AA54A0B7-8F9F0DAAAC651D4420410688_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:D29C2AF198D38A96-55CAE220-4F2D40AF-AA54A0B7-8F9F0DAAAC651D4420410688_see|text=|trigger=button}{sub-section}{sub-section:D29C2AF198D38A96-55CAE220-4F2D40AF-AA54A0B7-8F9F0DAAAC651D4420410688_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:D29C2AF198D38A96-55CAE220-4F2D40AF-AA54A0B7-8F9F0DAAAC651D4420410688_sam|text=|trigger=button}{sub-section}{sub-section:D29C2AF198D38A96-55CAE220-4F2D40AF-AA54A0B7-8F9F0DAAAC651D4420410688_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=BFCDE9743EC19478-0B0C119C-4DFC4789-931F8981-274FFB58180A5CA9EB7AA2F2}{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:BFCDE9743EC19478-0B0C119C-4DFC4789-931F8981-274FFB58180A5CA9EB7AA2F2_des|text=|trigger=button}{sub-section}{sub-section:BFCDE9743EC19478-0B0C119C-4DFC4789-931F8981-274FFB58180A5CA9EB7AA2F2_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:BFCDE9743EC19478-0B0C119C-4DFC4789-931F8981-274FFB58180A5CA9EB7AA2F2_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:BFCDE9743EC19478-0B0C119C-4DFC4789-931F8981-274FFB58180A5CA9EB7AA2F2_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:BFCDE9743EC19478-0B0C119C-4DFC4789-931F8981-274FFB58180A5CA9EB7AA2F2_ret|text=|trigger=button}{sub-section}{sub-section:BFCDE9743EC19478-0B0C119C-4DFC4789-931F8981-274FFB58180A5CA9EB7AA2F2_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:BFCDE9743EC19478-0B0C119C-4DFC4789-931F8981-274FFB58180A5CA9EB7AA2F2_see|text=|trigger=button}{sub-section}{sub-section:BFCDE9743EC19478-0B0C119C-4DFC4789-931F8981-274FFB58180A5CA9EB7AA2F2_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:BFCDE9743EC19478-0B0C119C-4DFC4789-931F8981-274FFB58180A5CA9EB7AA2F2_see|text=|trigger=button}{sub-section}{sub-section:BFCDE9743EC19478-0B0C119C-4DFC4789-931F8981-274FFB58180A5CA9EB7AA2F2_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:BFCDE9743EC19478-0B0C119C-4DFC4789-931F8981-274FFB58180A5CA9EB7AA2F2_sam|text=|trigger=button}{sub-section}{sub-section:BFCDE9743EC19478-0B0C119C-4DFC4789-931F8981-274FFB58180A5CA9EB7AA2F2_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=F28BEFC30B71D172-54FAEF24-4DE243C0-B879BEAC-DB643B4D9570574F619D5757}{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:F28BEFC30B71D172-54FAEF24-4DE243C0-B879BEAC-DB643B4D9570574F619D5757_des|text=|trigger=button}{sub-section}{sub-section:F28BEFC30B71D172-54FAEF24-4DE243C0-B879BEAC-DB643B4D9570574F619D5757_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:F28BEFC30B71D172-54FAEF24-4DE243C0-B879BEAC-DB643B4D9570574F619D5757_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:F28BEFC30B71D172-54FAEF24-4DE243C0-B879BEAC-DB643B4D9570574F619D5757_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:F28BEFC30B71D172-54FAEF24-4DE243C0-B879BEAC-DB643B4D9570574F619D5757_ret|text=|trigger=button}{sub-section}{sub-section:F28BEFC30B71D172-54FAEF24-4DE243C0-B879BEAC-DB643B4D9570574F619D5757_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:F28BEFC30B71D172-54FAEF24-4DE243C0-B879BEAC-DB643B4D9570574F619D5757_see|text=|trigger=button}{sub-section}{sub-section:F28BEFC30B71D172-54FAEF24-4DE243C0-B879BEAC-DB643B4D9570574F619D5757_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:F28BEFC30B71D172-54FAEF24-4DE243C0-B879BEAC-DB643B4D9570574F619D5757_see|text=|trigger=button}{sub-section}{sub-section:F28BEFC30B71D172-54FAEF24-4DE243C0-B879BEAC-DB643B4D9570574F619D5757_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:F28BEFC30B71D172-54FAEF24-4DE243C0-B879BEAC-DB643B4D9570574F619D5757_sam|text=|trigger=button}{sub-section}{sub-section:F28BEFC30B71D172-54FAEF24-4DE243C0-B879BEAC-DB643B4D9570574F619D5757_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=58F55A6E97E54686-7FC8B24B-490F46A5-BFD29146-AADF92075F319D4724400D1D}{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:58F55A6E97E54686-7FC8B24B-490F46A5-BFD29146-AADF92075F319D4724400D1D_des|text=|trigger=button}{sub-section}{sub-section:58F55A6E97E54686-7FC8B24B-490F46A5-BFD29146-AADF92075F319D4724400D1D_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:58F55A6E97E54686-7FC8B24B-490F46A5-BFD29146-AADF92075F319D4724400D1D_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:58F55A6E97E54686-7FC8B24B-490F46A5-BFD29146-AADF92075F319D4724400D1D_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:58F55A6E97E54686-7FC8B24B-490F46A5-BFD29146-AADF92075F319D4724400D1D_ret|text=|trigger=button}{sub-section}{sub-section:58F55A6E97E54686-7FC8B24B-490F46A5-BFD29146-AADF92075F319D4724400D1D_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:58F55A6E97E54686-7FC8B24B-490F46A5-BFD29146-AADF92075F319D4724400D1D_see|text=|trigger=button}{sub-section}{sub-section:58F55A6E97E54686-7FC8B24B-490F46A5-BFD29146-AADF92075F319D4724400D1D_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:58F55A6E97E54686-7FC8B24B-490F46A5-BFD29146-AADF92075F319D4724400D1D_see|text=|trigger=button}{sub-section}{sub-section:58F55A6E97E54686-7FC8B24B-490F46A5-BFD29146-AADF92075F319D4724400D1D_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:58F55A6E97E54686-7FC8B24B-490F46A5-BFD29146-AADF92075F319D4724400D1D_sam|text=|trigger=button}{sub-section}{sub-section:58F55A6E97E54686-7FC8B24B-490F46A5-BFD29146-AADF92075F319D4724400D1D_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=0B4B1083725F1E35-6C694FD3-483E4E85-80E78582-38A4888EBE19DD04B43752EC}{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:0B4B1083725F1E35-6C694FD3-483E4E85-80E78582-38A4888EBE19DD04B43752EC_des|text=|trigger=button}{sub-section}{sub-section:0B4B1083725F1E35-6C694FD3-483E4E85-80E78582-38A4888EBE19DD04B43752EC_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:0B4B1083725F1E35-6C694FD3-483E4E85-80E78582-38A4888EBE19DD04B43752EC_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:0B4B1083725F1E35-6C694FD3-483E4E85-80E78582-38A4888EBE19DD04B43752EC_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:0B4B1083725F1E35-6C694FD3-483E4E85-80E78582-38A4888EBE19DD04B43752EC_ret|text=|trigger=button}{sub-section}{sub-section:0B4B1083725F1E35-6C694FD3-483E4E85-80E78582-38A4888EBE19DD04B43752EC_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:0B4B1083725F1E35-6C694FD3-483E4E85-80E78582-38A4888EBE19DD04B43752EC_see|text=|trigger=button}{sub-section}{sub-section:0B4B1083725F1E35-6C694FD3-483E4E85-80E78582-38A4888EBE19DD04B43752EC_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:0B4B1083725F1E35-6C694FD3-483E4E85-80E78582-38A4888EBE19DD04B43752EC_see|text=|trigger=button}{sub-section}{sub-section:0B4B1083725F1E35-6C694FD3-483E4E85-80E78582-38A4888EBE19DD04B43752EC_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:0B4B1083725F1E35-6C694FD3-483E4E85-80E78582-38A4888EBE19DD04B43752EC_sam|text=|trigger=button}{sub-section}{sub-section:0B4B1083725F1E35-6C694FD3-483E4E85-80E78582-38A4888EBE19DD04B43752EC_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=581E0C5C1FCB51F4-E2D34DE0-401E4781-A92E8294-4595BFB1F8FF52FB9F78D04B}{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:581E0C5C1FCB51F4-E2D34DE0-401E4781-A92E8294-4595BFB1F8FF52FB9F78D04B_des|text=|trigger=button}{sub-section}{sub-section:581E0C5C1FCB51F4-E2D34DE0-401E4781-A92E8294-4595BFB1F8FF52FB9F78D04B_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:581E0C5C1FCB51F4-E2D34DE0-401E4781-A92E8294-4595BFB1F8FF52FB9F78D04B_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:581E0C5C1FCB51F4-E2D34DE0-401E4781-A92E8294-4595BFB1F8FF52FB9F78D04B_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:581E0C5C1FCB51F4-E2D34DE0-401E4781-A92E8294-4595BFB1F8FF52FB9F78D04B_ret|text=|trigger=button}{sub-section}{sub-section:581E0C5C1FCB51F4-E2D34DE0-401E4781-A92E8294-4595BFB1F8FF52FB9F78D04B_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:581E0C5C1FCB51F4-E2D34DE0-401E4781-A92E8294-4595BFB1F8FF52FB9F78D04B_see|text=|trigger=button}{sub-section}{sub-section:581E0C5C1FCB51F4-E2D34DE0-401E4781-A92E8294-4595BFB1F8FF52FB9F78D04B_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:581E0C5C1FCB51F4-E2D34DE0-401E4781-A92E8294-4595BFB1F8FF52FB9F78D04B_see|text=|trigger=button}{sub-section}{sub-section:581E0C5C1FCB51F4-E2D34DE0-401E4781-A92E8294-4595BFB1F8FF52FB9F78D04B_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:581E0C5C1FCB51F4-E2D34DE0-401E4781-A92E8294-4595BFB1F8FF52FB9F78D04B_sam|text=|trigger=button}{sub-section}{sub-section:581E0C5C1FCB51F4-E2D34DE0-401E4781-A92E8294-4595BFB1F8FF52FB9F78D04B_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=FC5667A883BBEC22-4EDC595A-4D0A41AC-83D3B5AD-244E7D164E80F36B9FDAAFD6}{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:FC5667A883BBEC22-4EDC595A-4D0A41AC-83D3B5AD-244E7D164E80F36B9FDAAFD6_des|text=|trigger=button}{sub-section}{sub-section:FC5667A883BBEC22-4EDC595A-4D0A41AC-83D3B5AD-244E7D164E80F36B9FDAAFD6_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:FC5667A883BBEC22-4EDC595A-4D0A41AC-83D3B5AD-244E7D164E80F36B9FDAAFD6_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:FC5667A883BBEC22-4EDC595A-4D0A41AC-83D3B5AD-244E7D164E80F36B9FDAAFD6_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:FC5667A883BBEC22-4EDC595A-4D0A41AC-83D3B5AD-244E7D164E80F36B9FDAAFD6_ret|text=|trigger=button}{sub-section}{sub-section:FC5667A883BBEC22-4EDC595A-4D0A41AC-83D3B5AD-244E7D164E80F36B9FDAAFD6_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:FC5667A883BBEC22-4EDC595A-4D0A41AC-83D3B5AD-244E7D164E80F36B9FDAAFD6_see|text=|trigger=button}{sub-section}{sub-section:FC5667A883BBEC22-4EDC595A-4D0A41AC-83D3B5AD-244E7D164E80F36B9FDAAFD6_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:FC5667A883BBEC22-4EDC595A-4D0A41AC-83D3B5AD-244E7D164E80F36B9FDAAFD6_see|text=|trigger=button}{sub-section}{sub-section:FC5667A883BBEC22-4EDC595A-4D0A41AC-83D3B5AD-244E7D164E80F36B9FDAAFD6_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:FC5667A883BBEC22-4EDC595A-4D0A41AC-83D3B5AD-244E7D164E80F36B9FDAAFD6_sam|text=|trigger=button}{sub-section}{sub-section:FC5667A883BBEC22-4EDC595A-4D0A41AC-83D3B5AD-244E7D164E80F36B9FDAAFD6_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=F4CE95F4E7C34D63-CEEDB08B-44514571-8B5EAF2D-89F8FC8C9645F671B1878AF6}{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:F4CE95F4E7C34D63-CEEDB08B-44514571-8B5EAF2D-89F8FC8C9645F671B1878AF6_des|text=|trigger=button}{sub-section}{sub-section:F4CE95F4E7C34D63-CEEDB08B-44514571-8B5EAF2D-89F8FC8C9645F671B1878AF6_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:F4CE95F4E7C34D63-CEEDB08B-44514571-8B5EAF2D-89F8FC8C9645F671B1878AF6_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:F4CE95F4E7C34D63-CEEDB08B-44514571-8B5EAF2D-89F8FC8C9645F671B1878AF6_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:F4CE95F4E7C34D63-CEEDB08B-44514571-8B5EAF2D-89F8FC8C9645F671B1878AF6_ret|text=|trigger=button}{sub-section}{sub-section:F4CE95F4E7C34D63-CEEDB08B-44514571-8B5EAF2D-89F8FC8C9645F671B1878AF6_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:F4CE95F4E7C34D63-CEEDB08B-44514571-8B5EAF2D-89F8FC8C9645F671B1878AF6_see|text=|trigger=button}{sub-section}{sub-section:F4CE95F4E7C34D63-CEEDB08B-44514571-8B5EAF2D-89F8FC8C9645F671B1878AF6_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:F4CE95F4E7C34D63-CEEDB08B-44514571-8B5EAF2D-89F8FC8C9645F671B1878AF6_see|text=|trigger=button}{sub-section}{sub-section:F4CE95F4E7C34D63-CEEDB08B-44514571-8B5EAF2D-89F8FC8C9645F671B1878AF6_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:F4CE95F4E7C34D63-CEEDB08B-44514571-8B5EAF2D-89F8FC8C9645F671B1878AF6_sam|text=|trigger=button}{sub-section}{sub-section:F4CE95F4E7C34D63-CEEDB08B-44514571-8B5EAF2D-89F8FC8C9645F671B1878AF6_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 7

New Version 8

Key
