Query Invocations

• onQueryBuild

• preQueryExecute

• postQueryExecute

• queryAddRow

onQueryBuild

Triggered upon construction of a JDBC PendingQuery class, used for all query executions from queryExecute() to bx:query.

Data Key	Type	Description
sql	String	The SQL statement being executed.
bindings	Array	Struct
pendingQuery	Java class	PendingQuery instance.
options	Java class	QueryOptions instance.

Example

function onQueryBuild( struct data ) {
    println("Query build in progress!");
}

preQueryExecute

Triggered immediately before query execution.

Data Key	Type	Description
sql	String	The SQL statement being executed.
bindings	List	Data bindings, processed and normalized for use as query parameters.
pendingQuery	Java class	PendingQuery instance.

Example

function preQueryExecute( struct data ) {
    println("Query ready to execute!");
}

postQueryExecute

Triggered immediately after query execution.

Data Key	Type	Description
sql	String	The SQL statement being executed
bindings	List	Data bindings, processed and normalized for use as query parameters.
executionTime	Number	Execution time in milliseconds.
data	Query	Result set populated into a Query object.
result	Struct	Struct of result metadata, including cached, cacheKey, sql, sqlParameters, executionTime, recordCount, and, optionally, generatedKey.
pendingQuery	Java class	PendingQuery instance.
executedQuery	Java class	ExecutedQuery instance.

Example

function postQueryExecute( struct data ) {
    println("Query execution complete!");
}

queryAddRow