QBCaseWhen

Methods Summarized

Type	Name	Summary
QBCase	then(value)	Set the return value to use when the condition of the searched case expression is met.

Methods Detailed

then(value)

Set the return value to use when the condition of the searched case expression is met.

Parameters

• Object value The value.

Returns: QBCase

Sample

var query = datasources.db.example_data.order_details.createSelect();

// case expressions can be added to the result of the query
	query.result.add(query.case.when(query.columns.quantity.ge(1000)).then('BIG').else('small'));

 // they can also be used in conditions
	query.where.add(query.case
		.when(query.columns.discount.gt(10)).then(50)
		.when(query.columns.quantity.le(20)).then(70)
		.else(100)
	.multiply(query.columns.unitprice).lt(10000));

---