-
Notifications
You must be signed in to change notification settings - Fork 0
/
PA_ATF_NoOrphanedGroups
41 lines (38 loc) · 1.26 KB
/
PA_ATF_NoOrphanedGroups
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
function getRecentGroups() {
var gr = new GlideRecord('x_osmo2_pa_approv_weekly_payroll_group');
gr.addEncodedQuery('sys_created_on>javascript:gs.beginningOfLastWeek()');
gr.query();
var log = [];
while (gr.next()) {
log.push(gr.getDisplayValue());
}
//gs.addInfoMessage('found this many Groups: ' + gr.getRowCount());
return log;
}
function findOrphanedGroups(keyString) {
var returnVal = '';
var g = new GlideRecord('x_osmo2_pa_approv_weekly_payroll');
g.addEncodedQuery('payroll_groupSTARTSWITH' + keyString);
g.query();
if (g.getRowCount() == 0) {
returnVal = '\nFound an orphan Group: ' + keyString;
}
return returnVal;
}
(function(outputs, steps, stepResult, assertEqual) {
var msg = '';
var keyArray = getRecentGroups();
for (i = 0; i < keyArray.length; i++) {
var result = findOrphanedGroups(keyArray[i]);
msg += result;
}
if (msg.length == 0) {
stepResult.setOutputMessage("Success, no orphaned Payroll Groups");
return true;
} else {
stepResult.setOutputMessage(msg);
return false;
}
})(outputs, steps, stepResult, assertEqual);
// uncomment the next line to execute this script as a jasmine test
//jasmine.getEnv().execute();