Optional SQL group by expression, appended to any ordering conditions in the underlying query
Having (having)Option SQL having expression, appended to any ordering conditions in the underlying query
Limit (limit)Setting limit to a non-zero value limits the number of records that will be retrieved from the data. Note that when run in a form, rekall will actually use limit + 1 in the query to check if there are further records.
Silent limit (limitsilent)By default, if the limit option is set and the limit is reached, then the user is warned. Setting this option supresses the warning.
Where condition (where)Optional SQL where expression to filter rows
Row order (order)Optional SQL order expression to specify order or rows
Configuration (configs)List of configuration values. These are primarily used in conjunction with reusable components.