...
- projection: [Required] A comma-separated list of expressions (from the ExpressionEngineFunction library) to apply to data from a C3.ai Type (e.g., avg, unique, min, max). You can simply think about a projection as the columns/fields, calculated or otherwise, which the "evaluate" method should return.
- group: A comma-separated list of columns/fields, to group the aggregated/transformed data by (e.g, compute the average area by the 'locationType' field in OutbreakLocation). Please note, in any 'evaluate' command, all columns in the 'group' field MUST ALSO BE in the 'projection' field, as the example below shows.
- having: A SQL style having clause.
- order: A comma-separated list of columns/fields, to order aggregated/transformed data by. Users can return access data in 'ascending' or 'descending' order. Please note, in any 'evaluate' command, all columns in the 'order' field MUST ALSO BE in the 'projection' field.
- filter: A filter expression that restricts the rows in a C3.ai Type, on which the evaluate method is run.
...