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:id=|class=servoy sSummary}{colgroup}{column:width=80px|padding=0px|width=80px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Constants Summary{th}{tr}{tbody}{tr}{td}[String]{td}{td}[#TYPE_BIG_DECIMAL]
Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_BIG_INTEGER]
Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_BINARY]
Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_BLOB]
Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_BOOLEAN]
Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_BYTE]
Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_CHARACTER]
Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_CLOB]
Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_DATE]
Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_DOUBLE]
Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_FLOAT]
Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_IMAGE]
Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_INTEGER]
Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_SHORT]
Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_STRING]
Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_TEXT]
Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_TIME]
Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_TIMESTAMP]
Constant used for casting.{td}{tr}{tbody}{table}\\ 

{table:id=constant|class=servoy sDetail}{colgroup}{column:width=100%|padding=0px|width=100%}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Constants Details{th}{tr}{tbody:id=TYPE_BIG_DECIMAL|class=node}{tr:id=name}{td}h6.TYPE_BIG_DECIMAL{td}{tr}{tr:id=des}{td}{sub-section:TYPE_BIG_DECIMAL_des|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_BIG_DECIMAL_des|trigger=none|class=sIndent}Constant used for casting.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:TYPE_BIG_DECIMAL_snc|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_BIG_DECIMAL_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:TYPE_BIG_DECIMAL_prs|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_BIG_DECIMAL_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:TYPE_BIG_DECIMAL_ret|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_BIG_DECIMAL_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:TYPE_BIG_DECIMAL_see|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_BIG_DECIMAL_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:TYPE_BIG_DECIMAL_link|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_BIG_DECIMAL_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:TYPE_BIG_DECIMAL_sam|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_BIG_DECIMAL_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING)); 
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_BIG_INTEGER|class=node}{tr:id=name}{td}h6.TYPE_BIG_INTEGER{td}{tr}{tr:id=des}{td}{sub-section:TYPE_BIG_INTEGER_des|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_BIG_INTEGER_des|trigger=none|class=sIndent}Constant used for casting.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:TYPE_BIG_INTEGER_snc|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_BIG_INTEGER_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:TYPE_BIG_INTEGER_prs|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_BIG_INTEGER_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:TYPE_BIG_INTEGER_ret|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_BIG_INTEGER_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:TYPE_BIG_INTEGER_see|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_BIG_INTEGER_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:TYPE_BIG_INTEGER_link|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_BIG_INTEGER_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:TYPE_BIG_INTEGER_sam|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_BIG_INTEGER_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING)); 
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_BINARY|class=node}{tr:id=name}{td}h6.TYPE_BINARY{td}{tr}{tr:id=des}{td}{sub-section:TYPE_BINARY_des|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_BINARY_des|trigger=none|class=sIndent}Constant used for casting.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:TYPE_BINARY_snc|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_BINARY_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:TYPE_BINARY_prs|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_BINARY_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:TYPE_BINARY_ret|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_BINARY_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:TYPE_BINARY_see|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_BINARY_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:TYPE_BINARY_link|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_BINARY_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:TYPE_BINARY_sam|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_BINARY_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING)); 
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_BLOB|class=node}{tr:id=name}{td}h6.TYPE_BLOB{td}{tr}{tr:id=des}{td}{sub-section:TYPE_BLOB_des|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_BLOB_des|trigger=none|class=sIndent}Constant used for casting.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:TYPE_BLOB_snc|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_BLOB_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:TYPE_BLOB_prs|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_BLOB_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:TYPE_BLOB_ret|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_BLOB_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:TYPE_BLOB_see|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_BLOB_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:TYPE_BLOB_link|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_BLOB_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:TYPE_BLOB_sam|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_BLOB_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING)); 
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_BOOLEAN|class=node}{tr:id=name}{td}h6.TYPE_BOOLEAN{td}{tr}{tr:id=des}{td}{sub-section:TYPE_BOOLEAN_des|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_BOOLEAN_des|trigger=none|class=sIndent}Constant used for casting.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:TYPE_BOOLEAN_snc|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_BOOLEAN_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:TYPE_BOOLEAN_prs|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_BOOLEAN_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:TYPE_BOOLEAN_ret|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_BOOLEAN_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:TYPE_BOOLEAN_see|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_BOOLEAN_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:TYPE_BOOLEAN_link|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_BOOLEAN_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:TYPE_BOOLEAN_sam|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_BOOLEAN_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING)); 
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_BYTE|class=node}{tr:id=name}{td}h6.TYPE_BYTE{td}{tr}{tr:id=des}{td}{sub-section:TYPE_BYTE_des|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_BYTE_des|trigger=none|class=sIndent}Constant used for casting.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:TYPE_BYTE_snc|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_BYTE_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:TYPE_BYTE_prs|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_BYTE_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:TYPE_BYTE_ret|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_BYTE_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:TYPE_BYTE_see|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_BYTE_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:TYPE_BYTE_link|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_BYTE_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:TYPE_BYTE_sam|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_BYTE_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING)); 
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_CHARACTER|class=node}{tr:id=name}{td}h6.TYPE_CHARACTER{td}{tr}{tr:id=des}{td}{sub-section:TYPE_CHARACTER_des|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_CHARACTER_des|trigger=none|class=sIndent}Constant used for casting.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:TYPE_CHARACTER_snc|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_CHARACTER_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:TYPE_CHARACTER_prs|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_CHARACTER_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:TYPE_CHARACTER_ret|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_CHARACTER_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:TYPE_CHARACTER_see|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_CHARACTER_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:TYPE_CHARACTER_link|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_CHARACTER_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:TYPE_CHARACTER_sam|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_CHARACTER_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING)); 
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_CLOB|class=node}{tr:id=name}{td}h6.TYPE_CLOB{td}{tr}{tr:id=des}{td}{sub-section:TYPE_CLOB_des|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_CLOB_des|trigger=none|class=sIndent}Constant used for casting.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:TYPE_CLOB_snc|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_CLOB_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:TYPE_CLOB_prs|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_CLOB_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:TYPE_CLOB_ret|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_CLOB_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:TYPE_CLOB_see|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_CLOB_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:TYPE_CLOB_link|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_CLOB_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:TYPE_CLOB_sam|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_CLOB_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING)); 
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_DATE|class=node}{tr:id=name}{td}h6.TYPE_DATE{td}{tr}{tr:id=des}{td}{sub-section:TYPE_DATE_des|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_DATE_des|trigger=none|class=sIndent}Constant used for casting.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:TYPE_DATE_snc|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_DATE_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:TYPE_DATE_prs|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_DATE_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:TYPE_DATE_ret|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_DATE_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:TYPE_DATE_see|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_DATE_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:TYPE_DATE_link|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_DATE_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:TYPE_DATE_sam|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_DATE_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING)); 
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_DOUBLE|class=node}{tr:id=name}{td}h6.TYPE_DOUBLE{td}{tr}{tr:id=des}{td}{sub-section:TYPE_DOUBLE_des|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_DOUBLE_des|trigger=none|class=sIndent}Constant used for casting.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:TYPE_DOUBLE_snc|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_DOUBLE_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:TYPE_DOUBLE_prs|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_DOUBLE_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:TYPE_DOUBLE_ret|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_DOUBLE_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:TYPE_DOUBLE_see|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_DOUBLE_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:TYPE_DOUBLE_link|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_DOUBLE_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:TYPE_DOUBLE_sam|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_DOUBLE_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING)); 
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_FLOAT|class=node}{tr:id=name}{td}h6.TYPE_FLOAT{td}{tr}{tr:id=des}{td}{sub-section:TYPE_FLOAT_des|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_FLOAT_des|trigger=none|class=sIndent}Constant used for casting.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:TYPE_FLOAT_snc|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_FLOAT_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:TYPE_FLOAT_prs|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_FLOAT_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:TYPE_FLOAT_ret|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_FLOAT_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:TYPE_FLOAT_see|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_FLOAT_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:TYPE_FLOAT_link|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_FLOAT_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:TYPE_FLOAT_sam|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_FLOAT_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING)); 
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_IMAGE|class=node}{tr:id=name}{td}h6.TYPE_IMAGE{td}{tr}{tr:id=des}{td}{sub-section:TYPE_IMAGE_des|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_IMAGE_des|trigger=none|class=sIndent}Constant used for casting.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:TYPE_IMAGE_snc|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_IMAGE_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:TYPE_IMAGE_prs|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_IMAGE_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:TYPE_IMAGE_ret|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_IMAGE_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:TYPE_IMAGE_see|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_IMAGE_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:TYPE_IMAGE_link|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_IMAGE_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:TYPE_IMAGE_sam|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_IMAGE_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING)); 
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_INTEGER|class=node}{tr:id=name}{td}h6.TYPE_INTEGER{td}{tr}{tr:id=des}{td}{sub-section:TYPE_INTEGER_des|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_INTEGER_des|trigger=none|class=sIndent}Constant used for casting.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:TYPE_INTEGER_snc|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_INTEGER_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:TYPE_INTEGER_prs|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_INTEGER_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:TYPE_INTEGER_ret|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_INTEGER_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:TYPE_INTEGER_see|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_INTEGER_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:TYPE_INTEGER_link|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_INTEGER_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:TYPE_INTEGER_sam|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_INTEGER_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING)); 
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_SHORT|class=node}{tr:id=name}{td}h6.TYPE_SHORT{td}{tr}{tr:id=des}{td}{sub-section:TYPE_SHORT_des|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_SHORT_des|trigger=none|class=sIndent}Constant used for casting.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:TYPE_SHORT_snc|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_SHORT_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:TYPE_SHORT_prs|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_SHORT_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:TYPE_SHORT_ret|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_SHORT_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:TYPE_SHORT_see|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_SHORT_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:TYPE_SHORT_link|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_SHORT_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:TYPE_SHORT_sam|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_SHORT_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING)); 
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_STRING|class=node}{tr:id=name}{td}h6.TYPE_STRING{td}{tr}{tr:id=des}{td}{sub-section:TYPE_STRING_des|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_STRING_des|trigger=none|class=sIndent}Constant used for casting.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:TYPE_STRING_snc|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_STRING_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:TYPE_STRING_prs|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_STRING_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:TYPE_STRING_ret|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_STRING_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:TYPE_STRING_see|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_STRING_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:TYPE_STRING_link|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_STRING_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:TYPE_STRING_sam|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_STRING_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING)); 
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_TEXT|class=node}{tr:id=name}{td}h6.TYPE_TEXT{td}{tr}{tr:id=des}{td}{sub-section:TYPE_TEXT_des|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_TEXT_des|trigger=none|class=sIndent}Constant used for casting.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:TYPE_TEXT_snc|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_TEXT_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:TYPE_TEXT_prs|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_TEXT_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:TYPE_TEXT_ret|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_TEXT_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:TYPE_TEXT_see|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_TEXT_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:TYPE_TEXT_link|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_TEXT_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:TYPE_TEXT_sam|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_TEXT_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING)); 
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_TIME|class=node}{tr:id=name}{td}h6.TYPE_TIME{td}{tr}{tr:id=des}{td}{sub-section:TYPE_TIME_des|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_TIME_des|trigger=none|class=sIndent}Constant used for casting.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:TYPE_TIME_snc|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_TIME_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:TYPE_TIME_prs|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_TIME_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:TYPE_TIME_ret|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_TIME_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:TYPE_TIME_see|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_TIME_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:TYPE_TIME_link|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_TIME_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:TYPE_TIME_sam|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_TIME_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING)); 
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_TIMESTAMP|class=node}{tr:id=name}{td}h6.TYPE_TIMESTAMP{td}{tr}{tr:id=des}{td}{sub-section:TYPE_TIMESTAMP_des|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_TIMESTAMP_des|trigger=none|class=sIndent}Constant used for casting.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:TYPE_TIMESTAMP_snc|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_TIMESTAMP_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:TYPE_TIMESTAMP_prs|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_TIMESTAMP_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:TYPE_TIMESTAMP_ret|texttrigger=button|triggertext=button}{sub-section}{sub-section:TYPE_TIMESTAMP_ret|trigger=none|class=sIndent}[String]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:TYPE_TIMESTAMP_see|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_TIMESTAMP_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:TYPE_TIMESTAMP_link|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_TIMESTAMP_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:TYPE_TIMESTAMP_sam|texttrigger=button|triggertext=button}{sub-section}{div:class=sIndent}{sub-section:TYPE_TIMESTAMP_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING)); 
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}
Child pages

Versions Compared

Old Version 1

New Version 2

Key
