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=F89210AFACCA9204-FAF4FF07-475444BC-9DBEBB5B-BC4B19CDF564F07313FF1606}{tr:id=name}{td}h6.DATETIME{td}{tr}{tr:id=des}{td}{sub-section:F89210AFACCA9204-FAF4FF07-475444BC-9DBEBB5B-BC4B19CDF564F07313FF1606_des|text=|trigger=button}{sub-section}{sub-section:F89210AFACCA9204-FAF4FF07-475444BC-9DBEBB5B-BC4B19CDF564F07313FF1606_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:F89210AFACCA9204-FAF4FF07-475444BC-9DBEBB5B-BC4B19CDF564F07313FF1606_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:F89210AFACCA9204-FAF4FF07-475444BC-9DBEBB5B-BC4B19CDF564F07313FF1606_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:F89210AFACCA9204-FAF4FF07-475444BC-9DBEBB5B-BC4B19CDF564F07313FF1606_ret|text=|trigger=button}{sub-section}{sub-section:F89210AFACCA9204-FAF4FF07-475444BC-9DBEBB5B-BC4B19CDF564F07313FF1606_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:F89210AFACCA9204-FAF4FF07-475444BC-9DBEBB5B-BC4B19CDF564F07313FF1606_see|text=|trigger=button}{sub-section}{sub-section:F89210AFACCA9204-FAF4FF07-475444BC-9DBEBB5B-BC4B19CDF564F07313FF1606_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:F89210AFACCA9204-FAF4FF07-475444BC-9DBEBB5B-BC4B19CDF564F07313FF1606_see|text=|trigger=button}{sub-section}{sub-section:F89210AFACCA9204-FAF4FF07-475444BC-9DBEBB5B-BC4B19CDF564F07313FF1606_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:F89210AFACCA9204-FAF4FF07-475444BC-9DBEBB5B-BC4B19CDF564F07313FF1606_sam|text=|trigger=button}{sub-section}{sub-section:F89210AFACCA9204-FAF4FF07-475444BC-9DBEBB5B-BC4B19CDF564F07313FF1606_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=1124F6D8734EE811-79585270-4D9648CC-BCFF9216-D5D07DCCBB4A3B97B8716A15}{tr:id=name}{td}h6.INTEGER{td}{tr}{tr:id=des}{td}{sub-section:1124F6D8734EE811-79585270-4D9648CC-BCFF9216-D5D07DCCBB4A3B97B8716A15_des|text=|trigger=button}{sub-section}{sub-section:1124F6D8734EE811-79585270-4D9648CC-BCFF9216-D5D07DCCBB4A3B97B8716A15_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:1124F6D8734EE811-79585270-4D9648CC-BCFF9216-D5D07DCCBB4A3B97B8716A15_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:1124F6D8734EE811-79585270-4D9648CC-BCFF9216-D5D07DCCBB4A3B97B8716A15_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:1124F6D8734EE811-79585270-4D9648CC-BCFF9216-D5D07DCCBB4A3B97B8716A15_ret|text=|trigger=button}{sub-section}{sub-section:1124F6D8734EE811-79585270-4D9648CC-BCFF9216-D5D07DCCBB4A3B97B8716A15_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:1124F6D8734EE811-79585270-4D9648CC-BCFF9216-D5D07DCCBB4A3B97B8716A15_see|text=|trigger=button}{sub-section}{sub-section:1124F6D8734EE811-79585270-4D9648CC-BCFF9216-D5D07DCCBB4A3B97B8716A15_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:1124F6D8734EE811-79585270-4D9648CC-BCFF9216-D5D07DCCBB4A3B97B8716A15_see|text=|trigger=button}{sub-section}{sub-section:1124F6D8734EE811-79585270-4D9648CC-BCFF9216-D5D07DCCBB4A3B97B8716A15_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:1124F6D8734EE811-79585270-4D9648CC-BCFF9216-D5D07DCCBB4A3B97B8716A15_sam|text=|trigger=button}{sub-section}{sub-section:1124F6D8734EE811-79585270-4D9648CC-BCFF9216-D5D07DCCBB4A3B97B8716A15_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=6865E761D9B3A84F-BE36B0AB-48A44601-98CEB80C-A8915BCE8E3E3EA94F146B25}{tr:id=name}{td}h6.MEDIA{td}{tr}{tr:id=des}{td}{sub-section:6865E761D9B3A84F-BE36B0AB-48A44601-98CEB80C-A8915BCE8E3E3EA94F146B25_des|text=|trigger=button}{sub-section}{sub-section:6865E761D9B3A84F-BE36B0AB-48A44601-98CEB80C-A8915BCE8E3E3EA94F146B25_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:6865E761D9B3A84F-BE36B0AB-48A44601-98CEB80C-A8915BCE8E3E3EA94F146B25_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:6865E761D9B3A84F-BE36B0AB-48A44601-98CEB80C-A8915BCE8E3E3EA94F146B25_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:6865E761D9B3A84F-BE36B0AB-48A44601-98CEB80C-A8915BCE8E3E3EA94F146B25_ret|text=|trigger=button}{sub-section}{sub-section:6865E761D9B3A84F-BE36B0AB-48A44601-98CEB80C-A8915BCE8E3E3EA94F146B25_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:6865E761D9B3A84F-BE36B0AB-48A44601-98CEB80C-A8915BCE8E3E3EA94F146B25_see|text=|trigger=button}{sub-section}{sub-section:6865E761D9B3A84F-BE36B0AB-48A44601-98CEB80C-A8915BCE8E3E3EA94F146B25_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:6865E761D9B3A84F-BE36B0AB-48A44601-98CEB80C-A8915BCE8E3E3EA94F146B25_see|text=|trigger=button}{sub-section}{sub-section:6865E761D9B3A84F-BE36B0AB-48A44601-98CEB80C-A8915BCE8E3E3EA94F146B25_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:6865E761D9B3A84F-BE36B0AB-48A44601-98CEB80C-A8915BCE8E3E3EA94F146B25_sam|text=|trigger=button}{sub-section}{sub-section:6865E761D9B3A84F-BE36B0AB-48A44601-98CEB80C-A8915BCE8E3E3EA94F146B25_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=2F8FC29F85B4C76A-BD0C088D-4C7F4979-85C59710-477F6466C4ADE0D1AADD5EDB}{tr:id=name}{td}h6.NUMBER{td}{tr}{tr:id=des}{td}{sub-section:2F8FC29F85B4C76A-BD0C088D-4C7F4979-85C59710-477F6466C4ADE0D1AADD5EDB_des|text=|trigger=button}{sub-section}{sub-section:2F8FC29F85B4C76A-BD0C088D-4C7F4979-85C59710-477F6466C4ADE0D1AADD5EDB_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:2F8FC29F85B4C76A-BD0C088D-4C7F4979-85C59710-477F6466C4ADE0D1AADD5EDB_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:2F8FC29F85B4C76A-BD0C088D-4C7F4979-85C59710-477F6466C4ADE0D1AADD5EDB_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:2F8FC29F85B4C76A-BD0C088D-4C7F4979-85C59710-477F6466C4ADE0D1AADD5EDB_ret|text=|trigger=button}{sub-section}{sub-section:2F8FC29F85B4C76A-BD0C088D-4C7F4979-85C59710-477F6466C4ADE0D1AADD5EDB_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:2F8FC29F85B4C76A-BD0C088D-4C7F4979-85C59710-477F6466C4ADE0D1AADD5EDB_see|text=|trigger=button}{sub-section}{sub-section:2F8FC29F85B4C76A-BD0C088D-4C7F4979-85C59710-477F6466C4ADE0D1AADD5EDB_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:2F8FC29F85B4C76A-BD0C088D-4C7F4979-85C59710-477F6466C4ADE0D1AADD5EDB_see|text=|trigger=button}{sub-section}{sub-section:2F8FC29F85B4C76A-BD0C088D-4C7F4979-85C59710-477F6466C4ADE0D1AADD5EDB_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:2F8FC29F85B4C76A-BD0C088D-4C7F4979-85C59710-477F6466C4ADE0D1AADD5EDB_sam|text=|trigger=button}{sub-section}{sub-section:2F8FC29F85B4C76A-BD0C088D-4C7F4979-85C59710-477F6466C4ADE0D1AADD5EDB_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=E685A7911FC944C9-9E1E53DE-469D425E-A2FB9BD2-3580867575BCEF40440E9CA7}{tr:id=name}{td}h6.TEXT{td}{tr}{tr:id=des}{td}{sub-section:E685A7911FC944C9-9E1E53DE-469D425E-A2FB9BD2-3580867575BCEF40440E9CA7_des|text=|trigger=button}{sub-section}{sub-section:E685A7911FC944C9-9E1E53DE-469D425E-A2FB9BD2-3580867575BCEF40440E9CA7_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:E685A7911FC944C9-9E1E53DE-469D425E-A2FB9BD2-3580867575BCEF40440E9CA7_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:E685A7911FC944C9-9E1E53DE-469D425E-A2FB9BD2-3580867575BCEF40440E9CA7_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:E685A7911FC944C9-9E1E53DE-469D425E-A2FB9BD2-3580867575BCEF40440E9CA7_ret|text=|trigger=button}{sub-section}{sub-section:E685A7911FC944C9-9E1E53DE-469D425E-A2FB9BD2-3580867575BCEF40440E9CA7_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:E685A7911FC944C9-9E1E53DE-469D425E-A2FB9BD2-3580867575BCEF40440E9CA7_see|text=|trigger=button}{sub-section}{sub-section:E685A7911FC944C9-9E1E53DE-469D425E-A2FB9BD2-3580867575BCEF40440E9CA7_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:E685A7911FC944C9-9E1E53DE-469D425E-A2FB9BD2-3580867575BCEF40440E9CA7_see|text=|trigger=button}{sub-section}{sub-section:E685A7911FC944C9-9E1E53DE-469D425E-A2FB9BD2-3580867575BCEF40440E9CA7_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:E685A7911FC944C9-9E1E53DE-469D425E-A2FB9BD2-3580867575BCEF40440E9CA7_sam|text=|trigger=button}{sub-section}{sub-section:E685A7911FC944C9-9E1E53DE-469D425E-A2FB9BD2-3580867575BCEF40440E9CA7_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=CE6EC76CF87DC6E4-EEF3C506-458B4566-A03E8AF4-8FE5F44D84DADB8CF85553EE}{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:CE6EC76CF87DC6E4-EEF3C506-458B4566-A03E8AF4-8FE5F44D84DADB8CF85553EE_des|text=|trigger=button}{sub-section}{sub-section:CE6EC76CF87DC6E4-EEF3C506-458B4566-A03E8AF4-8FE5F44D84DADB8CF85553EE_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:CE6EC76CF87DC6E4-EEF3C506-458B4566-A03E8AF4-8FE5F44D84DADB8CF85553EE_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:CE6EC76CF87DC6E4-EEF3C506-458B4566-A03E8AF4-8FE5F44D84DADB8CF85553EE_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:CE6EC76CF87DC6E4-EEF3C506-458B4566-A03E8AF4-8FE5F44D84DADB8CF85553EE_ret|text=|trigger=button}{sub-section}{sub-section:CE6EC76CF87DC6E4-EEF3C506-458B4566-A03E8AF4-8FE5F44D84DADB8CF85553EE_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:CE6EC76CF87DC6E4-EEF3C506-458B4566-A03E8AF4-8FE5F44D84DADB8CF85553EE_see|text=|trigger=button}{sub-section}{sub-section:CE6EC76CF87DC6E4-EEF3C506-458B4566-A03E8AF4-8FE5F44D84DADB8CF85553EE_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:CE6EC76CF87DC6E4-EEF3C506-458B4566-A03E8AF4-8FE5F44D84DADB8CF85553EE_see|text=|trigger=button}{sub-section}{sub-section:CE6EC76CF87DC6E4-EEF3C506-458B4566-A03E8AF4-8FE5F44D84DADB8CF85553EE_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:CE6EC76CF87DC6E4-EEF3C506-458B4566-A03E8AF4-8FE5F44D84DADB8CF85553EE_sam|text=|trigger=button}{sub-section}{sub-section:CE6EC76CF87DC6E4-EEF3C506-458B4566-A03E8AF4-8FE5F44D84DADB8CF85553EE_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=EFDC8576D1827113-598B3D3A-456E4A3F-B445BF44-8EB3FC6A1B2FD0C7F0B01184}{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:EFDC8576D1827113-598B3D3A-456E4A3F-B445BF44-8EB3FC6A1B2FD0C7F0B01184_des|text=|trigger=button}{sub-section}{sub-section:EFDC8576D1827113-598B3D3A-456E4A3F-B445BF44-8EB3FC6A1B2FD0C7F0B01184_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:EFDC8576D1827113-598B3D3A-456E4A3F-B445BF44-8EB3FC6A1B2FD0C7F0B01184_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:EFDC8576D1827113-598B3D3A-456E4A3F-B445BF44-8EB3FC6A1B2FD0C7F0B01184_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:EFDC8576D1827113-598B3D3A-456E4A3F-B445BF44-8EB3FC6A1B2FD0C7F0B01184_ret|text=|trigger=button}{sub-section}{sub-section:EFDC8576D1827113-598B3D3A-456E4A3F-B445BF44-8EB3FC6A1B2FD0C7F0B01184_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:EFDC8576D1827113-598B3D3A-456E4A3F-B445BF44-8EB3FC6A1B2FD0C7F0B01184_see|text=|trigger=button}{sub-section}{sub-section:EFDC8576D1827113-598B3D3A-456E4A3F-B445BF44-8EB3FC6A1B2FD0C7F0B01184_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:EFDC8576D1827113-598B3D3A-456E4A3F-B445BF44-8EB3FC6A1B2FD0C7F0B01184_see|text=|trigger=button}{sub-section}{sub-section:EFDC8576D1827113-598B3D3A-456E4A3F-B445BF44-8EB3FC6A1B2FD0C7F0B01184_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:EFDC8576D1827113-598B3D3A-456E4A3F-B445BF44-8EB3FC6A1B2FD0C7F0B01184_sam|text=|trigger=button}{sub-section}{sub-section:EFDC8576D1827113-598B3D3A-456E4A3F-B445BF44-8EB3FC6A1B2FD0C7F0B01184_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=6AA859A73778DF50-B394E3C8-493C4CD8-AF70BB8E-0BF14F50F3B9E48497C9C4BC}{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:6AA859A73778DF50-B394E3C8-493C4CD8-AF70BB8E-0BF14F50F3B9E48497C9C4BC_des|text=|trigger=button}{sub-section}{sub-section:6AA859A73778DF50-B394E3C8-493C4CD8-AF70BB8E-0BF14F50F3B9E48497C9C4BC_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:6AA859A73778DF50-B394E3C8-493C4CD8-AF70BB8E-0BF14F50F3B9E48497C9C4BC_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:6AA859A73778DF50-B394E3C8-493C4CD8-AF70BB8E-0BF14F50F3B9E48497C9C4BC_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:6AA859A73778DF50-B394E3C8-493C4CD8-AF70BB8E-0BF14F50F3B9E48497C9C4BC_ret|text=|trigger=button}{sub-section}{sub-section:6AA859A73778DF50-B394E3C8-493C4CD8-AF70BB8E-0BF14F50F3B9E48497C9C4BC_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:6AA859A73778DF50-B394E3C8-493C4CD8-AF70BB8E-0BF14F50F3B9E48497C9C4BC_see|text=|trigger=button}{sub-section}{sub-section:6AA859A73778DF50-B394E3C8-493C4CD8-AF70BB8E-0BF14F50F3B9E48497C9C4BC_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:6AA859A73778DF50-B394E3C8-493C4CD8-AF70BB8E-0BF14F50F3B9E48497C9C4BC_see|text=|trigger=button}{sub-section}{sub-section:6AA859A73778DF50-B394E3C8-493C4CD8-AF70BB8E-0BF14F50F3B9E48497C9C4BC_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:6AA859A73778DF50-B394E3C8-493C4CD8-AF70BB8E-0BF14F50F3B9E48497C9C4BC_sam|text=|trigger=button}{sub-section}{sub-section:6AA859A73778DF50-B394E3C8-493C4CD8-AF70BB8E-0BF14F50F3B9E48497C9C4BC_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=5637E392E7F8A536-68A9911C-40CC4356-8198A050-AFD8340A62377AA3771E5CFA}{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:5637E392E7F8A536-68A9911C-40CC4356-8198A050-AFD8340A62377AA3771E5CFA_des|text=|trigger=button}{sub-section}{sub-section:5637E392E7F8A536-68A9911C-40CC4356-8198A050-AFD8340A62377AA3771E5CFA_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:5637E392E7F8A536-68A9911C-40CC4356-8198A050-AFD8340A62377AA3771E5CFA_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:5637E392E7F8A536-68A9911C-40CC4356-8198A050-AFD8340A62377AA3771E5CFA_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:5637E392E7F8A536-68A9911C-40CC4356-8198A050-AFD8340A62377AA3771E5CFA_ret|text=|trigger=button}{sub-section}{sub-section:5637E392E7F8A536-68A9911C-40CC4356-8198A050-AFD8340A62377AA3771E5CFA_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:5637E392E7F8A536-68A9911C-40CC4356-8198A050-AFD8340A62377AA3771E5CFA_see|text=|trigger=button}{sub-section}{sub-section:5637E392E7F8A536-68A9911C-40CC4356-8198A050-AFD8340A62377AA3771E5CFA_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:5637E392E7F8A536-68A9911C-40CC4356-8198A050-AFD8340A62377AA3771E5CFA_see|text=|trigger=button}{sub-section}{sub-section:5637E392E7F8A536-68A9911C-40CC4356-8198A050-AFD8340A62377AA3771E5CFA_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:5637E392E7F8A536-68A9911C-40CC4356-8198A050-AFD8340A62377AA3771E5CFA_sam|text=|trigger=button}{sub-section}{sub-section:5637E392E7F8A536-68A9911C-40CC4356-8198A050-AFD8340A62377AA3771E5CFA_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=76170BCE99BC7E70-77DD89AF-49D14E25-8AEFB85F-7F30EEE5FAB8B72FB98CBBFC}{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:76170BCE99BC7E70-77DD89AF-49D14E25-8AEFB85F-7F30EEE5FAB8B72FB98CBBFC_des|text=|trigger=button}{sub-section}{sub-section:76170BCE99BC7E70-77DD89AF-49D14E25-8AEFB85F-7F30EEE5FAB8B72FB98CBBFC_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:76170BCE99BC7E70-77DD89AF-49D14E25-8AEFB85F-7F30EEE5FAB8B72FB98CBBFC_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:76170BCE99BC7E70-77DD89AF-49D14E25-8AEFB85F-7F30EEE5FAB8B72FB98CBBFC_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:76170BCE99BC7E70-77DD89AF-49D14E25-8AEFB85F-7F30EEE5FAB8B72FB98CBBFC_ret|text=|trigger=button}{sub-section}{sub-section:76170BCE99BC7E70-77DD89AF-49D14E25-8AEFB85F-7F30EEE5FAB8B72FB98CBBFC_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:76170BCE99BC7E70-77DD89AF-49D14E25-8AEFB85F-7F30EEE5FAB8B72FB98CBBFC_see|text=|trigger=button}{sub-section}{sub-section:76170BCE99BC7E70-77DD89AF-49D14E25-8AEFB85F-7F30EEE5FAB8B72FB98CBBFC_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:76170BCE99BC7E70-77DD89AF-49D14E25-8AEFB85F-7F30EEE5FAB8B72FB98CBBFC_see|text=|trigger=button}{sub-section}{sub-section:76170BCE99BC7E70-77DD89AF-49D14E25-8AEFB85F-7F30EEE5FAB8B72FB98CBBFC_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:76170BCE99BC7E70-77DD89AF-49D14E25-8AEFB85F-7F30EEE5FAB8B72FB98CBBFC_sam|text=|trigger=button}{sub-section}{sub-section:76170BCE99BC7E70-77DD89AF-49D14E25-8AEFB85F-7F30EEE5FAB8B72FB98CBBFC_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=829ED117B076730C-661FAB90-41EB4D92-85579784-F1A05FE7E57821D0C2B55435}{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:829ED117B076730C-661FAB90-41EB4D92-85579784-F1A05FE7E57821D0C2B55435_des|text=|trigger=button}{sub-section}{sub-section:829ED117B076730C-661FAB90-41EB4D92-85579784-F1A05FE7E57821D0C2B55435_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:829ED117B076730C-661FAB90-41EB4D92-85579784-F1A05FE7E57821D0C2B55435_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:829ED117B076730C-661FAB90-41EB4D92-85579784-F1A05FE7E57821D0C2B55435_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:829ED117B076730C-661FAB90-41EB4D92-85579784-F1A05FE7E57821D0C2B55435_ret|text=|trigger=button}{sub-section}{sub-section:829ED117B076730C-661FAB90-41EB4D92-85579784-F1A05FE7E57821D0C2B55435_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:829ED117B076730C-661FAB90-41EB4D92-85579784-F1A05FE7E57821D0C2B55435_see|text=|trigger=button}{sub-section}{sub-section:829ED117B076730C-661FAB90-41EB4D92-85579784-F1A05FE7E57821D0C2B55435_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:829ED117B076730C-661FAB90-41EB4D92-85579784-F1A05FE7E57821D0C2B55435_see|text=|trigger=button}{sub-section}{sub-section:829ED117B076730C-661FAB90-41EB4D92-85579784-F1A05FE7E57821D0C2B55435_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:829ED117B076730C-661FAB90-41EB4D92-85579784-F1A05FE7E57821D0C2B55435_sam|text=|trigger=button}{sub-section}{sub-section:829ED117B076730C-661FAB90-41EB4D92-85579784-F1A05FE7E57821D0C2B55435_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=0ABB56B05F700DFF-9F2713FB-4BEB4453-AF35ABFE-FAF07B0DCAC1EC2737ADFD4C}{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:0ABB56B05F700DFF-9F2713FB-4BEB4453-AF35ABFE-FAF07B0DCAC1EC2737ADFD4C_des|text=|trigger=button}{sub-section}{sub-section:0ABB56B05F700DFF-9F2713FB-4BEB4453-AF35ABFE-FAF07B0DCAC1EC2737ADFD4C_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:0ABB56B05F700DFF-9F2713FB-4BEB4453-AF35ABFE-FAF07B0DCAC1EC2737ADFD4C_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:0ABB56B05F700DFF-9F2713FB-4BEB4453-AF35ABFE-FAF07B0DCAC1EC2737ADFD4C_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:0ABB56B05F700DFF-9F2713FB-4BEB4453-AF35ABFE-FAF07B0DCAC1EC2737ADFD4C_ret|text=|trigger=button}{sub-section}{sub-section:0ABB56B05F700DFF-9F2713FB-4BEB4453-AF35ABFE-FAF07B0DCAC1EC2737ADFD4C_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:0ABB56B05F700DFF-9F2713FB-4BEB4453-AF35ABFE-FAF07B0DCAC1EC2737ADFD4C_see|text=|trigger=button}{sub-section}{sub-section:0ABB56B05F700DFF-9F2713FB-4BEB4453-AF35ABFE-FAF07B0DCAC1EC2737ADFD4C_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:0ABB56B05F700DFF-9F2713FB-4BEB4453-AF35ABFE-FAF07B0DCAC1EC2737ADFD4C_see|text=|trigger=button}{sub-section}{sub-section:0ABB56B05F700DFF-9F2713FB-4BEB4453-AF35ABFE-FAF07B0DCAC1EC2737ADFD4C_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:0ABB56B05F700DFF-9F2713FB-4BEB4453-AF35ABFE-FAF07B0DCAC1EC2737ADFD4C_sam|text=|trigger=button}{sub-section}{sub-section:0ABB56B05F700DFF-9F2713FB-4BEB4453-AF35ABFE-FAF07B0DCAC1EC2737ADFD4C_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=33245B55EDE54848-E9E1A2A3-48934E1A-8F64B0A7-F4F07565CE05A668D0A2FCC6}{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:33245B55EDE54848-E9E1A2A3-48934E1A-8F64B0A7-F4F07565CE05A668D0A2FCC6_des|text=|trigger=button}{sub-section}{sub-section:33245B55EDE54848-E9E1A2A3-48934E1A-8F64B0A7-F4F07565CE05A668D0A2FCC6_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:33245B55EDE54848-E9E1A2A3-48934E1A-8F64B0A7-F4F07565CE05A668D0A2FCC6_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:33245B55EDE54848-E9E1A2A3-48934E1A-8F64B0A7-F4F07565CE05A668D0A2FCC6_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:33245B55EDE54848-E9E1A2A3-48934E1A-8F64B0A7-F4F07565CE05A668D0A2FCC6_ret|text=|trigger=button}{sub-section}{sub-section:33245B55EDE54848-E9E1A2A3-48934E1A-8F64B0A7-F4F07565CE05A668D0A2FCC6_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:33245B55EDE54848-E9E1A2A3-48934E1A-8F64B0A7-F4F07565CE05A668D0A2FCC6_see|text=|trigger=button}{sub-section}{sub-section:33245B55EDE54848-E9E1A2A3-48934E1A-8F64B0A7-F4F07565CE05A668D0A2FCC6_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:33245B55EDE54848-E9E1A2A3-48934E1A-8F64B0A7-F4F07565CE05A668D0A2FCC6_see|text=|trigger=button}{sub-section}{sub-section:33245B55EDE54848-E9E1A2A3-48934E1A-8F64B0A7-F4F07565CE05A668D0A2FCC6_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:33245B55EDE54848-E9E1A2A3-48934E1A-8F64B0A7-F4F07565CE05A668D0A2FCC6_sam|text=|trigger=button}{sub-section}{sub-section:33245B55EDE54848-E9E1A2A3-48934E1A-8F64B0A7-F4F07565CE05A668D0A2FCC6_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=B20532660B10B3D3-48189F47-470A44AD-BBE1A502-D5FA3A2B46F8806843BCED30}{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:B20532660B10B3D3-48189F47-470A44AD-BBE1A502-D5FA3A2B46F8806843BCED30_des|text=|trigger=button}{sub-section}{sub-section:B20532660B10B3D3-48189F47-470A44AD-BBE1A502-D5FA3A2B46F8806843BCED30_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:B20532660B10B3D3-48189F47-470A44AD-BBE1A502-D5FA3A2B46F8806843BCED30_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:B20532660B10B3D3-48189F47-470A44AD-BBE1A502-D5FA3A2B46F8806843BCED30_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:B20532660B10B3D3-48189F47-470A44AD-BBE1A502-D5FA3A2B46F8806843BCED30_ret|text=|trigger=button}{sub-section}{sub-section:B20532660B10B3D3-48189F47-470A44AD-BBE1A502-D5FA3A2B46F8806843BCED30_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:B20532660B10B3D3-48189F47-470A44AD-BBE1A502-D5FA3A2B46F8806843BCED30_see|text=|trigger=button}{sub-section}{sub-section:B20532660B10B3D3-48189F47-470A44AD-BBE1A502-D5FA3A2B46F8806843BCED30_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:B20532660B10B3D3-48189F47-470A44AD-BBE1A502-D5FA3A2B46F8806843BCED30_see|text=|trigger=button}{sub-section}{sub-section:B20532660B10B3D3-48189F47-470A44AD-BBE1A502-D5FA3A2B46F8806843BCED30_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:B20532660B10B3D3-48189F47-470A44AD-BBE1A502-D5FA3A2B46F8806843BCED30_sam|text=|trigger=button}{sub-section}{sub-section:B20532660B10B3D3-48189F47-470A44AD-BBE1A502-D5FA3A2B46F8806843BCED30_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=67613F15449ED4A6-C3985898-42AC498D-892D8650-186B5EF4E41F271FBDFEC4DA}{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:67613F15449ED4A6-C3985898-42AC498D-892D8650-186B5EF4E41F271FBDFEC4DA_des|text=|trigger=button}{sub-section}{sub-section:67613F15449ED4A6-C3985898-42AC498D-892D8650-186B5EF4E41F271FBDFEC4DA_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:67613F15449ED4A6-C3985898-42AC498D-892D8650-186B5EF4E41F271FBDFEC4DA_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:67613F15449ED4A6-C3985898-42AC498D-892D8650-186B5EF4E41F271FBDFEC4DA_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:67613F15449ED4A6-C3985898-42AC498D-892D8650-186B5EF4E41F271FBDFEC4DA_ret|text=|trigger=button}{sub-section}{sub-section:67613F15449ED4A6-C3985898-42AC498D-892D8650-186B5EF4E41F271FBDFEC4DA_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:67613F15449ED4A6-C3985898-42AC498D-892D8650-186B5EF4E41F271FBDFEC4DA_see|text=|trigger=button}{sub-section}{sub-section:67613F15449ED4A6-C3985898-42AC498D-892D8650-186B5EF4E41F271FBDFEC4DA_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:67613F15449ED4A6-C3985898-42AC498D-892D8650-186B5EF4E41F271FBDFEC4DA_see|text=|trigger=button}{sub-section}{sub-section:67613F15449ED4A6-C3985898-42AC498D-892D8650-186B5EF4E41F271FBDFEC4DA_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:67613F15449ED4A6-C3985898-42AC498D-892D8650-186B5EF4E41F271FBDFEC4DA_sam|text=|trigger=button}{sub-section}{sub-section:67613F15449ED4A6-C3985898-42AC498D-892D8650-186B5EF4E41F271FBDFEC4DA_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=675DB78F22D8054B-950EB635-4B6D4A81-B3C18937-424402729FDEA220B6AA8289}{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:675DB78F22D8054B-950EB635-4B6D4A81-B3C18937-424402729FDEA220B6AA8289_des|text=|trigger=button}{sub-section}{sub-section:675DB78F22D8054B-950EB635-4B6D4A81-B3C18937-424402729FDEA220B6AA8289_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:675DB78F22D8054B-950EB635-4B6D4A81-B3C18937-424402729FDEA220B6AA8289_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:675DB78F22D8054B-950EB635-4B6D4A81-B3C18937-424402729FDEA220B6AA8289_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:675DB78F22D8054B-950EB635-4B6D4A81-B3C18937-424402729FDEA220B6AA8289_ret|text=|trigger=button}{sub-section}{sub-section:675DB78F22D8054B-950EB635-4B6D4A81-B3C18937-424402729FDEA220B6AA8289_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:675DB78F22D8054B-950EB635-4B6D4A81-B3C18937-424402729FDEA220B6AA8289_see|text=|trigger=button}{sub-section}{sub-section:675DB78F22D8054B-950EB635-4B6D4A81-B3C18937-424402729FDEA220B6AA8289_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:675DB78F22D8054B-950EB635-4B6D4A81-B3C18937-424402729FDEA220B6AA8289_see|text=|trigger=button}{sub-section}{sub-section:675DB78F22D8054B-950EB635-4B6D4A81-B3C18937-424402729FDEA220B6AA8289_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:675DB78F22D8054B-950EB635-4B6D4A81-B3C18937-424402729FDEA220B6AA8289_sam|text=|trigger=button}{sub-section}{sub-section:675DB78F22D8054B-950EB635-4B6D4A81-B3C18937-424402729FDEA220B6AA8289_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=4211D0BDA9C26D20-FEC9FED4-40844DBC-A0DFBA27-6CB34B6761DCAF43EE240BE8}{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:4211D0BDA9C26D20-FEC9FED4-40844DBC-A0DFBA27-6CB34B6761DCAF43EE240BE8_des|text=|trigger=button}{sub-section}{sub-section:4211D0BDA9C26D20-FEC9FED4-40844DBC-A0DFBA27-6CB34B6761DCAF43EE240BE8_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:4211D0BDA9C26D20-FEC9FED4-40844DBC-A0DFBA27-6CB34B6761DCAF43EE240BE8_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:4211D0BDA9C26D20-FEC9FED4-40844DBC-A0DFBA27-6CB34B6761DCAF43EE240BE8_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:4211D0BDA9C26D20-FEC9FED4-40844DBC-A0DFBA27-6CB34B6761DCAF43EE240BE8_ret|text=|trigger=button}{sub-section}{sub-section:4211D0BDA9C26D20-FEC9FED4-40844DBC-A0DFBA27-6CB34B6761DCAF43EE240BE8_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:4211D0BDA9C26D20-FEC9FED4-40844DBC-A0DFBA27-6CB34B6761DCAF43EE240BE8_see|text=|trigger=button}{sub-section}{sub-section:4211D0BDA9C26D20-FEC9FED4-40844DBC-A0DFBA27-6CB34B6761DCAF43EE240BE8_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:4211D0BDA9C26D20-FEC9FED4-40844DBC-A0DFBA27-6CB34B6761DCAF43EE240BE8_see|text=|trigger=button}{sub-section}{sub-section:4211D0BDA9C26D20-FEC9FED4-40844DBC-A0DFBA27-6CB34B6761DCAF43EE240BE8_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:4211D0BDA9C26D20-FEC9FED4-40844DBC-A0DFBA27-6CB34B6761DCAF43EE240BE8_sam|text=|trigger=button}{sub-section}{sub-section:4211D0BDA9C26D20-FEC9FED4-40844DBC-A0DFBA27-6CB34B6761DCAF43EE240BE8_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=31FF7A050A29219F-E9E23A97-45F04A0D-97C3B6B5-1E606EE3FC338173C88FD64D}{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:31FF7A050A29219F-E9E23A97-45F04A0D-97C3B6B5-1E606EE3FC338173C88FD64D_des|text=|trigger=button}{sub-section}{sub-section:31FF7A050A29219F-E9E23A97-45F04A0D-97C3B6B5-1E606EE3FC338173C88FD64D_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:31FF7A050A29219F-E9E23A97-45F04A0D-97C3B6B5-1E606EE3FC338173C88FD64D_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:31FF7A050A29219F-E9E23A97-45F04A0D-97C3B6B5-1E606EE3FC338173C88FD64D_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:31FF7A050A29219F-E9E23A97-45F04A0D-97C3B6B5-1E606EE3FC338173C88FD64D_ret|text=|trigger=button}{sub-section}{sub-section:31FF7A050A29219F-E9E23A97-45F04A0D-97C3B6B5-1E606EE3FC338173C88FD64D_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:31FF7A050A29219F-E9E23A97-45F04A0D-97C3B6B5-1E606EE3FC338173C88FD64D_see|text=|trigger=button}{sub-section}{sub-section:31FF7A050A29219F-E9E23A97-45F04A0D-97C3B6B5-1E606EE3FC338173C88FD64D_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:31FF7A050A29219F-E9E23A97-45F04A0D-97C3B6B5-1E606EE3FC338173C88FD64D_see|text=|trigger=button}{sub-section}{sub-section:31FF7A050A29219F-E9E23A97-45F04A0D-97C3B6B5-1E606EE3FC338173C88FD64D_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:31FF7A050A29219F-E9E23A97-45F04A0D-97C3B6B5-1E606EE3FC338173C88FD64D_sam|text=|trigger=button}{sub-section}{sub-section:31FF7A050A29219F-E9E23A97-45F04A0D-97C3B6B5-1E606EE3FC338173C88FD64D_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=5C084C42806BDEBE-9D6A52E4-4F4A4A4A-A2C09B2E-9A996576C31AEDE094BF5A57}{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:5C084C42806BDEBE-9D6A52E4-4F4A4A4A-A2C09B2E-9A996576C31AEDE094BF5A57_des|text=|trigger=button}{sub-section}{sub-section:5C084C42806BDEBE-9D6A52E4-4F4A4A4A-A2C09B2E-9A996576C31AEDE094BF5A57_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:5C084C42806BDEBE-9D6A52E4-4F4A4A4A-A2C09B2E-9A996576C31AEDE094BF5A57_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:5C084C42806BDEBE-9D6A52E4-4F4A4A4A-A2C09B2E-9A996576C31AEDE094BF5A57_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:5C084C42806BDEBE-9D6A52E4-4F4A4A4A-A2C09B2E-9A996576C31AEDE094BF5A57_ret|text=|trigger=button}{sub-section}{sub-section:5C084C42806BDEBE-9D6A52E4-4F4A4A4A-A2C09B2E-9A996576C31AEDE094BF5A57_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:5C084C42806BDEBE-9D6A52E4-4F4A4A4A-A2C09B2E-9A996576C31AEDE094BF5A57_see|text=|trigger=button}{sub-section}{sub-section:5C084C42806BDEBE-9D6A52E4-4F4A4A4A-A2C09B2E-9A996576C31AEDE094BF5A57_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:5C084C42806BDEBE-9D6A52E4-4F4A4A4A-A2C09B2E-9A996576C31AEDE094BF5A57_see|text=|trigger=button}{sub-section}{sub-section:5C084C42806BDEBE-9D6A52E4-4F4A4A4A-A2C09B2E-9A996576C31AEDE094BF5A57_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:5C084C42806BDEBE-9D6A52E4-4F4A4A4A-A2C09B2E-9A996576C31AEDE094BF5A57_sam|text=|trigger=button}{sub-section}{sub-section:5C084C42806BDEBE-9D6A52E4-4F4A4A4A-A2C09B2E-9A996576C31AEDE094BF5A57_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 2

New Version 3

Key
