Filter out changes where an incident is attached
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-29-2025 09:02 AM
Hi, can someone tell me how to create a filter to pull out the change request having an incident attached to them?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-29-2025 10:06 AM - edited 07-29-2025 10:09 AM
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! */
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-29-2025 10:52 AM
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! */
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-30-2025 08:48 AM
@sanjeevtanw Any breakthroughs??
/* If my response wasn’t a total disaster ↙️ ⭐ drop a Kudos or Accept as Solution ✅ ↘️ Cheers! */