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.
In this example, the client is filtering for multiple Api numbers in the NM 115 reporting results grid.

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.✅Correct way to use pipe:
CODE3004526515|300312106900❌Incorrect way to use pipe and all records will be returned:
CODE3004526515|300312106900|