Script Include calling Issue in Report

[Community Alums]

Not able to get the script include values in the report
Values is showing as NULL

Code Snippet :

var test = Class.create();

test.prototype = Object.extendsObject(AbstractAjaxProcessor, {

    getMyid: function() {

        var arr = [];

        var gr = new GlideRecord('incident');

        gr.addQuery('sys_id', '57af7aec73d423002728660c4cf6a71c');

        gr.query();

        if (gr.next()) {

            // gs.info("Incident number: " + gr.number);

            arr.push(gr.sys_id.toString());

        }

        return arr;

    },

    type: 'test'

});

[SanjivMeher]

I think in your script include, this is all you need and remove everything else. Then try in your report.

  function getMyid() {
        var arr = [];
        var gr = new GlideRecord('incident');
        gr.addQuery('sys_id', '57af7aec73d423002728660c4cf6a71c');
        gr.query();

        if (gr.next()) {
            // gs.info("Incident number: " + gr.number);
            arr.push(gr.sys_id.toString());
        }
        return arr;
    }

[Community Alums]

I tried but its returning NULL

[SanjivMeher]

Make the script include name identical to the function name. 

So script include name should be getMyid and in the report, just call javascript: getMyid();

[Chaitanya ILCR · Accepted solution]

Hi @Community Alums ,

Check the Sandbox enabled checkbox on the script include and try

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya