Query

Object

query.addColumn() Adds a column to a query and populates its rows with the contents of a one-dimensional array. Pads query columns, if necessary, to ensure that all columns have the same number of rows.
query.addRow() Adds a specified number of empty rows to a query.
query.columnArray() return the column names as array
query.columnCount() column count of given query
query.columnData() Returns all the data in a query for a given column
query.columnExists() Determines whether a specific column is present in a query.
query.columnList() return the column names as list
query.currentRow() return the row where the pointer of the query is pointing ATM
query.deleteColumn() removes a row from a query and return removed row as array
query.deleteRow() Deletes the row within a query object. Modifies the original query object
query.each() call the given UDF/Closure with every row (struct) in the query.
query.every() This function calls a given closure/function with every element in a given query and returns true, if all of the closure calls returns true.
query.filter() This function creates a new Query that returns all rows from an query that match the given filter.
query.getCell() return the value of a specific query cell
query.getRow() this function is deprecated, use function QueryRowData instead.
query.keyExists() Determines whether a specific column is present in a query.
query.map() Calls the given closure with every row in the given query. the function returns a query that contains all values returned by the closure.
query.recordCount() row count of given query
query.reduce() Iterates over every row of the given query and calls the closure with that row. This function will reduce the query to a single value and will return this value.
query.rowData() Returns a struct with the data from a query for a given row number
query.setCell() Sets a cell to a value. If no row number is specified, the cell on the last row is set.
query.slice() creates a new query containing a part of the given query
query.some() This function calls a given closure/function with every element in a given query and returns true, if one of the closure calls returns true.
query.sort() Sorts the query based on the column specified and the order criteria given. Modifies the original query object

See also