How to list Incidents with a Related Change Request linked

J Moxy
Tera Contributor

I would like to list all the Incidents where, in the Incident Details form, in the Related Records section, a Change Request was added 

Untitled.png

 I ran the filter below on the Incidents table but no records are returned. 

 

Untitled2.png

I assume it is because there is a many to many relationship between the Incidents table and the Change Record table.

How would I create a list of all the incidents where there is a change request ?

 

Thanks

J

1 REPLY 1

GlideFather
Tera Patron

Hi @J Moxy 

check the task_rel_task table

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