How to call a script include / server script through reports?

This article describes using reports to call a script include.

JavaScript that runs on the server is stored in script includes. You can include an existing script from a script or even a report.

Typically, reports are used to pull data based on existing or current values. The reporting requirement may become complex at times, and we may be unable to use the conditions to obtain the desired results.

You might need to use a script include to get the result (dynamic records).

1. Use the sys_id column to get dynamic records. In report have the following condition,

   sys_id is javascript:new ReportUtils().getRecords() 

   where "ReportUtils" is the script include name and getRecords is the function name in the script include.
   
   
2. You can even go through the below KB's for few examples:
   • Create a report on users having multiple assets
   • Report on alm_asset table with users having more than 1 asset
3.  Create a business rule and call the function defined in the business rule.
   
   For example, refer the OOB business rule "getMyApprovals". It has a function "getMyApprovals".
   You can call this script using the below syntax:

   Approver is javascript:getMyApprovals()