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=ACCA9204EC9060FC-FF072275-44BC45FE-BB5BAC7F-F07313FF1606098AA142334A}{tr:id=name}{td}h6.DATETIME{td}{tr}{tr:id=des}{td}{sub-section:ACCA9204EC9060FC-FF072275-44BC45FE-BB5BAC7F-F07313FF1606098AA142334A_des|text=|trigger=button}{sub-section}{sub-section:ACCA9204EC9060FC-FF072275-44BC45FE-BB5BAC7F-F07313FF1606098AA142334A_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:ACCA9204EC9060FC-FF072275-44BC45FE-BB5BAC7F-F07313FF1606098AA142334A_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:ACCA9204EC9060FC-FF072275-44BC45FE-BB5BAC7F-F07313FF1606098AA142334A_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:ACCA9204EC9060FC-FF072275-44BC45FE-BB5BAC7F-F07313FF1606098AA142334A_ret|text=|trigger=button}{sub-section}{sub-section:ACCA9204EC9060FC-FF072275-44BC45FE-BB5BAC7F-F07313FF1606098AA142334A_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:ACCA9204EC9060FC-FF072275-44BC45FE-BB5BAC7F-F07313FF1606098AA142334A_see|text=|trigger=button}{sub-section}{sub-section:ACCA9204EC9060FC-FF072275-44BC45FE-BB5BAC7F-F07313FF1606098AA142334A_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:ACCA9204EC9060FC-FF072275-44BC45FE-BB5BAC7F-F07313FF1606098AA142334A_see|text=|trigger=button}{sub-section}{sub-section:ACCA9204EC9060FC-FF072275-44BC45FE-BB5BAC7F-F07313FF1606098AA142334A_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:ACCA9204EC9060FC-FF072275-44BC45FE-BB5BAC7F-F07313FF1606098AA142334A_sam|text=|trigger=button}{sub-section}{sub-section:ACCA9204EC9060FC-FF072275-44BC45FE-BB5BAC7F-F07313FF1606098AA142334A_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=734EE81152A7C09E-5270BC9D-48CC407B-92169828-3B97B8716A154E6B2467DF05}{tr:id=name}{td}h6.INTEGER{td}{tr}{tr:id=des}{td}{sub-section:734EE81152A7C09E-5270BC9D-48CC407B-92169828-3B97B8716A154E6B2467DF05_des|text=|trigger=button}{sub-section}{sub-section:734EE81152A7C09E-5270BC9D-48CC407B-92169828-3B97B8716A154E6B2467DF05_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:734EE81152A7C09E-5270BC9D-48CC407B-92169828-3B97B8716A154E6B2467DF05_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:734EE81152A7C09E-5270BC9D-48CC407B-92169828-3B97B8716A154E6B2467DF05_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:734EE81152A7C09E-5270BC9D-48CC407B-92169828-3B97B8716A154E6B2467DF05_ret|text=|trigger=button}{sub-section}{sub-section:734EE81152A7C09E-5270BC9D-48CC407B-92169828-3B97B8716A154E6B2467DF05_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:734EE81152A7C09E-5270BC9D-48CC407B-92169828-3B97B8716A154E6B2467DF05_see|text=|trigger=button}{sub-section}{sub-section:734EE81152A7C09E-5270BC9D-48CC407B-92169828-3B97B8716A154E6B2467DF05_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:734EE81152A7C09E-5270BC9D-48CC407B-92169828-3B97B8716A154E6B2467DF05_see|text=|trigger=button}{sub-section}{sub-section:734EE81152A7C09E-5270BC9D-48CC407B-92169828-3B97B8716A154E6B2467DF05_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:734EE81152A7C09E-5270BC9D-48CC407B-92169828-3B97B8716A154E6B2467DF05_sam|text=|trigger=button}{sub-section}{sub-section:734EE81152A7C09E-5270BC9D-48CC407B-92169828-3B97B8716A154E6B2467DF05_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=D9B3A84F0E2F615E-B0AB2ECE-460143F4-B80CAC0E-3EA94F146B259B1641BA9F15}{tr:id=name}{td}h6.MEDIA{td}{tr}{tr:id=des}{td}{sub-section:D9B3A84F0E2F615E-B0AB2ECE-460143F4-B80CAC0E-3EA94F146B259B1641BA9F15_des|text=|trigger=button}{sub-section}{sub-section:D9B3A84F0E2F615E-B0AB2ECE-460143F4-B80CAC0E-3EA94F146B259B1641BA9F15_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:D9B3A84F0E2F615E-B0AB2ECE-460143F4-B80CAC0E-3EA94F146B259B1641BA9F15_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:D9B3A84F0E2F615E-B0AB2ECE-460143F4-B80CAC0E-3EA94F146B259B1641BA9F15_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:D9B3A84F0E2F615E-B0AB2ECE-460143F4-B80CAC0E-3EA94F146B259B1641BA9F15_ret|text=|trigger=button}{sub-section}{sub-section:D9B3A84F0E2F615E-B0AB2ECE-460143F4-B80CAC0E-3EA94F146B259B1641BA9F15_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:D9B3A84F0E2F615E-B0AB2ECE-460143F4-B80CAC0E-3EA94F146B259B1641BA9F15_see|text=|trigger=button}{sub-section}{sub-section:D9B3A84F0E2F615E-B0AB2ECE-460143F4-B80CAC0E-3EA94F146B259B1641BA9F15_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:D9B3A84F0E2F615E-B0AB2ECE-460143F4-B80CAC0E-3EA94F146B259B1641BA9F15_see|text=|trigger=button}{sub-section}{sub-section:D9B3A84F0E2F615E-B0AB2ECE-460143F4-B80CAC0E-3EA94F146B259B1641BA9F15_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:D9B3A84F0E2F615E-B0AB2ECE-460143F4-B80CAC0E-3EA94F146B259B1641BA9F15_sam|text=|trigger=button}{sub-section}{sub-section:D9B3A84F0E2F615E-B0AB2ECE-460143F4-B80CAC0E-3EA94F146B259B1641BA9F15_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=85B4C76AF36DF2D8-088DE2DD-49794BF1-9710BA8F-E0D1AADD5EDBD1B3387A030E}{tr:id=name}{td}h6.NUMBER{td}{tr}{tr:id=des}{td}{sub-section:85B4C76AF36DF2D8-088DE2DD-49794BF1-9710BA8F-E0D1AADD5EDBD1B3387A030E_des|text=|trigger=button}{sub-section}{sub-section:85B4C76AF36DF2D8-088DE2DD-49794BF1-9710BA8F-E0D1AADD5EDBD1B3387A030E_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:85B4C76AF36DF2D8-088DE2DD-49794BF1-9710BA8F-E0D1AADD5EDBD1B3387A030E_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:85B4C76AF36DF2D8-088DE2DD-49794BF1-9710BA8F-E0D1AADD5EDBD1B3387A030E_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:85B4C76AF36DF2D8-088DE2DD-49794BF1-9710BA8F-E0D1AADD5EDBD1B3387A030E_ret|text=|trigger=button}{sub-section}{sub-section:85B4C76AF36DF2D8-088DE2DD-49794BF1-9710BA8F-E0D1AADD5EDBD1B3387A030E_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:85B4C76AF36DF2D8-088DE2DD-49794BF1-9710BA8F-E0D1AADD5EDBD1B3387A030E_see|text=|trigger=button}{sub-section}{sub-section:85B4C76AF36DF2D8-088DE2DD-49794BF1-9710BA8F-E0D1AADD5EDBD1B3387A030E_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:85B4C76AF36DF2D8-088DE2DD-49794BF1-9710BA8F-E0D1AADD5EDBD1B3387A030E_see|text=|trigger=button}{sub-section}{sub-section:85B4C76AF36DF2D8-088DE2DD-49794BF1-9710BA8F-E0D1AADD5EDBD1B3387A030E_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:85B4C76AF36DF2D8-088DE2DD-49794BF1-9710BA8F-E0D1AADD5EDBD1B3387A030E_sam|text=|trigger=button}{sub-section}{sub-section:85B4C76AF36DF2D8-088DE2DD-49794BF1-9710BA8F-E0D1AADD5EDBD1B3387A030E_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=1FC944C9E1B82EF5-53DE6CCD-425E4C32-9BD2AB07-EF40440E9CA74611A52A50D2}{tr:id=name}{td}h6.TEXT{td}{tr}{tr:id=des}{td}{sub-section:1FC944C9E1B82EF5-53DE6CCD-425E4C32-9BD2AB07-EF40440E9CA74611A52A50D2_des|text=|trigger=button}{sub-section}{sub-section:1FC944C9E1B82EF5-53DE6CCD-425E4C32-9BD2AB07-EF40440E9CA74611A52A50D2_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:1FC944C9E1B82EF5-53DE6CCD-425E4C32-9BD2AB07-EF40440E9CA74611A52A50D2_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:1FC944C9E1B82EF5-53DE6CCD-425E4C32-9BD2AB07-EF40440E9CA74611A52A50D2_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:1FC944C9E1B82EF5-53DE6CCD-425E4C32-9BD2AB07-EF40440E9CA74611A52A50D2_ret|text=|trigger=button}{sub-section}{sub-section:1FC944C9E1B82EF5-53DE6CCD-425E4C32-9BD2AB07-EF40440E9CA74611A52A50D2_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:1FC944C9E1B82EF5-53DE6CCD-425E4C32-9BD2AB07-EF40440E9CA74611A52A50D2_see|text=|trigger=button}{sub-section}{sub-section:1FC944C9E1B82EF5-53DE6CCD-425E4C32-9BD2AB07-EF40440E9CA74611A52A50D2_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:1FC944C9E1B82EF5-53DE6CCD-425E4C32-9BD2AB07-EF40440E9CA74611A52A50D2_see|text=|trigger=button}{sub-section}{sub-section:1FC944C9E1B82EF5-53DE6CCD-425E4C32-9BD2AB07-EF40440E9CA74611A52A50D2_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:1FC944C9E1B82EF5-53DE6CCD-425E4C32-9BD2AB07-EF40440E9CA74611A52A50D2_sam|text=|trigger=button}{sub-section}{sub-section:1FC944C9E1B82EF5-53DE6CCD-425E4C32-9BD2AB07-EF40440E9CA74611A52A50D2_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=F87DC6E49C6233A0-C5060F7B-45664B6A-8AF496A8-DB8CF85553EE47937D38F0AA}{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:F87DC6E49C6233A0-C5060F7B-45664B6A-8AF496A8-DB8CF85553EE47937D38F0AA_des|text=|trigger=button}{sub-section}{sub-section:F87DC6E49C6233A0-C5060F7B-45664B6A-8AF496A8-DB8CF85553EE47937D38F0AA_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:F87DC6E49C6233A0-C5060F7B-45664B6A-8AF496A8-DB8CF85553EE47937D38F0AA_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:F87DC6E49C6233A0-C5060F7B-45664B6A-8AF496A8-DB8CF85553EE47937D38F0AA_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:F87DC6E49C6233A0-C5060F7B-45664B6A-8AF496A8-DB8CF85553EE47937D38F0AA_ret|text=|trigger=button}{sub-section}{sub-section:F87DC6E49C6233A0-C5060F7B-45664B6A-8AF496A8-DB8CF85553EE47937D38F0AA_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:F87DC6E49C6233A0-C5060F7B-45664B6A-8AF496A8-DB8CF85553EE47937D38F0AA_see|text=|trigger=button}{sub-section}{sub-section:F87DC6E49C6233A0-C5060F7B-45664B6A-8AF496A8-DB8CF85553EE47937D38F0AA_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:F87DC6E49C6233A0-C5060F7B-45664B6A-8AF496A8-DB8CF85553EE47937D38F0AA_see|text=|trigger=button}{sub-section}{sub-section:F87DC6E49C6233A0-C5060F7B-45664B6A-8AF496A8-DB8CF85553EE47937D38F0AA_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:F87DC6E49C6233A0-C5060F7B-45664B6A-8AF496A8-DB8CF85553EE47937D38F0AA_sam|text=|trigger=button}{sub-section}{sub-section:F87DC6E49C6233A0-C5060F7B-45664B6A-8AF496A8-DB8CF85553EE47937D38F0AA_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=D1827113CDE6D2A7-3D3A301E-4A3F4FB8-BF449740-D0C7F0B01184E369543F0E40}{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:D1827113CDE6D2A7-3D3A301E-4A3F4FB8-BF449740-D0C7F0B01184E369543F0E40_des|text=|trigger=button}{sub-section}{sub-section:D1827113CDE6D2A7-3D3A301E-4A3F4FB8-BF449740-D0C7F0B01184E369543F0E40_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:D1827113CDE6D2A7-3D3A301E-4A3F4FB8-BF449740-D0C7F0B01184E369543F0E40_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:D1827113CDE6D2A7-3D3A301E-4A3F4FB8-BF449740-D0C7F0B01184E369543F0E40_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:D1827113CDE6D2A7-3D3A301E-4A3F4FB8-BF449740-D0C7F0B01184E369543F0E40_ret|text=|trigger=button}{sub-section}{sub-section:D1827113CDE6D2A7-3D3A301E-4A3F4FB8-BF449740-D0C7F0B01184E369543F0E40_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:D1827113CDE6D2A7-3D3A301E-4A3F4FB8-BF449740-D0C7F0B01184E369543F0E40_see|text=|trigger=button}{sub-section}{sub-section:D1827113CDE6D2A7-3D3A301E-4A3F4FB8-BF449740-D0C7F0B01184E369543F0E40_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:D1827113CDE6D2A7-3D3A301E-4A3F4FB8-BF449740-D0C7F0B01184E369543F0E40_see|text=|trigger=button}{sub-section}{sub-section:D1827113CDE6D2A7-3D3A301E-4A3F4FB8-BF449740-D0C7F0B01184E369543F0E40_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:D1827113CDE6D2A7-3D3A301E-4A3F4FB8-BF449740-D0C7F0B01184E369543F0E40_sam|text=|trigger=button}{sub-section}{sub-section:D1827113CDE6D2A7-3D3A301E-4A3F4FB8-BF449740-D0C7F0B01184E369543F0E40_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=3778DF5076D14F0E-E3C84849-4CD84238-BB8EAEC3-E48497C9C4BCE1A7A0269AF8}{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:3778DF5076D14F0E-E3C84849-4CD84238-BB8EAEC3-E48497C9C4BCE1A7A0269AF8_des|text=|trigger=button}{sub-section}{sub-section:3778DF5076D14F0E-E3C84849-4CD84238-BB8EAEC3-E48497C9C4BCE1A7A0269AF8_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:3778DF5076D14F0E-E3C84849-4CD84238-BB8EAEC3-E48497C9C4BCE1A7A0269AF8_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:3778DF5076D14F0E-E3C84849-4CD84238-BB8EAEC3-E48497C9C4BCE1A7A0269AF8_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:3778DF5076D14F0E-E3C84849-4CD84238-BB8EAEC3-E48497C9C4BCE1A7A0269AF8_ret|text=|trigger=button}{sub-section}{sub-section:3778DF5076D14F0E-E3C84849-4CD84238-BB8EAEC3-E48497C9C4BCE1A7A0269AF8_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:3778DF5076D14F0E-E3C84849-4CD84238-BB8EAEC3-E48497C9C4BCE1A7A0269AF8_see|text=|trigger=button}{sub-section}{sub-section:3778DF5076D14F0E-E3C84849-4CD84238-BB8EAEC3-E48497C9C4BCE1A7A0269AF8_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:3778DF5076D14F0E-E3C84849-4CD84238-BB8EAEC3-E48497C9C4BCE1A7A0269AF8_see|text=|trigger=button}{sub-section}{sub-section:3778DF5076D14F0E-E3C84849-4CD84238-BB8EAEC3-E48497C9C4BCE1A7A0269AF8_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:3778DF5076D14F0E-E3C84849-4CD84238-BB8EAEC3-E48497C9C4BCE1A7A0269AF8_sam|text=|trigger=button}{sub-section}{sub-section:3778DF5076D14F0E-E3C84849-4CD84238-BB8EAEC3-E48497C9C4BCE1A7A0269AF8_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=E7F8A5367902648F-911CCD56-435649AB-A0508475-7AA3771E5CFA6EDC5F2D6DA9}{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:E7F8A5367902648F-911CCD56-435649AB-A0508475-7AA3771E5CFA6EDC5F2D6DA9_des|text=|trigger=button}{sub-section}{sub-section:E7F8A5367902648F-911CCD56-435649AB-A0508475-7AA3771E5CFA6EDC5F2D6DA9_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:E7F8A5367902648F-911CCD56-435649AB-A0508475-7AA3771E5CFA6EDC5F2D6DA9_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:E7F8A5367902648F-911CCD56-435649AB-A0508475-7AA3771E5CFA6EDC5F2D6DA9_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:E7F8A5367902648F-911CCD56-435649AB-A0508475-7AA3771E5CFA6EDC5F2D6DA9_ret|text=|trigger=button}{sub-section}{sub-section:E7F8A5367902648F-911CCD56-435649AB-A0508475-7AA3771E5CFA6EDC5F2D6DA9_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:E7F8A5367902648F-911CCD56-435649AB-A0508475-7AA3771E5CFA6EDC5F2D6DA9_see|text=|trigger=button}{sub-section}{sub-section:E7F8A5367902648F-911CCD56-435649AB-A0508475-7AA3771E5CFA6EDC5F2D6DA9_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:E7F8A5367902648F-911CCD56-435649AB-A0508475-7AA3771E5CFA6EDC5F2D6DA9_see|text=|trigger=button}{sub-section}{sub-section:E7F8A5367902648F-911CCD56-435649AB-A0508475-7AA3771E5CFA6EDC5F2D6DA9_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:E7F8A5367902648F-911CCD56-435649AB-A0508475-7AA3771E5CFA6EDC5F2D6DA9_sam|text=|trigger=button}{sub-section}{sub-section:E7F8A5367902648F-911CCD56-435649AB-A0508475-7AA3771E5CFA6EDC5F2D6DA9_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=99BC7E70ABBC8A71-89AF458B-4E2548F4-B85F93E5-B72FB98CBBFC2CF9F411062F}{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:99BC7E70ABBC8A71-89AF458B-4E2548F4-B85F93E5-B72FB98CBBFC2CF9F411062F_des|text=|trigger=button}{sub-section}{sub-section:99BC7E70ABBC8A71-89AF458B-4E2548F4-B85F93E5-B72FB98CBBFC2CF9F411062F_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:99BC7E70ABBC8A71-89AF458B-4E2548F4-B85F93E5-B72FB98CBBFC2CF9F411062F_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:99BC7E70ABBC8A71-89AF458B-4E2548F4-B85F93E5-B72FB98CBBFC2CF9F411062F_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:99BC7E70ABBC8A71-89AF458B-4E2548F4-B85F93E5-B72FB98CBBFC2CF9F411062F_ret|text=|trigger=button}{sub-section}{sub-section:99BC7E70ABBC8A71-89AF458B-4E2548F4-B85F93E5-B72FB98CBBFC2CF9F411062F_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:99BC7E70ABBC8A71-89AF458B-4E2548F4-B85F93E5-B72FB98CBBFC2CF9F411062F_see|text=|trigger=button}{sub-section}{sub-section:99BC7E70ABBC8A71-89AF458B-4E2548F4-B85F93E5-B72FB98CBBFC2CF9F411062F_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:99BC7E70ABBC8A71-89AF458B-4E2548F4-B85F93E5-B72FB98CBBFC2CF9F411062F_see|text=|trigger=button}{sub-section}{sub-section:99BC7E70ABBC8A71-89AF458B-4E2548F4-B85F93E5-B72FB98CBBFC2CF9F411062F_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:99BC7E70ABBC8A71-89AF458B-4E2548F4-B85F93E5-B72FB98CBBFC2CF9F411062F_sam|text=|trigger=button}{sub-section}{sub-section:99BC7E70ABBC8A71-89AF458B-4E2548F4-B85F93E5-B72FB98CBBFC2CF9F411062F_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=B076730CFD61C7B7-AB9067EF-4D9245AA-97848444-21D0C2B5543529D2C93F87EF}{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:B076730CFD61C7B7-AB9067EF-4D9245AA-97848444-21D0C2B5543529D2C93F87EF_des|text=|trigger=button}{sub-section}{sub-section:B076730CFD61C7B7-AB9067EF-4D9245AA-97848444-21D0C2B5543529D2C93F87EF_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:B076730CFD61C7B7-AB9067EF-4D9245AA-97848444-21D0C2B5543529D2C93F87EF_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:B076730CFD61C7B7-AB9067EF-4D9245AA-97848444-21D0C2B5543529D2C93F87EF_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:B076730CFD61C7B7-AB9067EF-4D9245AA-97848444-21D0C2B5543529D2C93F87EF_ret|text=|trigger=button}{sub-section}{sub-section:B076730CFD61C7B7-AB9067EF-4D9245AA-97848444-21D0C2B5543529D2C93F87EF_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:B076730CFD61C7B7-AB9067EF-4D9245AA-97848444-21D0C2B5543529D2C93F87EF_see|text=|trigger=button}{sub-section}{sub-section:B076730CFD61C7B7-AB9067EF-4D9245AA-97848444-21D0C2B5543529D2C93F87EF_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:B076730CFD61C7B7-AB9067EF-4D9245AA-97848444-21D0C2B5543529D2C93F87EF_see|text=|trigger=button}{sub-section}{sub-section:B076730CFD61C7B7-AB9067EF-4D9245AA-97848444-21D0C2B5543529D2C93F87EF_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:B076730CFD61C7B7-AB9067EF-4D9245AA-97848444-21D0C2B5543529D2C93F87EF_sam|text=|trigger=button}{sub-section}{sub-section:B076730CFD61C7B7-AB9067EF-4D9245AA-97848444-21D0C2B5543529D2C93F87EF_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=5F700DFF618E417D-13FB462A-44534A28-ABFEAF42-EC2737ADFD4C3A172C6D3B15}{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:5F700DFF618E417D-13FB462A-44534A28-ABFEAF42-EC2737ADFD4C3A172C6D3B15_des|text=|trigger=button}{sub-section}{sub-section:5F700DFF618E417D-13FB462A-44534A28-ABFEAF42-EC2737ADFD4C3A172C6D3B15_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:5F700DFF618E417D-13FB462A-44534A28-ABFEAF42-EC2737ADFD4C3A172C6D3B15_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:5F700DFF618E417D-13FB462A-44534A28-ABFEAF42-EC2737ADFD4C3A172C6D3B15_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:5F700DFF618E417D-13FB462A-44534A28-ABFEAF42-EC2737ADFD4C3A172C6D3B15_ret|text=|trigger=button}{sub-section}{sub-section:5F700DFF618E417D-13FB462A-44534A28-ABFEAF42-EC2737ADFD4C3A172C6D3B15_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:5F700DFF618E417D-13FB462A-44534A28-ABFEAF42-EC2737ADFD4C3A172C6D3B15_see|text=|trigger=button}{sub-section}{sub-section:5F700DFF618E417D-13FB462A-44534A28-ABFEAF42-EC2737ADFD4C3A172C6D3B15_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:5F700DFF618E417D-13FB462A-44534A28-ABFEAF42-EC2737ADFD4C3A172C6D3B15_see|text=|trigger=button}{sub-section}{sub-section:5F700DFF618E417D-13FB462A-44534A28-ABFEAF42-EC2737ADFD4C3A172C6D3B15_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:5F700DFF618E417D-13FB462A-44534A28-ABFEAF42-EC2737ADFD4C3A172C6D3B15_sam|text=|trigger=button}{sub-section}{sub-section:5F700DFF618E417D-13FB462A-44534A28-ABFEAF42-EC2737ADFD4C3A172C6D3B15_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=EDE54848548A7F8F-A2A374E1-4E1A4823-B0A78AB8-A668D0A2FCC6DA4DBFDF5E08}{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:EDE54848548A7F8F-A2A374E1-4E1A4823-B0A78AB8-A668D0A2FCC6DA4DBFDF5E08_des|text=|trigger=button}{sub-section}{sub-section:EDE54848548A7F8F-A2A374E1-4E1A4823-B0A78AB8-A668D0A2FCC6DA4DBFDF5E08_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:EDE54848548A7F8F-A2A374E1-4E1A4823-B0A78AB8-A668D0A2FCC6DA4DBFDF5E08_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:EDE54848548A7F8F-A2A374E1-4E1A4823-B0A78AB8-A668D0A2FCC6DA4DBFDF5E08_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:EDE54848548A7F8F-A2A374E1-4E1A4823-B0A78AB8-A668D0A2FCC6DA4DBFDF5E08_ret|text=|trigger=button}{sub-section}{sub-section:EDE54848548A7F8F-A2A374E1-4E1A4823-B0A78AB8-A668D0A2FCC6DA4DBFDF5E08_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:EDE54848548A7F8F-A2A374E1-4E1A4823-B0A78AB8-A668D0A2FCC6DA4DBFDF5E08_see|text=|trigger=button}{sub-section}{sub-section:EDE54848548A7F8F-A2A374E1-4E1A4823-B0A78AB8-A668D0A2FCC6DA4DBFDF5E08_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:EDE54848548A7F8F-A2A374E1-4E1A4823-B0A78AB8-A668D0A2FCC6DA4DBFDF5E08_see|text=|trigger=button}{sub-section}{sub-section:EDE54848548A7F8F-A2A374E1-4E1A4823-B0A78AB8-A668D0A2FCC6DA4DBFDF5E08_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:EDE54848548A7F8F-A2A374E1-4E1A4823-B0A78AB8-A668D0A2FCC6DA4DBFDF5E08_sam|text=|trigger=button}{sub-section}{sub-section:EDE54848548A7F8F-A2A374E1-4E1A4823-B0A78AB8-A668D0A2FCC6DA4DBFDF5E08_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=0B10B3D31C995427-9F47C657-44AD459E-A50281F0-806843BCED300E1C77404D7E}{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:0B10B3D31C995427-9F47C657-44AD459E-A50281F0-806843BCED300E1C77404D7E_des|text=|trigger=button}{sub-section}{sub-section:0B10B3D31C995427-9F47C657-44AD459E-A50281F0-806843BCED300E1C77404D7E_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:0B10B3D31C995427-9F47C657-44AD459E-A50281F0-806843BCED300E1C77404D7E_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:0B10B3D31C995427-9F47C657-44AD459E-A50281F0-806843BCED300E1C77404D7E_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:0B10B3D31C995427-9F47C657-44AD459E-A50281F0-806843BCED300E1C77404D7E_ret|text=|trigger=button}{sub-section}{sub-section:0B10B3D31C995427-9F47C657-44AD459E-A50281F0-806843BCED300E1C77404D7E_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:0B10B3D31C995427-9F47C657-44AD459E-A50281F0-806843BCED300E1C77404D7E_see|text=|trigger=button}{sub-section}{sub-section:0B10B3D31C995427-9F47C657-44AD459E-A50281F0-806843BCED300E1C77404D7E_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:0B10B3D31C995427-9F47C657-44AD459E-A50281F0-806843BCED300E1C77404D7E_see|text=|trigger=button}{sub-section}{sub-section:0B10B3D31C995427-9F47C657-44AD459E-A50281F0-806843BCED300E1C77404D7E_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:0B10B3D31C995427-9F47C657-44AD459E-A50281F0-806843BCED300E1C77404D7E_sam|text=|trigger=button}{sub-section}{sub-section:0B10B3D31C995427-9F47C657-44AD459E-A50281F0-806843BCED300E1C77404D7E_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=449ED4A631A7F00F-5898203D-498D4C45-865084DE-271FBDFEC4DA95A6DA15A68E}{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:449ED4A631A7F00F-5898203D-498D4C45-865084DE-271FBDFEC4DA95A6DA15A68E_des|text=|trigger=button}{sub-section}{sub-section:449ED4A631A7F00F-5898203D-498D4C45-865084DE-271FBDFEC4DA95A6DA15A68E_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:449ED4A631A7F00F-5898203D-498D4C45-865084DE-271FBDFEC4DA95A6DA15A68E_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:449ED4A631A7F00F-5898203D-498D4C45-865084DE-271FBDFEC4DA95A6DA15A68E_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:449ED4A631A7F00F-5898203D-498D4C45-865084DE-271FBDFEC4DA95A6DA15A68E_ret|text=|trigger=button}{sub-section}{sub-section:449ED4A631A7F00F-5898203D-498D4C45-865084DE-271FBDFEC4DA95A6DA15A68E_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:449ED4A631A7F00F-5898203D-498D4C45-865084DE-271FBDFEC4DA95A6DA15A68E_see|text=|trigger=button}{sub-section}{sub-section:449ED4A631A7F00F-5898203D-498D4C45-865084DE-271FBDFEC4DA95A6DA15A68E_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:449ED4A631A7F00F-5898203D-498D4C45-865084DE-271FBDFEC4DA95A6DA15A68E_see|text=|trigger=button}{sub-section}{sub-section:449ED4A631A7F00F-5898203D-498D4C45-865084DE-271FBDFEC4DA95A6DA15A68E_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:449ED4A631A7F00F-5898203D-498D4C45-865084DE-271FBDFEC4DA95A6DA15A68E_sam|text=|trigger=button}{sub-section}{sub-section:449ED4A631A7F00F-5898203D-498D4C45-865084DE-271FBDFEC4DA95A6DA15A68E_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=22D8054B9C567E1B-B635E70C-4A814A60-89379698-A220B6AA82898651B1F95E5D}{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:22D8054B9C567E1B-B635E70C-4A814A60-89379698-A220B6AA82898651B1F95E5D_des|text=|trigger=button}{sub-section}{sub-section:22D8054B9C567E1B-B635E70C-4A814A60-89379698-A220B6AA82898651B1F95E5D_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:22D8054B9C567E1B-B635E70C-4A814A60-89379698-A220B6AA82898651B1F95E5D_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:22D8054B9C567E1B-B635E70C-4A814A60-89379698-A220B6AA82898651B1F95E5D_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:22D8054B9C567E1B-B635E70C-4A814A60-89379698-A220B6AA82898651B1F95E5D_ret|text=|trigger=button}{sub-section}{sub-section:22D8054B9C567E1B-B635E70C-4A814A60-89379698-A220B6AA82898651B1F95E5D_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:22D8054B9C567E1B-B635E70C-4A814A60-89379698-A220B6AA82898651B1F95E5D_see|text=|trigger=button}{sub-section}{sub-section:22D8054B9C567E1B-B635E70C-4A814A60-89379698-A220B6AA82898651B1F95E5D_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:22D8054B9C567E1B-B635E70C-4A814A60-89379698-A220B6AA82898651B1F95E5D_see|text=|trigger=button}{sub-section}{sub-section:22D8054B9C567E1B-B635E70C-4A814A60-89379698-A220B6AA82898651B1F95E5D_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:22D8054B9C567E1B-B635E70C-4A814A60-89379698-A220B6AA82898651B1F95E5D_sam|text=|trigger=button}{sub-section}{sub-section:22D8054B9C567E1B-B635E70C-4A814A60-89379698-A220B6AA82898651B1F95E5D_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=A9C26D209E1DC823-FED42407-4DBC4BEA-BA279337-AF43EE240BE8FE93027EDBCC}{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:A9C26D209E1DC823-FED42407-4DBC4BEA-BA279337-AF43EE240BE8FE93027EDBCC_des|text=|trigger=button}{sub-section}{sub-section:A9C26D209E1DC823-FED42407-4DBC4BEA-BA279337-AF43EE240BE8FE93027EDBCC_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:A9C26D209E1DC823-FED42407-4DBC4BEA-BA279337-AF43EE240BE8FE93027EDBCC_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:A9C26D209E1DC823-FED42407-4DBC4BEA-BA279337-AF43EE240BE8FE93027EDBCC_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:A9C26D209E1DC823-FED42407-4DBC4BEA-BA279337-AF43EE240BE8FE93027EDBCC_ret|text=|trigger=button}{sub-section}{sub-section:A9C26D209E1DC823-FED42407-4DBC4BEA-BA279337-AF43EE240BE8FE93027EDBCC_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:A9C26D209E1DC823-FED42407-4DBC4BEA-BA279337-AF43EE240BE8FE93027EDBCC_see|text=|trigger=button}{sub-section}{sub-section:A9C26D209E1DC823-FED42407-4DBC4BEA-BA279337-AF43EE240BE8FE93027EDBCC_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:A9C26D209E1DC823-FED42407-4DBC4BEA-BA279337-AF43EE240BE8FE93027EDBCC_see|text=|trigger=button}{sub-section}{sub-section:A9C26D209E1DC823-FED42407-4DBC4BEA-BA279337-AF43EE240BE8FE93027EDBCC_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:A9C26D209E1DC823-FED42407-4DBC4BEA-BA279337-AF43EE240BE8FE93027EDBCC_sam|text=|trigger=button}{sub-section}{sub-section:A9C26D209E1DC823-FED42407-4DBC4BEA-BA279337-AF43EE240BE8FE93027EDBCC_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=0A29219F76C3F3FF-3A978617-4A0D473A-B6B595C8-8173C88FD64D6CB0464DD7A1}{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:0A29219F76C3F3FF-3A978617-4A0D473A-B6B595C8-8173C88FD64D6CB0464DD7A1_des|text=|trigger=button}{sub-section}{sub-section:0A29219F76C3F3FF-3A978617-4A0D473A-B6B595C8-8173C88FD64D6CB0464DD7A1_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:0A29219F76C3F3FF-3A978617-4A0D473A-B6B595C8-8173C88FD64D6CB0464DD7A1_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:0A29219F76C3F3FF-3A978617-4A0D473A-B6B595C8-8173C88FD64D6CB0464DD7A1_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:0A29219F76C3F3FF-3A978617-4A0D473A-B6B595C8-8173C88FD64D6CB0464DD7A1_ret|text=|trigger=button}{sub-section}{sub-section:0A29219F76C3F3FF-3A978617-4A0D473A-B6B595C8-8173C88FD64D6CB0464DD7A1_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:0A29219F76C3F3FF-3A978617-4A0D473A-B6B595C8-8173C88FD64D6CB0464DD7A1_see|text=|trigger=button}{sub-section}{sub-section:0A29219F76C3F3FF-3A978617-4A0D473A-B6B595C8-8173C88FD64D6CB0464DD7A1_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:0A29219F76C3F3FF-3A978617-4A0D473A-B6B595C8-8173C88FD64D6CB0464DD7A1_see|text=|trigger=button}{sub-section}{sub-section:0A29219F76C3F3FF-3A978617-4A0D473A-B6B595C8-8173C88FD64D6CB0464DD7A1_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:0A29219F76C3F3FF-3A978617-4A0D473A-B6B595C8-8173C88FD64D6CB0464DD7A1_sam|text=|trigger=button}{sub-section}{sub-section:0A29219F76C3F3FF-3A978617-4A0D473A-B6B595C8-8173C88FD64D6CB0464DD7A1_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=806BDEBEC1F5300E-52E4DF58-4A4A49EB-9B2EAACB-EDE094BF5A57985A83B3E128}{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:806BDEBEC1F5300E-52E4DF58-4A4A49EB-9B2EAACB-EDE094BF5A57985A83B3E128_des|text=|trigger=button}{sub-section}{sub-section:806BDEBEC1F5300E-52E4DF58-4A4A49EB-9B2EAACB-EDE094BF5A57985A83B3E128_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:806BDEBEC1F5300E-52E4DF58-4A4A49EB-9B2EAACB-EDE094BF5A57985A83B3E128_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:806BDEBEC1F5300E-52E4DF58-4A4A49EB-9B2EAACB-EDE094BF5A57985A83B3E128_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:806BDEBEC1F5300E-52E4DF58-4A4A49EB-9B2EAACB-EDE094BF5A57985A83B3E128_ret|text=|trigger=button}{sub-section}{sub-section:806BDEBEC1F5300E-52E4DF58-4A4A49EB-9B2EAACB-EDE094BF5A57985A83B3E128_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:806BDEBEC1F5300E-52E4DF58-4A4A49EB-9B2EAACB-EDE094BF5A57985A83B3E128_see|text=|trigger=button}{sub-section}{sub-section:806BDEBEC1F5300E-52E4DF58-4A4A49EB-9B2EAACB-EDE094BF5A57985A83B3E128_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:806BDEBEC1F5300E-52E4DF58-4A4A49EB-9B2EAACB-EDE094BF5A57985A83B3E128_see|text=|trigger=button}{sub-section}{sub-section:806BDEBEC1F5300E-52E4DF58-4A4A49EB-9B2EAACB-EDE094BF5A57985A83B3E128_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:806BDEBEC1F5300E-52E4DF58-4A4A49EB-9B2EAACB-EDE094BF5A57985A83B3E128_sam|text=|trigger=button}{sub-section}{sub-section:806BDEBEC1F5300E-52E4DF58-4A4A49EB-9B2EAACB-EDE094BF5A57985A83B3E128_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 3

New Version 4

Key
