Skip to main content
ashwinia3199
Participating Frequently
Mar 22, 2024 1:26 PM UTC
Question

Not In operator not working in record filter

Hello,

In record filter not in operator is not working for multiple selection. 

for single selection is working.

If I passed IN operator, then working as expected. 

can anyone help me on this? please find code for reference.

9 replies

peter.lewis
Employee
Mar 22, 2024 1:38 PM UTC

Hmmm, isn't this expected behavior? Just to give an example, suppose I have 10 values in my list (1-10). If I use the operator "not in 1", that will return me 2-10. If I select both "not in 1" and "not in 2", that gives me the sets of 2-10 and 1 + 3-10. If you find the union of that list that returns all the values, so it's not filtering anything.

If that's not what you want, can you talk a bit more about your use case?

Participating Frequently
Mar 22, 2024 1:41 PM UTC

It seems the user wants to have the selected values excluded from the grid shown below