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=E9B9C95C932252B4-4CE894CB-4EAB4466-842AAEAA-3DF0EC722E9A8C0C780FF8EA}{tr:id=name}{td}h6.DATETIME{td}{tr}{tr:id=des}{td}{sub-section:E9B9C95C932252B4-4CE894CB-4EAB4466-842AAEAA-3DF0EC722E9A8C0C780FF8EA_des|text=|trigger=button}{sub-section}{sub-section:E9B9C95C932252B4-4CE894CB-4EAB4466-842AAEAA-3DF0EC722E9A8C0C780FF8EA_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:E9B9C95C932252B4-4CE894CB-4EAB4466-842AAEAA-3DF0EC722E9A8C0C780FF8EA_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:E9B9C95C932252B4-4CE894CB-4EAB4466-842AAEAA-3DF0EC722E9A8C0C780FF8EA_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:E9B9C95C932252B4-4CE894CB-4EAB4466-842AAEAA-3DF0EC722E9A8C0C780FF8EA_ret|text=|trigger=button}{sub-section}{sub-section:E9B9C95C932252B4-4CE894CB-4EAB4466-842AAEAA-3DF0EC722E9A8C0C780FF8EA_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:E9B9C95C932252B4-4CE894CB-4EAB4466-842AAEAA-3DF0EC722E9A8C0C780FF8EA_see|text=|trigger=button}{sub-section}{sub-section:E9B9C95C932252B4-4CE894CB-4EAB4466-842AAEAA-3DF0EC722E9A8C0C780FF8EA_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:E9B9C95C932252B4-4CE894CB-4EAB4466-842AAEAA-3DF0EC722E9A8C0C780FF8EA_see|text=|trigger=button}{sub-section}{sub-section:E9B9C95C932252B4-4CE894CB-4EAB4466-842AAEAA-3DF0EC722E9A8C0C780FF8EA_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:E9B9C95C932252B4-4CE894CB-4EAB4466-842AAEAA-3DF0EC722E9A8C0C780FF8EA_sam|text=|trigger=button}{sub-section}{sub-section:E9B9C95C932252B4-4CE894CB-4EAB4466-842AAEAA-3DF0EC722E9A8C0C780FF8EA_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=F209C3DDF290AB88-FCD7D9F2-4A4D4057-84F08BC2-2E2BFA1232B9C86D1DC81F37}{tr:id=name}{td}h6.INTEGER{td}{tr}{tr:id=des}{td}{sub-section:F209C3DDF290AB88-FCD7D9F2-4A4D4057-84F08BC2-2E2BFA1232B9C86D1DC81F37_des|text=|trigger=button}{sub-section}{sub-section:F209C3DDF290AB88-FCD7D9F2-4A4D4057-84F08BC2-2E2BFA1232B9C86D1DC81F37_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:F209C3DDF290AB88-FCD7D9F2-4A4D4057-84F08BC2-2E2BFA1232B9C86D1DC81F37_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:F209C3DDF290AB88-FCD7D9F2-4A4D4057-84F08BC2-2E2BFA1232B9C86D1DC81F37_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:F209C3DDF290AB88-FCD7D9F2-4A4D4057-84F08BC2-2E2BFA1232B9C86D1DC81F37_ret|text=|trigger=button}{sub-section}{sub-section:F209C3DDF290AB88-FCD7D9F2-4A4D4057-84F08BC2-2E2BFA1232B9C86D1DC81F37_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:F209C3DDF290AB88-FCD7D9F2-4A4D4057-84F08BC2-2E2BFA1232B9C86D1DC81F37_see|text=|trigger=button}{sub-section}{sub-section:F209C3DDF290AB88-FCD7D9F2-4A4D4057-84F08BC2-2E2BFA1232B9C86D1DC81F37_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:F209C3DDF290AB88-FCD7D9F2-4A4D4057-84F08BC2-2E2BFA1232B9C86D1DC81F37_see|text=|trigger=button}{sub-section}{sub-section:F209C3DDF290AB88-FCD7D9F2-4A4D4057-84F08BC2-2E2BFA1232B9C86D1DC81F37_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:F209C3DDF290AB88-FCD7D9F2-4A4D4057-84F08BC2-2E2BFA1232B9C86D1DC81F37_sam|text=|trigger=button}{sub-section}{sub-section:F209C3DDF290AB88-FCD7D9F2-4A4D4057-84F08BC2-2E2BFA1232B9C86D1DC81F37_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=0D9B0AAE89E30A85-6C5678FA-4F364F17-9CE7976B-EEBD35DBF841432A2E93B388}{tr:id=name}{td}h6.MEDIA{td}{tr}{tr:id=des}{td}{sub-section:0D9B0AAE89E30A85-6C5678FA-4F364F17-9CE7976B-EEBD35DBF841432A2E93B388_des|text=|trigger=button}{sub-section}{sub-section:0D9B0AAE89E30A85-6C5678FA-4F364F17-9CE7976B-EEBD35DBF841432A2E93B388_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:0D9B0AAE89E30A85-6C5678FA-4F364F17-9CE7976B-EEBD35DBF841432A2E93B388_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:0D9B0AAE89E30A85-6C5678FA-4F364F17-9CE7976B-EEBD35DBF841432A2E93B388_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:0D9B0AAE89E30A85-6C5678FA-4F364F17-9CE7976B-EEBD35DBF841432A2E93B388_ret|text=|trigger=button}{sub-section}{sub-section:0D9B0AAE89E30A85-6C5678FA-4F364F17-9CE7976B-EEBD35DBF841432A2E93B388_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:0D9B0AAE89E30A85-6C5678FA-4F364F17-9CE7976B-EEBD35DBF841432A2E93B388_see|text=|trigger=button}{sub-section}{sub-section:0D9B0AAE89E30A85-6C5678FA-4F364F17-9CE7976B-EEBD35DBF841432A2E93B388_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:0D9B0AAE89E30A85-6C5678FA-4F364F17-9CE7976B-EEBD35DBF841432A2E93B388_see|text=|trigger=button}{sub-section}{sub-section:0D9B0AAE89E30A85-6C5678FA-4F364F17-9CE7976B-EEBD35DBF841432A2E93B388_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:0D9B0AAE89E30A85-6C5678FA-4F364F17-9CE7976B-EEBD35DBF841432A2E93B388_sam|text=|trigger=button}{sub-section}{sub-section:0D9B0AAE89E30A85-6C5678FA-4F364F17-9CE7976B-EEBD35DBF841432A2E93B388_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=87049E2DFB258252-8665BCC9-404E43A0-8E3C872D-9F171BD81CAD39506D50F965}{tr:id=name}{td}h6.NUMBER{td}{tr}{tr:id=des}{td}{sub-section:87049E2DFB258252-8665BCC9-404E43A0-8E3C872D-9F171BD81CAD39506D50F965_des|text=|trigger=button}{sub-section}{sub-section:87049E2DFB258252-8665BCC9-404E43A0-8E3C872D-9F171BD81CAD39506D50F965_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:87049E2DFB258252-8665BCC9-404E43A0-8E3C872D-9F171BD81CAD39506D50F965_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:87049E2DFB258252-8665BCC9-404E43A0-8E3C872D-9F171BD81CAD39506D50F965_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:87049E2DFB258252-8665BCC9-404E43A0-8E3C872D-9F171BD81CAD39506D50F965_ret|text=|trigger=button}{sub-section}{sub-section:87049E2DFB258252-8665BCC9-404E43A0-8E3C872D-9F171BD81CAD39506D50F965_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:87049E2DFB258252-8665BCC9-404E43A0-8E3C872D-9F171BD81CAD39506D50F965_see|text=|trigger=button}{sub-section}{sub-section:87049E2DFB258252-8665BCC9-404E43A0-8E3C872D-9F171BD81CAD39506D50F965_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:87049E2DFB258252-8665BCC9-404E43A0-8E3C872D-9F171BD81CAD39506D50F965_see|text=|trigger=button}{sub-section}{sub-section:87049E2DFB258252-8665BCC9-404E43A0-8E3C872D-9F171BD81CAD39506D50F965_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:87049E2DFB258252-8665BCC9-404E43A0-8E3C872D-9F171BD81CAD39506D50F965_sam|text=|trigger=button}{sub-section}{sub-section:87049E2DFB258252-8665BCC9-404E43A0-8E3C872D-9F171BD81CAD39506D50F965_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=3F6A422BB26E25C5-816C4C69-40F64B10-BEA5B4DD-659B00195207A0F121F34DCE}{tr:id=name}{td}h6.TEXT{td}{tr}{tr:id=des}{td}{sub-section:3F6A422BB26E25C5-816C4C69-40F64B10-BEA5B4DD-659B00195207A0F121F34DCE_des|text=|trigger=button}{sub-section}{sub-section:3F6A422BB26E25C5-816C4C69-40F64B10-BEA5B4DD-659B00195207A0F121F34DCE_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:3F6A422BB26E25C5-816C4C69-40F64B10-BEA5B4DD-659B00195207A0F121F34DCE_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:3F6A422BB26E25C5-816C4C69-40F64B10-BEA5B4DD-659B00195207A0F121F34DCE_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:3F6A422BB26E25C5-816C4C69-40F64B10-BEA5B4DD-659B00195207A0F121F34DCE_ret|text=|trigger=button}{sub-section}{sub-section:3F6A422BB26E25C5-816C4C69-40F64B10-BEA5B4DD-659B00195207A0F121F34DCE_ret|trigger=none|class=sIndent}[Number]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:3F6A422BB26E25C5-816C4C69-40F64B10-BEA5B4DD-659B00195207A0F121F34DCE_see|text=|trigger=button}{sub-section}{sub-section:3F6A422BB26E25C5-816C4C69-40F64B10-BEA5B4DD-659B00195207A0F121F34DCE_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:3F6A422BB26E25C5-816C4C69-40F64B10-BEA5B4DD-659B00195207A0F121F34DCE_see|text=|trigger=button}{sub-section}{sub-section:3F6A422BB26E25C5-816C4C69-40F64B10-BEA5B4DD-659B00195207A0F121F34DCE_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:3F6A422BB26E25C5-816C4C69-40F64B10-BEA5B4DD-659B00195207A0F121F34DCE_sam|text=|trigger=button}{sub-section}{sub-section:3F6A422BB26E25C5-816C4C69-40F64B10-BEA5B4DD-659B00195207A0F121F34DCE_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=787195ED24AE586A-1C035178-464C4021-811F9156-CC89EE1CBA65EC4C86D221B6}{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:787195ED24AE586A-1C035178-464C4021-811F9156-CC89EE1CBA65EC4C86D221B6_des|text=|trigger=button}{sub-section}{sub-section:787195ED24AE586A-1C035178-464C4021-811F9156-CC89EE1CBA65EC4C86D221B6_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:787195ED24AE586A-1C035178-464C4021-811F9156-CC89EE1CBA65EC4C86D221B6_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:787195ED24AE586A-1C035178-464C4021-811F9156-CC89EE1CBA65EC4C86D221B6_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:787195ED24AE586A-1C035178-464C4021-811F9156-CC89EE1CBA65EC4C86D221B6_ret|text=|trigger=button}{sub-section}{sub-section:787195ED24AE586A-1C035178-464C4021-811F9156-CC89EE1CBA65EC4C86D221B6_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:787195ED24AE586A-1C035178-464C4021-811F9156-CC89EE1CBA65EC4C86D221B6_see|text=|trigger=button}{sub-section}{sub-section:787195ED24AE586A-1C035178-464C4021-811F9156-CC89EE1CBA65EC4C86D221B6_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:787195ED24AE586A-1C035178-464C4021-811F9156-CC89EE1CBA65EC4C86D221B6_see|text=|trigger=button}{sub-section}{sub-section:787195ED24AE586A-1C035178-464C4021-811F9156-CC89EE1CBA65EC4C86D221B6_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:787195ED24AE586A-1C035178-464C4021-811F9156-CC89EE1CBA65EC4C86D221B6_sam|text=|trigger=button}{sub-section}{sub-section:787195ED24AE586A-1C035178-464C4021-811F9156-CC89EE1CBA65EC4C86D221B6_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=876743244424D707-96D73C99-4D564D4C-AE378A7E-E27E5BBAA711F144D67B9A91}{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:876743244424D707-96D73C99-4D564D4C-AE378A7E-E27E5BBAA711F144D67B9A91_des|text=|trigger=button}{sub-section}{sub-section:876743244424D707-96D73C99-4D564D4C-AE378A7E-E27E5BBAA711F144D67B9A91_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:876743244424D707-96D73C99-4D564D4C-AE378A7E-E27E5BBAA711F144D67B9A91_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:876743244424D707-96D73C99-4D564D4C-AE378A7E-E27E5BBAA711F144D67B9A91_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:876743244424D707-96D73C99-4D564D4C-AE378A7E-E27E5BBAA711F144D67B9A91_ret|text=|trigger=button}{sub-section}{sub-section:876743244424D707-96D73C99-4D564D4C-AE378A7E-E27E5BBAA711F144D67B9A91_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:876743244424D707-96D73C99-4D564D4C-AE378A7E-E27E5BBAA711F144D67B9A91_see|text=|trigger=button}{sub-section}{sub-section:876743244424D707-96D73C99-4D564D4C-AE378A7E-E27E5BBAA711F144D67B9A91_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:876743244424D707-96D73C99-4D564D4C-AE378A7E-E27E5BBAA711F144D67B9A91_see|text=|trigger=button}{sub-section}{sub-section:876743244424D707-96D73C99-4D564D4C-AE378A7E-E27E5BBAA711F144D67B9A91_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:876743244424D707-96D73C99-4D564D4C-AE378A7E-E27E5BBAA711F144D67B9A91_sam|text=|trigger=button}{sub-section}{sub-section:876743244424D707-96D73C99-4D564D4C-AE378A7E-E27E5BBAA711F144D67B9A91_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=86135BCF17685712-2A0FCE11-42604483-87AF85CB-5DB5353A1EDFF20A9B8786DC}{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:86135BCF17685712-2A0FCE11-42604483-87AF85CB-5DB5353A1EDFF20A9B8786DC_des|text=|trigger=button}{sub-section}{sub-section:86135BCF17685712-2A0FCE11-42604483-87AF85CB-5DB5353A1EDFF20A9B8786DC_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:86135BCF17685712-2A0FCE11-42604483-87AF85CB-5DB5353A1EDFF20A9B8786DC_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:86135BCF17685712-2A0FCE11-42604483-87AF85CB-5DB5353A1EDFF20A9B8786DC_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:86135BCF17685712-2A0FCE11-42604483-87AF85CB-5DB5353A1EDFF20A9B8786DC_ret|text=|trigger=button}{sub-section}{sub-section:86135BCF17685712-2A0FCE11-42604483-87AF85CB-5DB5353A1EDFF20A9B8786DC_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:86135BCF17685712-2A0FCE11-42604483-87AF85CB-5DB5353A1EDFF20A9B8786DC_see|text=|trigger=button}{sub-section}{sub-section:86135BCF17685712-2A0FCE11-42604483-87AF85CB-5DB5353A1EDFF20A9B8786DC_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:86135BCF17685712-2A0FCE11-42604483-87AF85CB-5DB5353A1EDFF20A9B8786DC_see|text=|trigger=button}{sub-section}{sub-section:86135BCF17685712-2A0FCE11-42604483-87AF85CB-5DB5353A1EDFF20A9B8786DC_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:86135BCF17685712-2A0FCE11-42604483-87AF85CB-5DB5353A1EDFF20A9B8786DC_sam|text=|trigger=button}{sub-section}{sub-section:86135BCF17685712-2A0FCE11-42604483-87AF85CB-5DB5353A1EDFF20A9B8786DC_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=C9DC2C5AF59D855B-F032E2C9-4E014FDB-AAEAB2F7-B84A37FE0CCF4AACF74F7924}{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:C9DC2C5AF59D855B-F032E2C9-4E014FDB-AAEAB2F7-B84A37FE0CCF4AACF74F7924_des|text=|trigger=button}{sub-section}{sub-section:C9DC2C5AF59D855B-F032E2C9-4E014FDB-AAEAB2F7-B84A37FE0CCF4AACF74F7924_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:C9DC2C5AF59D855B-F032E2C9-4E014FDB-AAEAB2F7-B84A37FE0CCF4AACF74F7924_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:C9DC2C5AF59D855B-F032E2C9-4E014FDB-AAEAB2F7-B84A37FE0CCF4AACF74F7924_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:C9DC2C5AF59D855B-F032E2C9-4E014FDB-AAEAB2F7-B84A37FE0CCF4AACF74F7924_ret|text=|trigger=button}{sub-section}{sub-section:C9DC2C5AF59D855B-F032E2C9-4E014FDB-AAEAB2F7-B84A37FE0CCF4AACF74F7924_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:C9DC2C5AF59D855B-F032E2C9-4E014FDB-AAEAB2F7-B84A37FE0CCF4AACF74F7924_see|text=|trigger=button}{sub-section}{sub-section:C9DC2C5AF59D855B-F032E2C9-4E014FDB-AAEAB2F7-B84A37FE0CCF4AACF74F7924_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:C9DC2C5AF59D855B-F032E2C9-4E014FDB-AAEAB2F7-B84A37FE0CCF4AACF74F7924_see|text=|trigger=button}{sub-section}{sub-section:C9DC2C5AF59D855B-F032E2C9-4E014FDB-AAEAB2F7-B84A37FE0CCF4AACF74F7924_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:C9DC2C5AF59D855B-F032E2C9-4E014FDB-AAEAB2F7-B84A37FE0CCF4AACF74F7924_sam|text=|trigger=button}{sub-section}{sub-section:C9DC2C5AF59D855B-F032E2C9-4E014FDB-AAEAB2F7-B84A37FE0CCF4AACF74F7924_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=02AE4C5860185889-24A8198B-49754E64-A0CA81E5-971F6479AC19DB7B47E74D82}{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:02AE4C5860185889-24A8198B-49754E64-A0CA81E5-971F6479AC19DB7B47E74D82_des|text=|trigger=button}{sub-section}{sub-section:02AE4C5860185889-24A8198B-49754E64-A0CA81E5-971F6479AC19DB7B47E74D82_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:02AE4C5860185889-24A8198B-49754E64-A0CA81E5-971F6479AC19DB7B47E74D82_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:02AE4C5860185889-24A8198B-49754E64-A0CA81E5-971F6479AC19DB7B47E74D82_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:02AE4C5860185889-24A8198B-49754E64-A0CA81E5-971F6479AC19DB7B47E74D82_ret|text=|trigger=button}{sub-section}{sub-section:02AE4C5860185889-24A8198B-49754E64-A0CA81E5-971F6479AC19DB7B47E74D82_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:02AE4C5860185889-24A8198B-49754E64-A0CA81E5-971F6479AC19DB7B47E74D82_see|text=|trigger=button}{sub-section}{sub-section:02AE4C5860185889-24A8198B-49754E64-A0CA81E5-971F6479AC19DB7B47E74D82_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:02AE4C5860185889-24A8198B-49754E64-A0CA81E5-971F6479AC19DB7B47E74D82_see|text=|trigger=button}{sub-section}{sub-section:02AE4C5860185889-24A8198B-49754E64-A0CA81E5-971F6479AC19DB7B47E74D82_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:02AE4C5860185889-24A8198B-49754E64-A0CA81E5-971F6479AC19DB7B47E74D82_sam|text=|trigger=button}{sub-section}{sub-section:02AE4C5860185889-24A8198B-49754E64-A0CA81E5-971F6479AC19DB7B47E74D82_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=821DB8B6F9E9D133-1BED855B-433F4B74-A59696CB-2605C58D9302D046E5DCC63A}{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:821DB8B6F9E9D133-1BED855B-433F4B74-A59696CB-2605C58D9302D046E5DCC63A_des|text=|trigger=button}{sub-section}{sub-section:821DB8B6F9E9D133-1BED855B-433F4B74-A59696CB-2605C58D9302D046E5DCC63A_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:821DB8B6F9E9D133-1BED855B-433F4B74-A59696CB-2605C58D9302D046E5DCC63A_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:821DB8B6F9E9D133-1BED855B-433F4B74-A59696CB-2605C58D9302D046E5DCC63A_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:821DB8B6F9E9D133-1BED855B-433F4B74-A59696CB-2605C58D9302D046E5DCC63A_ret|text=|trigger=button}{sub-section}{sub-section:821DB8B6F9E9D133-1BED855B-433F4B74-A59696CB-2605C58D9302D046E5DCC63A_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:821DB8B6F9E9D133-1BED855B-433F4B74-A59696CB-2605C58D9302D046E5DCC63A_see|text=|trigger=button}{sub-section}{sub-section:821DB8B6F9E9D133-1BED855B-433F4B74-A59696CB-2605C58D9302D046E5DCC63A_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:821DB8B6F9E9D133-1BED855B-433F4B74-A59696CB-2605C58D9302D046E5DCC63A_see|text=|trigger=button}{sub-section}{sub-section:821DB8B6F9E9D133-1BED855B-433F4B74-A59696CB-2605C58D9302D046E5DCC63A_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:821DB8B6F9E9D133-1BED855B-433F4B74-A59696CB-2605C58D9302D046E5DCC63A_sam|text=|trigger=button}{sub-section}{sub-section:821DB8B6F9E9D133-1BED855B-433F4B74-A59696CB-2605C58D9302D046E5DCC63A_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=AA7BD5CDD29C2AF1-3EE555CA-479F4F2D-B6D8AA54-FCA31E5C266D8F9F0DAAAC65}{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:AA7BD5CDD29C2AF1-3EE555CA-479F4F2D-B6D8AA54-FCA31E5C266D8F9F0DAAAC65_des|text=|trigger=button}{sub-section}{sub-section:AA7BD5CDD29C2AF1-3EE555CA-479F4F2D-B6D8AA54-FCA31E5C266D8F9F0DAAAC65_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:AA7BD5CDD29C2AF1-3EE555CA-479F4F2D-B6D8AA54-FCA31E5C266D8F9F0DAAAC65_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:AA7BD5CDD29C2AF1-3EE555CA-479F4F2D-B6D8AA54-FCA31E5C266D8F9F0DAAAC65_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:AA7BD5CDD29C2AF1-3EE555CA-479F4F2D-B6D8AA54-FCA31E5C266D8F9F0DAAAC65_ret|text=|trigger=button}{sub-section}{sub-section:AA7BD5CDD29C2AF1-3EE555CA-479F4F2D-B6D8AA54-FCA31E5C266D8F9F0DAAAC65_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:AA7BD5CDD29C2AF1-3EE555CA-479F4F2D-B6D8AA54-FCA31E5C266D8F9F0DAAAC65_see|text=|trigger=button}{sub-section}{sub-section:AA7BD5CDD29C2AF1-3EE555CA-479F4F2D-B6D8AA54-FCA31E5C266D8F9F0DAAAC65_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:AA7BD5CDD29C2AF1-3EE555CA-479F4F2D-B6D8AA54-FCA31E5C266D8F9F0DAAAC65_see|text=|trigger=button}{sub-section}{sub-section:AA7BD5CDD29C2AF1-3EE555CA-479F4F2D-B6D8AA54-FCA31E5C266D8F9F0DAAAC65_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:AA7BD5CDD29C2AF1-3EE555CA-479F4F2D-B6D8AA54-FCA31E5C266D8F9F0DAAAC65_sam|text=|trigger=button}{sub-section}{sub-section:AA7BD5CDD29C2AF1-3EE555CA-479F4F2D-B6D8AA54-FCA31E5C266D8F9F0DAAAC65_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=3A0F019EBFCDE974-1D3A0B0C-4B654DFC-8562931F-9354A8AE4A0C274FFB58180A}{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:3A0F019EBFCDE974-1D3A0B0C-4B654DFC-8562931F-9354A8AE4A0C274FFB58180A_des|text=|trigger=button}{sub-section}{sub-section:3A0F019EBFCDE974-1D3A0B0C-4B654DFC-8562931F-9354A8AE4A0C274FFB58180A_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:3A0F019EBFCDE974-1D3A0B0C-4B654DFC-8562931F-9354A8AE4A0C274FFB58180A_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:3A0F019EBFCDE974-1D3A0B0C-4B654DFC-8562931F-9354A8AE4A0C274FFB58180A_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:3A0F019EBFCDE974-1D3A0B0C-4B654DFC-8562931F-9354A8AE4A0C274FFB58180A_ret|text=|trigger=button}{sub-section}{sub-section:3A0F019EBFCDE974-1D3A0B0C-4B654DFC-8562931F-9354A8AE4A0C274FFB58180A_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:3A0F019EBFCDE974-1D3A0B0C-4B654DFC-8562931F-9354A8AE4A0C274FFB58180A_see|text=|trigger=button}{sub-section}{sub-section:3A0F019EBFCDE974-1D3A0B0C-4B654DFC-8562931F-9354A8AE4A0C274FFB58180A_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:3A0F019EBFCDE974-1D3A0B0C-4B654DFC-8562931F-9354A8AE4A0C274FFB58180A_see|text=|trigger=button}{sub-section}{sub-section:3A0F019EBFCDE974-1D3A0B0C-4B654DFC-8562931F-9354A8AE4A0C274FFB58180A_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:3A0F019EBFCDE974-1D3A0B0C-4B654DFC-8562931F-9354A8AE4A0C274FFB58180A_sam|text=|trigger=button}{sub-section}{sub-section:3A0F019EBFCDE974-1D3A0B0C-4B654DFC-8562931F-9354A8AE4A0C274FFB58180A_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=0317D23BF28BEFC3-641954FA-44284DE2-A54CB879-0748D5653246DB643B4D9570}{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:0317D23BF28BEFC3-641954FA-44284DE2-A54CB879-0748D5653246DB643B4D9570_des|text=|trigger=button}{sub-section}{sub-section:0317D23BF28BEFC3-641954FA-44284DE2-A54CB879-0748D5653246DB643B4D9570_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:0317D23BF28BEFC3-641954FA-44284DE2-A54CB879-0748D5653246DB643B4D9570_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:0317D23BF28BEFC3-641954FA-44284DE2-A54CB879-0748D5653246DB643B4D9570_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:0317D23BF28BEFC3-641954FA-44284DE2-A54CB879-0748D5653246DB643B4D9570_ret|text=|trigger=button}{sub-section}{sub-section:0317D23BF28BEFC3-641954FA-44284DE2-A54CB879-0748D5653246DB643B4D9570_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:0317D23BF28BEFC3-641954FA-44284DE2-A54CB879-0748D5653246DB643B4D9570_see|text=|trigger=button}{sub-section}{sub-section:0317D23BF28BEFC3-641954FA-44284DE2-A54CB879-0748D5653246DB643B4D9570_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:0317D23BF28BEFC3-641954FA-44284DE2-A54CB879-0748D5653246DB643B4D9570_see|text=|trigger=button}{sub-section}{sub-section:0317D23BF28BEFC3-641954FA-44284DE2-A54CB879-0748D5653246DB643B4D9570_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:0317D23BF28BEFC3-641954FA-44284DE2-A54CB879-0748D5653246DB643B4D9570_sam|text=|trigger=button}{sub-section}{sub-section:0317D23BF28BEFC3-641954FA-44284DE2-A54CB879-0748D5653246DB643B4D9570_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=E989115E58F55A6E-59867FC8-4A0B490F-80ADBFD2-6CA049A5B2A7AADF92075F31}{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:E989115E58F55A6E-59867FC8-4A0B490F-80ADBFD2-6CA049A5B2A7AADF92075F31_des|text=|trigger=button}{sub-section}{sub-section:E989115E58F55A6E-59867FC8-4A0B490F-80ADBFD2-6CA049A5B2A7AADF92075F31_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:E989115E58F55A6E-59867FC8-4A0B490F-80ADBFD2-6CA049A5B2A7AADF92075F31_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:E989115E58F55A6E-59867FC8-4A0B490F-80ADBFD2-6CA049A5B2A7AADF92075F31_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:E989115E58F55A6E-59867FC8-4A0B490F-80ADBFD2-6CA049A5B2A7AADF92075F31_ret|text=|trigger=button}{sub-section}{sub-section:E989115E58F55A6E-59867FC8-4A0B490F-80ADBFD2-6CA049A5B2A7AADF92075F31_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:E989115E58F55A6E-59867FC8-4A0B490F-80ADBFD2-6CA049A5B2A7AADF92075F31_see|text=|trigger=button}{sub-section}{sub-section:E989115E58F55A6E-59867FC8-4A0B490F-80ADBFD2-6CA049A5B2A7AADF92075F31_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:E989115E58F55A6E-59867FC8-4A0B490F-80ADBFD2-6CA049A5B2A7AADF92075F31_see|text=|trigger=button}{sub-section}{sub-section:E989115E58F55A6E-59867FC8-4A0B490F-80ADBFD2-6CA049A5B2A7AADF92075F31_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:E989115E58F55A6E-59867FC8-4A0B490F-80ADBFD2-6CA049A5B2A7AADF92075F31_sam|text=|trigger=button}{sub-section}{sub-section:E989115E58F55A6E-59867FC8-4A0B490F-80ADBFD2-6CA049A5B2A7AADF92075F31_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=0EEA096E0B4B1083-D6F66C69-4A10483E-AC8780E7-2FF58830B10B38A4888EBE19}{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:0EEA096E0B4B1083-D6F66C69-4A10483E-AC8780E7-2FF58830B10B38A4888EBE19_des|text=|trigger=button}{sub-section}{sub-section:0EEA096E0B4B1083-D6F66C69-4A10483E-AC8780E7-2FF58830B10B38A4888EBE19_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:0EEA096E0B4B1083-D6F66C69-4A10483E-AC8780E7-2FF58830B10B38A4888EBE19_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:0EEA096E0B4B1083-D6F66C69-4A10483E-AC8780E7-2FF58830B10B38A4888EBE19_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:0EEA096E0B4B1083-D6F66C69-4A10483E-AC8780E7-2FF58830B10B38A4888EBE19_ret|text=|trigger=button}{sub-section}{sub-section:0EEA096E0B4B1083-D6F66C69-4A10483E-AC8780E7-2FF58830B10B38A4888EBE19_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:0EEA096E0B4B1083-D6F66C69-4A10483E-AC8780E7-2FF58830B10B38A4888EBE19_see|text=|trigger=button}{sub-section}{sub-section:0EEA096E0B4B1083-D6F66C69-4A10483E-AC8780E7-2FF58830B10B38A4888EBE19_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:0EEA096E0B4B1083-D6F66C69-4A10483E-AC8780E7-2FF58830B10B38A4888EBE19_see|text=|trigger=button}{sub-section}{sub-section:0EEA096E0B4B1083-D6F66C69-4A10483E-AC8780E7-2FF58830B10B38A4888EBE19_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:0EEA096E0B4B1083-D6F66C69-4A10483E-AC8780E7-2FF58830B10B38A4888EBE19_sam|text=|trigger=button}{sub-section}{sub-section:0EEA096E0B4B1083-D6F66C69-4A10483E-AC8780E7-2FF58830B10B38A4888EBE19_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=7C649E86581E0C5C-8198E2D3-41BD401E-8470A92E-248C954C613B4595BFB1F8FF}{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:7C649E86581E0C5C-8198E2D3-41BD401E-8470A92E-248C954C613B4595BFB1F8FF_des|text=|trigger=button}{sub-section}{sub-section:7C649E86581E0C5C-8198E2D3-41BD401E-8470A92E-248C954C613B4595BFB1F8FF_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:7C649E86581E0C5C-8198E2D3-41BD401E-8470A92E-248C954C613B4595BFB1F8FF_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:7C649E86581E0C5C-8198E2D3-41BD401E-8470A92E-248C954C613B4595BFB1F8FF_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:7C649E86581E0C5C-8198E2D3-41BD401E-8470A92E-248C954C613B4595BFB1F8FF_ret|text=|trigger=button}{sub-section}{sub-section:7C649E86581E0C5C-8198E2D3-41BD401E-8470A92E-248C954C613B4595BFB1F8FF_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:7C649E86581E0C5C-8198E2D3-41BD401E-8470A92E-248C954C613B4595BFB1F8FF_see|text=|trigger=button}{sub-section}{sub-section:7C649E86581E0C5C-8198E2D3-41BD401E-8470A92E-248C954C613B4595BFB1F8FF_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:7C649E86581E0C5C-8198E2D3-41BD401E-8470A92E-248C954C613B4595BFB1F8FF_see|text=|trigger=button}{sub-section}{sub-section:7C649E86581E0C5C-8198E2D3-41BD401E-8470A92E-248C954C613B4595BFB1F8FF_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:7C649E86581E0C5C-8198E2D3-41BD401E-8470A92E-248C954C613B4595BFB1F8FF_sam|text=|trigger=button}{sub-section}{sub-section:7C649E86581E0C5C-8198E2D3-41BD401E-8470A92E-248C954C613B4595BFB1F8FF_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=49355F4BFC5667A8-AD0B4EDC-49D64D0A-AF0583D3-54BDF9706F0A244E7D164E80}{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:49355F4BFC5667A8-AD0B4EDC-49D64D0A-AF0583D3-54BDF9706F0A244E7D164E80_des|text=|trigger=button}{sub-section}{sub-section:49355F4BFC5667A8-AD0B4EDC-49D64D0A-AF0583D3-54BDF9706F0A244E7D164E80_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:49355F4BFC5667A8-AD0B4EDC-49D64D0A-AF0583D3-54BDF9706F0A244E7D164E80_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:49355F4BFC5667A8-AD0B4EDC-49D64D0A-AF0583D3-54BDF9706F0A244E7D164E80_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:49355F4BFC5667A8-AD0B4EDC-49D64D0A-AF0583D3-54BDF9706F0A244E7D164E80_ret|text=|trigger=button}{sub-section}{sub-section:49355F4BFC5667A8-AD0B4EDC-49D64D0A-AF0583D3-54BDF9706F0A244E7D164E80_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:49355F4BFC5667A8-AD0B4EDC-49D64D0A-AF0583D3-54BDF9706F0A244E7D164E80_see|text=|trigger=button}{sub-section}{sub-section:49355F4BFC5667A8-AD0B4EDC-49D64D0A-AF0583D3-54BDF9706F0A244E7D164E80_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:49355F4BFC5667A8-AD0B4EDC-49D64D0A-AF0583D3-54BDF9706F0A244E7D164E80_see|text=|trigger=button}{sub-section}{sub-section:49355F4BFC5667A8-AD0B4EDC-49D64D0A-AF0583D3-54BDF9706F0A244E7D164E80_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:49355F4BFC5667A8-AD0B4EDC-49D64D0A-AF0583D3-54BDF9706F0A244E7D164E80_sam|text=|trigger=button}{sub-section}{sub-section:49355F4BFC5667A8-AD0B4EDC-49D64D0A-AF0583D3-54BDF9706F0A244E7D164E80_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=AFD330F9F4CE95F4-BDC9CEED-47FA4451-975E8B5E-E8A74E36281B89F8FC8C9645}{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:AFD330F9F4CE95F4-BDC9CEED-47FA4451-975E8B5E-E8A74E36281B89F8FC8C9645_des|text=|trigger=button}{sub-section}{sub-section:AFD330F9F4CE95F4-BDC9CEED-47FA4451-975E8B5E-E8A74E36281B89F8FC8C9645_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:AFD330F9F4CE95F4-BDC9CEED-47FA4451-975E8B5E-E8A74E36281B89F8FC8C9645_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:AFD330F9F4CE95F4-BDC9CEED-47FA4451-975E8B5E-E8A74E36281B89F8FC8C9645_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:AFD330F9F4CE95F4-BDC9CEED-47FA4451-975E8B5E-E8A74E36281B89F8FC8C9645_ret|text=|trigger=button}{sub-section}{sub-section:AFD330F9F4CE95F4-BDC9CEED-47FA4451-975E8B5E-E8A74E36281B89F8FC8C9645_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:AFD330F9F4CE95F4-BDC9CEED-47FA4451-975E8B5E-E8A74E36281B89F8FC8C9645_see|text=|trigger=button}{sub-section}{sub-section:AFD330F9F4CE95F4-BDC9CEED-47FA4451-975E8B5E-E8A74E36281B89F8FC8C9645_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:AFD330F9F4CE95F4-BDC9CEED-47FA4451-975E8B5E-E8A74E36281B89F8FC8C9645_see|text=|trigger=button}{sub-section}{sub-section:AFD330F9F4CE95F4-BDC9CEED-47FA4451-975E8B5E-E8A74E36281B89F8FC8C9645_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:AFD330F9F4CE95F4-BDC9CEED-47FA4451-975E8B5E-E8A74E36281B89F8FC8C9645_sam|text=|trigger=button}{sub-section}{sub-section:AFD330F9F4CE95F4-BDC9CEED-47FA4451-975E8B5E-E8A74E36281B89F8FC8C9645_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 6

New Version 7

Key
