{div:style=display:none} DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY (EXCEPT INSIDE THE DIV BELOW WITH ID=DESCRIPTION), UNLESS YOU KNOW WHAT YOU'RE DOING. THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO AUTO UPDATE THE CONTENT THROUGH THE DOC GENERATOR{div} {div:id=description}{div}\\ {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}[QBFunction]{td}{td}[#abs] Create abs(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBSort]{td}{td}[#asc] Create an ascending sort expression{td}{tr}{tbody}{tbody}{tr}{td}[QBAggregate]{td}{td}[#avg] Create an aggregate expression.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#bit_length] Create bit\_length(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#ceil] Create ceil(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBAggregate]{td}{td}[#count] Create an aggregate expression.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#day] Extract day from date{td}{tr}{tbody}{tbody}{tr}{td}[QBSort]{td}{td}[#desc] Create an descending sort expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#floor] Create floor(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#hour] Extract hour from date{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#isNull] Compare column with null.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#len] Create length(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#lower] Create lower(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBAggregate]{td}{td}[#max] Create an aggregate expression.{td}{tr}{tbody}{tbody}{tr}{td}[QBAggregate]{td}{td}[#min] Create an aggregate expression.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#minute] Extract minute from date{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#month] Extract month from date{td}{tr}{tbody}{tbody}{tr}{td}[QBColumn]{td}{td}[#not] Create a negated condition.{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}{tbody}{tr}{td}[QBFunction]{td}{td}[#round] Create round(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#second] Extract second from date{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#sqrt] Create sqrt(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBAggregate]{td}{td}[#sum] Create an aggregate expression.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#trim] Create trim(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#upper] Create upper(column) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#year] Extract year from date{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}[QBCondition]{td}{td}[#between]\(value1, value2) Compare column to a range of 2 values or other columns.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#cast]\(type) Create cast(column, type) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#concat]\(arg) Concatename with value{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#divide]\(arg) Divide by value{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#eq]\(value) Compare column with a value or another column.{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#ge]\(value) Compare column with a value or another column.{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#gt]\(value) Compare column with a value or another column.{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#isin]\(query) Compare column with subquery result.{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#isin]\(values) Compare column with values.{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#le]\(value) Compare column with a value or another column.{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#like]\(pattern) Compare column with a value or another column.{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#like]\(pattern, escape) Compare column with a value or another column.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#locate]\(arg) Create locate(arg) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#locate]\(arg, start) Create locate(arg, start) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBCondition]{td}{td}[#lt]\(value) Compare column with a value or another column.{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#minus]\(arg) Subtract value{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#mod]\(arg) Create mod(arg) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#multiply]\(arg) Multiply with value{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#nullif]\(arg) Create nullif(arg) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#plus]\(arg) Add up value{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#substring]\(pos) Create substring(pos) expression{td}{tr}{tbody}{tbody}{tr}{td}[QBFunction]{td}{td}[#substring]\(pos, len) Create substring(pos, len) expression{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=abs}{tr:id=name}{td}h6.abs{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.custname.abs) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=asc}{tr:id=name}{td}h6.asc{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBSort]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} /** @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.asc) .add(query.columns.companyid) foundset.loadRecords(query) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=avg}{tr:id=name}{td}h6.avg{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBAggregate]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} /** @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.avg.eq(1)) foundset.loadRecords(query) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=bit_length}{tr:id=name}{td}h6.bit_length{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.custname.bit_length) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=ceil}{tr:id=name}{td}h6.ceil{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.mycol.ceil) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=count}{tr:id=name}{td}h6.count{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBAggregate]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} /** @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) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=day}{tr:id=name}{td}h6.day{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.mydatecol.day) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=desc}{tr:id=name}{td}h6.desc{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBSort]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} /** @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) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=floor}{tr:id=name}{td}h6.floor{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.mycol.floor) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=hour}{tr:id=name}{td}h6.hour{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.mydatecol.hour) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=isNull}{tr:id=name}{td}h6.isNull{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.where.add(query.columns.flag.isNull) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=len}{tr:id=name}{td}h6.len{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.custname.len) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=lower}{tr:id=name}{td}h6.lower{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.custname.lower) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=max}{tr:id=name}{td}h6.max{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBAggregate]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} /** @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.max(10)) foundset.loadRecords(query) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=min}{tr:id=name}{td}h6.min{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBAggregate]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} /** @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.min(10)) foundset.loadRecords(query) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=minute}{tr:id=name}{td}h6.minute{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.mydatecol.minute) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=month}{tr:id=name}{td}h6.month{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.mydatecol.month) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=not}{tr:id=name}{td}h6.not{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBColumn]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.where.add(query.columns.flag.not.eq(1)) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=parent}{tr:id=name}{td}h6.parent{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBTableClause]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{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}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=root}{tr:id=name}{td}h6.root{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBSelect]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{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}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=round}{tr:id=name}{td}h6.round{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.mycol.round) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=second}{tr:id=name}{td}h6.second{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.mydatecol.second) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=sqrt}{tr:id=name}{td}h6.sqrt{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.custname.sqrt) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=sum}{tr:id=name}{td}h6.sum{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBAggregate]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} /** @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.sum(10)) foundset.loadRecords(query) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=trim}{tr:id=name}{td}h6.trim{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.custname.trim) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=upper}{tr:id=name}{td}h6.upper{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.custname.upper) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=year}{tr:id=name}{td}h6.year{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.mydatecol.year) {code}{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=between-Object_Object}{tr:id=name}{td}h6.between{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}between{span}{span}\(value1, value2){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value1 \{[Object]} value2 {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.where.add(query.columns.flag.between(0, 5)) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=cast-String}{tr:id=name}{td}h6.cast{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}cast{span}{span}\(type){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[String]} type -- string type, see QUERY\_COLUMN\_TYPES {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.mycol.cast(QUERY_COLUMN_TYPES.TYPE_INTEGER)) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=concat-Object}{tr:id=name}{td}h6.concat{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}concat{span}{span}\(arg){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- valeu to concatenate with {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.firstname.concat(' ').concat(query.columns.lastname)) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=divide-Object}{tr:id=name}{td}h6.divide{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}divide{span}{span}\(arg){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- nr to divide by {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.mycol.divide(2)) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=eq-Object}{tr:id=name}{td}h6.eq{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}eq{span}{span}\(value){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.where.add(query.columns.flag.eq(1)) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=ge-Object}{tr:id=name}{td}h6.ge{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}ge{span}{span}\(value){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.where.add(query.columns.flag.ge(2)) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=gt-Object}{tr:id=name}{td}h6.gt{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}gt{span}{span}\(value){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.where.add(query.columns.flag.gt(0)) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=isin-QBPart}{tr:id=name}{td}h6.isin{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}isin{span}{span}\(query){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[QBPart]} query -- subquery {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.where.add(query.columns.flag.isin(query2)) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=isin-ObjectArray}{tr:id=name}{td}h6.isin{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}isin{span}{span}\(values){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]\[]} values -- array of values {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.where.add(query.columns.flag.isin([1, 5, 99])) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=le-Object}{tr:id=name}{td}h6.le{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}le{span}{span}\(value){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.where.add(query.columns.flag.le(2)) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=like-String}{tr:id=name}{td}h6.like{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}like{span}{span}\(pattern){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[String]} pattern -- the string value of the pattern {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.where.add(query.columns.companyname.like('Serv%')) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=like-String_String}{tr:id=name}{td}h6.like{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}like{span}{span}\(pattern, escape){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[String]} pattern -- the string value of the pattern \{[String]} escape -- the escape char {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.where.add(query.columns.companyname.like('X_%', '_')) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=locate-Object}{tr:id=name}{td}h6.locate{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}locate{span}{span}\(arg){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- string to locate {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.mycol.locate('sample')) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=locate-Object_Number}{tr:id=name}{td}h6.locate{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}locate{span}{span}\(arg, start){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- string to locate \{[Number]} start -- start pos {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.mycol.locate('sample', 5)) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=lt-Object}{tr:id=name}{td}h6.lt{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBCondition]{span}{span:style=font-weight: bold;}lt{span}{span}\(value){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} value {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBCondition]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.where.add(query.columns.flag.lt(99)) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=minus-Object}{tr:id=name}{td}h6.minus{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}minus{span}{span}\(arg){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- nr to subtract {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.mycol.minus(2)) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=mod-Object}{tr:id=name}{td}h6.mod{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}mod{span}{span}\(arg){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- mod arg {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.mycol.mod(2)) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=multiply-Object}{tr:id=name}{td}h6.multiply{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}multiply{span}{span}\(arg){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- nr to multiply with {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.mycol.multiply(2)) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=nullif-Object}{tr:id=name}{td}h6.nullif{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}nullif{span}{span}\(arg){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- object to compare {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.mycol.nullif('none')) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=plus-Object}{tr:id=name}{td}h6.plus{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}plus{span}{span}\(arg){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Object]} arg -- nr to add {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.mycol.plus(2)) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=substring-Number}{tr:id=name}{td}h6.substring{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}substring{span}{span}\(pos){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Number]} pos {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.mycol.substring(3)) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=substring-Number_Number}{tr:id=name}{td}h6.substring{td}{tr}{tr:id=sig}{td}{span:style=margin-right: 5px;}[QBFunction]{span}{span:style=font-weight: bold;}substring{span}{span}\(pos, len){span}{td}{tr}{tr:id=prs}{td}*Parameters*\\{div:class=sIndent}\{[Number]} pos \{[Number]} len {div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[QBFunction]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript} query.result.add(query.columns.mycol.substring(3, 2)) {code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table} |