QBIntegerColumn

Overview

The QBIntegerColumn class represents a integer column in a QBSelect query.

For more information about constructing and executing queries and columns, refer to the QBSelect section of this documentation.

Extends

QBColumn

Properties Summarized

Type

Name

Summary

QBColumn

abs

Create abs(column) expression

QBColumn

avg

Create an aggregate average expression.

QBCondition

isNull

Compare column with null.

QBColumn

max

Create an aggregate max expression.

QBColumn

min

Create an aggregate min expression.

QBColumnComparable

not

Create a negated condition.

QBColumn

sqrt

Create sqrt(column) expression

QBColumn

sum

Create an aggregate sum expression.

Methods Summarized

Type

Name

Summary

QBCondition

between(value1, value2)

Compare column to a range of 2 values or other columns.

QBColumn

coalesce(value)

Create coalesce(arg) expression

Divide by value

Compare column with a value or another column.

QBCondition

ge(value)

Compare column with a value or another column.

QBCondition

gt(value)

Compare column with a value or another column.

QBCondition

isin(query)

Compare column with subquery result.

QBCondition

isin(values)

Compare column with values.

QBCondition

isin(customQuery, args)

Compare column with custom query result.

QBCondition

le(value)

Compare column with a value or another column.

QBCondition

lt(value)

Compare column with a value or another column.

Subtract value

Create mod(arg) expression

Multiply with value

Create nullif(arg) expression

QBColumn

plus(value)

Add up value

Properties Detailed

abs

Create abs(column) expression

Type QBColumn a QBColumn representing the absolute value of the column.

Sample

query.result.add(query.columns.custname.abs)

avg

Create an aggregate average expression.

Type QBColumn a QBColumn representing the average aggregate of the column.

Sample

var query = datasources.db.example_data.orders.createSelect();
	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)

isNull

Compare column with null.

Type QBCondition a QBCondition representing the "is null" comparison.

Sample

query.where.add(query.columns.flag.isNull)

max

Create an aggregate max expression.

Type QBColumn a QBColumn representing the sum aggregate function.

Sample

var query = datasources.db.example_data.orders.createSelect();
	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)

min

Create an aggregate min expression.

Type QBColumn a QBColumn representing the minimum aggregate function.

Sample

var query = datasources.db.example_data.orders.createSelect();
	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)

not

Create a negated condition.

Type QBColumnComparable a QBColumn representing the negated condition.

Sample

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

sqrt

Create sqrt(column) expression

Type QBColumn a QBNumberColumn representing the square root of the column.

Sample

query.result.add(query.columns.custname.sqrt)

sum

Create an aggregate sum expression.

Type QBColumn a QBColumn representing the sum aggregate of the column.

Sample

var query = datasources.db.example_data.orders.createSelect();
	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.sum.gt(100))
	foundset.loadRecords(query)

Methods Detailed

between(value1, value2)

Compare column to a range of 2 values or other columns.

Parameters

Object value1 ;
Object value2 ;

Returns: QBCondition a QBCondition representing the "between" comparison for the two values.

Sample

query.where.add(query.columns.flag.between(0, 5))

coalesce(value)

Create coalesce(arg) expression

Parameters

Object value when column is null

Returns: QBColumn a QBColumn representing the coalesce expression.

Sample

query.result.add(query.columns.mycol.coalesce('defval'))

divide(value)

Divide by value

Parameters

Object value nr to divide by

Returns: QBColumn a QBNumberColumn representing the column divided by the value.

Sample

query.result.add(query.columns.mycol.divide(2))

eq(value)

Compare column with a value or another column. Operator: equals

Parameters

Object value ;

Returns: QBCondition a QBCondition representing the "equals" comparison.

Sample

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

ge(value)

Compare column with a value or another column. Operator: greaterThanOrEqual

Parameters

Object value ;

Returns: QBCondition a QBCondition representing the "greater than or equal to" comparison.

Sample

query.where.add(query.columns.flag.ge(2))

gt(value)

Compare column with a value or another column. Operator: greaterThan

Parameters

Object value ;

Returns: QBCondition a QBCondition representing the "greater than" comparison.

Sample

query.where.add(query.columns.flag.gt(0))

isin(query)

Compare column with subquery result.

Parameters

QBPart query subquery

Returns: QBCondition a QBCondition representing the "in" comparison with a subquery.

Sample

query.where.add(query.columns.flag.isin(query2))

isin(values)

Compare column with values.

Parameters

Array values array of values

Returns: QBCondition a QBCondition representing the "in" comparison with a list of values.

Sample

query.where.add(query.columns.flag.isin([1, 5, 99]))

isin(customQuery, args)

Compare column with custom query result.

Parameters

String customQuery custom query
Array args query arguments

Returns: QBCondition a QBCondition representing the "in" comparison with a custom query and arguments.

Sample

query.where.add(query.columns.ccy.isin("select ccycode from currencies c where c.category = " + query.getTableAlias() + ".currency_category and c.flag = ?", ['T']))

le(value)

Compare column with a value or another column. Operator: lessThanOrEqual

Parameters

Object value ;

Returns: QBCondition a QBCondition representing the "less than or equal to" comparison.

Sample

query.where.add(query.columns.flag.le(2))

lt(value)

Compare column with a value or another column. Operator: lessThan

Parameters

Object value ;

Returns: QBCondition a QBCondition representing the "less than" comparison.

Sample

query.where.add(query.columns.flag.lt(99))

minus(value)

Subtract value

Parameters

Object value nr to subtract

Returns: QBColumn a QBNumberColumn representing the column substracted with the value.

Sample

query.result.add(query.columns.mycol.minus(2))

mod(arg)

Create mod(arg) expression

Parameters

Object arg mod arg

Returns: QBColumn a QBColumn representing the modulo of the column.

Sample

query.result.add(query.columns.mycol.mod(2))

multiply(value)

Multiply with value

Parameters

Object value nr to multiply with

Returns: QBColumn a QBNumberColumn representing the column multiplied with the value.

Sample

query.result.add(query.columns.mycol.multiply(2))

nullif(arg)

Create nullif(arg) expression

Parameters

Object arg object to compare

Returns: QBColumn a QBColumn representing the nullif expression.

Sample

query.result.add(query.columns.mycol.nullif('none'))

plus(value)

Add up value

Parameters

Object value nr to add

Returns: QBColumn a QBNumberColumn representing the column added with the value.

Sample

query.result.add(query.columns.mycol.plus(2))

PreviousQBGroupBy NextQBJoin

Last updated 22 days ago

Was this helpful?