Description
This function gets all the values that appear in a particular field in event data, in histories that match a filter.
Parameters
| Name | Type | Description |
|---|---|---|
| datasource | String, optional | The name of the datasource from where histories will be retrieved. This parameter overrides the same parameter in the worker configuration which in turn overrides the default datasource |
| key | Required | A fully qualified key into "event" data packets |
| filter | Filter-object, optional | The filter specifies which histories will be inspected. The syntax of filter objects relates to many methods and is explained in Filter Objects |
| sealed | Boolean | If sealed is true, then only histories that have been switched into read-only mode will be searched. If sealed is false then only writable histories will be searched. If sealed is not supplied, then all histories will be searched |
| getsql | Boolean, optional | If this parameter is supplied and set to true then the return structure will include an element called "sql" which contains the query and the parameters which were used to retrieve the history data from the database. This option returns a large amount of data and is intended for testing and debugging |
Returns
If the getEventValues() operation was successful then the "result" structure will contain an array of string/int/real/bool/null. Each value appears in the named key in an "event" data packet somewhere in a history that matches the filter.
Example
"method": "getEventValues",
"params": {
"key":"response.overdue.days",
"filter" : {"key":"labela", "EQ":"Licence"}
}"result": [ 2, 3, 8, 30 ]
Last modified on 27 June 2023
Share this page
