Filter out changes where an incident is attached

sanjeevtanw
Kilo Contributor

Hi, can someone tell me how to create a filter to pull out the change request having an incident attached to them?

3 REPLIES 3

GlideFather
Tera Patron

Hi @sanjeevtanw 

 

change the URI and navigate to this links

  • For active incidents with associated change request:

https://your-instance.service-now.com/incident_list.do?sysparm_query=active%3Dtrue%5Erfc!%3DNULL

 

  • For ALL incidents regardless their state with associated change request:

https://your-instance.service-now.com/incident_list.do?sysparm_query=rfc!%3DNULL

 

EDIT: updated links

———
/* If my response wasn’t a total disaster ↙️ drop a Kudos or Accept as Solution ↘️ Cheers! */


@sanjeevtanw 

 

oh sorry, now I noticed that you want to filter these changes out...

 

then you can write a script with GlideRecord on the incident table (as per my link above) to get changes that are associated with incidents, and this query to apply to the change_request table, that the records are unfiltered in the secondary GR query

 

Please draft something and we can discuss it

———
/* If my response wasn’t a total disaster ↙️ drop a Kudos or Accept as Solution ↘️ Cheers! */


@sanjeevtanw Any breakthroughs??

———
/* If my response wasn’t a total disaster ↙️ drop a Kudos or Accept as Solution ↘️ Cheers! */