Skip to main content
ashwinia3199
Participating Frequently
March 22, 2024
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
March 22, 2024

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
March 22, 2024

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