QueryBuilder

Functions and more information for QueryBuilder

clearGroupBy ( )

Clears the group by-clause

clearHaving ( )

Clears the having-clause

clearOrderBy ( )

Clears the order by-clause

clearSelect ( )

Clears the select-clause

clearWhere ( )

Clear the where-clause

execute ( )

Executes the query

expression ( lhs: Object , Operator: String , rhs: Object ) →{ Criteria }

Create an expression

Parameters
Name Type Description
lhs Object

lhs Lefthand side of the expression
Operator String

Operator
rhs Object

rhs Righthand side of the expression

from ( model: String )

Sets the model to query from

Parameters
Name Type Description
model String

model Name of model to query from

func ( name: String , args: Array ) →{ Object }

Creates a function-invocation

Parameters
Name Type Description
name String

name Name of function to invoke
args Array

args Array of arguments to pass to the function

getQueryHandle ( ) →{ QueryHandle }

Gets the QueryHandle for this QueryBuilder

groupBy ( path: String )

Adds an attribute to group the result by

Parameters
Name Type Description
path String

path Path of attribute to group by

having ( having: Object )

Sets the having-clause expression

Parameters
Name Type Description
having Object

having Expression

orderBy ( path: String , desc: Boolean )

Adds an attribute to order the result by

Parameters
Name Type Description
path String

path Path of attribute to order by
desc Boolean

desc Sort the result descending or not

reference ( path: String ) →{ Object }

Creates a reference from a path

Parameters
Name Type Description
path String

path Path of reference

select ( select: String , alias: String )

Selects an attribute

Parameters
Name Type Description
select String

select Path of attribute to select
alias String

alias Alias of selected attribute

value ( value: Object ) →{ Object }

Creates a value

Parameters
Name Type Description
value Object

value Value to be wrapped

where ( where: Object )

Sets the where-clause expression

Parameters
Name Type Description
where Object

where Expression to filter on

Objects