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

TerryC03 · ‎03-07-2024

Would this still work if the application scope is not global? The application scope is Performance Analytics Content Pack for Essential SAFe.

Harish KM · ‎03-07-2024

Hi @TerryC03 When you create a script include in global scope ensure you select accessible from all scopes like below

and in your report condition call like this

in your report use in condition like this

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

Regards
Harish

TerryC03 · ‎03-07-2024

This does work. Thank you for the help! However, when I apply the report to an interactive filter on the "SAFe Team Dashboard", the sys_ids remain the same. I was hoping to change the 3 latest completed sprints according to SAFe Team.

Harish KM · ‎03-07-2024

Hi @TerryC03 i think you need to add one more query to get only closed complete sprints. add the bolded line to your script include, and try closing few sprints that should update your report data

var gr = new GlideRecord('sn_safe_sprint');
gr.addEncodedQuery('state=3');// get only close complete
gr.setLimit(3);

Regards
Harish

TerryC03 · ‎03-08-2024

That did not work, unfortunately. I'm looking for something more dynamic. For example, on the SAFe Team Dashboard, when the SAFe Team is selected, I would like to view its 3 latest completed sprints.