Survey is undefined

[nameisnani]

Hi Team ,

while clicking on the emoji , coming as undefind 

(function runMailScript( /* GlideRecord */ current, /* TemplatePrinter */ template,
    /* Optional EmailOutbound */
    email, /* Optional GlideRecord */ email_action,
    /* Optional GlideRecord */
    event) {


    gs.log("current " + current.number, 'sys');

    var surv = new GlideRecord('asmt_assessment_instance');
    surv.addNotNullQuery('trigger_id');
    surv.addQuery('trigger_id', current.sys_id);
    surv.query();
    surv.next();
    gs.log("Incident from survey " + surv.number, 'sys');

    var params = current.number + "," + surv.number;
    //var subject = "survey:" + surv.number + " " + " " + "incident:" + current.number + " ";
    var subject = "Reminder:Please share your feedback on " + "Incident: " + current.number;
    //+ " " + ": Survey Number : " + surv.number;
    email.setSubject(subject);



    template.print('<a href="' + gs.getProperty('glide.servlet.uri') + '/sp?id=take_survey&instance_id=' + surv.sys_id + '"><img src="CSAT.png" width="280" height="55"/></a>');





})(current, template, email, email_action, event);

 Nootification 

Event 

Scdeule Job 

 through scheduled job 

sendNotification();

function sendNotification() {
    try {
        var gr = new GlideRecord('asmt_assessment_instance');
        gr.addEncodedQuery('metric_type=64e7c28d8794b190158285d50cbb3547^state=ready^due_dateRELATIVELT@dayofweek@ahead@7^u_reminder_sent=false');

        gr.query();
        while (gr.next()) {
            gs.eventQueue('send_reminder_survey', gr, gr.user, '');
            gr.u_reminder_sent = 'true'; //  u_reminder_sent is a Boolean field
            gr.update();
            gs.log('Testing');
        }
    } catch (ex) {
        gs.info(ex);
    }
}

can anyone please help me here .

Thanks In Adavnce

[Sandeep Rajput]

@nameisnani Could you please check if the following GlideRecord query is returning any results.

var surv = new GlideRecord('asmt_assessment_instance');
    surv.addNotNullQuery('trigger_id');
    surv.addQuery('trigger_id', current.sys_id);
    surv.query();
    surv.next();

[nameisnani]

@Sandeep Rajput  

Where I need to check. Could you please help

[Sandeep Rajput]

Copy and paste the script in a background script replace current.sys_id with an actual sys_id and check if it returns any record.

[Anil Lande]

Hi,

Please try below and share logs?

(function runMailScript( /* GlideRecord */ current, /* TemplatePrinter */ template,
    /* Optional EmailOutbound */
    email, /* Optional GlideRecord */ email_action,
    /* Optional GlideRecord */
    event) {

    gs.log("AAAA Incident Number : " + current.number, 'sys');
    var surv = new GlideRecord('asmt_assessment_instance');
    surv.addNotNullQuery('trigger_id');
    surv.addQuery('trigger_id', current.sys_id);
    surv.query();
	gs.info('AAA Survey Query : '+surv.getEncodedQuery());
if(surv.next()){ 
    gs.log("AAA Incident from survey " + surv.number, 'sys');
    var params = current.number + "," + surv.number;
    //var subject = "survey:" + surv.number + " " + " " + "incident:" + current.number + " ";
    var subject = "Reminder:Please share your feedback on " + "Incident: " + current.number;
    //+ " " + ": Survey Number : " + surv.number;
    email.setSubject(subject);
    template.print('<a href="' + gs.getProperty('glide.servlet.uri') + '/sp?id=take_survey&instance_id=' + surv.sys_id + '"><img src="CSAT.png" width="280" height="55"/></a>');
}