Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

Find CIs missing either of one of the parents with specific rel type in query builder.

GChe
Giga Contributor

I am able to use No relationships to create 2 separate queries to find any CI missing a specific parent each. I am also able to use AND and get the CIs missing both parents. However when I change the AND to OR, I am getting duplicate records, with results from each of the queries in the OR. How can I find those that are missing either one of  the parents. Thanks in advance for your help.

GChe_0-1758277223243.png

 

Also, is there a way to say missing a certain type of relationship rather than missing any relationship? 

0 REPLIES 0