Skip to main content
Skip table of contents

Filtering multiples values in the same grid column

🤔 Problem

If you ever encounter an issue where a client is trying to filter multiples values in a grid column using the '|'(pipe) operator and they are claiming that the filters are not being applied, here is how to troubleshoot it.

🌱 Solution

So the first step would be to go to that same grid and type in the same values the client is putting.

  1. In this example, the client is filtering for multiple Api numbers in the NM 115 reporting results grid.

    image-20251015-192044.png
  2. You can ask for the string being inserted in the column filter, but the issue likely lies in the incorrect use of the pipe operator (|). In our system, this operator represents a logical OR. You must provide a value after the pipe; otherwise, it will match a blank condition and return all records.

    Therefore, always ensure that your filter does not end with a | and that there is a valid value after every pipe operator.

  3. ✅Correct way to use pipe:

    CODE
    3004526515|300312106900

    ❌Incorrect way to use pipe and all records will be returned:

    CODE
    3004526515|300312106900| 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.