changes.mady.by.user Servoy Docs
Saved on Aug 30, 2013
Saved on Oct 16, 2013
...
query.result.distinct = true
/** @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)
/** @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)
query.result.add(query.columns.label_text.max)
query.result.add(query.columns.item_count.max, 'maximum_items')
query.result.add(query.columns.custname)
query.result.add(query.columns.custname, 'customer_name')
query.result.add(query.columns.custname.upper())
query.result.add(query.columns.custname.upper(), 'customer_name')
query.result.addPk()
query.result.addValue(100)
query.result.addValue(100, 'myvalue')
query.result.clear()