List of all Keysets in Repository for a specific date

[UomoDelGhiaccio]

I’m attempting to collect a list of all the keysets in a group.
I can collect individual records, but not multiple records.

Single Record

Multiple Records

Eventually, I only want the files for the current day.
I’m guessing that it would be the DateC vaue

[Phil]

This works for me:

var repo = new ActiveXObject("RepositoryLib.WorkflowRepository");

var todayISOdate =  Watch.ExpandString("%y-%m-%d");
var fields       = ["Field1", "Field2","DateC"];
var condition    = 'DateC LIKE "' + todayISOdate + '%"';

var ks = repo.GetKeySets("Group1", JSON.stringify(fields), condition);

Watch.Log(ks,2);

The condition DateC LIKE "2023-07-04%" uses the % wildcard so that any date that starts with the specified date is included in the query results.

[UomoDelGhiaccio]

@Phil

var repo = new ActiveXObject(“RepositoryLib.WorkflowRepository”); var todayISOdate = Watch.ExpandString(“%y-%m-%d”); var fields = [“Field1”, “Field2”,“DateC”]; var condition = ‘DateC LIKE "’ + todayISOdate + ‘%"’; var ks = repo.GetKeySets(“Group1”, JSON.stringify(fields), condition); Watch.Log(ks,2);

This code works great!