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=6B6E4248F89210AF-96B7FAF4-492C4754-B5929DBE-B6FA71CEBBF4BC4B19CDF564}{tr:id=name}{td}h6.DATETIME{td}{tr}{tr:id=des}{td}{sub-section:6B6E4248F89210AF-96B7FAF4-492C4754-B5929DBE-B6FA71CEBBF4BC4B19CDF564_des|text=|trigger=button}{sub-section}{sub-section:6B6E4248F89210AF-96B7FAF4-492C4754-B5929DBE-B6FA71CEBBF4BC4B19CDF564_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:6B6E4248F89210AF-96B7FAF4-492C4754-B5929DBE-B6FA71CEBBF4BC4B19CDF564_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:6B6E4248F89210AF-96B7FAF4-492C4754-B5929DBE-B6FA71CEBBF4BC4B19CDF564_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:6B6E4248F89210AF-96B7FAF4-492C4754-B5929DBE-B6FA71CEBBF4BC4B19CDF564_ret|text=|trigger=button}{sub-section}{sub-section:6B6E4248F89210AF-96B7FAF4-492C4754-B5929DBE-B6FA71CEBBF4BC4B19CDF564_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:6B6E4248F89210AF-96B7FAF4-492C4754-B5929DBE-B6FA71CEBBF4BC4B19CDF564_see|text=|trigger=button}{sub-section}{sub-section:6B6E4248F89210AF-96B7FAF4-492C4754-B5929DBE-B6FA71CEBBF4BC4B19CDF564_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:6B6E4248F89210AF-96B7FAF4-492C4754-B5929DBE-B6FA71CEBBF4BC4B19CDF564_see|text=|trigger=button}{sub-section}{sub-section:6B6E4248F89210AF-96B7FAF4-492C4754-B5929DBE-B6FA71CEBBF4BC4B19CDF564_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:6B6E4248F89210AF-96B7FAF4-492C4754-B5929DBE-B6FA71CEBBF4BC4B19CDF564_sam|text=|trigger=button}{sub-section}{sub-section:6B6E4248F89210AF-96B7FAF4-492C4754-B5929DBE-B6FA71CEBBF4BC4B19CDF564_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=E1AC93821124F6D8-D39A7958-400C4D96-8770BCFF-28A0300AC1F5D5D07DCCBB4A}{tr:id=name}{td}h6.INTEGER{td}{tr}{tr:id=des}{td}{sub-section:E1AC93821124F6D8-D39A7958-400C4D96-8770BCFF-28A0300AC1F5D5D07DCCBB4A_des|text=|trigger=button}{sub-section}{sub-section:E1AC93821124F6D8-D39A7958-400C4D96-8770BCFF-28A0300AC1F5D5D07DCCBB4A_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:E1AC93821124F6D8-D39A7958-400C4D96-8770BCFF-28A0300AC1F5D5D07DCCBB4A_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:E1AC93821124F6D8-D39A7958-400C4D96-8770BCFF-28A0300AC1F5D5D07DCCBB4A_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:E1AC93821124F6D8-D39A7958-400C4D96-8770BCFF-28A0300AC1F5D5D07DCCBB4A_ret|text=|trigger=button}{sub-section}{sub-section:E1AC93821124F6D8-D39A7958-400C4D96-8770BCFF-28A0300AC1F5D5D07DCCBB4A_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:E1AC93821124F6D8-D39A7958-400C4D96-8770BCFF-28A0300AC1F5D5D07DCCBB4A_see|text=|trigger=button}{sub-section}{sub-section:E1AC93821124F6D8-D39A7958-400C4D96-8770BCFF-28A0300AC1F5D5D07DCCBB4A_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:E1AC93821124F6D8-D39A7958-400C4D96-8770BCFF-28A0300AC1F5D5D07DCCBB4A_see|text=|trigger=button}{sub-section}{sub-section:E1AC93821124F6D8-D39A7958-400C4D96-8770BCFF-28A0300AC1F5D5D07DCCBB4A_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:E1AC93821124F6D8-D39A7958-400C4D96-8770BCFF-28A0300AC1F5D5D07DCCBB4A_sam|text=|trigger=button}{sub-section}{sub-section:E1AC93821124F6D8-D39A7958-400C4D96-8770BCFF-28A0300AC1F5D5D07DCCBB4A_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=E123E8826865E761-E2CEBE36-41DA48A4-A18498CE-87D7321F2B6AA8915BCE8E3E}{tr:id=name}{td}h6.MEDIA{td}{tr}{tr:id=des}{td}{sub-section:E123E8826865E761-E2CEBE36-41DA48A4-A18498CE-87D7321F2B6AA8915BCE8E3E_des|text=|trigger=button}{sub-section}{sub-section:E123E8826865E761-E2CEBE36-41DA48A4-A18498CE-87D7321F2B6AA8915BCE8E3E_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:E123E8826865E761-E2CEBE36-41DA48A4-A18498CE-87D7321F2B6AA8915BCE8E3E_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:E123E8826865E761-E2CEBE36-41DA48A4-A18498CE-87D7321F2B6AA8915BCE8E3E_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:E123E8826865E761-E2CEBE36-41DA48A4-A18498CE-87D7321F2B6AA8915BCE8E3E_ret|text=|trigger=button}{sub-section}{sub-section:E123E8826865E761-E2CEBE36-41DA48A4-A18498CE-87D7321F2B6AA8915BCE8E3E_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:E123E8826865E761-E2CEBE36-41DA48A4-A18498CE-87D7321F2B6AA8915BCE8E3E_see|text=|trigger=button}{sub-section}{sub-section:E123E8826865E761-E2CEBE36-41DA48A4-A18498CE-87D7321F2B6AA8915BCE8E3E_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:E123E8826865E761-E2CEBE36-41DA48A4-A18498CE-87D7321F2B6AA8915BCE8E3E_see|text=|trigger=button}{sub-section}{sub-section:E123E8826865E761-E2CEBE36-41DA48A4-A18498CE-87D7321F2B6AA8915BCE8E3E_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:E123E8826865E761-E2CEBE36-41DA48A4-A18498CE-87D7321F2B6AA8915BCE8E3E_sam|text=|trigger=button}{sub-section}{sub-section:E123E8826865E761-E2CEBE36-41DA48A4-A18498CE-87D7321F2B6AA8915BCE8E3E_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=085A26CE2F8FC29F-3304BD0C-4D454C7F-BB1585C5-5DA22218DDD3477F6466C4AD}{tr:id=name}{td}h6.NUMBER{td}{tr}{tr:id=des}{td}{sub-section:085A26CE2F8FC29F-3304BD0C-4D454C7F-BB1585C5-5DA22218DDD3477F6466C4AD_des|text=|trigger=button}{sub-section}{sub-section:085A26CE2F8FC29F-3304BD0C-4D454C7F-BB1585C5-5DA22218DDD3477F6466C4AD_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:085A26CE2F8FC29F-3304BD0C-4D454C7F-BB1585C5-5DA22218DDD3477F6466C4AD_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:085A26CE2F8FC29F-3304BD0C-4D454C7F-BB1585C5-5DA22218DDD3477F6466C4AD_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:085A26CE2F8FC29F-3304BD0C-4D454C7F-BB1585C5-5DA22218DDD3477F6466C4AD_ret|text=|trigger=button}{sub-section}{sub-section:085A26CE2F8FC29F-3304BD0C-4D454C7F-BB1585C5-5DA22218DDD3477F6466C4AD_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:085A26CE2F8FC29F-3304BD0C-4D454C7F-BB1585C5-5DA22218DDD3477F6466C4AD_see|text=|trigger=button}{sub-section}{sub-section:085A26CE2F8FC29F-3304BD0C-4D454C7F-BB1585C5-5DA22218DDD3477F6466C4AD_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:085A26CE2F8FC29F-3304BD0C-4D454C7F-BB1585C5-5DA22218DDD3477F6466C4AD_see|text=|trigger=button}{sub-section}{sub-section:085A26CE2F8FC29F-3304BD0C-4D454C7F-BB1585C5-5DA22218DDD3477F6466C4AD_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:085A26CE2F8FC29F-3304BD0C-4D454C7F-BB1585C5-5DA22218DDD3477F6466C4AD_sam|text=|trigger=button}{sub-section}{sub-section:085A26CE2F8FC29F-3304BD0C-4D454C7F-BB1585C5-5DA22218DDD3477F6466C4AD_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=F982ED84E685A791-190C9E1E-4E55469D-A153A2FB-35E73A542A813580867575BC}{tr:id=name}{td}h6.TEXT{td}{tr}{tr:id=des}{td}{sub-section:F982ED84E685A791-190C9E1E-4E55469D-A153A2FB-35E73A542A813580867575BC_des|text=|trigger=button}{sub-section}{sub-section:F982ED84E685A791-190C9E1E-4E55469D-A153A2FB-35E73A542A813580867575BC_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:F982ED84E685A791-190C9E1E-4E55469D-A153A2FB-35E73A542A813580867575BC_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:F982ED84E685A791-190C9E1E-4E55469D-A153A2FB-35E73A542A813580867575BC_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:F982ED84E685A791-190C9E1E-4E55469D-A153A2FB-35E73A542A813580867575BC_ret|text=|trigger=button}{sub-section}{sub-section:F982ED84E685A791-190C9E1E-4E55469D-A153A2FB-35E73A542A813580867575BC_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:F982ED84E685A791-190C9E1E-4E55469D-A153A2FB-35E73A542A813580867575BC_see|text=|trigger=button}{sub-section}{sub-section:F982ED84E685A791-190C9E1E-4E55469D-A153A2FB-35E73A542A813580867575BC_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:F982ED84E685A791-190C9E1E-4E55469D-A153A2FB-35E73A542A813580867575BC_see|text=|trigger=button}{sub-section}{sub-section:F982ED84E685A791-190C9E1E-4E55469D-A153A2FB-35E73A542A813580867575BC_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:F982ED84E685A791-190C9E1E-4E55469D-A153A2FB-35E73A542A813580867575BC_sam|text=|trigger=button}{sub-section}{sub-section:F982ED84E685A791-190C9E1E-4E55469D-A153A2FB-35E73A542A813580867575BC_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=4B2F5B76CE6EC76C-6D4CEEF3-44C2458B-924FA03E-53CD8E3C2D308FE5F44D84DA}{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:4B2F5B76CE6EC76C-6D4CEEF3-44C2458B-924FA03E-53CD8E3C2D308FE5F44D84DA_des|text=|trigger=button}{sub-section}{sub-section:4B2F5B76CE6EC76C-6D4CEEF3-44C2458B-924FA03E-53CD8E3C2D308FE5F44D84DA_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:4B2F5B76CE6EC76C-6D4CEEF3-44C2458B-924FA03E-53CD8E3C2D308FE5F44D84DA_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:4B2F5B76CE6EC76C-6D4CEEF3-44C2458B-924FA03E-53CD8E3C2D308FE5F44D84DA_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:4B2F5B76CE6EC76C-6D4CEEF3-44C2458B-924FA03E-53CD8E3C2D308FE5F44D84DA_ret|text=|trigger=button}{sub-section}{sub-section:4B2F5B76CE6EC76C-6D4CEEF3-44C2458B-924FA03E-53CD8E3C2D308FE5F44D84DA_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:4B2F5B76CE6EC76C-6D4CEEF3-44C2458B-924FA03E-53CD8E3C2D308FE5F44D84DA_see|text=|trigger=button}{sub-section}{sub-section:4B2F5B76CE6EC76C-6D4CEEF3-44C2458B-924FA03E-53CD8E3C2D308FE5F44D84DA_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:4B2F5B76CE6EC76C-6D4CEEF3-44C2458B-924FA03E-53CD8E3C2D308FE5F44D84DA_see|text=|trigger=button}{sub-section}{sub-section:4B2F5B76CE6EC76C-6D4CEEF3-44C2458B-924FA03E-53CD8E3C2D308FE5F44D84DA_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:4B2F5B76CE6EC76C-6D4CEEF3-44C2458B-924FA03E-53CD8E3C2D308FE5F44D84DA_sam|text=|trigger=button}{sub-section}{sub-section:4B2F5B76CE6EC76C-6D4CEEF3-44C2458B-924FA03E-53CD8E3C2D308FE5F44D84DA_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=8F319A6FEFDC8576-F8C6598B-4E64456E-A66BB445-1067A8E3B1EC8EB3FC6A1B2F}{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:8F319A6FEFDC8576-F8C6598B-4E64456E-A66BB445-1067A8E3B1EC8EB3FC6A1B2F_des|text=|trigger=button}{sub-section}{sub-section:8F319A6FEFDC8576-F8C6598B-4E64456E-A66BB445-1067A8E3B1EC8EB3FC6A1B2F_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:8F319A6FEFDC8576-F8C6598B-4E64456E-A66BB445-1067A8E3B1EC8EB3FC6A1B2F_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:8F319A6FEFDC8576-F8C6598B-4E64456E-A66BB445-1067A8E3B1EC8EB3FC6A1B2F_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:8F319A6FEFDC8576-F8C6598B-4E64456E-A66BB445-1067A8E3B1EC8EB3FC6A1B2F_ret|text=|trigger=button}{sub-section}{sub-section:8F319A6FEFDC8576-F8C6598B-4E64456E-A66BB445-1067A8E3B1EC8EB3FC6A1B2F_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:8F319A6FEFDC8576-F8C6598B-4E64456E-A66BB445-1067A8E3B1EC8EB3FC6A1B2F_see|text=|trigger=button}{sub-section}{sub-section:8F319A6FEFDC8576-F8C6598B-4E64456E-A66BB445-1067A8E3B1EC8EB3FC6A1B2F_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:8F319A6FEFDC8576-F8C6598B-4E64456E-A66BB445-1067A8E3B1EC8EB3FC6A1B2F_see|text=|trigger=button}{sub-section}{sub-section:8F319A6FEFDC8576-F8C6598B-4E64456E-A66BB445-1067A8E3B1EC8EB3FC6A1B2F_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:8F319A6FEFDC8576-F8C6598B-4E64456E-A66BB445-1067A8E3B1EC8EB3FC6A1B2F_sam|text=|trigger=button}{sub-section}{sub-section:8F319A6FEFDC8576-F8C6598B-4E64456E-A66BB445-1067A8E3B1EC8EB3FC6A1B2F_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=0CBFABC16AA859A7-151EB394-427F493C-BC0EAF70-52D91B876B080BF14F50F3B9}{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:0CBFABC16AA859A7-151EB394-427F493C-BC0EAF70-52D91B876B080BF14F50F3B9_des|text=|trigger=button}{sub-section}{sub-section:0CBFABC16AA859A7-151EB394-427F493C-BC0EAF70-52D91B876B080BF14F50F3B9_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:0CBFABC16AA859A7-151EB394-427F493C-BC0EAF70-52D91B876B080BF14F50F3B9_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:0CBFABC16AA859A7-151EB394-427F493C-BC0EAF70-52D91B876B080BF14F50F3B9_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:0CBFABC16AA859A7-151EB394-427F493C-BC0EAF70-52D91B876B080BF14F50F3B9_ret|text=|trigger=button}{sub-section}{sub-section:0CBFABC16AA859A7-151EB394-427F493C-BC0EAF70-52D91B876B080BF14F50F3B9_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:0CBFABC16AA859A7-151EB394-427F493C-BC0EAF70-52D91B876B080BF14F50F3B9_see|text=|trigger=button}{sub-section}{sub-section:0CBFABC16AA859A7-151EB394-427F493C-BC0EAF70-52D91B876B080BF14F50F3B9_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:0CBFABC16AA859A7-151EB394-427F493C-BC0EAF70-52D91B876B080BF14F50F3B9_see|text=|trigger=button}{sub-section}{sub-section:0CBFABC16AA859A7-151EB394-427F493C-BC0EAF70-52D91B876B080BF14F50F3B9_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:0CBFABC16AA859A7-151EB394-427F493C-BC0EAF70-52D91B876B080BF14F50F3B9_sam|text=|trigger=button}{sub-section}{sub-section:0CBFABC16AA859A7-151EB394-427F493C-BC0EAF70-52D91B876B080BF14F50F3B9_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=408B3AE85637E392-413368A9-493940CC-BFEA8198-0DDB35FFB94BAFD8340A6237}{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:408B3AE85637E392-413368A9-493940CC-BFEA8198-0DDB35FFB94BAFD8340A6237_des|text=|trigger=button}{sub-section}{sub-section:408B3AE85637E392-413368A9-493940CC-BFEA8198-0DDB35FFB94BAFD8340A6237_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:408B3AE85637E392-413368A9-493940CC-BFEA8198-0DDB35FFB94BAFD8340A6237_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:408B3AE85637E392-413368A9-493940CC-BFEA8198-0DDB35FFB94BAFD8340A6237_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:408B3AE85637E392-413368A9-493940CC-BFEA8198-0DDB35FFB94BAFD8340A6237_ret|text=|trigger=button}{sub-section}{sub-section:408B3AE85637E392-413368A9-493940CC-BFEA8198-0DDB35FFB94BAFD8340A6237_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:408B3AE85637E392-413368A9-493940CC-BFEA8198-0DDB35FFB94BAFD8340A6237_see|text=|trigger=button}{sub-section}{sub-section:408B3AE85637E392-413368A9-493940CC-BFEA8198-0DDB35FFB94BAFD8340A6237_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:408B3AE85637E392-413368A9-493940CC-BFEA8198-0DDB35FFB94BAFD8340A6237_see|text=|trigger=button}{sub-section}{sub-section:408B3AE85637E392-413368A9-493940CC-BFEA8198-0DDB35FFB94BAFD8340A6237_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:408B3AE85637E392-413368A9-493940CC-BFEA8198-0DDB35FFB94BAFD8340A6237_sam|text=|trigger=button}{sub-section}{sub-section:408B3AE85637E392-413368A9-493940CC-BFEA8198-0DDB35FFB94BAFD8340A6237_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=E8F5D75176170BCE-97B477DD-431149D1-8B5D8AEF-FD414DBFFB647F30EEE5FAB8}{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:E8F5D75176170BCE-97B477DD-431149D1-8B5D8AEF-FD414DBFFB647F30EEE5FAB8_des|text=|trigger=button}{sub-section}{sub-section:E8F5D75176170BCE-97B477DD-431149D1-8B5D8AEF-FD414DBFFB647F30EEE5FAB8_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:E8F5D75176170BCE-97B477DD-431149D1-8B5D8AEF-FD414DBFFB647F30EEE5FAB8_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:E8F5D75176170BCE-97B477DD-431149D1-8B5D8AEF-FD414DBFFB647F30EEE5FAB8_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:E8F5D75176170BCE-97B477DD-431149D1-8B5D8AEF-FD414DBFFB647F30EEE5FAB8_ret|text=|trigger=button}{sub-section}{sub-section:E8F5D75176170BCE-97B477DD-431149D1-8B5D8AEF-FD414DBFFB647F30EEE5FAB8_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:E8F5D75176170BCE-97B477DD-431149D1-8B5D8AEF-FD414DBFFB647F30EEE5FAB8_see|text=|trigger=button}{sub-section}{sub-section:E8F5D75176170BCE-97B477DD-431149D1-8B5D8AEF-FD414DBFFB647F30EEE5FAB8_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:E8F5D75176170BCE-97B477DD-431149D1-8B5D8AEF-FD414DBFFB647F30EEE5FAB8_see|text=|trigger=button}{sub-section}{sub-section:E8F5D75176170BCE-97B477DD-431149D1-8B5D8AEF-FD414DBFFB647F30EEE5FAB8_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:E8F5D75176170BCE-97B477DD-431149D1-8B5D8AEF-FD414DBFFB647F30EEE5FAB8_sam|text=|trigger=button}{sub-section}{sub-section:E8F5D75176170BCE-97B477DD-431149D1-8B5D8AEF-FD414DBFFB647F30EEE5FAB8_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=ABCBD7D1829ED117-73D5661F-454441EB-8B908557-F9E930487413F1A05FE7E578}{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:ABCBD7D1829ED117-73D5661F-454441EB-8B908557-F9E930487413F1A05FE7E578_des|text=|trigger=button}{sub-section}{sub-section:ABCBD7D1829ED117-73D5661F-454441EB-8B908557-F9E930487413F1A05FE7E578_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:ABCBD7D1829ED117-73D5661F-454441EB-8B908557-F9E930487413F1A05FE7E578_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:ABCBD7D1829ED117-73D5661F-454441EB-8B908557-F9E930487413F1A05FE7E578_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:ABCBD7D1829ED117-73D5661F-454441EB-8B908557-F9E930487413F1A05FE7E578_ret|text=|trigger=button}{sub-section}{sub-section:ABCBD7D1829ED117-73D5661F-454441EB-8B908557-F9E930487413F1A05FE7E578_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:ABCBD7D1829ED117-73D5661F-454441EB-8B908557-F9E930487413F1A05FE7E578_see|text=|trigger=button}{sub-section}{sub-section:ABCBD7D1829ED117-73D5661F-454441EB-8B908557-F9E930487413F1A05FE7E578_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:ABCBD7D1829ED117-73D5661F-454441EB-8B908557-F9E930487413F1A05FE7E578_see|text=|trigger=button}{sub-section}{sub-section:ABCBD7D1829ED117-73D5661F-454441EB-8B908557-F9E930487413F1A05FE7E578_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:ABCBD7D1829ED117-73D5661F-454441EB-8B908557-F9E930487413F1A05FE7E578_sam|text=|trigger=button}{sub-section}{sub-section:ABCBD7D1829ED117-73D5661F-454441EB-8B908557-F9E930487413F1A05FE7E578_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=94C3FB4F0ABB56B0-BE249F27-44A24BEB-A1B2AF35-E276FB2965FCFAF07B0DCAC1}{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:94C3FB4F0ABB56B0-BE249F27-44A24BEB-A1B2AF35-E276FB2965FCFAF07B0DCAC1_des|text=|trigger=button}{sub-section}{sub-section:94C3FB4F0ABB56B0-BE249F27-44A24BEB-A1B2AF35-E276FB2965FCFAF07B0DCAC1_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:94C3FB4F0ABB56B0-BE249F27-44A24BEB-A1B2AF35-E276FB2965FCFAF07B0DCAC1_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:94C3FB4F0ABB56B0-BE249F27-44A24BEB-A1B2AF35-E276FB2965FCFAF07B0DCAC1_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:94C3FB4F0ABB56B0-BE249F27-44A24BEB-A1B2AF35-E276FB2965FCFAF07B0DCAC1_ret|text=|trigger=button}{sub-section}{sub-section:94C3FB4F0ABB56B0-BE249F27-44A24BEB-A1B2AF35-E276FB2965FCFAF07B0DCAC1_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:94C3FB4F0ABB56B0-BE249F27-44A24BEB-A1B2AF35-E276FB2965FCFAF07B0DCAC1_see|text=|trigger=button}{sub-section}{sub-section:94C3FB4F0ABB56B0-BE249F27-44A24BEB-A1B2AF35-E276FB2965FCFAF07B0DCAC1_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:94C3FB4F0ABB56B0-BE249F27-44A24BEB-A1B2AF35-E276FB2965FCFAF07B0DCAC1_see|text=|trigger=button}{sub-section}{sub-section:94C3FB4F0ABB56B0-BE249F27-44A24BEB-A1B2AF35-E276FB2965FCFAF07B0DCAC1_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:94C3FB4F0ABB56B0-BE249F27-44A24BEB-A1B2AF35-E276FB2965FCFAF07B0DCAC1_sam|text=|trigger=button}{sub-section}{sub-section:94C3FB4F0ABB56B0-BE249F27-44A24BEB-A1B2AF35-E276FB2965FCFAF07B0DCAC1_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=F4060BA633245B55-03BAE9E1-40834893-B0188F64-C2A1062C6A29F4F07565CE05}{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:F4060BA633245B55-03BAE9E1-40834893-B0188F64-C2A1062C6A29F4F07565CE05_des|text=|trigger=button}{sub-section}{sub-section:F4060BA633245B55-03BAE9E1-40834893-B0188F64-C2A1062C6A29F4F07565CE05_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:F4060BA633245B55-03BAE9E1-40834893-B0188F64-C2A1062C6A29F4F07565CE05_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:F4060BA633245B55-03BAE9E1-40834893-B0188F64-C2A1062C6A29F4F07565CE05_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:F4060BA633245B55-03BAE9E1-40834893-B0188F64-C2A1062C6A29F4F07565CE05_ret|text=|trigger=button}{sub-section}{sub-section:F4060BA633245B55-03BAE9E1-40834893-B0188F64-C2A1062C6A29F4F07565CE05_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:F4060BA633245B55-03BAE9E1-40834893-B0188F64-C2A1062C6A29F4F07565CE05_see|text=|trigger=button}{sub-section}{sub-section:F4060BA633245B55-03BAE9E1-40834893-B0188F64-C2A1062C6A29F4F07565CE05_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:F4060BA633245B55-03BAE9E1-40834893-B0188F64-C2A1062C6A29F4F07565CE05_see|text=|trigger=button}{sub-section}{sub-section:F4060BA633245B55-03BAE9E1-40834893-B0188F64-C2A1062C6A29F4F07565CE05_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:F4060BA633245B55-03BAE9E1-40834893-B0188F64-C2A1062C6A29F4F07565CE05_sam|text=|trigger=button}{sub-section}{sub-section:F4060BA633245B55-03BAE9E1-40834893-B0188F64-C2A1062C6A29F4F07565CE05_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=6933AEA1B2053266-F2014818-48E1470A-8A1BBBE1-2E65EDEC7CBAD5FA3A2B46F8}{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:6933AEA1B2053266-F2014818-48E1470A-8A1BBBE1-2E65EDEC7CBAD5FA3A2B46F8_des|text=|trigger=button}{sub-section}{sub-section:6933AEA1B2053266-F2014818-48E1470A-8A1BBBE1-2E65EDEC7CBAD5FA3A2B46F8_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:6933AEA1B2053266-F2014818-48E1470A-8A1BBBE1-2E65EDEC7CBAD5FA3A2B46F8_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:6933AEA1B2053266-F2014818-48E1470A-8A1BBBE1-2E65EDEC7CBAD5FA3A2B46F8_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:6933AEA1B2053266-F2014818-48E1470A-8A1BBBE1-2E65EDEC7CBAD5FA3A2B46F8_ret|text=|trigger=button}{sub-section}{sub-section:6933AEA1B2053266-F2014818-48E1470A-8A1BBBE1-2E65EDEC7CBAD5FA3A2B46F8_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:6933AEA1B2053266-F2014818-48E1470A-8A1BBBE1-2E65EDEC7CBAD5FA3A2B46F8_see|text=|trigger=button}{sub-section}{sub-section:6933AEA1B2053266-F2014818-48E1470A-8A1BBBE1-2E65EDEC7CBAD5FA3A2B46F8_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:6933AEA1B2053266-F2014818-48E1470A-8A1BBBE1-2E65EDEC7CBAD5FA3A2B46F8_see|text=|trigger=button}{sub-section}{sub-section:6933AEA1B2053266-F2014818-48E1470A-8A1BBBE1-2E65EDEC7CBAD5FA3A2B46F8_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:6933AEA1B2053266-F2014818-48E1470A-8A1BBBE1-2E65EDEC7CBAD5FA3A2B46F8_sam|text=|trigger=button}{sub-section}{sub-section:6933AEA1B2053266-F2014818-48E1470A-8A1BBBE1-2E65EDEC7CBAD5FA3A2B46F8_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=C3DCCC0267613F15-1427C398-4C6E42AC-8DF8892D-ED6BE8B446AA186B5EF4E41F}{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:C3DCCC0267613F15-1427C398-4C6E42AC-8DF8892D-ED6BE8B446AA186B5EF4E41F_des|text=|trigger=button}{sub-section}{sub-section:C3DCCC0267613F15-1427C398-4C6E42AC-8DF8892D-ED6BE8B446AA186B5EF4E41F_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:C3DCCC0267613F15-1427C398-4C6E42AC-8DF8892D-ED6BE8B446AA186B5EF4E41F_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:C3DCCC0267613F15-1427C398-4C6E42AC-8DF8892D-ED6BE8B446AA186B5EF4E41F_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:C3DCCC0267613F15-1427C398-4C6E42AC-8DF8892D-ED6BE8B446AA186B5EF4E41F_ret|text=|trigger=button}{sub-section}{sub-section:C3DCCC0267613F15-1427C398-4C6E42AC-8DF8892D-ED6BE8B446AA186B5EF4E41F_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:C3DCCC0267613F15-1427C398-4C6E42AC-8DF8892D-ED6BE8B446AA186B5EF4E41F_see|text=|trigger=button}{sub-section}{sub-section:C3DCCC0267613F15-1427C398-4C6E42AC-8DF8892D-ED6BE8B446AA186B5EF4E41F_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:C3DCCC0267613F15-1427C398-4C6E42AC-8DF8892D-ED6BE8B446AA186B5EF4E41F_see|text=|trigger=button}{sub-section}{sub-section:C3DCCC0267613F15-1427C398-4C6E42AC-8DF8892D-ED6BE8B446AA186B5EF4E41F_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:C3DCCC0267613F15-1427C398-4C6E42AC-8DF8892D-ED6BE8B446AA186B5EF4E41F_sam|text=|trigger=button}{sub-section}{sub-section:C3DCCC0267613F15-1427C398-4C6E42AC-8DF8892D-ED6BE8B446AA186B5EF4E41F_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=D9E607B6675DB78F-A409950E-49244B6D-B718B3C1-4A701495B546424402729FDE}{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:D9E607B6675DB78F-A409950E-49244B6D-B718B3C1-4A701495B546424402729FDE_des|text=|trigger=button}{sub-section}{sub-section:D9E607B6675DB78F-A409950E-49244B6D-B718B3C1-4A701495B546424402729FDE_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:D9E607B6675DB78F-A409950E-49244B6D-B718B3C1-4A701495B546424402729FDE_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:D9E607B6675DB78F-A409950E-49244B6D-B718B3C1-4A701495B546424402729FDE_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:D9E607B6675DB78F-A409950E-49244B6D-B718B3C1-4A701495B546424402729FDE_ret|text=|trigger=button}{sub-section}{sub-section:D9E607B6675DB78F-A409950E-49244B6D-B718B3C1-4A701495B546424402729FDE_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:D9E607B6675DB78F-A409950E-49244B6D-B718B3C1-4A701495B546424402729FDE_see|text=|trigger=button}{sub-section}{sub-section:D9E607B6675DB78F-A409950E-49244B6D-B718B3C1-4A701495B546424402729FDE_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:D9E607B6675DB78F-A409950E-49244B6D-B718B3C1-4A701495B546424402729FDE_see|text=|trigger=button}{sub-section}{sub-section:D9E607B6675DB78F-A409950E-49244B6D-B718B3C1-4A701495B546424402729FDE_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:D9E607B6675DB78F-A409950E-49244B6D-B718B3C1-4A701495B546424402729FDE_sam|text=|trigger=button}{sub-section}{sub-section:D9E607B6675DB78F-A409950E-49244B6D-B718B3C1-4A701495B546424402729FDE_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=C8C953304211D0BD-BC05FEC9-4F6A4084-BABFA0DF-10E4AB7A399E6CB34B6761DC}{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:C8C953304211D0BD-BC05FEC9-4F6A4084-BABFA0DF-10E4AB7A399E6CB34B6761DC_des|text=|trigger=button}{sub-section}{sub-section:C8C953304211D0BD-BC05FEC9-4F6A4084-BABFA0DF-10E4AB7A399E6CB34B6761DC_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:C8C953304211D0BD-BC05FEC9-4F6A4084-BABFA0DF-10E4AB7A399E6CB34B6761DC_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:C8C953304211D0BD-BC05FEC9-4F6A4084-BABFA0DF-10E4AB7A399E6CB34B6761DC_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:C8C953304211D0BD-BC05FEC9-4F6A4084-BABFA0DF-10E4AB7A399E6CB34B6761DC_ret|text=|trigger=button}{sub-section}{sub-section:C8C953304211D0BD-BC05FEC9-4F6A4084-BABFA0DF-10E4AB7A399E6CB34B6761DC_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:C8C953304211D0BD-BC05FEC9-4F6A4084-BABFA0DF-10E4AB7A399E6CB34B6761DC_see|text=|trigger=button}{sub-section}{sub-section:C8C953304211D0BD-BC05FEC9-4F6A4084-BABFA0DF-10E4AB7A399E6CB34B6761DC_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:C8C953304211D0BD-BC05FEC9-4F6A4084-BABFA0DF-10E4AB7A399E6CB34B6761DC_see|text=|trigger=button}{sub-section}{sub-section:C8C953304211D0BD-BC05FEC9-4F6A4084-BABFA0DF-10E4AB7A399E6CB34B6761DC_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:C8C953304211D0BD-BC05FEC9-4F6A4084-BABFA0DF-10E4AB7A399E6CB34B6761DC_sam|text=|trigger=button}{sub-section}{sub-section:C8C953304211D0BD-BC05FEC9-4F6A4084-BABFA0DF-10E4AB7A399E6CB34B6761DC_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=75E5CF0A31FF7A05-9587E9E2-44D645F0-94CE97C3-3DE98527F07B1E606EE3FC33}{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:75E5CF0A31FF7A05-9587E9E2-44D645F0-94CE97C3-3DE98527F07B1E606EE3FC33_des|text=|trigger=button}{sub-section}{sub-section:75E5CF0A31FF7A05-9587E9E2-44D645F0-94CE97C3-3DE98527F07B1E606EE3FC33_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:75E5CF0A31FF7A05-9587E9E2-44D645F0-94CE97C3-3DE98527F07B1E606EE3FC33_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:75E5CF0A31FF7A05-9587E9E2-44D645F0-94CE97C3-3DE98527F07B1E606EE3FC33_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:75E5CF0A31FF7A05-9587E9E2-44D645F0-94CE97C3-3DE98527F07B1E606EE3FC33_ret|text=|trigger=button}{sub-section}{sub-section:75E5CF0A31FF7A05-9587E9E2-44D645F0-94CE97C3-3DE98527F07B1E606EE3FC33_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:75E5CF0A31FF7A05-9587E9E2-44D645F0-94CE97C3-3DE98527F07B1E606EE3FC33_see|text=|trigger=button}{sub-section}{sub-section:75E5CF0A31FF7A05-9587E9E2-44D645F0-94CE97C3-3DE98527F07B1E606EE3FC33_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:75E5CF0A31FF7A05-9587E9E2-44D645F0-94CE97C3-3DE98527F07B1E606EE3FC33_see|text=|trigger=button}{sub-section}{sub-section:75E5CF0A31FF7A05-9587E9E2-44D645F0-94CE97C3-3DE98527F07B1E606EE3FC33_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:75E5CF0A31FF7A05-9587E9E2-44D645F0-94CE97C3-3DE98527F07B1E606EE3FC33_sam|text=|trigger=button}{sub-section}{sub-section:75E5CF0A31FF7A05-9587E9E2-44D645F0-94CE97C3-3DE98527F07B1E606EE3FC33_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=22BB46745C084C42-AC8F9D6A-47F54F4A-BDEBA2C0-E8F7728236D59A996576C31A}{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:22BB46745C084C42-AC8F9D6A-47F54F4A-BDEBA2C0-E8F7728236D59A996576C31A_des|text=|trigger=button}{sub-section}{sub-section:22BB46745C084C42-AC8F9D6A-47F54F4A-BDEBA2C0-E8F7728236D59A996576C31A_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:22BB46745C084C42-AC8F9D6A-47F54F4A-BDEBA2C0-E8F7728236D59A996576C31A_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:22BB46745C084C42-AC8F9D6A-47F54F4A-BDEBA2C0-E8F7728236D59A996576C31A_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:22BB46745C084C42-AC8F9D6A-47F54F4A-BDEBA2C0-E8F7728236D59A996576C31A_ret|text=|trigger=button}{sub-section}{sub-section:22BB46745C084C42-AC8F9D6A-47F54F4A-BDEBA2C0-E8F7728236D59A996576C31A_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:22BB46745C084C42-AC8F9D6A-47F54F4A-BDEBA2C0-E8F7728236D59A996576C31A_see|text=|trigger=button}{sub-section}{sub-section:22BB46745C084C42-AC8F9D6A-47F54F4A-BDEBA2C0-E8F7728236D59A996576C31A_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:22BB46745C084C42-AC8F9D6A-47F54F4A-BDEBA2C0-E8F7728236D59A996576C31A_see|text=|trigger=button}{sub-section}{sub-section:22BB46745C084C42-AC8F9D6A-47F54F4A-BDEBA2C0-E8F7728236D59A996576C31A_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:22BB46745C084C42-AC8F9D6A-47F54F4A-BDEBA2C0-E8F7728236D59A996576C31A_sam|text=|trigger=button}{sub-section}{sub-section:22BB46745C084C42-AC8F9D6A-47F54F4A-BDEBA2C0-E8F7728236D59A996576C31A_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 1

New Version 2

Key
