Missing condition operator "is not one of"

reddy567
Mega Contributor

‎10-23-2017 02:50 PM

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

  • 21,219 Views
10 REPLIES 10

Jaspal Singh
Mega Patron
Mega Patron

‎10-24-2017 12:35 AM

I guess there is already another one with how to add a "is not one of" condition operator to the table. submitted by you,


0 Helpfuls

Sigval Bergesen
Tera Contributor

‎11-25-2020 06:32 AM

please do not quote me on this, but I would guess there should be a property for this, probably named something including the table name and field, having a comma separated value for all the available field query options. 

 

never the less, you can fake this to work as long as you just want to make a filter like this once in a while this works fine: 

make an is one of filter and run it, then in your url you should se this represented by the field name and then "IN" then after that all your values separated by comma.. just change the IN part to "NOT%20IN" instead and then hit enter to look up this modified url. now you'll see the option not one of 😉  

ceskie
Kilo Guru
In response to Sigval Bergesen

‎12-19-2022 03:35 AM

You, sir, are a true workaround connoisseur! I'd just humbly add, one can also group by any field following this logic. When field is too long and SN doesn't offer you the group by option, you can simply group by another field, then rewrite URL to contain desired field.

0 Helpfuls