Description
This function gets all the values that appear in a particular field of subject data in histories that match the 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 "subject" 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 getSubjectValues() 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 the subject data in a history that matches the filter.
Example
"method": "getSubjectValues",
"params": {
"key":"applicationfor.licence.type",
"filter" : {"key":"labela", "EQ":"Licence"}
}"result": [
"Event",
"Music and Dancing",
"Off",
"On and Off
]
Last modified on June 27, 2023
Share this page
