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.
SyntaxRemoveKeySets(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);
|