Result difference from Email Notification script and Background script

[rajasekharteja]

Hello All,

I'm trying to redirect user to specific page url but in the url i need to pass assessment instance Id.

when i checked the below code it's getting Assessment sysid in background script but the same script when I tried using in email notification script it's not showing the sysid in logs also and in url.

Background Script :

 var current = '6142b8aa97628ad036b87fa71153afde';

 var userID = gs.getUserID();

    var instanceUrl = '';

    var surveySysId = gs.getProperty('feedback_survey'); //storing the survey sysid here

    var at = new GlideRecord("asmt_assessment_instance");

    at.addQuery("user", userID);

    at.addQuery("task_id", current);

    at.addQuery("metric_type=" + surveySysId + "^stateINready,wip");

    at.query();

    if (at.next()) { // using existing survey instance to render

        instanceUrl = at.sys_id;

        gs.info('@@@ ' + instanceUrl);

    }

Email Script:

  var userID = gs.getUserID();

    var instanceUrl = '';

    var surveySysId = gs.getProperty('feedback_survey'); //storing the survey sysid here

    var at = new GlideRecord("asmt_assessment_instance");

    at.addQuery("user", userID);

    at.addQuery("task_id", current);

    at.addQuery("metric_type=" + surveySysId + "^stateINready,wip");

    at.query();

    if (at.next()) { // using existing survey instance to render

        instanceUrl = at.sys_id;

        gs.info('@@@ ' + instanceUrl);

    }

    var link = '<a href="' + gs.getProperty('glide.servlet.uri') + 'audit?id=take_survey&instance_id= ' + at.sys_id + '"> here </a>';

    template.print(link);

Please help me to get assesment sysid in email script.

Result from Email Script where it's showing sysid as undefined.

Thanks,

Raj

[Mark Manders]

Have you tried 'at.addQuery("task_id",current.getUniqueValue()")

[rajasekharteja]

Hi Mark,

Thanks for quick response.

I tried by updating as per your input but it's still the same.

Updated Code:

var userID = gs.getUserID();

    var instanceUrl = '';

    var surveySysId = gs.getProperty('x_snc_coe.scalable_feedback_survey');

    var at = new GlideRecord("asmt_assessment_instance");

    at.addQuery("user", userID);

    at.addQuery("task_id", current.getUniqueValue());

    at.addQuery("metric_type=" + surveySysId + "^stateINready,wip");

    at.query();

    if (at.next()) { // using existing survey instance to render

        instanceUrl = at.getUniqueValue();

        gs.info('@@@ ' + instanceUrl());

    }

    var link = '<a href="' + gs.getProperty('glide.servlet.uri') + 'audit?id=take_survey&instance_id= ' + instanceUrl + '"> here </a>';

    template.print(link);

[Mark Manders]

Can you add logging to your script, because I am very curious what your variables return.

You are getting the userID from the currently logged in user (gs.getUserID()). But you are calling that from an email script to create a link. So the 'currently logged in user' probably doesn't return any useful user, or at least none to be found as user to whom an assessment instance is assigned.

[Isaac Swoboda]

I would have to agree with @Mark Manders. Using gs.getUserID() in the email script will not have a proper user SYS_ID as the notification engine is running this script and not the user who kicked off the action. You will need to use another field from the "current" record which will give you the user sys_id you are looking for, or kick off the notification from an event and pass in the users ID as a parameter in gs.eventQueue. This will require you registering an event as well in the system. Once you did that though you could use the event object from the mail script to retrieve the passed in User ID parameter.