The CreatorCon Call for Content is officially open! Get started here.

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