Missing condition operator "is not one of"

reddy567
Mega Contributor

Hi All,

Could anyone please tell me how to get/add a "is not one of" condition operator into the filter conditions for the tables. I see that condition operator is not listed for all the tables.

Thanks,

Kranti

10 REPLIES 10

jaheerhattiwale
Mega Sage

@reddy567 Add like below

 

gr.addQuery("sys_idNOT IN"+sysIds);

 

NOT IN is the operator

 

Please mark as correct answer if this solves your issue.