I want to run this loop for every row that has a startTime within the last 6 months (183 days). The Scripted service is retuning some of fields from a database and some from an api. Do I require a nested loop? I tried the second code block but nothing was returned.
SELECT
Results.userIdentifier,
Results.userIdentifier,
Results.startTime,
Results.userEmail,
Results.fullName
FROM {{
var SCRIPTED_SERVICE_NAME = "Scripted Service";
var results = [];
var returnValue = extFuncService.get(SCRIPTED_SERVICE_NAME);
for each (var row in returnValue)
results.push({
userIdentifier: row.userIdentifier,
userNamespace: row.userNamespace,
startTime: row.startTime,
userEmail: row.userEmail,
fullName: row.fullName,
});
}
results;
}} as Results
SELECT
Results.userIdentifier,
Results.userIdentifier,
Results.startTime,
Results.userEmail,
Results.fullName
FROM {{
var SCRIPTED_SERVICE_NAME = "Scripted Service";
var results = [];
var returnValue = extFuncService.get(SCRIPTED_SERVICE_NAME);
for each (var row in returnValue)
while (row.startTime >= (SELECT GETDATE()-183))
results.push({
userIdentifier: row.userIdentifier,
userNamespace: row.userNamespace,
startTime: row.startTime,
userEmail: row.userEmail,
fullName: row.fullName,
});
}
}
results;
}} as Results