Unable to call script include in report

[Priyanka145]

Hi All,

I m having a script include to return the group members of assignment group, and below is the script.

I need to call in the report and trying like below but not working. Please guide in how to call script include in report

getSDgroupmembers: function()
{
var members = [];
var SDeskDK = gs.getProperty('ServiceDeskRemote');
var grmebr = new GlideRecord('sys_user_grmember');
grmebr.addQuery('group',SDeskDK);
grmebr.query();
while(grmebr.next())
{
members.push(grmebr.user.getDisplayValue());
}
return members;
},

type: 'ServiceDeskGroupMembers'

In the report, it is called as below and report is on incident metric table.

Value is javascript:new ServiceDeskGroupMembers().getSDgroupmembers() AND

Definition is Assigned to duration

[Ahmmed Ali]

Hi @Priyanka145 

Can you post screenshot of your script include and filter condition?

Thanks,

Ali

[Priyanka145]

Hi @Ahmmed Ali 

The script worked well now, im able to call the script include in report the way you have told by adding join in  the script. 

[sushantmalsure]

@Priyanka145 I have tried something similar and it worked for me on my PDI.

Only thing I have done is from script include i have returned 'return members.join();'

SI screenshot:

Report Screenshot

[pawan k singh]

If you have created the Script Include in ServiceNow version "Washington" and above make sure, you have checked the "Sandbox enabled" Checkbox. This will work.

Please mark my answer helpful if it helped you.

Regards

Pawan K Singh