Re: How can i trigger notification for 14th day an...

NAIDILE S · ‎07-21-2025

var today = new GlideDateTime(); // Use GlideDateTime for full timestamp

var grAttestReminder = new GlideRecord("asmt_assessment_instance");

gs.info("NAIDILS - Starting Attestation Reminder Scan");

var controlObjectiveSysId = gs.getProperty('sn_grc.control.objective.annual.data.compliance');

var encodedQuery = 'stateINready,wip^sn_grc_item.content=' + controlObjectiveSysId;

grAttestReminder.addEncodedQuery(encodedQuery);

grAttestReminder.query();

while (grAttestReminder.next()) {

var grItem = grAttestReminder.sn_grc_item.getRefRecord();

var owner = grItem.owner;

var ownerManager = owner ? owner.manager : "";

var createdDateTime = new GlideDateTime(grAttestReminder.getValue('sys_created_on'));

var durationMs = GlideDateTime.subtract(today, createdDateTime).getNumericValue(); // in ms

// var days = durationMs / (1000 * 60 * 60 * 24); // convert ms to days

var days = Math.floor(durationMs / (1000 * 60 * 60 * 24)); // Force integer

gs.info("NAIDILS - Record: " + grAttestReminder.number + ", Days since creation: " + days);

if (days >= 13.5 && days < 14.5) {

gs.info("NAIDILS - Sending 14-day reminder for: " + grAttestReminder.number);

gs.eventQueue('sn_grc.attest.sendreminder', grAttestReminder, owner, '');

} else if (days >= 29.5 && days < 30.5) {

gs.info("NAIDILS - Sending 30-day reminder for: " + grAttestReminder.number);

gs.eventQueue('sn_grc.attest.sendreminder', grAttestReminder, owner, ownerManager);

}

}

its not goin inside the if loop atall , kindly help me here