Toggle menu

getSubjectKeys()

Description

This function gets all the key names that are used in subject data in histories that match a filter.

Parameters

NameTypeDescription
datasourceString, optionalThe 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
filterFilter-object, optionalThe filter specifies which histories will be counted. The syntax of filter objects relates to many methods and is explained in Filter Objects
sealedBooleanIf 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
getsqlBoolean, optionalIf 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 getSubjectKeys() operation was successful then the "result" structure will contain an array of strings. Each string is the fully qualified key of a field that appears in subject data in at least one of the histories that match the filter.

Example

"method":"getsubjectkeys",
"params": {
    "filter":{"key":"labela", "EQ":"Disruption"}
}

 "result": [
            "route",
            "what",
            "where.description",
            "where.notes[0]",
            "where.notes[1]",
            "where.notes[2]"
        ]

Last modified on June 27, 2023

Share this page

Facebook icon Twitter icon email icon

Print

print icon