I have created a report, but on home page its showing the n number of records , but i want it show only the first 5 records.
i have restrict the record form the list layout, but it was applicable to all of the table.
is there any method so we can restrict the number of record to 5 only.
Thanks
Hi Tammy,
The script works with slight tweak, please find below script written on change management to limit report records to 5 entries
Script Include: Name: my_script_include
API Name: global.my_script_include
Client Callable : true
--------------------------------------------------------------------------------------------------------
var my_script_include = Class.create();
my_script_include.prototype = Object.extendsObject(AbstractAjaxProcessor, {
runReport : function()
{
var x=[];
var gr = new GlideRecord("change_request");
gr.addQuery("active", true);
gr.setLimit('5');
gr.query();
while (gr.next()) {
x.push(gr.getValue('number'));
}
return x;
},
type: 'my_script_include'
});
---------------------------------------------------------------------------------------------------------------
Report Condition should be based on the returning parameter, in above case it is Change id (number)
ID is one of javascript: new my_script_include().runReport()
Please hit like or mark helpful !
thanks,
Abhishek
