QBSelect

Unknown macro: {td}

and
Create an AND-condition to add conditions to.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

QBColumns

Unknown macro: {td}

columns
Get columns from query

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

QBFunctions

Unknown macro: {td}

functions
Get the functions clause from a query, used for functions that are not tied to a column.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

QBGroupBy

Unknown macro: {td}

groupBy
Get the group by clause from a query
<pre>
// SELECT val2, COUNT(val2) FROM tab GROUP BY val2 ORDER BY COUNT(val2) DESC
query.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

having
Get the having-part of the query, used to add conditions.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

QBJoins

Unknown macro: {td}

joins
Get the joins clause of this table based clause.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

or
Create an OR-condition to add conditions to.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

QBParameters

Unknown macro: {td}

params
Get the named parameters from a query.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

QBTableClause

Unknown macro: {td}

parent
Get query builder parent table clause, this may be a query or a join clause.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

QBResult

Unknown macro: {td}

result
Get the result part of the query, used to add result columns or values.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

QBSelect

Unknown macro: {td}

root
Get query builder parent.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

QBSorts

Unknown macro: {td}

sort
Get the sorting part of the query.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

where
Get the where-part of the query, used to add conditions.

Unknown macro: {table}

{column:padding=0px|width=80px}{column}{column}{column}

Unknown macro: {tr}

Unknown macro: {th}

Method Summary

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

exists()
Get an exists-condition from a subquery
<pre>
// where exists (select 1 from tab where flag = ?)
query.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

getColumn(name)
Get a column from the table.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

getColumn(columnTableAlias, name)
Get a column from the table with given alias.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

QBParameter

Unknown macro: {td}

getParameter()
Get or create a parameter for the query, this used to parameterize queries.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

not(cond)
Create an negated condition.

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {td}

not(cond)

Unknown macro: {table}

{column:padding=0px|width=100%}{column}

Unknown macro: {tr}

Unknown macro: {th}

Property Details

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

and

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Create an AND-condition to add conditions to.
<pre>
// where (flag = ? and order_date is null) or (flag = ? and order_date > ?)
query.where().add(
query.or()
.add(
query.and()
.add(query.getColumn("flag").eq(new Integer(1)))
.add(query.getColumn("order_date").isNull())
)
.add(
query.and()
.add(query.getColumn("flag").eq(new Integer(2)))
.add(query.getColumn("order_date").gt(new Date()))
)
);
</pre>

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

query.where.add(
	  query.or
	    .add(
	      query.and
		    .add(query.columns.flag.eq(1))
	    .add(query.columns.order_date.isNull)
		 )
	    .add(
	      query.and
	        .add(query.columns.flag.eq(2))
	        .add(query.column.order_date.gt(new Date()))
	     )
	);

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

columns

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Get columns from query

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

QBColumns

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

foundset.getQuery().columns

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

functions

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Get the functions clause from a query, used for functions that are not tied to a column.
<pre>
// select pk from tab where floor(val / ?) > pk [1999]
IQueryBuilder query = queryFactory.createSelect(table.getDataSource()).result().addPk().getParent();
query.where()
.add(query.functions().floor(query.getColumn(val.getName()).divide(new Integer(1999))).gt(query.getColumn(id.getName())))
.getRoot().sort().add(query.getColumn(id.getName()).asc());
</pre>

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

QBFunctions

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

/** @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('servoy'))) //$NON-NLS-1$
foundset.loadRecords(query)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

groupBy

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Get the group by clause from a query
<pre>
// SELECT val2, COUNT(val2) FROM tab GROUP BY val2 ORDER BY COUNT(val2) DESC
query.result().add(query.getColumn(val2.getName())).add(query.getColumn(val2.getName()).count())
.getParent().groupBy().add(val2.getName())
.getParent().sort().add(query.getColumn(val2.getName()).count().desc());
</pre>

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

QBGroupBy

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
.root.having.add(query.joins.orders_to_order_details.columns.quantity.count.eq(0))
foundset.loadRecords(query)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

having

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Get the having-part of the query, used to add conditions.
The conditions added here are AND-ed.
<pre>
// select value from tab group by value having count(value) > 1
query.result().add(query.getColumn("value"))
.getParent().groupBy().add("value")
.getParent().having().add("value").count().gt(Integer.valueOf(1)));
</pre>

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.groupBy.addPk() // have to group by on pk when using having-conditions in (foundset) pk queries
.root.having.add(query.joins.orders_to_order_details.columns.quantity.count.eq(0))
foundset.loadRecords(query)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

joins

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Get the joins clause of this table based clause.
<p>Joins added to this clause will be based on this table clauses table.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

QBJoins

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

foundset.getQuery().joins

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

or

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Create an OR-condition to add conditions to.
<pre>
// where custid = ? and (order_date is null or order_date > ?)
query.where().add(query.getColumn("custid").eq(new Integer(200)))
.add(
query.or()
.add(query.getColumn("order_date").isNull())
.add(query.getColumn("order_date").gt(new Date()))
);
</pre>

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

query.where.add(
	  query.or
	    .add(
	      query.and
		    .add(query.columns.flag.eq(1))
	    .add(query.columns.order_date.isNull)
		 )
	    .add(
	      query.and
	        .add(query.columns.flag.eq(2))
	        .add(query.column.order_date.gt(new Date()))
	     )
	);

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

params

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Get the named parameters from a query.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

QBParameters

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

/** @type {QBSelect<db:/example_data/orders>} */
	var query = databaseManager.createSelect('db:/example_data/orders')
	query.where.add(query.columns.contact_id.eq(query.getParameter('mycontactid')))
	
	// load orders where contact_id = 100
	query.params['mycontactid'] = 100
	foundset.loadRecords(query)
	
	// load orders where contact_id = 200
	query.params['mycontactid'] = 200
	foundset.loadRecords(query)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

