RemoveKeySets

Deletes all keysets in GroupName that match Condition. The condition is specified using basic SQL WHERE syntax. The method returns the number of keysets that were deleted.
When passing 'ID' as the Condition, all keysets in GroupName will be deleted.

Syntax

RemoveKeySets(GroupName: string, Condition: string): integer

Examples

Basic 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).

JavaScript​

repoObject.RemoveKeySets("Users", 'Gender="M"');

VB Script​​​

repoObject.RemoveKeySets "Users", "Gender='M'"

Deleting a row

This script attempts to delete a client from the rows, then returns "true" or "false" in JobInfo variable %9 as a response.

var CustomerID = Watch.GetVariable("CustomerID");
var repoObject = new ActiveXObject("RepositoryLib.WorkflowRepository");
var deletedCount = JSON.parse(repoObject.RemoveKeySets("customers","customerID = '" + CustomerID + "'"));
var answer = (deletedCount > 0) ? "true" : "false";
Watch.SetJobInfo(9, answer);