BAQ Where List ... NOT IN

Kinetic ERP
, , , , , ,
1

I am working to build a customization that allows for filtering out certain customers from a dashboard grid. The regular grid filters only allow for excluding one CustID - I need to remove 5-10.
I have a Chip Selector set up to choose the excluded Customers, and a Function to turn that result into a list:
image

…that then goes into the BAQ Where List.

Screenshot 2024-05-23 095056
Screenshot 2024-05-23 095056393×525 7.08 KB

Everything goes as expected until…

image
image1009×278 22.2 KB

When the change is detected and the BAQ executed again … it throws an error:

Errors in criteria parser for expression: sql_CustID NOT IN (1906,2135,227) Errors: invalid argument outside of criteria: @@@3@a@,@@@4@a@,@@@5@a@

So my question is … is NOT IN not permitted in Where List? Or is there something I’m putting in incorrectly?

2

It turns out that NOT IN is not a permitted operator – for some reason.
Leaving everything else the same, I don’t get the same error with IN or <> or =

So I will have to come up with a different solution to filter the grid :face_with_spiral_eyes:

3

I just got a chance to test a possible solution and it looks like if you add “NOT” to the beginning of your column that it should work, so “NOT sql_CustID” and leave the condition as “IN”. It’s similar to how Epicor structures their queries when you look at the Query Phrase area of BAQs.

2 Likes
4

OMG
What a horribly non-intuitive way of doing things!

Thank you, @GThom