parent

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Get query builder parent table clause, this may be a query or a join clause.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

QBTableClause

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

/** @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)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

result

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Get the result part of the query, used to add result columns or values.
<pre>
query.result().add(query.getColumn("id")).add.query.getColumn("note"); // select id, note from tab
</pre>

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

QBResult

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

query.result.add(query.columns.company_id).add(query.columns.customerid)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

root

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Get query builder parent.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

QBSelect

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

/** @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)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

sort

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Get the sorting part of the query.
<pre>
query.sort().add(query.getColumn("note").desc()).add(query.getColumn("id")); // order by note desc, id asc
</pre>

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

QBSorts

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders')
query.sort
.add(query.joins.orders_to_order_details.columns.quantity.desc)
.add(query.columns.companyid)
foundset.loadRecords(query)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

where

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Get the where-part of the query, used to add conditions.
The conditions added here are AND-ed.
<pre>
query.where().add(query.getColumn("flag").eq(new Integer(1)).add(query.getColumn("foo").isNull(); // where flag = 1 and foo is null
</pre>

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

var query = foundset.getQuery()
query.where.add(query.columns.flag.eq(1))

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {table}

{column:padding=0px|width=100%}{column}

Unknown macro: {tr}

Unknown macro: {th}

Method Details

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

exists

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

exists

Unknown macro: {span}

()

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Get an exists-condition from a subquery
<pre>
// where exists (select 1 from tab where flag = ?)
query.where().add(query.exists(subQuery.result().addValue(new Integer(1)).getParent().where().add(subQuery.getColumn("flag").eq("T")).getRoot()));

// or simple variant: adds 'select 1' and calls getRoot()
query.where().add(query.exists(subQuery.where().add(subQuery.getColumn("flag").eq("T"))));
</pre>

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

foundset.query.where.add(query.exists(query2))

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

getColumn

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

getColumn

Unknown macro: {span}

(name)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Get a column from the table.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

{String} name – the name of column to get

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

foundset.getQuery().getColumn('orderid')

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

getColumn

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

getColumn

Unknown macro: {span}

(columnTableAlias, name)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Get a column from the table with given alias.
<p>The alias may be of the main table or any level deep joined table.

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

{String} columnTableAlias – the alias for the table
{String} name – the name of column to get

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

foundset.getQuery().getColumn('orderid', 'opk')

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

getParameter

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

QBParameter

Unknown macro: {span}

getParameter

Unknown macro: {span}

()

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Get or create a parameter for the query, this used to parameterize queries.
<pre>
query.where().add(query.getColumn("flag").eq(query.getParameter("myvar"));
query.getParameter("myvar").setvalue(new Integer(1));
</pre>

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

QBParameter

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

/** @type {QBSelect<db:/example_data/orders>} */
	var query = databaseManager.createSelect('db:/example_data/orders')
	query.where.add(query.columns.contact_id.eq(query.getParameter('mycontactid')))
	
	// load orders where contact_id = 100
	query.params['mycontactid'] = 100
	foundset.loadRecords(query)
	
	// load orders where contact_id = 200
	query.params['mycontactid'] = 200
	foundset.loadRecords(query)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

not

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

not

Unknown macro: {span}

(cond)

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Create an negated condition.
<pre>
// where not (order_date is null or order_date > ?)
query.where().add(query.not(
query.or()
.add(query.getColumn("order_date").isNull())
.add(query.getColumn("order_date").gt(new Date()))
)
);
</pre>

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

{QBCondition} cond – the condition to negate

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Also see

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

External links

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

Unknown macro: {tr}

Unknown macro: {td}

Sample

Unknown macro: {sub-section}

Unknown macro: {div}

Unknown macro: {sub-section}

foundset.query.where.add(query.not(query.columns.flag.eq(1)))

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {tbody}

Unknown macro: {tr}

Unknown macro: {td}

not

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {span}

Unknown macro: {span}

not

Unknown macro: {span}

(cond)

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Unknown macro: {sub-section}

Replace with description

Unknown macro: {builder-show}

Unknown macro: {tr}

Unknown macro: {td}

Since

Unknown macro: {sub-section}

Replace with version info

Unknown macro: {tr}

Unknown macro: {td}

Parameters

Unknown macro: {sub-section}

{QBLogicalCondition} cond – the logical condition to negate

Unknown macro: {tr}

Unknown macro: {td}

Returns

Unknown macro: {sub-section}