executeQuery

Allows the execution of Custom HQL queries with binding, pagination, and many options. Underlying mechanism is ORMExecuteQuery. The params filtering can be using named or positional.

Returns

• This function returns any

Arguments

Key	Type	Required	Default	Description
query	string	Yes	---	The valid HQL to process
params	array or struct	No		Positional or named parameters
offset	numeric	No	0	Pagination offset
max	numeric	No	0	Max records to return
timeout	numeric	No	0	Query timeout
asQuery	boolean	No	true	Return query or array of objects
unique	boolean	No	false	Return a unique result
datasource	string	No	---	Use a specific or default datasource
asStream	boolean	No	false	Returns the result as a Java Stream using cbStreams

Examples

// simple query
ormService.executeQuery( "select distinct a.accountID from Account a" );
// using with list of parameters
ormService.executeQuery( "select distinct e.employeeID from Employee e where e.department = ? and e.created > ?", ['IS','01/01/2010'] );
// same query but with paging
ormService.executeQuery( "select distinct e.employeeID from Employee e where e.department = ? and e.created > ?", ['IS','01/01/2010'],1,30);

// same query but with named params and paging
ormService.executeQuery( "select distinct e.employeeID from Employee e where e.department = :dep and e.created > :created", {dep='Accounting',created='01/01/2010'],10,20);

// GET FUNKY!!