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=EC9060FCC08173B2-2275F587-45FE4185-AC7FAEDD-098AA142334A5CD9D1C72BFA}{tr:id=name}{td}h6.DATETIME{td}{tr}{tr:id=des}{td}{sub-section:EC9060FCC08173B2-2275F587-45FE4185-AC7FAEDD-098AA142334A5CD9D1C72BFA_des|text=|trigger=button}{sub-section}{sub-section:EC9060FCC08173B2-2275F587-45FE4185-AC7FAEDD-098AA142334A5CD9D1C72BFA_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:EC9060FCC08173B2-2275F587-45FE4185-AC7FAEDD-098AA142334A5CD9D1C72BFA_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:EC9060FCC08173B2-2275F587-45FE4185-AC7FAEDD-098AA142334A5CD9D1C72BFA_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:EC9060FCC08173B2-2275F587-45FE4185-AC7FAEDD-098AA142334A5CD9D1C72BFA_ret|text=|trigger=button}{sub-section}{sub-section:EC9060FCC08173B2-2275F587-45FE4185-AC7FAEDD-098AA142334A5CD9D1C72BFA_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:EC9060FCC08173B2-2275F587-45FE4185-AC7FAEDD-098AA142334A5CD9D1C72BFA_see|text=|trigger=button}{sub-section}{sub-section:EC9060FCC08173B2-2275F587-45FE4185-AC7FAEDD-098AA142334A5CD9D1C72BFA_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:EC9060FCC08173B2-2275F587-45FE4185-AC7FAEDD-098AA142334A5CD9D1C72BFA_see|text=|trigger=button}{sub-section}{sub-section:EC9060FCC08173B2-2275F587-45FE4185-AC7FAEDD-098AA142334A5CD9D1C72BFA_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:EC9060FCC08173B2-2275F587-45FE4185-AC7FAEDD-098AA142334A5CD9D1C72BFA_sam|text=|trigger=button}{sub-section}{sub-section:EC9060FCC08173B2-2275F587-45FE4185-AC7FAEDD-098AA142334A5CD9D1C72BFA_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=52A7C09E60DC8AD7-BC9D662D-407B46C2-98288187-4E6B2467DF0557EBE3D96FB3}{tr:id=name}{td}h6.INTEGER{td}{tr}{tr:id=des}{td}{sub-section:52A7C09E60DC8AD7-BC9D662D-407B46C2-98288187-4E6B2467DF0557EBE3D96FB3_des|text=|trigger=button}{sub-section}{sub-section:52A7C09E60DC8AD7-BC9D662D-407B46C2-98288187-4E6B2467DF0557EBE3D96FB3_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:52A7C09E60DC8AD7-BC9D662D-407B46C2-98288187-4E6B2467DF0557EBE3D96FB3_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:52A7C09E60DC8AD7-BC9D662D-407B46C2-98288187-4E6B2467DF0557EBE3D96FB3_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:52A7C09E60DC8AD7-BC9D662D-407B46C2-98288187-4E6B2467DF0557EBE3D96FB3_ret|text=|trigger=button}{sub-section}{sub-section:52A7C09E60DC8AD7-BC9D662D-407B46C2-98288187-4E6B2467DF0557EBE3D96FB3_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:52A7C09E60DC8AD7-BC9D662D-407B46C2-98288187-4E6B2467DF0557EBE3D96FB3_see|text=|trigger=button}{sub-section}{sub-section:52A7C09E60DC8AD7-BC9D662D-407B46C2-98288187-4E6B2467DF0557EBE3D96FB3_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:52A7C09E60DC8AD7-BC9D662D-407B46C2-98288187-4E6B2467DF0557EBE3D96FB3_see|text=|trigger=button}{sub-section}{sub-section:52A7C09E60DC8AD7-BC9D662D-407B46C2-98288187-4E6B2467DF0557EBE3D96FB3_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:52A7C09E60DC8AD7-BC9D662D-407B46C2-98288187-4E6B2467DF0557EBE3D96FB3_sam|text=|trigger=button}{sub-section}{sub-section:52A7C09E60DC8AD7-BC9D662D-407B46C2-98288187-4E6B2467DF0557EBE3D96FB3_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=0E2F615E56EED363-2ECE2298-43F443BC-AC0E9560-9B1641BA9F156FB70714E828}{tr:id=name}{td}h6.MEDIA{td}{tr}{tr:id=des}{td}{sub-section:0E2F615E56EED363-2ECE2298-43F443BC-AC0E9560-9B1641BA9F156FB70714E828_des|text=|trigger=button}{sub-section}{sub-section:0E2F615E56EED363-2ECE2298-43F443BC-AC0E9560-9B1641BA9F156FB70714E828_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:0E2F615E56EED363-2ECE2298-43F443BC-AC0E9560-9B1641BA9F156FB70714E828_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:0E2F615E56EED363-2ECE2298-43F443BC-AC0E9560-9B1641BA9F156FB70714E828_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:0E2F615E56EED363-2ECE2298-43F443BC-AC0E9560-9B1641BA9F156FB70714E828_ret|text=|trigger=button}{sub-section}{sub-section:0E2F615E56EED363-2ECE2298-43F443BC-AC0E9560-9B1641BA9F156FB70714E828_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:0E2F615E56EED363-2ECE2298-43F443BC-AC0E9560-9B1641BA9F156FB70714E828_see|text=|trigger=button}{sub-section}{sub-section:0E2F615E56EED363-2ECE2298-43F443BC-AC0E9560-9B1641BA9F156FB70714E828_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:0E2F615E56EED363-2ECE2298-43F443BC-AC0E9560-9B1641BA9F156FB70714E828_see|text=|trigger=button}{sub-section}{sub-section:0E2F615E56EED363-2ECE2298-43F443BC-AC0E9560-9B1641BA9F156FB70714E828_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:0E2F615E56EED363-2ECE2298-43F443BC-AC0E9560-9B1641BA9F156FB70714E828_sam|text=|trigger=button}{sub-section}{sub-section:0E2F615E56EED363-2ECE2298-43F443BC-AC0E9560-9B1641BA9F156FB70714E828_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=F36DF2D8B4871984-E2DD83B1-4BF140A5-BA8FAAC2-D1B3387A030E36E198EB4913}{tr:id=name}{td}h6.NUMBER{td}{tr}{tr:id=des}{td}{sub-section:F36DF2D8B4871984-E2DD83B1-4BF140A5-BA8FAAC2-D1B3387A030E36E198EB4913_des|text=|trigger=button}{sub-section}{sub-section:F36DF2D8B4871984-E2DD83B1-4BF140A5-BA8FAAC2-D1B3387A030E36E198EB4913_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:F36DF2D8B4871984-E2DD83B1-4BF140A5-BA8FAAC2-D1B3387A030E36E198EB4913_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:F36DF2D8B4871984-E2DD83B1-4BF140A5-BA8FAAC2-D1B3387A030E36E198EB4913_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:F36DF2D8B4871984-E2DD83B1-4BF140A5-BA8FAAC2-D1B3387A030E36E198EB4913_ret|text=|trigger=button}{sub-section}{sub-section:F36DF2D8B4871984-E2DD83B1-4BF140A5-BA8FAAC2-D1B3387A030E36E198EB4913_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:F36DF2D8B4871984-E2DD83B1-4BF140A5-BA8FAAC2-D1B3387A030E36E198EB4913_see|text=|trigger=button}{sub-section}{sub-section:F36DF2D8B4871984-E2DD83B1-4BF140A5-BA8FAAC2-D1B3387A030E36E198EB4913_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:F36DF2D8B4871984-E2DD83B1-4BF140A5-BA8FAAC2-D1B3387A030E36E198EB4913_see|text=|trigger=button}{sub-section}{sub-section:F36DF2D8B4871984-E2DD83B1-4BF140A5-BA8FAAC2-D1B3387A030E36E198EB4913_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:F36DF2D8B4871984-E2DD83B1-4BF140A5-BA8FAAC2-D1B3387A030E36E198EB4913_sam|text=|trigger=button}{sub-section}{sub-section:F36DF2D8B4871984-E2DD83B1-4BF140A5-BA8FAAC2-D1B3387A030E36E198EB4913_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=E1B82EF510B27A92-6CCDDD18-4C324B26-AB07B7A1-4611A52A50D2031EC5F4806C}{tr:id=name}{td}h6.TEXT{td}{tr}{tr:id=des}{td}{sub-section:E1B82EF510B27A92-6CCDDD18-4C324B26-AB07B7A1-4611A52A50D2031EC5F4806C_des|text=|trigger=button}{sub-section}{sub-section:E1B82EF510B27A92-6CCDDD18-4C324B26-AB07B7A1-4611A52A50D2031EC5F4806C_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:E1B82EF510B27A92-6CCDDD18-4C324B26-AB07B7A1-4611A52A50D2031EC5F4806C_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:E1B82EF510B27A92-6CCDDD18-4C324B26-AB07B7A1-4611A52A50D2031EC5F4806C_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:E1B82EF510B27A92-6CCDDD18-4C324B26-AB07B7A1-4611A52A50D2031EC5F4806C_ret|text=|trigger=button}{sub-section}{sub-section:E1B82EF510B27A92-6CCDDD18-4C324B26-AB07B7A1-4611A52A50D2031EC5F4806C_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:E1B82EF510B27A92-6CCDDD18-4C324B26-AB07B7A1-4611A52A50D2031EC5F4806C_see|text=|trigger=button}{sub-section}{sub-section:E1B82EF510B27A92-6CCDDD18-4C324B26-AB07B7A1-4611A52A50D2031EC5F4806C_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:E1B82EF510B27A92-6CCDDD18-4C324B26-AB07B7A1-4611A52A50D2031EC5F4806C_see|text=|trigger=button}{sub-section}{sub-section:E1B82EF510B27A92-6CCDDD18-4C324B26-AB07B7A1-4611A52A50D2031EC5F4806C_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:E1B82EF510B27A92-6CCDDD18-4C324B26-AB07B7A1-4611A52A50D2031EC5F4806C_sam|text=|trigger=button}{sub-section}{sub-section:E1B82EF510B27A92-6CCDDD18-4C324B26-AB07B7A1-4611A52A50D2031EC5F4806C_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=9C6233A0CC25F433-0F7B38B2-4B6A467A-96A8BC9A-47937D38F0AA42D4A46CB29B}{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:9C6233A0CC25F433-0F7B38B2-4B6A467A-96A8BC9A-47937D38F0AA42D4A46CB29B_des|text=|trigger=button}{sub-section}{sub-section:9C6233A0CC25F433-0F7B38B2-4B6A467A-96A8BC9A-47937D38F0AA42D4A46CB29B_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:9C6233A0CC25F433-0F7B38B2-4B6A467A-96A8BC9A-47937D38F0AA42D4A46CB29B_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:9C6233A0CC25F433-0F7B38B2-4B6A467A-96A8BC9A-47937D38F0AA42D4A46CB29B_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:9C6233A0CC25F433-0F7B38B2-4B6A467A-96A8BC9A-47937D38F0AA42D4A46CB29B_ret|text=|trigger=button}{sub-section}{sub-section:9C6233A0CC25F433-0F7B38B2-4B6A467A-96A8BC9A-47937D38F0AA42D4A46CB29B_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:9C6233A0CC25F433-0F7B38B2-4B6A467A-96A8BC9A-47937D38F0AA42D4A46CB29B_see|text=|trigger=button}{sub-section}{sub-section:9C6233A0CC25F433-0F7B38B2-4B6A467A-96A8BC9A-47937D38F0AA42D4A46CB29B_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:9C6233A0CC25F433-0F7B38B2-4B6A467A-96A8BC9A-47937D38F0AA42D4A46CB29B_see|text=|trigger=button}{sub-section}{sub-section:9C6233A0CC25F433-0F7B38B2-4B6A467A-96A8BC9A-47937D38F0AA42D4A46CB29B_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:9C6233A0CC25F433-0F7B38B2-4B6A467A-96A8BC9A-47937D38F0AA42D4A46CB29B_sam|text=|trigger=button}{sub-section}{sub-section:9C6233A0CC25F433-0F7B38B2-4B6A467A-96A8BC9A-47937D38F0AA42D4A46CB29B_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=CDE6D2A7043F4636-301ECEBF-4FB84CDB-97408E2B-E369543F0E40DBF3910B5438}{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:CDE6D2A7043F4636-301ECEBF-4FB84CDB-97408E2B-E369543F0E40DBF3910B5438_des|text=|trigger=button}{sub-section}{sub-section:CDE6D2A7043F4636-301ECEBF-4FB84CDB-97408E2B-E369543F0E40DBF3910B5438_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:CDE6D2A7043F4636-301ECEBF-4FB84CDB-97408E2B-E369543F0E40DBF3910B5438_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:CDE6D2A7043F4636-301ECEBF-4FB84CDB-97408E2B-E369543F0E40DBF3910B5438_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:CDE6D2A7043F4636-301ECEBF-4FB84CDB-97408E2B-E369543F0E40DBF3910B5438_ret|text=|trigger=button}{sub-section}{sub-section:CDE6D2A7043F4636-301ECEBF-4FB84CDB-97408E2B-E369543F0E40DBF3910B5438_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:CDE6D2A7043F4636-301ECEBF-4FB84CDB-97408E2B-E369543F0E40DBF3910B5438_see|text=|trigger=button}{sub-section}{sub-section:CDE6D2A7043F4636-301ECEBF-4FB84CDB-97408E2B-E369543F0E40DBF3910B5438_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:CDE6D2A7043F4636-301ECEBF-4FB84CDB-97408E2B-E369543F0E40DBF3910B5438_see|text=|trigger=button}{sub-section}{sub-section:CDE6D2A7043F4636-301ECEBF-4FB84CDB-97408E2B-E369543F0E40DBF3910B5438_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:CDE6D2A7043F4636-301ECEBF-4FB84CDB-97408E2B-E369543F0E40DBF3910B5438_sam|text=|trigger=button}{sub-section}{sub-section:CDE6D2A7043F4636-301ECEBF-4FB84CDB-97408E2B-E369543F0E40DBF3910B5438_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=76D14F0E097635F8-48491F7F-42384252-AEC3BF1F-E1A7A0269AF83ADD44E577E8}{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:76D14F0E097635F8-48491F7F-42384252-AEC3BF1F-E1A7A0269AF83ADD44E577E8_des|text=|trigger=button}{sub-section}{sub-section:76D14F0E097635F8-48491F7F-42384252-AEC3BF1F-E1A7A0269AF83ADD44E577E8_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:76D14F0E097635F8-48491F7F-42384252-AEC3BF1F-E1A7A0269AF83ADD44E577E8_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:76D14F0E097635F8-48491F7F-42384252-AEC3BF1F-E1A7A0269AF83ADD44E577E8_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:76D14F0E097635F8-48491F7F-42384252-AEC3BF1F-E1A7A0269AF83ADD44E577E8_ret|text=|trigger=button}{sub-section}{sub-section:76D14F0E097635F8-48491F7F-42384252-AEC3BF1F-E1A7A0269AF83ADD44E577E8_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:76D14F0E097635F8-48491F7F-42384252-AEC3BF1F-E1A7A0269AF83ADD44E577E8_see|text=|trigger=button}{sub-section}{sub-section:76D14F0E097635F8-48491F7F-42384252-AEC3BF1F-E1A7A0269AF83ADD44E577E8_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:76D14F0E097635F8-48491F7F-42384252-AEC3BF1F-E1A7A0269AF83ADD44E577E8_see|text=|trigger=button}{sub-section}{sub-section:76D14F0E097635F8-48491F7F-42384252-AEC3BF1F-E1A7A0269AF83ADD44E577E8_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:76D14F0E097635F8-48491F7F-42384252-AEC3BF1F-E1A7A0269AF83ADD44E577E8_sam|text=|trigger=button}{sub-section}{sub-section:76D14F0E097635F8-48491F7F-42384252-AEC3BF1F-E1A7A0269AF83ADD44E577E8_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=7902648F0D1DEFEC-CD562089-49AB4DA8-8475BF79-6EDC5F2D6DA94CC8824BC3EE}{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:7902648F0D1DEFEC-CD562089-49AB4DA8-8475BF79-6EDC5F2D6DA94CC8824BC3EE_des|text=|trigger=button}{sub-section}{sub-section:7902648F0D1DEFEC-CD562089-49AB4DA8-8475BF79-6EDC5F2D6DA94CC8824BC3EE_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:7902648F0D1DEFEC-CD562089-49AB4DA8-8475BF79-6EDC5F2D6DA94CC8824BC3EE_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:7902648F0D1DEFEC-CD562089-49AB4DA8-8475BF79-6EDC5F2D6DA94CC8824BC3EE_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:7902648F0D1DEFEC-CD562089-49AB4DA8-8475BF79-6EDC5F2D6DA94CC8824BC3EE_ret|text=|trigger=button}{sub-section}{sub-section:7902648F0D1DEFEC-CD562089-49AB4DA8-8475BF79-6EDC5F2D6DA94CC8824BC3EE_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:7902648F0D1DEFEC-CD562089-49AB4DA8-8475BF79-6EDC5F2D6DA94CC8824BC3EE_see|text=|trigger=button}{sub-section}{sub-section:7902648F0D1DEFEC-CD562089-49AB4DA8-8475BF79-6EDC5F2D6DA94CC8824BC3EE_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:7902648F0D1DEFEC-CD562089-49AB4DA8-8475BF79-6EDC5F2D6DA94CC8824BC3EE_see|text=|trigger=button}{sub-section}{sub-section:7902648F0D1DEFEC-CD562089-49AB4DA8-8475BF79-6EDC5F2D6DA94CC8824BC3EE_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:7902648F0D1DEFEC-CD562089-49AB4DA8-8475BF79-6EDC5F2D6DA94CC8824BC3EE_sam|text=|trigger=button}{sub-section}{sub-section:7902648F0D1DEFEC-CD562089-49AB4DA8-8475BF79-6EDC5F2D6DA94CC8824BC3EE_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=ABBC8A7167621E1D-458B162C-48F44B3F-93E59247-2CF9F411062F7136E55F6023}{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:ABBC8A7167621E1D-458B162C-48F44B3F-93E59247-2CF9F411062F7136E55F6023_des|text=|trigger=button}{sub-section}{sub-section:ABBC8A7167621E1D-458B162C-48F44B3F-93E59247-2CF9F411062F7136E55F6023_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:ABBC8A7167621E1D-458B162C-48F44B3F-93E59247-2CF9F411062F7136E55F6023_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:ABBC8A7167621E1D-458B162C-48F44B3F-93E59247-2CF9F411062F7136E55F6023_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:ABBC8A7167621E1D-458B162C-48F44B3F-93E59247-2CF9F411062F7136E55F6023_ret|text=|trigger=button}{sub-section}{sub-section:ABBC8A7167621E1D-458B162C-48F44B3F-93E59247-2CF9F411062F7136E55F6023_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:ABBC8A7167621E1D-458B162C-48F44B3F-93E59247-2CF9F411062F7136E55F6023_see|text=|trigger=button}{sub-section}{sub-section:ABBC8A7167621E1D-458B162C-48F44B3F-93E59247-2CF9F411062F7136E55F6023_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:ABBC8A7167621E1D-458B162C-48F44B3F-93E59247-2CF9F411062F7136E55F6023_see|text=|trigger=button}{sub-section}{sub-section:ABBC8A7167621E1D-458B162C-48F44B3F-93E59247-2CF9F411062F7136E55F6023_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:ABBC8A7167621E1D-458B162C-48F44B3F-93E59247-2CF9F411062F7136E55F6023_sam|text=|trigger=button}{sub-section}{sub-section:ABBC8A7167621E1D-458B162C-48F44B3F-93E59247-2CF9F411062F7136E55F6023_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=FD61C7B7585364A5-67EFA1BB-45AA419A-84449206-29D2C93F87EF62957030EC5D}{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:FD61C7B7585364A5-67EFA1BB-45AA419A-84449206-29D2C93F87EF62957030EC5D_des|text=|trigger=button}{sub-section}{sub-section:FD61C7B7585364A5-67EFA1BB-45AA419A-84449206-29D2C93F87EF62957030EC5D_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:FD61C7B7585364A5-67EFA1BB-45AA419A-84449206-29D2C93F87EF62957030EC5D_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:FD61C7B7585364A5-67EFA1BB-45AA419A-84449206-29D2C93F87EF62957030EC5D_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:FD61C7B7585364A5-67EFA1BB-45AA419A-84449206-29D2C93F87EF62957030EC5D_ret|text=|trigger=button}{sub-section}{sub-section:FD61C7B7585364A5-67EFA1BB-45AA419A-84449206-29D2C93F87EF62957030EC5D_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:FD61C7B7585364A5-67EFA1BB-45AA419A-84449206-29D2C93F87EF62957030EC5D_see|text=|trigger=button}{sub-section}{sub-section:FD61C7B7585364A5-67EFA1BB-45AA419A-84449206-29D2C93F87EF62957030EC5D_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:FD61C7B7585364A5-67EFA1BB-45AA419A-84449206-29D2C93F87EF62957030EC5D_see|text=|trigger=button}{sub-section}{sub-section:FD61C7B7585364A5-67EFA1BB-45AA419A-84449206-29D2C93F87EF62957030EC5D_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:FD61C7B7585364A5-67EFA1BB-45AA419A-84449206-29D2C93F87EF62957030EC5D_sam|text=|trigger=button}{sub-section}{sub-section:FD61C7B7585364A5-67EFA1BB-45AA419A-84449206-29D2C93F87EF62957030EC5D_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=618E417DDFC0C114-462AFEE8-4A2849AC-AF42AE93-3A172C6D3B1544AE65917FD4}{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:618E417DDFC0C114-462AFEE8-4A2849AC-AF42AE93-3A172C6D3B1544AE65917FD4_des|text=|trigger=button}{sub-section}{sub-section:618E417DDFC0C114-462AFEE8-4A2849AC-AF42AE93-3A172C6D3B1544AE65917FD4_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:618E417DDFC0C114-462AFEE8-4A2849AC-AF42AE93-3A172C6D3B1544AE65917FD4_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:618E417DDFC0C114-462AFEE8-4A2849AC-AF42AE93-3A172C6D3B1544AE65917FD4_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:618E417DDFC0C114-462AFEE8-4A2849AC-AF42AE93-3A172C6D3B1544AE65917FD4_ret|text=|trigger=button}{sub-section}{sub-section:618E417DDFC0C114-462AFEE8-4A2849AC-AF42AE93-3A172C6D3B1544AE65917FD4_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:618E417DDFC0C114-462AFEE8-4A2849AC-AF42AE93-3A172C6D3B1544AE65917FD4_see|text=|trigger=button}{sub-section}{sub-section:618E417DDFC0C114-462AFEE8-4A2849AC-AF42AE93-3A172C6D3B1544AE65917FD4_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:618E417DDFC0C114-462AFEE8-4A2849AC-AF42AE93-3A172C6D3B1544AE65917FD4_see|text=|trigger=button}{sub-section}{sub-section:618E417DDFC0C114-462AFEE8-4A2849AC-AF42AE93-3A172C6D3B1544AE65917FD4_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:618E417DDFC0C114-462AFEE8-4A2849AC-AF42AE93-3A172C6D3B1544AE65917FD4_sam|text=|trigger=button}{sub-section}{sub-section:618E417DDFC0C114-462AFEE8-4A2849AC-AF42AE93-3A172C6D3B1544AE65917FD4_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=548A7F8F8FA727B8-74E133A3-48234955-8AB880CC-DA4DBFDF5E0832E1A9DC02CF}{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:548A7F8F8FA727B8-74E133A3-48234955-8AB880CC-DA4DBFDF5E0832E1A9DC02CF_des|text=|trigger=button}{sub-section}{sub-section:548A7F8F8FA727B8-74E133A3-48234955-8AB880CC-DA4DBFDF5E0832E1A9DC02CF_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:548A7F8F8FA727B8-74E133A3-48234955-8AB880CC-DA4DBFDF5E0832E1A9DC02CF_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:548A7F8F8FA727B8-74E133A3-48234955-8AB880CC-DA4DBFDF5E0832E1A9DC02CF_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:548A7F8F8FA727B8-74E133A3-48234955-8AB880CC-DA4DBFDF5E0832E1A9DC02CF_ret|text=|trigger=button}{sub-section}{sub-section:548A7F8F8FA727B8-74E133A3-48234955-8AB880CC-DA4DBFDF5E0832E1A9DC02CF_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:548A7F8F8FA727B8-74E133A3-48234955-8AB880CC-DA4DBFDF5E0832E1A9DC02CF_see|text=|trigger=button}{sub-section}{sub-section:548A7F8F8FA727B8-74E133A3-48234955-8AB880CC-DA4DBFDF5E0832E1A9DC02CF_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:548A7F8F8FA727B8-74E133A3-48234955-8AB880CC-DA4DBFDF5E0832E1A9DC02CF_see|text=|trigger=button}{sub-section}{sub-section:548A7F8F8FA727B8-74E133A3-48234955-8AB880CC-DA4DBFDF5E0832E1A9DC02CF_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:548A7F8F8FA727B8-74E133A3-48234955-8AB880CC-DA4DBFDF5E0832E1A9DC02CF_sam|text=|trigger=button}{sub-section}{sub-section:548A7F8F8FA727B8-74E133A3-48234955-8AB880CC-DA4DBFDF5E0832E1A9DC02CF_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=1C99542754D1E86E-C657B484-459E4C6C-81F091EA-0E1C77404D7EE1E99A7E9501}{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:1C99542754D1E86E-C657B484-459E4C6C-81F091EA-0E1C77404D7EE1E99A7E9501_des|text=|trigger=button}{sub-section}{sub-section:1C99542754D1E86E-C657B484-459E4C6C-81F091EA-0E1C77404D7EE1E99A7E9501_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:1C99542754D1E86E-C657B484-459E4C6C-81F091EA-0E1C77404D7EE1E99A7E9501_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:1C99542754D1E86E-C657B484-459E4C6C-81F091EA-0E1C77404D7EE1E99A7E9501_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:1C99542754D1E86E-C657B484-459E4C6C-81F091EA-0E1C77404D7EE1E99A7E9501_ret|text=|trigger=button}{sub-section}{sub-section:1C99542754D1E86E-C657B484-459E4C6C-81F091EA-0E1C77404D7EE1E99A7E9501_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:1C99542754D1E86E-C657B484-459E4C6C-81F091EA-0E1C77404D7EE1E99A7E9501_see|text=|trigger=button}{sub-section}{sub-section:1C99542754D1E86E-C657B484-459E4C6C-81F091EA-0E1C77404D7EE1E99A7E9501_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:1C99542754D1E86E-C657B484-459E4C6C-81F091EA-0E1C77404D7EE1E99A7E9501_see|text=|trigger=button}{sub-section}{sub-section:1C99542754D1E86E-C657B484-459E4C6C-81F091EA-0E1C77404D7EE1E99A7E9501_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:1C99542754D1E86E-C657B484-459E4C6C-81F091EA-0E1C77404D7EE1E99A7E9501_sam|text=|trigger=button}{sub-section}{sub-section:1C99542754D1E86E-C657B484-459E4C6C-81F091EA-0E1C77404D7EE1E99A7E9501_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=31A7F00F1EA72B82-203DF19F-4C454BEC-84DEB055-95A6DA15A68EAE34AF1A027E}{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:31A7F00F1EA72B82-203DF19F-4C454BEC-84DEB055-95A6DA15A68EAE34AF1A027E_des|text=|trigger=button}{sub-section}{sub-section:31A7F00F1EA72B82-203DF19F-4C454BEC-84DEB055-95A6DA15A68EAE34AF1A027E_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:31A7F00F1EA72B82-203DF19F-4C454BEC-84DEB055-95A6DA15A68EAE34AF1A027E_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:31A7F00F1EA72B82-203DF19F-4C454BEC-84DEB055-95A6DA15A68EAE34AF1A027E_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:31A7F00F1EA72B82-203DF19F-4C454BEC-84DEB055-95A6DA15A68EAE34AF1A027E_ret|text=|trigger=button}{sub-section}{sub-section:31A7F00F1EA72B82-203DF19F-4C454BEC-84DEB055-95A6DA15A68EAE34AF1A027E_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:31A7F00F1EA72B82-203DF19F-4C454BEC-84DEB055-95A6DA15A68EAE34AF1A027E_see|text=|trigger=button}{sub-section}{sub-section:31A7F00F1EA72B82-203DF19F-4C454BEC-84DEB055-95A6DA15A68EAE34AF1A027E_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:31A7F00F1EA72B82-203DF19F-4C454BEC-84DEB055-95A6DA15A68EAE34AF1A027E_see|text=|trigger=button}{sub-section}{sub-section:31A7F00F1EA72B82-203DF19F-4C454BEC-84DEB055-95A6DA15A68EAE34AF1A027E_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:31A7F00F1EA72B82-203DF19F-4C454BEC-84DEB055-95A6DA15A68EAE34AF1A027E_sam|text=|trigger=button}{sub-section}{sub-section:31A7F00F1EA72B82-203DF19F-4C454BEC-84DEB055-95A6DA15A68EAE34AF1A027E_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=9C567E1BF5F8F9D5-E70C56DA-4A604368-969880E3-8651B1F95E5DF8F374D7FA1A}{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:9C567E1BF5F8F9D5-E70C56DA-4A604368-969880E3-8651B1F95E5DF8F374D7FA1A_des|text=|trigger=button}{sub-section}{sub-section:9C567E1BF5F8F9D5-E70C56DA-4A604368-969880E3-8651B1F95E5DF8F374D7FA1A_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:9C567E1BF5F8F9D5-E70C56DA-4A604368-969880E3-8651B1F95E5DF8F374D7FA1A_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:9C567E1BF5F8F9D5-E70C56DA-4A604368-969880E3-8651B1F95E5DF8F374D7FA1A_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:9C567E1BF5F8F9D5-E70C56DA-4A604368-969880E3-8651B1F95E5DF8F374D7FA1A_ret|text=|trigger=button}{sub-section}{sub-section:9C567E1BF5F8F9D5-E70C56DA-4A604368-969880E3-8651B1F95E5DF8F374D7FA1A_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:9C567E1BF5F8F9D5-E70C56DA-4A604368-969880E3-8651B1F95E5DF8F374D7FA1A_see|text=|trigger=button}{sub-section}{sub-section:9C567E1BF5F8F9D5-E70C56DA-4A604368-969880E3-8651B1F95E5DF8F374D7FA1A_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:9C567E1BF5F8F9D5-E70C56DA-4A604368-969880E3-8651B1F95E5DF8F374D7FA1A_see|text=|trigger=button}{sub-section}{sub-section:9C567E1BF5F8F9D5-E70C56DA-4A604368-969880E3-8651B1F95E5DF8F374D7FA1A_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:9C567E1BF5F8F9D5-E70C56DA-4A604368-969880E3-8651B1F95E5DF8F374D7FA1A_sam|text=|trigger=button}{sub-section}{sub-section:9C567E1BF5F8F9D5-E70C56DA-4A604368-969880E3-8651B1F95E5DF8F374D7FA1A_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=9E1DC823F064400B-24076888-4BEA4CCB-9337AAFF-FE93027EDBCC7ABD486BCB4F}{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:9E1DC823F064400B-24076888-4BEA4CCB-9337AAFF-FE93027EDBCC7ABD486BCB4F_des|text=|trigger=button}{sub-section}{sub-section:9E1DC823F064400B-24076888-4BEA4CCB-9337AAFF-FE93027EDBCC7ABD486BCB4F_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:9E1DC823F064400B-24076888-4BEA4CCB-9337AAFF-FE93027EDBCC7ABD486BCB4F_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:9E1DC823F064400B-24076888-4BEA4CCB-9337AAFF-FE93027EDBCC7ABD486BCB4F_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:9E1DC823F064400B-24076888-4BEA4CCB-9337AAFF-FE93027EDBCC7ABD486BCB4F_ret|text=|trigger=button}{sub-section}{sub-section:9E1DC823F064400B-24076888-4BEA4CCB-9337AAFF-FE93027EDBCC7ABD486BCB4F_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:9E1DC823F064400B-24076888-4BEA4CCB-9337AAFF-FE93027EDBCC7ABD486BCB4F_see|text=|trigger=button}{sub-section}{sub-section:9E1DC823F064400B-24076888-4BEA4CCB-9337AAFF-FE93027EDBCC7ABD486BCB4F_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:9E1DC823F064400B-24076888-4BEA4CCB-9337AAFF-FE93027EDBCC7ABD486BCB4F_see|text=|trigger=button}{sub-section}{sub-section:9E1DC823F064400B-24076888-4BEA4CCB-9337AAFF-FE93027EDBCC7ABD486BCB4F_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:9E1DC823F064400B-24076888-4BEA4CCB-9337AAFF-FE93027EDBCC7ABD486BCB4F_sam|text=|trigger=button}{sub-section}{sub-section:9E1DC823F064400B-24076888-4BEA4CCB-9337AAFF-FE93027EDBCC7ABD486BCB4F_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=76C3F3FF2338152E-86172DC4-473A4928-95C8A036-6CB0464DD7A1A1C741E46E59}{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:76C3F3FF2338152E-86172DC4-473A4928-95C8A036-6CB0464DD7A1A1C741E46E59_des|text=|trigger=button}{sub-section}{sub-section:76C3F3FF2338152E-86172DC4-473A4928-95C8A036-6CB0464DD7A1A1C741E46E59_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:76C3F3FF2338152E-86172DC4-473A4928-95C8A036-6CB0464DD7A1A1C741E46E59_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:76C3F3FF2338152E-86172DC4-473A4928-95C8A036-6CB0464DD7A1A1C741E46E59_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:76C3F3FF2338152E-86172DC4-473A4928-95C8A036-6CB0464DD7A1A1C741E46E59_ret|text=|trigger=button}{sub-section}{sub-section:76C3F3FF2338152E-86172DC4-473A4928-95C8A036-6CB0464DD7A1A1C741E46E59_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:76C3F3FF2338152E-86172DC4-473A4928-95C8A036-6CB0464DD7A1A1C741E46E59_see|text=|trigger=button}{sub-section}{sub-section:76C3F3FF2338152E-86172DC4-473A4928-95C8A036-6CB0464DD7A1A1C741E46E59_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:76C3F3FF2338152E-86172DC4-473A4928-95C8A036-6CB0464DD7A1A1C741E46E59_see|text=|trigger=button}{sub-section}{sub-section:76C3F3FF2338152E-86172DC4-473A4928-95C8A036-6CB0464DD7A1A1C741E46E59_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:76C3F3FF2338152E-86172DC4-473A4928-95C8A036-6CB0464DD7A1A1C741E46E59_sam|text=|trigger=button}{sub-section}{sub-section:76C3F3FF2338152E-86172DC4-473A4928-95C8A036-6CB0464DD7A1A1C741E46E59_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=C1F5300EC8AEC726-DF58B806-49EB4DA9-AACB9441-985A83B3E12812324F7F5DAB}{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:C1F5300EC8AEC726-DF58B806-49EB4DA9-AACB9441-985A83B3E12812324F7F5DAB_des|text=|trigger=button}{sub-section}{sub-section:C1F5300EC8AEC726-DF58B806-49EB4DA9-AACB9441-985A83B3E12812324F7F5DAB_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:C1F5300EC8AEC726-DF58B806-49EB4DA9-AACB9441-985A83B3E12812324F7F5DAB_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:C1F5300EC8AEC726-DF58B806-49EB4DA9-AACB9441-985A83B3E12812324F7F5DAB_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:C1F5300EC8AEC726-DF58B806-49EB4DA9-AACB9441-985A83B3E12812324F7F5DAB_ret|text=|trigger=button}{sub-section}{sub-section:C1F5300EC8AEC726-DF58B806-49EB4DA9-AACB9441-985A83B3E12812324F7F5DAB_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:C1F5300EC8AEC726-DF58B806-49EB4DA9-AACB9441-985A83B3E12812324F7F5DAB_see|text=|trigger=button}{sub-section}{sub-section:C1F5300EC8AEC726-DF58B806-49EB4DA9-AACB9441-985A83B3E12812324F7F5DAB_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:C1F5300EC8AEC726-DF58B806-49EB4DA9-AACB9441-985A83B3E12812324F7F5DAB_see|text=|trigger=button}{sub-section}{sub-section:C1F5300EC8AEC726-DF58B806-49EB4DA9-AACB9441-985A83B3E12812324F7F5DAB_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:C1F5300EC8AEC726-DF58B806-49EB4DA9-AACB9441-985A83B3E12812324F7F5DAB_sam|text=|trigger=button}{sub-section}{sub-section:C1F5300EC8AEC726-DF58B806-49EB4DA9-AACB9441-985A83B3E12812324F7F5DAB_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 4

New Version 5

Key
