Page History

Wiki Markup
{hidden}
DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY, UNLESS YOU KNOW WHAT YOU'RE DOING.
		THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO EXTRACT CHANGES FROM THE PAGE AND MERGE THEM BACK INTO SERVOY SOURCE{hidden}
{sub-section:description|text=}{sub-section}\\ 

{table:id=|class=servoy sSummary}{colgroup}{column:width=80px|padding=0px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Property Summary{th}{tr}{tbody}{tr}{td}[String]\[]{td}{td}[#conditionnames]
Get the names for the conditions in the query where\-clause.{td}{tr}{tbody}{tbody}{tr}{td}[QBTableClause]{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}[QBWhereCondition]{td}{td}[#add]\(condition)
Add a condition to the AND or OR condition list.{td}{tr}{tbody}{tbody}{tr}{td}[QBWhereCondition]{td}{td}[#add]\(name, condition)
Add a named condition to the AND or OR condition list.{td}{tr}{tbody}{tbody}{tr}{td}[QBWhereCondition]{td}{td}[#clear]\()
Clear the conditions in the query where\-clause.{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#getCondition]\()
Get a named condition in the query where\-clause.{td}{tr}{tbody}{tbody}{tr}{td}[QBWhereCondition]{td}{td}[#remove]\()
Remove a named condition from the AND or OR condition list.{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=conditionnames|class=node}{tr:id=name}{td}h6.conditionnames{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:conditionnames_des|trigger=button|text=}{sub-section}{sub-section:conditionnames_des|trigger=none|class=sIndent}GetReplace the names for the conditions in the query where\-clause.with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:conditionnames_snc|trigger=button|text=}{sub-section}{sub-section:conditionnames_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:conditionnames_prs|trigger=button|text=}{sub-section}{sub-section:conditionnames_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:conditionnames_ret|trigger=button|text=}{sub-section}{sub-section:conditionnames_ret|trigger=none|class=sIndent}[String]\[]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:conditionnames_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:conditionnames_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:conditionnames_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:conditionnames_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:conditionnames_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:conditionnames_sam|trigger=none}{code:language=javascript}
var q = foundset.getQuery()
for (var c in q.where.conditionnames)
{
	var cond = q.where.getCondition(c)
}
{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}GetReplace query builder parent table clause, this may be a query or a join clause.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}[QBTableClause]{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}GetReplace query builder parent.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-QBCondition|class=node}{tr:id=name}{td}h6.add{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBWhereCondition]{span}{span:id=iets|style=float: left; font-weight: bold;}add{span}{span:id=iets|style=float: left;}\(condition){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:add-QBCondition_des|trigger=button|text=}{sub-section}{sub-section:add-QBCondition_des|trigger=none|class=sIndent}AddReplace a condition to the AND or OR condition list.with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:add-QBCondition_snc|trigger=button|text=}{sub-section}{sub-section:add-QBCondition_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:add-QBCondition_prs|trigger=button|text=}{sub-section}{sub-section:add-QBCondition_prs|trigger=none|class=sIndent}\{[QBCondition]} condition -- the condition to add
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:add-QBCondition_ret|trigger=button|text=}{sub-section}{sub-section:add-QBCondition_ret|trigger=none|class=sIndent}[QBWhereCondition]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:add-QBCondition_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:add-QBCondition_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:add-QBCondition_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:add-QBCondition_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:add-QBCondition_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:add-QBCondition_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.where.add(query.columns.orderdate.isNull)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=add-String_QBCondition|class=node}{tr:id=name}{td}h6.add{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBWhereCondition]{span}{span:id=iets|style=float: left; font-weight: bold;}add{span}{span:id=iets|style=float: left;}\(name, condition){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:add-String_QBCondition_des|trigger=button|text=}{sub-section}{sub-section:add-String_QBCondition_des|trigger=none|class=sIndent}AddReplace a named condition to the AND or OR condition list.with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:add-String_QBCondition_snc|trigger=button|text=}{sub-section}{sub-section:add-String_QBCondition_snc|trigger=none|class=sIndent} Replace with version info{sub-section}{td}{tr}{builder-show}{tr:id=prs}{td}*Parameters*\\{sub-section:add-String_QBCondition_prs|trigger=button|text=}{sub-section}{sub-section:add-String_QBCondition_prs|trigger=none|class=sIndent}\{[String]} name -- the name of the condition
\{[QBCondition]} condition -- the condition to add
{sub-section}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:add-String_QBCondition_ret|trigger=button|text=}{sub-section}{sub-section:add-String_QBCondition_ret|trigger=none|class=sIndent}[QBWhereCondition]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:add-String_QBCondition_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:add-String_QBCondition_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:add-String_QBCondition_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:add-String_QBCondition_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:add-String_QBCondition_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:add-String_QBCondition_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.where.add("mycond", query.columns.orderdate.isNull)
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=clear|class=node}{tr:id=name}{td}h6.clear{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBWhereCondition]{span}{span:id=iets|style=float: left; font-weight: bold;}clear{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:clear_des|trigger=button|text=}{sub-section}{sub-section:clear_des|trigger=none|class=sIndent}Clear the conditions in the query where\-clause.Replace with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:clear_snc|trigger=button|text=}{sub-section}{sub-section:clear_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: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}[QBWhereCondition]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{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}{div:class=sIndent}{sub-section:clear_link|trigger=none}{sub-section}{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}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.where.clear()
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=getCondition|class=node}{tr:id=name}{td}h6.getCondition{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBCondition]{span}{span:id=iets|style=float: left; font-weight: bold;}getCondition{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:getCondition_des|trigger=button|text=}{sub-section}{sub-section:getCondition_des|trigger=none|class=sIndent}GetReplace a named condition in the query where\-clause.with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:getCondition_snc|trigger=button|text=}{sub-section}{sub-section:getCondition_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:getCondition_prs|trigger=button|text=}{sub-section}{sub-section:getCondition_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:getCondition_ret|trigger=button|text=}{sub-section}{sub-section:getCondition_ret|trigger=none|class=sIndent}[QBCondition]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:getCondition_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getCondition_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:getCondition_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getCondition_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:getCondition_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:getCondition_sam|trigger=none}{code:language=javascript}
var q = foundset.getQuery()
for (var c in q.where.conditionnames)
{
	var cond = q.where.getCondition(c)
}
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=remove|class=node}{tr:id=name}{td}h6.remove{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[QBWhereCondition]{span}{span:id=iets|style=float: left; font-weight: bold;}remove{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{builder-show:permission=edit}{tr:id=des}{td}{sub-section:remove_des|trigger=button|text=}{sub-section}{sub-section:remove_des|trigger=none|class=sIndent}RemoveReplace a named condition from the AND or OR condition list.with description{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=snc}{td}*Since*\\{sub-section:remove_snc|trigger=button|text=}{sub-section}{sub-section:remove_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:remove_prs|trigger=button|text=}{sub-section}{sub-section:remove_prs|trigger=none|class=sIndent}{sub-section}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:remove_ret|trigger=button|text=}{sub-section}{sub-section:remove_ret|trigger=none|class=sIndent}[QBWhereCondition]{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:remove_see|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:remove_see|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:remove_link|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:remove_link|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:remove_sam|trigger=button|text=}{sub-section}{div:class=sIndent}{sub-section:remove_sam|trigger=none}{code:language=javascript}
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.where.remove("mycond")
{code}{sub-section}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}
Child pages

Versions Compared

Old Version 1

New Version 2

Key
