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  

How to know which values could not be found using "is one of" filter option

Gaurav Tewari
Tera Contributor

I am trying to search for a list of values using "is one of" filter conditions. Suppose I enter 20 values in filter but SN returns only 17 records. I want to see which are the 3 values for which there is no data in system. Is there a way to find which are those missing values? For example in the attached screenshot I am trying to search for 5 change numbers out of which only 2 exist so I want to find which are the 3 changes which do not exist in system.

 

GauravTewari_0-1728474482468.png

 

0 REPLIES 0