2022.2

myKeySet = repoObject.GetKeySets("Users", "[""FirstName"",""LastName""]",
"Gender='M'")
Querying a single row
This JavaScript example shows how to get one or more rows from the repository and use them in the
process. The script gets 3 fields ("firstname", "lastname" and "email") from the CustomerID field. It
assumes there's a local variable called %{CustomerID} set in the workflow process.
var CustomerID = Watch.GetVariable("CustomerID");
var repoObject = new ActiveXObject("RepositoryLib.WorkflowRepository");
var customer = repoObject.GetKeySets("customers",'["firstname","lastname",
"customerID"]',"customerID = '" + CustomerID + "'");
Watch.SetJobInfo(9,customer);
By replacing the last option from GetKeySets (the filter on CustomerID) with an asterisk, you can get all
the rows from the data repository.
Return value: JSONStringArray
The method returns a JSONStringArray of key-value pairs, for example:
'[{"FirstName": "John","LastName": "Smith"},{"FirstName": "Richard",
"LastName": "Doe"}]'
The return value (saved for example in the %9 JobInfo variable, as the above example does) can be
used in a number of ways:
l
It can be returned to a web page that's making an HTTP request to Workflow. JSON is the
simplest way to transfer information between any system that supports JavaScript.
l
It can be passed to Designer and loaded up directly as an object in a script there.
l
The JSON can be converted to XML, which makes it useable in the DataMapper module. This
can be easily done in a preprocessor script in the DataMapper (see DataMapper online help).
GetValue
Performs a lookup in group GroupName and retrieves the first value for key KeyName that matches
Condition. The condition is specified using basic SQL WHERE syntax. The Condition may be left
empty in which case the very first value found for the specified KeyName is returned.
Syntax
GetValue(GroupName: string, KeyName: string, Condition: string)
Page 154