question Re: calling script include in report in Developer forum

calling script include in report

Deepthi13 — Mon, 15 Apr 2019 07:12:44 GMT

i tried in following way but when i RUN report 0 records where displaying, when i run same script in background script i am getting desired out put after printing. Please suggest.

please find my screen shot and script as below

Re: calling script include in report

Alberto Consonn — Mon, 15 Apr 2019 07:17:53 GMT

Hi,

please refer to the following threads, you will find useful information for achieve it:

https://community.servicenow.com/community?id=community_question&sys_id=54e043a5db98dbc01dcaf3231f9619ed

https://community.servicenow.com/community?id=community_question&sys_id=5c7043e1db98dbc01dcaf3231f961999

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

Thank you

Cheers
Alberto

Re: calling script include in report

Deepthi13 — Mon, 15 Apr 2019 07:20:36 GMT

hi alberto, i have seen that links and followed same way, but i need to modify script include probably can u check once script include

function getDupes(){
var dupRecords = [];
var gaDupCheck1 = new GlideAggregate('cmdb_ci');
gaDupCheck1.addQuery('active','true');
gaDupCheck1.addAggregate('COUNT', 'serial_number');
gaDupCheck1.groupBy('serial_number');
gaDupCheck1.addHaving('COUNT', '>', 1);
gaDupCheck1.query();
while (gaDupCheck1.next()) {
dupRecords.push(gaDupCheck1.serial_number.toString());
}
return dupRecords;
}

Re: calling script include in report

Alberto Consonn — Mon, 15 Apr 2019 07:32:34 GMT

The code seems okay, you have to change the condition in the report:

javascript: new ScriptIncludeName().getDupes();

Please try this.

Cheers

Alberto

Re: calling script include in report

Deepthi13 — Mon, 15 Apr 2019 07:36:09 GMT

Hi alberto ,

yes i changed to ( javascript: new getDupes().dupRecords(); )

but still facing same and i am getting 0 records, pls suggest

I want to get duplicate serial number cmdb_ci_computer records in report

Re: calling script include in report

Dubz — Mon, 15 Apr 2019 07:47:25 GMT

Have you marked your script include as client callable? That box must be ticked to be called in a report condition.

You don't need the class, you can call it as you were, script include should look like below:

Re: calling script include in report

Deepthi13 — Mon, 15 Apr 2019 07:52:06 GMT

hi david, still i am getting 0 records in report

please find script include as below, this is client callable

function getDupes(){
var dupRecords = [];
var gaDupCheck1 = new GlideAggregate('cmdb_ci_computer');
gaDupCheck1.addQuery('active','true');
gaDupCheck1.addAggregate('COUNT', 'serial_number');
gaDupCheck1.groupBy('serial_number');
gaDupCheck1.addHaving('COUNT', '>', 1);
gaDupCheck1.query();
while (gaDupCheck1.next()) {
dupRecords.push(gaDupCheck1.serial_number.toString());
}
return dupRecords;
}

please find report as below,

javascript : new getDupes().dupRecords();

Re: calling script include in report

Rahul Kumar17 — Mon, 15 Apr 2019 08:01:56 GMT

i have checked ur code is correct run in background script

var dupRecords = []; 
 var gaDupCheck1 = new GlideAggregate('cmdb_ci_computer'); 
 gaDupCheck1.addQuery('active','true'); 
 gaDupCheck1.addAggregate('COUNT', 'serial_number'); 
 gaDupCheck1.groupBy('serial_number'); 
 gaDupCheck1.addHaving('COUNT', '>', 1); 
 gaDupCheck1.query(); 
 while (gaDupCheck1.next()) { 
 dupRecords.push(gaDupCheck1.serial_number.toString()); 
 } 
 gs.print(dupRecords);

it's giving the value

56WHL71,AEX5635Z0001AC,L3BB911

only mistake this line

javascript : new script_include_name.method_name();

thanq

Re: calling script include in report

Rahul Kumar17 — Mon, 15 Apr 2019 08:04:08 GMT

don't use client callable

u pass the

javascript : new script_include_name.method_name();

thanq

Re: calling script include in report

Deepthi13 — Mon, 15 Apr 2019 08:07:33 GMT

hi rahul,

pls check below and suggest if some thing wrong in calling script include

my script include as below,

function getDupes(){
var dupRecords = [];
var gaDupCheck1 = new GlideAggregate('cmdb_ci_computer');
gaDupCheck1.addQuery('active','true');
gaDupCheck1.addAggregate('COUNT', 'serial_number');
gaDupCheck1.groupBy('serial_number');
gaDupCheck1.addHaving('COUNT', '>', 1);
gaDupCheck1.query();
while (gaDupCheck1.next()) {
dupRecords.push(gaDupCheck1.serial_number.toString());
}
return dupRecords;
}

i given as below in report

javascript : new getDupes().dupRecords();

Re: calling script include in report

Dubz — Mon, 15 Apr 2019 08:10:12 GMT

Confirm your script include is named getDupes and call it as you were:

javascript: getDupes()

this works on my PDI:

script include:

Report:

Re: calling script include in report

Deepthi13 — Mon, 15 Apr 2019 08:11:37 GMT

my method name is dupRecords() , is any thing wrong ?

javascript : new getDupes().dupRecords();

Re: calling script include in report

Dubz — Mon, 15 Apr 2019 08:12:55 GMT

You only call the script include name and then the function name liek that if you've defined a class for your script inculde. Have a look at the link below, it explains the difference and how and when to use them.

https://community.servicenow.com/community?id=community_blog&sys_id=88bce625dbd0dbc01dcaf3231f9619be

Re: calling script include in report

Rahul Kumar17 — Mon, 15 Apr 2019 08:26:23 GMT

yes,

it's working fine

Re: calling script include in report

Rahul Kumar17 — Mon, 15 Apr 2019 08:31:51 GMT

i think

it's wrong

dupRecords() is array variable name so don't pass variable name

Re: calling script include in report

Rahul Kumar17 — Mon, 15 Apr 2019 08:33:16 GMT

u pass the

javasript: new script_include_name.methode_name()

Re: calling script include in report

Rahul Kumar17 — Mon, 15 Apr 2019 08:38:15 GMT

hi,

it's working or not tell me

Re: calling script include in report

Dubz — Mon, 15 Apr 2019 08:38:27 GMT

Just to reiterate: you only call scriptIncludeName().methodName() if you have defined a class for your script include. Deepthi, you have written a classless script include so you need to call it as you were:

javascript: getDupes()

To confirm, you definitely need to have the client callable box ticked in order to call this in a report condition.

Re: calling script include in report

Rahul Kumar17 — Mon, 15 Apr 2019 08:44:23 GMT

sorry,

yes correct

call

javascript:getDupes();

thanq David Dubuis for remember me

Re: calling script include in report

Dubz — Mon, 15 Apr 2019 09:11:47 GMT

Deepthi, please confirm you've configured this as above. If you have it should now be working so please mark my answer correct to close the thread down.