calling script include in report

[Deepthi13]

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

[Dubz]

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:

[Deepthi13]

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();

[Rahul Kumar17]

hi

don't use client callable 

u pass the 

javascript : new script_include_name.method_name();

thanq

[Dubz]

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

javascript: getDupes()

this works on my PDI:

script include:

Report:

[Dubz]

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.