Calling Script Include through Reports

Aruna Sree Yela · ‎07-18-2023

Hi,

I have a requirement to provide a report with incidents details where a location contains more than 3 incidents.

The Below snip is from incident table grouped by locations, hence I wanna give a report that contains only the incidents from highlighted locations( location contains >= 3 Incidents)

For test, I tried that from Fix Script I'm getting the output as expected. But when I call the same code from script include I'm getting only the incidents from first location. Here I'm providing the details of it.

FIX SCRIPT:

OUTPUT:

SCRIPT INCLUDE:

CALLING THE SCRIPT INCLUDE IN FIX SCRIPT:

OUTPUT:

Can anyone please help me to fix this issue.

Thank you

Ankur Bawiskar · ‎07-18-2023

@Aruna Sree Yela

got it

so update as this

function Stores_SI_AB(){
	try{
		var arr = [];
		var locationRec = new GlideRecord('cmn_location');
		locationRec.query();
		while (locationRec.next()) {
			var inc = new GlideRecord('incident');
			inc.addEncodedQuery('location.sys_id=' + locationRec.sys_id);
			inc.query();
			var count = inc.getRowCount();
			if (count > 3) {
				while(inc.next()){
					arr.push(inc.getUniqueValue());
				}
			}
		}
		return arr.toString();
	}
	catch(ex){
		gs.info(ex);
	}
}

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Aruna Sree Yela · ‎07-19-2023

Hi @Ankur Bawiskar ,

Thank you for the solution. I have a small query regarding this.

While I'm running the report it's taking too long to load that report, I feel that's due to fetching the sys_id's. Is there any possibility to avoid this situation.

Thanks

Aruna

Ankur Bawiskar · ‎07-19-2023

@Aruna Sree Yela

it will take time and will have performance impact since it's querying all locations and entire incident table

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Aruna Sree Yela · ‎07-19-2023

@Ankur Bawiskar ,

Here, I'm scheduling the report, this performance impact won't effect that right?