var query =datasources.db.example_data.person.createSelect();query.where.add(query.joins.person_to_parent.joins.person_to_parent.columns.name.eq('john'))foundset.loadRecords(query)
var query =datasources.db.example_data.order_details.createSelect();// case expressions can be added to the result of the queryquery.result.add(query.case.when(query.columns.quantity.ge(1000)).then('BIG').else('small'));// they can also be used in conditionsquery.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));
when(condition)
Add a when-clause to the case searched expression.
var query =datasources.db.example_data.order_details.createSelect();// case expressions can be added to the result of the queryquery.result.add(query.case.when(query.columns.quantity.ge(1000)).then('BIG').else('small'));// they can also be used in conditionsquery.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));