Client Callable Script Include returning null

TerryC03 · ‎03-07-2024

Hello,

When I enter my script include into a report, the sysID is returning null.

What would be the reason for this? Below is my script include:

Harish KM · ‎03-07-2024

Hi @TerryC03 tested in my PDI, works fine now. Follow the below steps

1. Create a client callable script include like below

latestSprint: function(){

var sprintID;

var answer = []; // since you want more than 1 record use array to push values

var gr = new GlideRecord('sn_safe_sprint');

gr.setLimit(3);

gr.orderByDesc('sys_updated_on');

gr.query();

while(gr.next()){

answer.push(gr.getValue('sys_id'));

}

return answer.toString();

},

in your report use in condition like this

sysid ISONE OF javascript&colon; new scriptincludename().latestSprint()

result:

Regards
Harish

View solution in original post

SanjivMeher · ‎03-07-2024

Is there a reason you marked the script include client callable?

You should be using a server side script include.

Also in you script include, you are not setting the sprintID with the sysid inside the while loop. after gs.log, you should set the sprintID.

And in the report, while calling, it should be new sprintUtil().latestSprint(). So you are missing () after the sprintUtil

Please mark this response as correct or helpful if it assisted you with your question.

TerryC03 · ‎03-07-2024

It's client callable to use javascript&colon; new sprintUtil().latestSprint() in the report filter. Is there a such thing as a "server-side" script include? How should I set the sprintID?

SanjivMeher · ‎03-07-2024

Yes. Create a new ScriptInclude with Client Callable unchecked and write you function there. And then call it from the report as javascript&colon;new scriptName().functionName();

Also inside the while loop, use sprintID=gr.sys_id; to populate the sprintID which you will use in the report.

Please mark this response as correct or helpful if it assisted you with your question.

TerryC03 · ‎03-07-2024

Ok. I will try it soon. Thanks.