Skip to main content
ashwinia3199
March 22, 2024
Question

Not In operator not working in record filter

  • March 22, 2024
  • 9 replies
  • 0 views

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?

March 22, 2024

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