Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to get the output of the script include please help

Deepshikha Chak
Tera Contributor
function getPreviousGroupAssignment(groupName) { 
    var returnMe = [];
    var assignments = new GlideRecord('metric_instance');
    assignments.addQuery('definition','39d43745c0a808ae0062603b77018b90');
    assignments.addQuery('value',groupName);
    assignments.query();

    while(assignments.next()) {
        var reassignments = new GlideRecord('metric_instance');
        reassignments.addQuery('definition','39d43745c0a808ae0062603b77018b90');
        reassignments.addQuery('id',assignments.id);
	    reassignments.addQuery('start','<',assignments.start);
        reassignments.addQuery('value','!=',groupName);
        reassignments.orderByDesc('start');
        reassignments.query();
        reassignments.next();
        returnMe.push(reassignments.sys_id.toString()); 
    }
    return returnMe
}
6 REPLIES 6

Sagar Pagar
Tera Patron

Hi,

 

Could you please let me know where you have to get the out put of script includes.

Also, there should be semi-colon after returning the array.

 

Updated Scripts -

 

function getPreviousGroupAssignment(groupName) { 
    var returnMe = [];
    var assignments = new GlideRecord('metric_instance');
    assignments.addQuery('definition','39d43745c0a808ae0062603b77018b90');
    assignments.addQuery('value',groupName);
    assignments.query();

    while(assignments.next()) {
        var reassignments = new GlideRecord('metric_instance');
        reassignments.addQuery('definition','39d43745c0a808ae0062603b77018b90');
        reassignments.addQuery('id',assignments.id);
	    reassignments.addQuery('start','<',assignments.start);
        reassignments.addQuery('value','!=',groupName);
        reassignments.orderByDesc('start');
        reassignments.query();
        reassignments.next();
        returnMe.push(reassignments.sys_id.toString()); 
    }
    return returnMe;
}

 

 

Call script include as -

 

var result = getPreviousGroupAssignment(group_parameter);

 

 

Take a look at - On Demand Script Include 

 

Thanks,

Sagar Pagar

The world works with ServiceNow

Hi Sagar,

 

I wants to get the output in the widget.Please assist how can I achieve it.

Hi @Deepshikha Chak,

You have to use the data object in server side, call teh script include and use the result in HTML/ client s scritps.

 

Server side scripts -

data.result = getPreviousGroupAssignment(group_parameter);

 

HTML scripts-

data.result will contains the result, you can use it as per your need. You may iterate using ng-repeat and print/show it.

 

Client scripts -

Use result as

c.data.result to show/validate the results.

 

Thanks,
Sagar Pagar

The world works with ServiceNow

AnubhavRitolia
Mega Sage

Hi @Deepshikha Chak 

 

Please find updated script below:

 

function getPreviousGroupAssignment(groupName) { 
    var returnMe = [];
    var assignments = new GlideRecord('metric_instance');
    assignments.addQuery('definition','39d43745c0a808ae0062603b77018b90');
    assignments.addQuery('value',groupName);
    assignments.query();

    while(assignments.next()) {
        var reassignments = new GlideRecord('metric_instance');
        reassignments.addQuery('definition','39d43745c0a808ae0062603b77018b90');
        reassignments.addQuery('id',assignments.id);
	    reassignments.addQuery('start','<',assignments.start);
        reassignments.addQuery('value','!=',groupName);
        reassignments.orderByDesc('start');
        reassignments.query();
        while(reassignments.next()) {
        returnMe.push(reassignments.sys_id.toString()); 
    }
}
    return returnMe;
}

 

 

Please mark this as correct answer and helpful if it resolved, or mark this helpful if this help you to reach towards solution.

Thanks
Anubhav Ritolia
ServiceNow Rising Star 2023