Simulation Aids Module by Automation Professionals
E-Mail Support

Aggregate Scripting Functions

Each of the script functions in this section are modeled after a corresponding aggregate expression function, but is tailored for use with python lists of values instead of a dataset column. This format gives them the appearance of handling column data when used within the select string of a view expression function instance. To conform to SQL standard behavior, these script functions ignore null/None values. The statistical functions in this group accept java.lang.Date list items, but convert them to milliseconds before use.

To make its select strings more similar to real SQL, the view expression function assigns all of these functions to its local scope, allowing their use without the "system.aggregate." prefix. However, these functions only accept list data types as arguments. Where real SQL will accept normal arithmetic and other expressions inside the aggregate function's parenthesis, these functions cannot. You must perform such operations with an appropriate jython expression.