8.5

GetKeySets
Retrieves Keys values in GroupName for keysets that match Condition. When Keys is left empty, all keys
are retrieved. When Condition is left empty, all keysets are retrieved.
Syntax
GetKeySets(GroupName: string, Keys: JSONStringArray, Condition: string):
JSONStringArray
Examples
JavaScript
repoObject.GetKeySets("Users", '["FirstName","LastName"]', "Gender='M'");
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
JavaScript
repoObject.GetValue("Users", "email", " LastName='Smith' AND
FirstName='John' "); // retrieves email for John Smith
repoObject.GetValue("Users", "email", " LastName='Smith' "); // retrieves