Page History

Wiki Markup
{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 CHANGESUPDATE FROM 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}[Boolean]{td}{td}[#distinct]
Get/set the distinct flag for the query.{td}{tr}{tbody}{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}[QBResult]{td}{td}[#add]\(aggregate)
Add an aggregate to the query result.{td}{tr}{tbody}{tbody}{tr}{td}[QBResult]{td}{td}[#add]\(aggregate, alias)
Add an aggregate with alias to the query result.{td}{tr}{tbody}{tbody}{tr}{td}[QBResult]{td}{td}[#add]\(column)
Add a column to the query result.{td}{tr}{tbody}{tbody}{tr}{td}[QBResult]{td}{td}[#add]\(column, alias)
Add a column with alias to the query result.{td}{tr}{tbody}{tbody}{tr}{td}[QBResult]{td}{td}[#add]\(func)
Add a function result to the query result.{td}{tr}{tbody}{tbody}{tr}{td}[QBResult]{td}{td}[#add]\(func, alias)
Add a function with alias result to the query result.{td}{tr}{tbody}{tbody}{tr}{td}[QBResult]{td}{td}[#addPk]\()
Add the tables' primary pk columns in alphabetical order to the query result.{td}{tr}{tbody}{tbody}{tr}{td}[QBResult]{td}{td}[#addValue]\(value)
Add a value to the query result.{td}{tr}{tbody}{tbody}{tr}{td}[QBResult]{td}{td}[#addValue]\(value, alias)
Add a value with an alias to the query result.{td}{tr}{tbody}{tbody}{tr}{td}[QBResult]{td}{td}[#clear]\()
Clear the columns in the query result.{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=distinct|class=node}{tr:id=name}{td}h6.distinct{td}{tr}{builder-show:permission=edit}{tr:id=desret}{td}{sub-section:distinct_des|trigger=button|text=}{sub-section}{sub-section:distinct_des|trigger=none|*Returns*\\{div:class=sIndent}Replace with description{sub-section[Boolean]{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sncsam}{td}*SinceSample*\\{sub-section:distinct_snc|trigger=button|text=}{sub-section}{sub-section:distinct_snc|trigger=none|class=sIndent} Replace with version info{sub-sectiondiv:class=sIndent}{code:language=javascript}
query.result.distinct = true
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{builder-show}{builder-show:permission=edittbody}{tbody:id=parent}{tr:id=name}{td}h6.parent{td}{tr}{tr:id=prsret}{td}*ParametersReturns*\\{sub-section:distinct_prs|trigger=button|text=}{sub-section}{sub-section:distinct_prs|trigger=none|class=sIndent}{sub-sectiondiv:class=sIndent}[QBSelect]{div}{td}{tr}{builder-show}{tr:id=retsam}{td}*ReturnsSample*\\{sub-section:distinct_ret|trigger=button|text=}{sub-section}{sub-section:distinct_ret|trigger=none|class=sIndent}[Boolean]{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}{builder-showtr:permissionclass=editlastDetailRow}{tr:id=seetd}{td}*Also see*\\{sub-section:distinct_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:distinct_see|trigger=none}{sub-section}{div}{{tr}{tbody}{tbody:id=root}{tr:id=name}{td}h6.root{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linkret}{td}*External links*\\{sub-section:distinct_link|trigger=button|text=}{sub-section}Returns*\\{div:class=sIndent}{sub-section:distinct_link|trigger=none}{sub-section}{[QBSelect]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:distinct_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:distinct_sam|trigger=none}{code:language=javascript}
query.result.distinct = true
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=parent|class=node}{tr:id=name}{td}h6.parent{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:parent_des|trigger=button|text=}{sub-section}{sub-section:parent_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: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-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:parent_ret|trigger=button|text=}{sub-section}{sub-section:parent_ret|trigger=none|class=sIndent}[QBSelect]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{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}
/** @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}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=root|class=node}{tr:id=name}{td}h6.root{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:root_des|trigger=button|text=}{sub-section}{sub-section:root_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:root_snc|trigger=button|text=}{sub-section}{sub-section:root_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:root_prs|trigger=button|text=}{sub-section}{sub-section:root_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:root_ret|trigger=button|text=}{sub-section}{sub-section:root_ret|trigger=none|class=sIndent}[QBSelect]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{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:id=link}{td}*External links*\\{sub-section:root_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:root_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:root_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:root_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/order_details>} */
	var subquery = databaseManager.createSelect('db:/example_data/order_details')
	
 /** @type {QBSelect<db:/example_data/orders>} */
	var query = databaseManager.createSelect('db:/example_data/orders')
	query.where.add(query
		.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}{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=add-QBAggregate|class=node}{tr:id=name}{td}h6.add{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBResult]{span}{span:id=iets|style=float: left; font-weight: bold;}add{span}{span:id=iets|style=float: left;}\(aggregate){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:add-QBAggregate_des|trigger=button|text=}{sub-section}{sub-section:add-QBAggregate_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:add-QBAggregate_snc|trigger=button|text=}{sub-section}{sub-section:add-QBAggregate_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:add-QBAggregate_prs|trigger=button|text=}{sub-section}{sub-section:add-QBAggregate_prs|trigger=none|class=sIndent}\{[QBAggregate]} aggregate -- the aggregate to add to result
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:add-QBAggregate_ret|trigger=button|text=}{sub-section}{sub-section:add-QBAggregate_ret|trigger=none|class=sIndent}[QBResult]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:add-QBAggregate_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:add-QBAggregate_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:add-QBAggregate_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:add-QBAggregate_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:add-QBAggregate_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:add-QBAggregate_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.label_text.max)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=add-QBAggregate_String|class=node}{tr:id=name}{td}h6.add{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBResult]{span}{span:id=iets|style=float: left; font-weight: bold;}add{span}{span:id=iets|style=float: left;}\(aggregate, alias){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:add-QBAggregate_String_des|trigger=button|text=}{sub-section}{sub-section:add-QBAggregate_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:add-QBAggregate_String_snc|trigger=button|text=}{sub-section}{sub-section:add-QBAggregate_String_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:add-QBAggregate_String_prs|trigger=button|text=}{sub-section}{sub-section:add-QBAggregate_String_prs|trigger=none|class=sIndent}\{[QBAggregate]} aggregate -- the aggregate to add to result
\{[String]} alias -- aggregate alias
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:add-QBAggregate_String_ret|trigger=button|text=}{sub-section}{sub-section:add-QBAggregate_String_ret|trigger=none|class=sIndent}[QBResult]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:add-QBAggregate_String_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:add-QBAggregate_String_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:add-QBAggregate_String_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:add-QBAggregate_String_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:add-QBAggregate_String_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:add-QBAggregate_String_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.item_count.max, 'maximum_items')
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=add-QBColumn|class=node}{tr:id=name}{td}h6.add{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBResult]{span}{span:id=iets|style=float: left; font-weight: bold;}add{span}{span:id=iets|style=float: left;}\(column){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:add-QBColumn_des|trigger=button|text=}{sub-section}{sub-section:add-QBColumn_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:add-QBColumn_snc|trigger=button|text=}{sub-section}{sub-section:add-QBColumn_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:add-QBColumn_prs|trigger=button|text=}{sub-section}{sub-section:add-QBColumn_prs|trigger=none|class=sIndent}\{[QBColumn]} column -- column to add to result
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:add-QBColumn_ret|trigger=button|text=}{sub-section}{sub-section:add-QBColumn_ret|trigger=none|class=sIndent}[QBResult]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:add-QBColumn_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:add-QBColumn_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:add-QBColumn_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:add-QBColumn_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:add-QBColumn_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:add-QBColumn_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.custname)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=add-QBColumn_String|class=node}{tr:id=name}{td}h6.add{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBResult]{span}{span:id=iets|style=float: left; font-weight: bold;}add{span}{span:id=iets|style=float: left;}\(column, alias){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:add-QBColumn_String_des|trigger=button|text=}{sub-section}{sub-section:add-QBColumn_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:add-QBColumn_String_snc|trigger=button|text=}{sub-section}{sub-section:add-QBColumn_String_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:add-QBColumn_String_prs|trigger=button|text=}{sub-section}{sub-section:add-QBColumn_String_prs|trigger=none|class=sIndent}\{[QBColumn]} column -- column to add to result
\{[String]} alias -- column alias
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:add-QBColumn_String_ret|trigger=button|text=}{sub-section}{sub-section:add-QBColumn_String_ret|trigger=none|class=sIndent}[QBResult]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:add-QBColumn_String_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:add-QBColumn_String_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:add-QBColumn_String_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:add-QBColumn_String_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:add-QBColumn_String_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:add-QBColumn_String_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.custname, 'customer_name')
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=add-QBFunction|class=node}{tr:id=name}{td}h6.add{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBResult]{span}{span:id=iets|style=float: left; font-weight: bold;}add{span}{span:id=iets|style=float: left;}\(func){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:add-QBFunction_des|trigger=button|text=}{sub-section}{sub-section:add-QBFunction_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:add-QBFunction_snc|trigger=button|text=}{sub-section}{sub-section:add-QBFunction_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:add-QBFunction_prs|trigger=button|text=}{sub-section}{sub-section:add-QBFunction_prs|trigger=none|class=sIndent}\{[QBFunction]} func -- the function to add to the result
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:add-QBFunction_ret|trigger=button|text=}{sub-section}{sub-section:add-QBFunction_ret|trigger=none|class=sIndent}[QBResult]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:add-QBFunction_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:add-QBFunction_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:add-QBFunction_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:add-QBFunction_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:add-QBFunction_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:add-QBFunction_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.custname.upper())
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=add-QBFunction_String|class=node}{tr:id=name}{td}h6.add{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBResult]{span}{span:id=iets|style=float: left; font-weight: bold;}add{span}{span:id=iets|style=float: left;}\(func, alias){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:add-QBFunction_String_des|trigger=button|text=}{sub-section}{sub-section:add-QBFunction_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:add-QBFunction_String_snc|trigger=button|text=}{sub-section}{sub-section:add-QBFunction_String_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:add-QBFunction_String_prs|trigger=button|text=}{sub-section}{sub-section:add-QBFunction_String_prs|trigger=none|class=sIndent}\{[QBFunction]} func -- the function to add to the result
\{[String]} alias -- function alias
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:add-QBFunction_String_ret|trigger=button|text=}{sub-section}{sub-section:add-QBFunction_String_ret|trigger=none|class=sIndent}[QBResult]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:add-QBFunction_String_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:add-QBFunction_String_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:add-QBFunction_String_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:add-QBFunction_String_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:add-QBFunction_String_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:add-QBFunction_String_sam|trigger=none}{code:language=javascript}
query.result.add(query.columns.custname.upper(), 'customer_name')
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=addPk|class=node}{tr:id=name}{td}h6.addPk{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBResult]{span}{span:id=iets|style=float: left; font-weight: bold;}addPk{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:addPk_des|trigger=button|text=}{sub-section}{sub-section:addPk_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:addPk_snc|trigger=button|text=}{sub-section}{sub-section:addPk_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:addPk_prs|trigger=button|text=}{sub-section}{sub-section:addPk_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:addPk_ret|trigger=button|text=}{sub-section}{sub-section:addPk_ret|trigger=none|class=sIndent}[QBResult]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:addPk_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:addPk_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:addPk_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:addPk_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:addPk_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:addPk_sam|trigger=none}{code:language=javascript}
query.result.addPk()
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=addValue-Object|class=node}{tr:id=name}{td}h6.addValue/** @type {QBSelect<db:/example_data/order_details>} */
	var subquery = databaseManager.createSelect('db:/example_data/order_details')
	
 /** @type {QBSelect<db:/example_data/orders>} */
	var query = databaseManager.createSelect('db:/example_data/orders')
	query.where.add(query
		.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}{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=add-QBAggregate}{tr:id=name}{td}h6.add{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBResult]{span}{span:style=font-weight: bold;}add{span}{span}\(aggregate){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[QBAggregate]} aggregate -- the aggregate to add to result
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBResult]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.label_text.max)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=add-QBAggregate_String}{tr:id=name}{td}h6.add{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBResult]{span}{span:style=font-weight: bold;}add{span}{span}\(aggregate, alias){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[QBAggregate]} aggregate -- the aggregate to add to result
\{[String]} alias -- aggregate alias
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBResult]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.item_count.max, 'maximum_items')
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=add-QBColumn}{tr:id=name}{td}h6.add{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBResult]{span}{span:style=font-weight: bold;}add{span}{span}\(column){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[QBColumn]} column -- column to add to result
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBResult]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.custname)
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=add-QBColumn_String}{tr:id=name}{td}h6.add{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBResult]{span}{span:style=font-weight: bold;}add{span}{span}\(column, alias){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[QBColumn]} column -- column to add to result
\{[String]} alias -- column alias
{div}{td}{tr}{tr:id=sigret}{td}{span:style=float: left; margin-right: 5px;*Returns*\\{div:class=sIndent}[QBResult]{span{div}{td}{tr}{spantr:id=iets|style=float: left; font-weight: bold;}addValue{span}{span:id=iets|style=float: left;}\(value){spansam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.custname, 'customer_name')
{code}{div}{td}{tr}{builder-showtr:permissionclass=editlastDetailRow}{tr:id=destd}{td}{sub-section:addValue-Object_des|trigger=button|text=}{sub-section}{sub-section:addValue-Object_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edittr}{tbody}{tbody:id=add-QBFunction}{tr:id=name}{td}h6.add{td}{tr}{tr:id=sncsig}{td}*Since*\\{sub-section:addValue-Object_snc|trigger=button|text=}{sub-section}{sub-section:addValue-Object_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show{span:style=margin-right: 5px;}[QBResult]{span}{span:style=font-weight: bold;}add{span}{span}\(func){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{sub-section:addValue-Object_prs|trigger=button|text=}{sub-section}{sub-section:addValue-Object_prs|trigger=none|div:class=sIndent}\{[ObjectQBFunction]} valuefunc -- value add to result
{sub-section the function to add to the result
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBResult]{div}{td}{tr}{tr:id=retsam}{td}*ReturnsSample*\\{sub-section:addValue-Object_ret|trigger=button|text=}{sub-section}{sub-section:addValue-Object_ret|trigger=none|class=sIndent}[QBResult]{sub-sectiondiv:class=sIndent}{code:language=javascript}
query.result.add(query.columns.custname.upper())
{code}{div}{td}{tr}{builder-showtr:permissionclass=editlastDetailRow}{tr:id=seetd}{td}*Also see*\\{sub-section:addValue-Object_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:addValue-Object_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit{tr}{tbody}{tbody:id=add-QBFunction_String}{tr:id=name}{td}h6.add{td}{tr}{tr:id=linksig}{td}*External links*\\{sub-section:addValue-Object_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:addValue-Object_link|trigger=none}{sub-section}{div{span:style=margin-right: 5px;}[QBResult]{span}{span:style=font-weight: bold;}add{span}{span}\(func, alias){span}{td}{tr}{builder-show}{tr:id=samprs}{td}*SampleParameters*\\{sub-section:addValue-Object_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:addValue-Object_sam|trigger=none}{code:language=javascript}
query.result.addValue(100)
{code}{sub-section}\{[QBFunction]} func -- the function to add to the result
\{[String]} alias -- function alias
{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=lastDetailRowsIndent}[QBResult]{tddiv}{td}{tr}{tbodytr:id=sam}{tbody:id=addValue-Object_String|class=node}{tr:id=name}{td}h6.addValuetd}*Sample*\\{div:class=sIndent}{code:language=javascript}
query.result.add(query.columns.custname.upper(), 'customer_name')
{code}{div}{td}{tr}{tr:idclass=siglastDetailRow}{td}{span:style=float: left; margin-right: 5px;}[QBResult]{span}{span:id=iets|style=float: left; font-weight: bold;}addValue{span}{span:id=iets|style=float: left;}\(value, alias){span}{td}{tr}{builder-show:permission=edittd}{tr}{tbody}{tbody:id=addPk}{tr:id=name}{td}h6.addPk{td}{tr}{tr:id=dessig}{td}{sub-section:addValue-Object_String_des|trigger=button|text=}{sub-section}{sub-section:addValue-Object_String_des|trigger=none|class=sIndent}Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=editspan:style=margin-right: 5px;}[QBResult]{span}{span:style=font-weight: bold;}addPk{span}{span}\(){span}{td}{tr}{tr:id=sncret}{td}*SinceReturns*\\{sub-section:addValue-Object_String_snc|trigger=button|text=}{sub-section}{sub-section:addValue-Object_String_snc|trigger=none|div:class=sIndent} Replace with version info{sub-section[QBResult]{div}{td}{tr}{builder-show}{tr:id=prssam}{td}*ParametersSample*\\{sub-section:addValue-Object_String_prs|trigger=button|text=}{sub-section}{sub-section:addValue-Object_String_prs|trigger=none|class=sIndent}\{[Object]} value -- value add to result
\{[String]} alias -- value alias
{sub-sectiondiv:class=sIndent}{code:language=javascript}
query.result.addPk()
{code}{div}{td}{tr}{tr:id=retclass=lastDetailRow}{td}{td}*Returns*\\{sub-section:addValue-Object_String_ret|trigger=button|text=}{sub-section}{sub-section:addValue-Object_String_ret|trigger=none|class=sIndent}[QBResult]{sub-section}{tr}{tbody}{tbody:id=addValue-Object}{tr:id=name}{td}h6.addValue{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBResult]{span}{span:style=font-weight: bold;}addValue{span}{span}\(value){span}{td}{tr}{builder-show:permission=edit}{tr:id=seeprs}{td}*Also seeParameters*\\{sub-section:addValue-Object_String_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:addValue-Object_String_see|trigger=none}{sub-section}\{[Object]} value -- value add to result
{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=linkret}{td}*External linksReturns*\\{sub-section:addValue-Object_String_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:addValue-Object_String_link|trigger=none}{sub-section}[QBResult]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:addValue-Object_String_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:addValue-Object_String_sam|trigger=none}{code:language=javascript}
query.result.addValue(100, 'myvalue')
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=clear|class=nodeaddValue-Object_String}{tr:id=name}{td}h6.clearaddValue{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBResult]{span}{span:id=iets|style=float: left; font-weight: bold;}clearaddValue{span}{span:id=iets|style=float: left;}\(value, alias){span}{td}{tr}{builder-show:permission=edit}{tr:id=desprs}{td}{sub-section:clear_des|trigger=button|text=}{sub-section}{sub-section:clear_des|trigger=none|class=sIndent}Replace with description{sub-section*Parameters*\\{div:class=sIndent}\{[Object]} value -- value add to result
\{[String]} alias -- value alias
{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=sncret}{td}*SinceReturns*\\{sub-section:clear_snc|trigger=button|text=}{sub-section}{sub-section:clear_snc|trigger=none|div:class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit[QBResult]{div}{td}{tr}{tr:id=prssam}{td}*ParametersSample*\\{sub-section:clear_prs|trigger=button|text=}{sub-section}{sub-section:clear_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:clear_ret|trigger=button|text=}{sub-section}{sub-section:clear_ret|trigger=none|class=sIndent}[QBResult]{sub-sectiondiv:class=sIndent}{code:language=javascript}
query.result.addValue(100, 'myvalue')
{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{builder-show:permission=edittbody}{tbody:id=clear}{tr:id=seename}{td}*Also see*\\{sub-section:clear_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:clear_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:clear_link|trigger=button|text=}{sub-section}h6.clear{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBResult]{span}{span:style=font-weight: bold;}clear{span}{span}\(){span}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}{sub-section:clear_link|trigger=none}{sub-section}{[QBResult]{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:clear_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:clear_sam|trigger=none}{code:language=javascript}
query.result.clear()
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}
Child pages

Versions Compared

Old Version 3

New Version 4

Key
