Custom scalar functions
Custom aggregate functions
- cnt() - replicates standard count(*) function from SQL - it's a simple example of how to implement aggregate function
- any() - it will select randomly one value from entire set of aggregated values of the passed column
Custom collation scripts
Custom SQL function scripts
See Custom SQL functions chapter in User Manual for instructions how to use Custom SQL function scripts.
- Display execution context - if you're not sure what variables do you have available in your QtScript function, check it with this function