8.6

VB Script
repoObject.GetKeySets "Users", "[""FirstName"",""LastName""]",
"Gender='M'"
Sample return value
The method returns a JSONStringArray of key-value pairs.
'[{"FirstName": "John","LastName": "Smith"},{"FirstName":
"Richard", "LastName": "Doe"}]'
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)
Examples
In each of these examples, the object repoObject is deemed having been obtained through a
call to the COM object "RepositoryLib.WorkflowRepository" (see "Obtaining an instance of the
Repository Object" on page117).
JavaScript
repoObject.GetValue("Users", "email", " LastName='Smith' AND
FirstName='John' "); // retrieves email for John Smith
repoObject.GetValue("Users", "email", " LastName='Smith' "); //
retrieves email for first user named Smith
repoObject.GetValue("Users", "email", ""); // retrieves email for
first user
VB Script
repoObject.GetValue "Users", "email", " LastName=""Smith"" AND
FirstName=""John"" " // retrieves email for John Smith
repoObject.GetValue "Users", "email", " LastName=""Smith"" " //
Page 126