Page History

{hiddendiv:style=display:none}
DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY (EXCEPT INSIDE THE DIV BELOW WITH ID=DESCRIPTION), UNLESS YOU KNOW WHAT YOU'RE DOING.
		THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO EXTRACTAUTO CHANGES FROMUPDATE THE PAGECONTENT ANDTHROUGH MERGETHE THEM BACK INTO SERVOY SOURCE{hiddenDOC GENERATOR{div}
{sub-sectiondiv:id=description|text=}{sub-sectiondiv}\\ 

{table:id=|class=servoy sSummary}{colgroup}{column:width=80px|padding=0px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Property Summary{th}{tr}{tbody}{tr}{td}[QBSelect]{td}{td}[#parent]
Get query builder parent table clause, this may be a query or a join clause.{td}{tr}{tbody}{tbody}{tr}{td}[QBSelect]{td}{td}[#root]
Get query builder parent.{td}{tr}{tbody}{table}\\ 

{table:id=|class=servoy sSummary}{colgroup}{column:width=80px|padding=0px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Method Summary{th}{tr}{tbody}{tr}{td}[QBFunction]{td}{td}[#abs]\(value)
Create abs(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#bit_length]\(value)
Create bit\_length(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#cast]\(value, type)
Cast using type name.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#ceil]\(arg)
Create ceil(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#coalesce]\(args)
Create year(date) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#concat]\(arg1, arg2)
Create concat(args, arg2) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#day]\(arg)
Create day(date) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#divide]\(arg1, arg2)
Create divide(args, arg2) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#floor]\(arg)
Create floor(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#hour]\(arg)
Create hour(date) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#len]\(value)
Create length(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#locate]\(string1, string2)
Create locate(str1, str2) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#locate]\(string1, string2, start)
Create locate(str1, str2, start) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#lower]\(value)
Create lower(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#minus]\(arg1, arg2)
Create minus(args, arg2) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#minute]\(arg)
Create minute(date) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#mod]\(dividend, divisor)
Create mod(dividend, divisor) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#month]\(arg)
Create month(date) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#multiply]\(arg1, arg2)
Create multiply(args, arg2) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#nullif]\(arg1)
Create nullif(arg1, arg2) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#plus]\(arg1, arg2)
Create plus(args, arg2) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#round]\(arg)
Create round(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#second]\(arg)
Create second(date) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#sqrt]\(value)
Create sqrt(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#substring]\(arg, pos)
Create substring(column, pos) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#substring]\(arg, pos, len)
Create substring(column, pos, len) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#trim]\(value)
Create trim(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#upper]\(value)
Create upper(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#year]\(arg)
Create year(date) expression{td}{tr}{tbody}{table}\\ 

{table:id=property|class=servoy sDetail}{colgroup}{column:width=100%|padding=0px}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Property Details{th}{tr}{tbody:id=parent|class=node}{tr:id=name}{td}h6.parent{td}{tr}{builder-show:permission=edit}{tr:id=desret}{td}{sub-section:parent_des|trigger=button|text=}{sub-section}{sub-section:parent_des|trigger=none|*Returns*\\{div:class=sIndent}Replace with description{sub-section[QBSelect]{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Sincetr:id=sam}{td}*Sample*\\{sub-section:parent_snc|trigger=button|text=}{sub-section}{sub-section:parent_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:parent_prs|trigger=button|text=}{sub-section}{sub-section:parent_prs|trigger=none|class=sIndent}{sub-sectiondiv:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/person>} */
	var query = databaseManager.createSelect('db:/example_data/person')
	query.where.add(query.joins.person_to_parent.joins.person_to_parent.columns.name.eq('john'))
	foundset.loadRecords(query)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{builder-show}{tbody}{tbody:id=root}{tr:id=name}{td}h6.root{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:parent_ret|trigger=button|text=}{sub-section}{sub-section:parent_ret|trigger=none|div:class=sIndent}[QBSelect]{sub-sectiondiv}{td}{tr}{builder-show:permission=edit}{tr:id=seesam}{td}*Also seeSample*\\{sub-section:parent_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:parent_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:parent_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:parent_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:parent_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:parent_sam|trigger=none}{code:language=javascript}code:language=javascript}
/** @type {QBSelect<db:/example_data/order_details>} */
	var subquery = databaseManager.createSelect('db:/example_data/order_details')
	
 /** @type {QBSelect<db:/example_data/person>orders>} */
	var query = databaseManager.createSelect('db:/example_data/personorders')
	query.where.add(query.joins.person_to_parent.joins.person_to_parent.columns.name.eq('john'))
	
		.or 
			.add(query.columns.order_id.not.isin([1, 2, 3]))
			
			.add(query.exists(
					subquery.where.add(subquery.columns.orderid.eq(query.columns.order_id)).root
			))
		)
		
	foundset.loadRecords(query)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbodytable}\\ 

{table:id=rootfunction|class=nodeservoy sDetail}{colgroup}{tr:id=namecolumn:width=100%|padding=0px}{tdcolumn}h6.root{tdcolgroup}{tr}{builder-show:permission=editstyle=height: 30px;}{trth:idcolspan=des1}{tdMethod Details{th}{tr}{sub-section:root_des|trigger=button|text=}{sub-section}{sub-section:root_des|trigger=none|class=sIndent}Replace with description{sub-section}tbody:id=abs-Object}{tr:id=name}{td}h6.abs{td}{tr}{builder-show}{builder-show:permission=edittr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}abs{span}{span}\(value){span}{td}{tr}{tr:id=sncprs}{td}*SinceParameters*\\{sub-section:root_snc|trigger=button|text=}{sub-section}{sub-section:root_snc|trigger=none|class=sIndent} Replace with version info{sub-sectiondiv:class=sIndent}\{[Object]} value
{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=prsret}{td}*ParametersReturns*\\{sub-section:root_prs|trigger=button|text=}{sub-section}{sub-section:root_prs|trigger=none|div:class=sIndent}{sub-section[QBFunction]{div}{td}{tr}{builder-show}{tr:id=retsam}{td}*ReturnsSample*\\{sub-section:root_ret|trigger=button|text=}{sub-section}{sub-section:root_ret|trigger=none|class=sIndent}[QBSelect]{sub-sectiondiv:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynum.abs.eq(query.functions.abs(myval))) 
foundset.loadRecords(query);
{code}{div}{td}{tr}{builder-showtr:permissionclass=editlastDetailRow}{tr:id=seetd}{td}*Also see*\\{sub-section:root_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:root_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit{tr}{tbody}{tbody:id=bit_length-Object}{tr:id=name}{td}h6.bit_length{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}bit_length{span}{span}\(value){span}{td}{tr}{tr:id=linkprs}{td}*External linksParameters*\\{sub-section:root_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:root_link|trigger=none}{sub-section}{\{[Object]} value
{div}{td}{tr}{builder-show}{tr:id=samret}{td}*SampleReturns*\\{sub-section:root_sam|trigger=button|text=}{sub-section}div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{sub-section:root_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/order_details>orders>} */
	var subqueryquery = databaseManager.createSelect('db:/example_data/order_detailsorders')
	
 /** @type {QBSelect<db:/example_data/orders>} */
	var query = databaseManager.createSelect('db:/example_data/orders')
	/$NON-NLS-1$
query.where.add(query
		.or 
			.add.columns.shipname.bit_length.eq(query.columnsfunctions.order_id.not.isin([1, 2, 3]))
			
			.add(query.exists(
					subquery.where.add(subquery.columns.orderid.eq(query.columns.order_id)).root
			))
		)
		
	bit_length('Sample'))) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}\\ 

{table:id=function|class=servoy sDetail}{colgroup}{column:width=100%|padding=0px}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Method Details{th}{tr}{tbody:id=abs-Object|class=node}{tr:id=name}{td}h6.abs{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[tbody:id=cast-Object_String}{tr:id=name}{td}h6.cast{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}abscast{span}{span:id=iets|style=float: left;}\(value, type){span}{td}{tr}{builder-show:permission=edit}{tr:id=desprs}{td}{sub-section:abs-Object_des|trigger=button|text=}{sub-section}{sub-section:abs-Object_des|trigger=none|class=sIndent}Replace with description{sub-section*Parameters*\\{div:class=sIndent}\{[Object]} value -- object to cast
\{[String]} type -- type see QUERY\_COLUMN\_TYPES
{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sncret}{td}*SinceReturns*\\{sub-section:abs-Object_snc|trigger=button|text=}{sub-section}{sub-section:abs-Object_snc|trigger=none|div:class=sIndent} Replace with version info{sub-section[QBFunction]{div}{td}{tr}{builder-show}{tr:id=prssam}{td}*ParametersSample*\\{sub-section:abs-Object_prs|trigger=button|text=}{sub-section}{sub-section:abs-Object_prs|trigger=none|class=sIndent}\{[Object]} value
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:abs-Object_ret|trigger=button|text=}{sub-section}{sub-section:abs-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:abs-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:abs-Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:abs-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:abs-Object_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:abs-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:abs-Object_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynum.abs.eq(query.functions.abs(myval))) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=bit_length-Object|class=node}{tr:id=name}{td}h6.bit_length{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}bit_length{span}{span:id=iets|style=float: left;}\(value){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:bit_length-Object_des|trigger=button|text=}{sub-section}{sub-section:bit_length-Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:bit_length-Object_snc|trigger=button|text=}{sub-section}{sub-section:bit_length-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:bit_length-Object_prs|trigger=button|text=}{sub-section}{sub-section:bit_length-Object_prs|trigger=none|class=sIndent}\{[Object]} value
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:bit_length-Object_ret|trigger=button|text=}{sub-section}{sub-section:bit_length-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:bit_length-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:bit_length-Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:bit_length-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:bit_length-Object_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:bit_length-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:bit_length-Object_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.bit_length.eq(query.functions.bit_length('Sample'))) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=cast-Object_String|class=node}{tr:id=name}{td}h6.cast{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}cast{span}{span:id=iets|style=float: left;}\(value, type){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:cast-Object_String_des|trigger=button|text=}{sub-section}{sub-section:cast-Object_String_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:cast-Object_String_snc|trigger=button|text=}{sub-section}{sub-section:cast-Object_String_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:cast-Object_String_prs|trigger=button|text=}{sub-section}{sub-section:cast-Object_String_prs|trigger=none|class=sIndent}\{[Object]} value -- object to cast
\{[String]} type -- type see QUERY\_COLUMN\_TYPES
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:cast-Object_String_ret|trigger=button|text=}{sub-section}{sub-section:cast-Object_String_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:cast-Object_String_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:cast-Object_String_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:cast-Object_String_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:cast-Object_String_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:cast-Object_String_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:cast-Object_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=ceil-Object|class=node}{tr:id=name}{td}h6.ceil{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}ceil{span}{span:id=iets|style=float: left;}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:ceil-Object_des|trigger=button|text=}{sub-section}{sub-section:ceil-Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:ceil-Object_snc|trigger=button|text=}{sub-section}{sub-section:ceil-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:ceil-Object_prs|trigger=button|text=}{sub-section}{sub-section:ceil-Object_prs|trigger=none|class=sIndent}\{[Object]} arg -- number object
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:ceil-Object_ret|trigger=button|text=}{sub-section}{sub-section:ceil-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:ceil-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:ceil-Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:ceil-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:ceil-Object_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:ceil-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:ceil-Object_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.ceil.eq(query.functions.ceil(myvar)) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=coalesce-ObjectArray|class=node}{tr:id=name}{td}h6.coalesce{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}coalesce{span}{span:id=iets|style=float: left;}\(args){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:coalesce-ObjectArray_des|trigger=button|text=}{sub-section}{sub-section:coalesce-ObjectArray_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:coalesce-ObjectArray_snc|trigger=button|text=}{sub-section}{sub-section:coalesce-ObjectArray_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:coalesce-ObjectArray_prs|trigger=button|text=}{sub-section}{sub-section:coalesce-ObjectArray_prs|trigger=none|class=sIndent}\{[Object]...} args -- arguments to coalesce
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:coalesce-ObjectArray_ret|trigger=button|text=}{sub-section}{sub-section:coalesce-ObjectArray_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:coalesce-ObjectArray_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:coalesce-ObjectArray_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:coalesce-ObjectArray_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:coalesce-ObjectArray_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:coalesce-ObjectArray_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:coalesce-ObjectArray_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mycol.coalesce('defval').eq(query.functions.coalesce(myvar, 'defval')) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=concat-Object_Object|class=node}{tr:id=name}{td}h6.concat{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}concat{span}{span:id=iets|style=float: left;}\(arg1, arg2){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:concat-Object_Object_des|trigger=button|text=}{sub-section}{sub-section:concat-Object_Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:concat-Object_Object_snc|trigger=button|text=}{sub-section}{sub-section:concat-Object_Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:concat-Object_Object_prs|trigger=button|text=}{sub-section}{sub-section:concat-Object_Object_prs|trigger=none|class=sIndent}\{[Object]} arg1
\{[Object]} arg2
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:concat-Object_Object_ret|trigger=button|text=}{sub-section}{sub-section:concat-Object_Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:concat-Object_Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:concat-Object_Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:concat-Object_Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:concat-Object_Object_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:concat-Object_Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:concat-Object_Object_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/udm/contacts>} */
	var query = databaseManager.createSelect('db:/udm/contacts') //$NON-NLS-1$
	query.result.add(query.columns.name_first.concat(' ').concat(query.columns.name_last))
	var ds = databaseManager.getDataSetByQuery(query, -1)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=day-Object|class=node}{tr:id=name}{td}h6.day{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}day{span}{span:id=iets|style=float: left;}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:day-Object_des|trigger=button|text=}{sub-section}{sub-section:day-Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:day-Object_snc|trigger=button|text=}{sub-section}{sub-section:day-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:day-Object_prs|trigger=button|text=}{sub-section}{sub-section:day-Object_prs|trigger=none|class=sIndent}\{[Object]} arg -- date object
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:day-Object_ret|trigger=button|text=}{sub-section}{sub-section:day-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:day-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:day-Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:day-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:day-Object_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:day-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:day-Object_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mydatecol.day.eq(query.functions.day(mydatevar)) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=divide-Object_Object|class=node}{tr:id=name}{td}h6.divide{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}divide{span}{span:id=iets|style=float: left;}\(arg1, arg2){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:divide-Object_Object_des|trigger=button|text=}{sub-section}{sub-section:divide-Object_Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:divide-Object_Object_snc|trigger=button|text=}{sub-section}{sub-section:divide-Object_Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:divide-Object_Object_prs|trigger=button|text=}{sub-section}{sub-section:divide-Object_Object_prs|trigger=none|class=sIndent}\{[Object]} arg1
\{[Object]} arg2
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:divide-Object_Object_ret|trigger=button|text=}{sub-section}{sub-section:divide-Object_Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:divide-Object_Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:divide-Object_Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:divide-Object_Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:divide-Object_Object_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:divide-Object_Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:divide-Object_Object_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.divide(2).eq(query.functions.divide(myvar, 2)) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=floor-Object|class=node}{tr:id=name}{td}h6.floor{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}floor{span}{span:id=iets|style=float: left;}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:floor-Object_des|trigger=button|text=}{sub-section}{sub-section:floor-Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:floor-Object_snc|trigger=button|text=}{sub-section}{sub-section:floor-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:floor-Object_prs|trigger=button|text=}{sub-section}{sub-section:floor-Object_prs|trigger=none|class=sIndent}\{[Object]} arg -- number object
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:floor-Object_ret|trigger=button|text=}{sub-section}{sub-section:floor-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:floor-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:floor-Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:floor-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:floor-Object_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:floor-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:floor-Object_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.floor.eq(query.functions.floor(myvar)) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=hour-Object|class=node}{tr:id=name}{td}h6.hour{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}hour{span}{span:id=iets|style=float: left;}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:hour-Object_des|trigger=button|text=}{sub-section}{sub-section:hour-Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:hour-Object_snc|trigger=button|text=}{sub-section}{sub-section:hour-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:hour-Object_prs|trigger=button|text=}{sub-section}{sub-section:hour-Object_prs|trigger=none|class=sIndent}\{[Object]} arg -- date object
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:hour-Object_ret|trigger=button|text=}{sub-section}{sub-section:hour-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:hour-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:hour-Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:hour-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:hour-Object_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:hour-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:hour-Object_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mydatecol.hour.eq(query.functions.hour(mydatevar)) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=len-Object|class=node}{tr:id=name}{td}h6.len{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}len{span}{span:id=iets|style=float: left;}\(value){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:len-Object_des|trigger=button|text=}{sub-section}{sub-section:len-Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:len-Object_snc|trigger=button|text=}{sub-section}{sub-section:len-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:len-Object_prs|trigger=button|text=}{sub-section}{sub-section:len-Object_prs|trigger=none|class=sIndent}\{[Object]} value
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:len-Object_ret|trigger=button|text=}{sub-section}{sub-section:len-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:len-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:len-Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:len-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:len-Object_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:len-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:len-Object_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.len.eq(query.functions.len('Sample'))) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=locate-Object_Object|class=node}{tr:id=name}{td}h6.locate{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}locate{span}{span:id=iets|style=float: left;}\(string1, string2){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:locate-Object_Object_des|trigger=button|text=}{sub-section}{sub-section:locate-Object_Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:locate-Object_Object_snc|trigger=button|text=}{sub-section}{sub-section:locate-Object_Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:locate-Object_Object_prs|trigger=button|text=}{sub-section}{sub-section:locate-Object_Object_prs|trigger=none|class=sIndent}\{[Object]} string1 -- string to locate
\{[Object]} string2 -- string to search in
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:locate-Object_Object_ret|trigger=button|text=}{sub-section}{sub-section:locate-Object_Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:locate-Object_Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:locate-Object_Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:locate-Object_Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:locate-Object_Object_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:locate-Object_Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:locate-Object_Object_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.locate('amp').eq(query.functions.locate('Sample', 'amp'))) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=locate-Object_Object_Number|class=node}{tr:id=name}{td}h6.locate{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}locate{span}{span:id=iets|style=float: left;}\(string1, string2, start){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:locate-Object_Object_Number_des|trigger=button|text=}{sub-section}{sub-section:locate-Object_Object_Number_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:locate-Object_Object_Number_snc|trigger=button|text=}{sub-section}{sub-section:locate-Object_Object_Number_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:locate-Object_Object_Number_prs|trigger=button|text=}{sub-section}{sub-section:locate-Object_Object_Number_prs|trigger=none|class=sIndent}\{[Object]} string1 -- string to locate
\{[Object]} string2 -- string to search in
\{[Number]} start -- start pos
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:locate-Object_Object_Number_ret|trigger=button|text=}{sub-section}{sub-section:locate-Object_Object_Number_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:locate-Object_Object_Number_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:locate-Object_Object_Number_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:locate-Object_Object_Number_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:locate-Object_Object_Number_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:locate-Object_Object_Number_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:locate-Object_Object_Number_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.locate('amp', 1).eq(query.functions.locate('Sample', 'amp', 1))) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=lower-Object|class=node}{tr:id=name}{td}h6.lower{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}lower{span}{span:id=iets|style=float: left;}\(value){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:lower-Object_des|trigger=button|text=}{sub-section}{sub-section:lower-Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:lower-Object_snc|trigger=button|text=}{sub-section}{sub-section:lower-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:lower-Object_prs|trigger=button|text=}{sub-section}{sub-section:lower-Object_prs|trigger=none|class=sIndent}\{[Object]} value
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:lower-Object_ret|trigger=button|text=}{sub-section}{sub-section:lower-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:lower-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:lower-Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:lower-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:lower-Object_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:lower-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:lower-Object_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.lower.eq(query.functions.lower('Sample'))) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=minus-Object_Object|class=node}{tr:id=name}{td}h6.minus{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}minus{span}{span:id=iets|style=float: left;}\(arg1, arg2){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:minus-Object_Object_des|trigger=button|text=}{sub-section}{sub-section:minus-Object_Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:minus-Object_Object_snc|trigger=button|text=}{sub-section}{sub-section:minus-Object_Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:minus-Object_Object_prs|trigger=button|text=}{sub-section}{sub-section:minus-Object_Object_prs|trigger=none|class=sIndent}\{[Object]} arg1
\{[Object]} arg2
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:minus-Object_Object_ret|trigger=button|text=}{sub-section}{sub-section:minus-Object_Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:minus-Object_Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:minus-Object_Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:minus-Object_Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:minus-Object_Object_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:minus-Object_Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:minus-Object_Object_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.minus(2).eq(query.functions.minus(myvar, 2)) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=minute-Object|class=node}{tr:id=name}{td}h6.minute{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}minute{span}{span:id=iets|style=float: left;}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:minute-Object_des|trigger=button|text=}{sub-section}{sub-section:minute-Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:minute-Object_snc|trigger=button|text=}{sub-section}{sub-section:minute-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:minute-Object_prs|trigger=button|text=}{sub-section}{sub-section:minute-Object_prs|trigger=none|class=sIndent}\{[Object]} arg -- date object
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:minute-Object_ret|trigger=button|text=}{sub-section}{sub-section:minute-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:minute-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:minute-Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:minute-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:minute-Object_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:minute-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:minute-Object_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mydatecol.minute.eq(query.functions.minute(mydatevar)) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=mod-Object_Object|class=node}{tr:id=name}{td}h6.mod{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}mod{span}{span:id=iets|style=float: left;}\(dividend, divisor){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:mod-Object_Object_des|trigger=button|text=}{sub-section}{sub-section:mod-Object_Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:mod-Object_Object_snc|trigger=button|text=}{sub-section}{sub-section:mod-Object_Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:mod-Object_Object_prs|trigger=button|text=}{sub-section}{sub-section:mod-Object_Object_prs|trigger=none|class=sIndent}\{[Object]} dividend
\{[Object]} divisor
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:mod-Object_Object_ret|trigger=button|text=}{sub-section}{sub-section:mod-Object_Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:mod-Object_Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:mod-Object_Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:mod-Object_Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:mod-Object_Object_link|trigger=none}{sub-section}{div}{td}{tr}{builder-showdiv:class=sIndent}{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}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=ceil-Object}{tr:id=name}{td}h6.ceil{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}ceil{span}{span}\(arg){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- number object
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{sub-section:mod-Object_Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:mod-Object_Object_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.mod(2)ceil.eq(query.functions.modceil(myvar, 2)) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=month-Object|class=nodecoalesce-ObjectArray}{tr:id=name}{td}h6.monthcoalesce{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}monthcoalesce{span}{span:id=iets|style=float: left;}\(argargs){span}{td}{tr}{builder-show:permission=edit}{tr:id=desprs}{td}{sub-section:month-Object_des|trigger=button|text=}{sub-section}{sub-section:month-Object_des|trigger=none|class=sIndent}Replace with description{sub-section*Parameters*\\{div:class=sIndent}\{[Object]...} args -- arguments to coalesce
{div}{td}{tr}{builder-show}{builder-show:permission=edittr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sncsam}{td}*SinceSample*\\{sub-section:month-Object_snc|trigger=button|text=}{sub-section}{sub-section:month-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-sectiondiv:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mycol.coalesce('defval').eq(query.functions.coalesce(myvar, 'defval')) 
foundset.loadRecords(query);
{code}{div}{td}{tr}{builder-show}{tr:id=prsclass=lastDetailRow}{td}{td}*Parameters*\\{sub-section:month-Object_prs|trigger=button|text=}{sub-section}{sub-section:month-Object_prs|trigger=none|class=sIndent}\{[Object]} arg -- date object
{sub-section}{tr}{tbody}{tbody:id=concat-Object_Object}{tr:id=name}{td}h6.concat{td}{tr}{tr:id=retsig}{td}*Returns*\\{sub-section:month-Object_ret|trigger=button|text=}{sub-section}{sub-section:month-Object_ret|trigger=none|class=sIndent{span:style=margin-right: 5px;}[QBFunction]{sub-sectionspan}{span:style=font-weight: bold;}concat{span}{span}\(arg1, arg2){span}{td}{tr}{builder-show:permission=edit}{tr:id=seeprs}{td}*Also seeParameters*\\{sub-section:month-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:month-Object_see|trigger=none}{sub-section}\{[Object]} arg1
\{[Object]} arg2
{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:month-Object_link|trigger=button|text=}{sub-section}:id=ret}{td}*Returns*\\{div:class=sIndent}{sub-section:month-Object_link|trigger=none}{sub-section}[QBFunction]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:month-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:month-Object_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_dataudm/orders>contacts>} */
	var query = databaseManager.createSelect('db:/example_dataudm/orderscontacts') //$NON-NLS-1$
	query.whereresult.add(query.columns.mydatecol.month.eqname_first.concat(' ').concat(query.functions.month(mydatevarcolumns.name_last))

foundset.loadRecords(query);	var ds = databaseManager.getDataSetByQuery(query, -1)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=multiplyday-Object_Object|class=node}{tr:id=name}{td}h6.multiplyday{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}multiply{span}{span:id=iets|style=float: left;}\(arg1, arg2){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:multiply-Object_Object_des|trigger=button|text=}{sub-section}{sub-section:multiply-Object_Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=editday{span}{span}\(arg){span}{td}{tr}{tr:id=sncprs}{td}*SinceParameters*\\{sub-section:multiply-Object_Object_snc|trigger=button|text=}{sub-section}{sub-section:multiply-Object_Object_snc|trigger=none|class=sIndent} Replace with version info{sub-sectiondiv:class=sIndent}\{[Object]} arg -- date object
{div}{td}{tr}{builder-show}{tr:id=prsret}{td}*ParametersReturns*\\{sub-section:multiply-Object_Object_prs|trigger=button|text=}{sub-section}{sub-section:multiply-Object_Object_prs|trigger=none|div:class=sIndent}\{[Object]} arg1
\{[ObjectQBFunction]} arg2
{sub-section{div}{td}{tr}{tr:id=retsam}{td}*ReturnsSample*\\{sub-section:multiply-Object_Object_ret|trigger=button|text=}{sub-section}{sub-section:multiply-Object_Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-sectiondiv:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mydatecol.day.eq(query.functions.day(mydatevar)) 
foundset.loadRecords(query);
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{builder-show:permission=edittbody}{tbody:id=divide-Object_Object}{tr:id=see}name}{td}h6.divide{td}*Also see*\\{sub-section:multiply-Object_Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:multiply-Object_Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}divide{span}{span}\(arg1, arg2){span}{td}{tr}{tr:id=linkprs}{td}*External linksParameters*\\{sub-section:multiply-Object_Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:multiply-Object_Object_link|trigger=none}{sub-section}\{[Object]} arg1
\{[Object]} arg2
{div}{td}{tr}{builder-show}{tr:id=samret}{td}*SampleReturns*\\{sub-section:multiply-Object_Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:multiply-Object_Object_sam|trigger=nonediv:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.multiplydivide(2).eq(query.functions.multiplydivide(myvar, 2)) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=nulliffloor-Object|class=node}{tr:id=name}{td}h6.nulliffloor{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}nulliffloor{span}{span:id=iets|style=float: left;}\(arg1arg){span}{td}{tr}{builder-showtr:permissionid=editprs}{tr:id=destd}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- number object
{div}{td}{sub-section:nullif-Object_des|trigger=button|text=}{sub-section}{sub-section:nullif-Object_des|trigger=none|class=sIndent}Replace with description{sub-sectiontr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sncsam}{td}*SinceSample*\\{sub-section:nullif-Object_snc|trigger=button|text=}{sub-section}{sub-section:nullif-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-sectiondiv:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.floor.eq(query.functions.floor(myvar)) 
foundset.loadRecords(query);
{code}{div}{td}{tr}{builder-show}{tr:id=prsclass=lastDetailRow}{td}{td}*Parameters*\\{sub-section:nullif-Object_prs|trigger=button|text=}{sub-section}{sub-section:nullif-Object_prs|trigger=none|class=sIndent}\{[Object]} arg1
{sub-section}{tr}{tbody}{tbody:id=hour-Object}{tr:id=name}{td}h6.hour{td}{tr}{tr:id=retsig}{td}*Returns*\\{sub-section:nullif-Object_ret|trigger=button|text=}{sub-section}{sub-section:nullif-Object_ret|trigger=none|class=sIndent{span:style=margin-right: 5px;}[QBFunction]{sub-sectionspan}{span:style=font-weight: bold;}hour{span}{span}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=seeprs}{td}*Also seeParameters*\\{sub-section:nullif-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:nullif-Object_see|trigger=none}{sub-section}\{[Object]} arg -- date object
{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linkret}{td}*External links*\\{sub-section:nullif-Object_link|trigger=button|text=}{sub-section}Returns*\\{div:class=sIndent}{sub-section:nullif-Object_link|trigger=none}{sub-section}{[QBFunction]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:nullif-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:nullif-Object_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.nullif('none')mydatecol.hour.eq(query.functions.nullif('Sample', 'none'hour(mydatevar))) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=pluslen-Object_Object|class=node}{tr:id=name}{td}h6.pluslen{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}pluslen{span}{span:id=iets|style=float: left;}\(arg1, arg2value){span}{td}{tr}{builder-show:permission=edit}{tr:id=desprs}{td}{sub-section:plus-Object_Object_des|trigger=button|text=}{sub-section}{sub-section:plus-Object_Object_des|trigger=none|class=sIndent}Replace with description{sub-section*Parameters*\\{div:class=sIndent}\{[Object]} value
{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sncret}{td}*SinceReturns*\\{sub-section:plus-Object_Object_snc|trigger=button|text=}{sub-section}{sub-section:plus-Object_Object_snc|trigger=none|div:class=sIndent} Replace with version info{sub-section[QBFunction]{div}{td}{tr}{builder-show}{tr:id=prssam}{td}*ParametersSample*\\{sub-section:plus-Object_Object_prs|trigger=button|text=}{sub-section}{sub-section:plus-Object_Object_prs|trigger=none|class=sIndent}\{[Object]} arg1
\{[Object]} arg2
{sub-section}{div:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.len.eq(query.functions.len('Sample'))) 
foundset.loadRecords(query);
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=locate-Object_Object}{tr:id=name}{td}h6.locate{td}{tr}{tr:id=retsig}{td}*Returns*\\{sub-section:plus-Object_Object_ret|trigger=button|text=}{sub-section}{sub-section:plus-Object_Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}locate{span}{span}\(string1, string2){span}{td}{tr}{builder-show:permission=edit}{tr:id=seeprs}{td}*Also seeParameters*\\{sub-section:plus-Object_Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:plus-Object_Object_see|trigger=none}{sub-section}\{[Object]} string1 -- string to locate
\{[Object]} string2 -- string to search in
{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:plus-Object_Object_link|trigger=button|text=}{sub-section}}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}{sub-section:plus-Object_Object_link|trigger=none}{sub-section}{[QBFunction]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:plus-Object_Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:plus-Object_Object_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcolshipname.pluslocate(2'amp').eq(query.functions.pluslocate(myvar'Sample', 2'amp'))) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=roundlocate-Object|class=nodeObject_Object_Number}{tr:id=name}{td}h6.roundlocate{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; style=font-weight: bold;}roundlocate{span}{span:id=iets|style=float: left;}\(argstring1, string2, start){span}{td}{tr}{builder-show:permission=edit}{tr:id=desprs}{td}{sub-section:round-Object_des|trigger=button|text=}{sub-section}{sub-section:round-Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit*Parameters*\\{div:class=sIndent}\{[Object]} string1 -- string to locate
\{[Object]} string2 -- string to search in
\{[Number]} start -- start pos
{div}{td}{tr}{tr:id=sncret}{td}*SinceReturns*\\{sub-section:round-Object_snc|trigger=button|text=}{sub-section}{sub-section:round-Object_snc|trigger=none|div:class=sIndent} Replace with version info{sub-section[QBFunction]{div}{td}{tr}{builder-show}{tr:id=prssam}{td}*ParametersSample*\\{sub-section:round-Object_prs|trigger=button|text=}{sub-section}{sub-section:round-Object_prs|trigger=none|class=sIndent}\{[Object]} arg -- number object
{sub-sectiondiv:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.locate('amp', 1).eq(query.functions.locate('Sample', 'amp', 1))) 
foundset.loadRecords(query);
{code}{div}{td}{tr}{tr:id=retclass=lastDetailRow}{td}{td}*Returns*\\{sub-section:round-Object_ret|trigger=button|text=}{sub-section}{sub-section:round-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit{tr}{tbody}{tbody:id=lower-Object}{tr:id=name}{td}h6.lower{td}{tr}{tr:id=seesig}{td}*Also see*\\{sub-section:round-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:round-Object_see|trigger=none}{sub-section}{div{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}lower{span}{span}\(value){span}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linkprs}{td}*External linksParameters*\\{sub-section:round-Object_link|trigger=button|text=}{sub-section}div:class=sIndent}\{[Object]} value
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}{sub-section:round-Object_link|trigger=none}{sub-section}{[QBFunction]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:round-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:round-Object_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcolshipname.roundlower.eq(query.functions.round(myvarlower('Sample'))) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=secondminus-Object_Object|class=node}{tr:id=name}{td}h6.secondminus{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}secondminus{span}{span:id=iets|style=float: left;{span}\(argarg1, arg2){span}{td}{tr}{builder-show:permission=edit}{tr:id=desprs}{td}{sub-section:second-Object_des|trigger=button|text=}{sub-section}{sub-section:second-Object_des|trigger=none|class=sIndent}Replace with description{sub-section*Parameters*\\{div:class=sIndent}\{[Object]} arg1
\{[Object]} arg2
{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sncret}{td}*SinceReturns*\\{sub-section:second-Object_snc|trigger=button|text=}{sub-section}{sub-section:second-Object_snc|trigger=none|div:class=sIndent} Replace with version info{sub-section[QBFunction]{div}{td}{tr}{builder-show}{tr:id=prssam}{td}*ParametersSample*\\{sub-section:second-Object_prs|trigger=button|text=}{sub-section}{sub-section:second-Object_prs|trigger=none|class=sIndent}\{[Object]} arg -- date object
{sub-section}{div:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.minus(2).eq(query.functions.minus(myvar, 2)) 
foundset.loadRecords(query);
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=minute-Object}{tr:id=name}{td}h6.minute{td}{tr}{tr:id=retsig}{td}*Returns*\\{sub-section:second-Object_ret|trigger=button|text=}{sub-section}{sub-section:second-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}minute{span}{span}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=seeprs}{td}*Also seeParameters*\\{sub-section:second-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:second-Object_see|trigger=none}{sub-section}\{[Object]} arg -- date object
{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linkret}{td}*External linksReturns*\\{sub-section:second-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:second-Object_link|trigger=none}{sub-section}[QBFunction]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:second-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:second-Object_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mydatecol.secondminute.eq(query.functions.secondminute(mydatevar)) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=sqrtmod-Object|class=node_Object}{tr:id=name}{td}h6.sqrtmod{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}sqrtmod{span}{span:id=iets|style=float: left;}\(valuedividend, divisor){span}{td}{tr}{builder-showtr:permission=edit}{tr:id=desid=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} dividend
\{[Object]} divisor
{div}{td}{sub-section:sqrt-Object_des|trigger=button|text=}{sub-section}{sub-section:sqrt-Object_des|trigger=none|class=sIndent}Replace with description{sub-sectiontr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sncsam}{td}*SinceSample*\\{sub-section:sqrt-Object_snc|trigger=button|text=}{sub-section}{sub-section:sqrt-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-sectiondiv:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.mod(2).eq(query.functions.mod(myvar, 2)) 
foundset.loadRecords(query);
{code}{div}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:sqrt-Object_prs|trigger=button|text=}{sub-section}{sub-section:sqrt-Object_prs|trigger=none|class=sIndent}\{[Object]} value
{sub-sectionclass=lastDetailRow}{td}{trtd}{tr:id=ret}{tdtbody}*Returns*\\{sub-section:sqrt-Object_ret|trigger=button|text=}{sub-section}{sub-section:sqrt-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section}{tbody:id=month-Object}{tr:id=name}{td}h6.month{td}{tr}{builder-show:permission=edit}{tr:id=seesig}{td}*Also see*\\{sub-section:sqrt-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:sqrt-Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}month{span}{span}\(arg){span}{td}{tr}{tr:id=linkprs}{td}*External linksParameters*\\{sub-section:sqrt-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:sqrt-Object_link|trigger=none}{sub-section}\{[Object]} arg -- date object
{div}{td}{tr}{builder-show}{tr:id=samret}{td}*SampleReturns*\\{sub-section:sqrt-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:sqrt-Object_sam|trigger=nonediv:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynummydatecol.sqrtmonth.eq(query.functions.sqrtmonth(myvalmydatevar))) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=substringmultiply-Object_Number|class=nodeObject}{tr:id=name}{td}h6.substringmultiply{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}substringmultiply{span}{span:id=iets|style=float: left;}\(argarg1, posarg2){span}{td}{tr}{builder-show:permission=edit}{tr:id=desprs}{td}{sub-section:substring-Object_Number_des|trigger=button|text=}{sub-section}{sub-section:substring-Object_Number_des|trigger=none|class=sIndent}Replace with description{sub-section*Parameters*\\{div:class=sIndent}\{[Object]} arg1
\{[Object]} arg2
{div}{td}{tr}{builder-show}{builder-show:permission=edittr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sncsam}{td}*SinceSample*\\{sub-section:substring-Object_Number_snc|trigger=button|text=}{sub-section}{sub-section:substring-Object_Number_snc|trigger=none|class=sIndent} Replace with version info{sub-sectiondiv:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.multiply(2).eq(query.functions.multiply(myvar, 2)) 
foundset.loadRecords(query);
{code}{div}{td}{tr}{builder-show}{tr:id=prsclass=lastDetailRow}{td}{td}*Parameters*\\{sub-section:substring-Object_Number_prs|trigger=button|text=}{sub-section}{sub-section:substring-Object_Number_prs|trigger=none|class=sIndent}\{[Object]} arg -- column name
\{[Number]} pos -- position
{sub-section}{tr}{tbody}{tbody:id=nullif-Object}{tr:id=name}{td}h6.nullif{td}{tr}{tr:id=retsig}{td}*Returns*\\{sub-section:substring-Object_Number_ret|trigger=button|text=}{sub-section}{sub-section:substring-Object_Number_ret|trigger=none|class=sIndent}[QBFunction]{sub-section{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}nullif{span}{span}\(arg1){span}{td}{tr}{builder-show:permission=edit}{tr:id=seeprs}{td}*Also seeParameters*\\{sub-section:substring-Object_Number_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:substring-Object_Number_see|trigger=none}{sub-section}}\{[Object]} arg1
{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linkret}{td}*External linksReturns*\\{sub-section:substring-Object_Number_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:substring-Object_Number_link|trigger=none}{sub-section}[QBFunction]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:substring-Object_Number_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:substring-Object_Number_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.substringnullif(3'none').eq(query.functions.substringnullif('Sample', 3', 'none'))) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=substringplus-Object_Number_Number|class=nodeObject}{tr:id=name}{td}h6.substringplus{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}substring{span}{span:id=iets|style=float: left;}\(arg, pos, len){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:substring-Object_Number_Number_des|trigger=button|text=}{sub-section}{sub-section:substring-Object_Number_Number_des|trigger=none|class=sIndent}Replace with description{sub-sectionplus{span}{span}\(arg1, arg2){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg1
\{[Object]} arg2
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.plus(2).eq(query.functions.plus(myvar, 2)) 
foundset.loadRecords(query);
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{builder-showtbody}{builder-showtbody:permissionid=editround-Object}{tr:id=snc}name}{td}h6.round{td}*Since*\\{sub-section:substring-Object_Number_Number_snc|trigger=button|text=}{sub-section}{sub-section:substring-Object_Number_Number_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}round{span}{span}\(arg){span}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:substring-Object_Number_Number_prs|trigger=button|text=}{sub-section}{sub-section:substring-Object_Number_Number_prs|trigger=none|div:class=sIndent}\{[Object]} arg -- columnnumber name
\{[Number]} pos -- position
\{[Number]} len -- length
{sub-sectionobject
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=retsam}{td}*ReturnsSample*\\{sub-section:substring-Object_Number_Number_ret|trigger=button|text=}{sub-section}{sub-section:substring-Object_Number_Number_ret|trigger=none|class=sIndent}[QBFunction]{sub-sectiondiv:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynumcol.round.eq(query.functions.round(myvar)) 
foundset.loadRecords(query);
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{builder-show:permission=edittbody}{tbody:id=second-Object}{tr:id=see}name}{td}h6.second{td}*Also see*\\{sub-section:substring-Object_Number_Number_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:substring-Object_Number_Number_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}second{span}{span}\(arg){span}{td}{tr}{tr:id=linkprs}{td}*External linksParameters*\\{sub-section:substring-Object_Number_Number_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:substring-Object_Number_Number_link|trigger=none}{sub-section}\{[Object]} arg -- date object
{div}{td}{tr}{builder-show}{tr:id=samret}{td}*SampleReturns*\\{sub-section:substring-Object_Number_Number_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:substring-Object_Number_Number_sam|trigger=nonediv:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.substring(3, 2)mydatecol.second.eq(query.functions.substring('Sample', 3, 2second(mydatevar))) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=trimsqrt-Object|class=node}{tr:id=name}{td}h6.trimsqrt{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}trim{span}{span:id=iets|style=float: left;}\(value){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:trim-Object_des|trigger=button|text=}{sub-section}{sub-section:trim-Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit=font-weight: bold;}sqrt{span}{span}\(value){span}{td}{tr}{tr:id=sncprs}{td}*SinceParameters*\\{sub-section:trim-Object_snc|trigger=button|text=}{sub-section}{sub-section:trim-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-sectiondiv:class=sIndent}\{[Object]} value
{div}{td}{tr}{builder-show}{tr:id=prsret}{td}*ParametersReturns*\\{sub-section:trim-Object_prs|trigger=button|text=}{sub-section}{sub-section:trim-Object_prs|trigger=none|div:class=sIndent}\{[ObjectQBFunction]} value
{sub-section{div}{td}{tr}{tr:id=retsam}{td}*ReturnsSample*\\{sub-section:trim-Object_ret|trigger=button|text=}{sub-section}{sub-section:trim-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section{div:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mynum.sqrt.eq(query.functions.sqrt(myval))) 
foundset.loadRecords(query);
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{builder-showtbody:permission=editid=substring-Object_Number}{tr:id=seename}{td}*Also see*\\{sub-section:trim-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:trim-Object_see|trigger=none}{sub-section}{divh6.substring{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}substring{span}{span}\(arg, pos){span}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linkprs}{td}*External linksParameters*\\{sub-section:trim-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:trim-Object_link|trigger=none}{sub-section}\{[Object]} arg -- column name
\{[Number]} pos -- position
{div}{td}{tr}{builder-show}{tr:id=samret}{td}*SampleReturns*\\{sub-section:trim-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:trim-Object_sam|trigger=nonediv:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.trimsubstring(3).eq(query.functions.trimsubstring('Sample', 3))) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=uppersubstring-Object|class=node_Number_Number}{tr:id=name}{td}h6.uppersubstring{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}uppersubstring{span}{span}\(arg, pos, len){span}{td}{tr}{tr:id=iets|style=float: left;}\(value){spanprs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- column name
\{[Number]} pos -- position
\{[Number]} len -- length
{div}{td}{tr}{builder-show:permission=edit}{tr:id=desret}{td}{sub-section:upper-Object_des|trigger=button|text=}{sub-section}{sub-section:upper-Object_des|trigger=none|*Returns*\\{div:class=sIndent}Replace with description{sub-section[QBFunction]{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sncsam}{td}*SinceSample*\\{sub-section:upper-Object_snc|trigger=button|text=}{sub-section}{sub-section:upper-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section{div:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.substring(3, 2).eq(query.functions.substring('Sample', 3, 2))) 
foundset.loadRecords(query);
{code}{div}{td}{tr}{builder-show}{tr:idclass=prslastDetailRow}{td}*Parameters*\\{sub-section:upper-Object_prs|trigger=button|text=}{sub-section}{sub-section:upper-Object_prs|trigger=none|class=sIndent}\{[Object]} value
{sub-section}{td}{tr}{tbody}{tbody:id=trim-Object}{tr:id=name}{td}h6.trim{td}{tr}{tr:id=retsig}{td}*Returns*\\{sub-section:upper-Object_ret|trigger=button|text=}{sub-section}{sub-section:upper-Object_ret|trigger=none|class=sIndent{span:style=margin-right: 5px;}[QBFunction]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:upper-Object_see|trigger=button|text=}{sub-section}span}{span:style=font-weight: bold;}trim{span}{span}\(value){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}{sub-section:upper-Object_see|trigger=none}{sub-section}\{[Object]} value
{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linkret}{td}*External linksReturns*\\{sub-section:upper-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:upper-Object_link|trigger=none}{sub-section}{[QBFunction]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:upper-Object_sam|trigger=button|text=}{sub-section}\{div:class=sIndent}{sub-section:upper-Object_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.uppertrim.eq(query.functions.uppertrim('Sample'))) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=yearupper-Object|class=node}{tr:id=name}{td}h6.yearupper{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBFunction]{span}{span:id=iets|style=float: left; font-weight: bold;}yearupper{span}{span}\(value){span}{td}{tr}{tr:id=iets|style=float: left;}\(arg){span}{td}{tr}{builder-show:permission=editprs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=dessam}{td}{sub-section:year-Object_des|trigger=button|text=}{sub-section}{sub-section:year-Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:year-Object_snc|trigger=button|text=}{sub-section}{sub-section:year-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section*Sample*\\{div:class=sIndent}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.shipname.upper.eq(query.functions.upper('Sample'))) 
foundset.loadRecords(query);
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{builder-showtbody}{trtbody:id=prs}{td}*Parameters*\\{sub-section:year-Object_prs|trigger=button|text=}{sub-section}{sub-section:year-Object_prs|trigger=none|class=sIndent}\{[Object]} arg -- date object
{sub-section}}{tr:id=name}{td}h6.year{td}{tr}{tr:id=retsig}{td}*Returns*\\{sub-section:year-Object_ret|trigger=button|text=}{sub-section}{sub-section:year-Object_ret|trigger=none|class=sIndent}[QBFunction]{sub-section{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}year{span}{span}\(arg){span}{td}{tr}{builder-show:permission=edit}{tr:id=seeprs}{td}*Also seeParameters*\\{sub-section:year-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:year-Object_see|trigger=none}{sub-section}{div:class=sIndent}\{[Object]} arg -- date object
{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linkret}{td}*External linksReturns*\\{sub-section:year-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:year-Object_link|trigger=none}{sub-section}{[QBFunction]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:year-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:year-Object_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.where.add(query.columns.mydatecol.year.eq(query.functions.year(mydatevar)) 
foundset.loadRecords(query);
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}