Hi,
You can create a script include and call the script include in report.
For ex: Below is the script include function logic to get the list of incidents that a close notes length is less than 5 characters
Script include function:
getIncidents: function() {
var res=[];
var gr= new GlideRecord('incident');
gr.addEncodedQuery("incident_state=7");
//gr.setLimit(2);
gr.query();
while(gr.next())
{
var len= gr.close_notes.toString().length;
if(len<5)
{
res.push(gr.sys_id.toString());
}
}
return res;
},
Report condition:
Create a report on Incident table and set condition on sys_id field.
Below is the method to call script include:
javascript: new <<script include name>>.<<script include function name>>();
Ex Condition:
Sys ID is one of javascript: new getLen().getIncidents(); //getLen is the script include name and getIncidents is the function name.
If I have answered your question, please mark my response as correct and/or helpful.
Thanks,
Suseela P.
