QBAggregate
Property Summary
Type | Name | Summary |
---|---|---|
Create abs(column) expression. | ||
Create an ascending sort expression. | ||
Create an aggregate expression.. | ||
Create bit_length(column) expression. | ||
Create ceil(column) expression. | ||
Create an aggregate expression.. | ||
Extract day from date. | ||
Create an descending sort expression. | ||
Add a distinct qualifier to the aggregate. | ||
Create floor(column) expression. | ||
Extract hour from date. | ||
Compare column with null.. | ||
Create length(column) expression. | ||
Create lower(column) expression. | ||
Create an aggregate expression.. | ||
Create an aggregate expression.. | ||
Extract minute from date. | ||
Extract month from date. | ||
Create a negated condition.. | ||
Get query builder parent table clause, this may be a query or a join clause.. | ||
Get query builder parent.. | ||
Create round(column) expression. | ||
Extract second from date. | ||
Create sqrt(column) expression. | ||
Create an aggregate expression.. | ||
Create trim(column) expression. | ||
Create upper(column) expression. | ||
Extract year from date. |
Methods Summary
Type | Name | Summary |
---|---|---|
Compare column to a range of 2 values or other columns.. | ||
Create cast(column, type) expression. | ||
Concatename with value. | ||
Divide by value. | ||
Compare column with a value or another column.. | ||
Compare column with a value or another column.. | ||
The flags are a bit pattern consisting of 1 or more of the following bits: - JSColumn.. | ||
Column type as a string. | ||
Compare column with a value or another column.. | ||
Compare column with subquery result.. | ||
Compare column with values.. | ||
Compare column with custom query result.. | ||
Compare column with a value or another column.. | ||
Compare column with a value or another column.. | ||
Compare column with a value or another column.. | ||
Create locate(arg) expression. | ||
Create locate(arg, start) expression. | ||
Compare column with a value or another column.. | ||
Subtract value. | ||
Create mod(arg) expression. | ||
Multiply with value. | ||
Create nullif(arg) expression. | ||
Add up value. | ||
Create substring(pos) expression. | ||
Create substring(pos, len) expression. |
Properties Details
abs
Create abs(column) expression
Returns QBColumn
Sample
asc
Create an ascending sort expression
Returns QBSort
Sample
avg
Create an aggregate expression.
Returns QBColumn
Sample
bit_length
Create bit_length(column) expression
Returns QBColumn
Sample
ceil
Create ceil(column) expression
Returns QBColumn
Sample
count
Create an aggregate expression.
Returns QBColumn
Sample
day
Extract day from date
Returns QBColumn
Sample
desc
Create an descending sort expression
Returns QBSort
Sample
distinct
Add a distinct qualifier to the aggregate
Returns QBColumn
Sample
floor
Create floor(column) expression
Returns QBColumn
Sample
hour
Extract hour from date
Returns QBColumn
Sample
isNull
Compare column with null.
Returns QBCondition
Sample
len
Create length(column) expression
Returns QBColumn
Sample
lower
Create lower(column) expression
Returns QBColumn
Sample
max
Create an aggregate expression.
Returns QBColumn
Sample
min
Create an aggregate expression.
Returns QBColumn
Sample
minute
Extract minute from date
Returns QBColumn
Sample
month
Extract month from date
Returns QBColumn
Sample
not
Create a negated condition.
Returns QBColumn
Sample
parent
Get query builder parent table clause, this may be a query or a join clause.
Returns QBTableClause
Sample
root
Get query builder parent.
Returns QBSelect
Sample
round
Create round(column) expression
Returns QBColumn
Sample
second
Extract second from date
Returns QBColumn
Sample
sqrt
Create sqrt(column) expression
Returns QBColumn
Sample
sum
Create an aggregate expression.
Returns QBColumn
Sample
trim
Create trim(column) expression
Returns QBColumn
Sample
upper
Create upper(column) expression
Returns QBColumn
Sample
year
Extract year from date
Returns QBColumn
Sample
Methods Details
between(value1, value2)
Compare column to a range of 2 values or other columns.
Parameters Object value1 ; Object value2 ;
Returns QBCondition
Sample
cast(type)
Create cast(column, type) expression
Parameters String type string type, see QUERY_COLUMN_TYPES
Returns QBColumn
Sample
concat(arg)
Concatename with value
Parameters Object arg valeu to concatenate with
Returns QBColumn
Sample
divide(arg)
Divide by value
Parameters Object arg nr to divide by
Returns QBColumn
Sample
eq(value)
Compare column with a value or another column. Operator: equals
Parameters Object value ;
Returns QBCondition
Sample
ge(value)
Compare column with a value or another column. Operator: greaterThanOrEqual
Parameters Object value ;
Returns QBCondition
Sample
getFlags()
The flags are a bit pattern consisting of 1 or more of the following bits:
JSColumn.UUID_COLUMN
JSColumn.EXCLUDED_COLUMN
JSColumn.TENANT_COLUMN
Returns Number
Sample
getTypeAsString()
Column type as a string
Returns String
Sample
gt(value)
Compare column with a value or another column. Operator: greaterThan
Parameters Object value ;
Returns QBCondition
Sample
isin(query)
Compare column with subquery result.
Parameters QBPart query subquery
Returns QBCondition
Sample
isin(values)
Compare column with values.
Parameters Array values array of values
Returns QBCondition
Sample
isin(customQuery, args)
Compare column with custom query result.
Parameters String customQuery custom query Array args query arguments
Returns QBCondition
Sample
le(value)
Compare column with a value or another column. Operator: lessThanOrEqual
Parameters Object value ;
Returns QBCondition
Sample
like(pattern)
Compare column with a value or another column. Operator: like
Parameters Object pattern the string value of the pattern
Returns QBCondition
Sample
like(pattern, escape)
Compare column with a value or another column. Operator: like, with escape character
Parameters Object pattern the string value of the pattern Number escape the escape char
Returns QBCondition
Sample
locate(arg)
Create locate(arg) expression
Parameters Object arg string to locate
Returns QBColumn
Sample
locate(arg, start)
Create locate(arg, start) expression
Parameters Object arg string to locate Number start start pos
Returns QBColumn
Sample
lt(value)
Compare column with a value or another column. Operator: lessThan
Parameters Object value ;
Returns QBCondition
Sample
minus(arg)
Subtract value
Parameters Object arg nr to subtract
Returns QBColumn
Sample
mod(arg)
Create mod(arg) expression
Parameters Object arg mod arg
Returns QBColumn
Sample
multiply(arg)
Multiply with value
Parameters Object arg nr to multiply with
Returns QBColumn
Sample
nullif(arg)
Create nullif(arg) expression
Parameters Object arg object to compare
Returns QBColumn
Sample
plus(arg)
Add up value
Parameters Object arg nr to add
Returns QBColumn
Sample
substring(pos)
Create substring(pos) expression
Parameters Number pos ;
Returns QBColumn
Sample
substring(pos, len)
Create substring(pos, len) expression
Parameters Number pos ; Number len ;
Returns QBColumn
Sample
Last updated