BAQ criteria not working

I am creating a BAQ and I am having an issue with my criteria. I want any of our sample parts to not display. I created a criteria in OrderDtl saying any “PartNum <> SAMP% constant” should be excluded yet it is still including PartNum’s that begin with “SAMP”.

Anyone able to shed light on why this is happening?

Set the operation to LIKE instead of <>, and check the Not checkbox.

2 Likes

I just tried this and it still didn’t work however that gave me the idea of Begins with the not checkbox and that worked. Thank you!

Set the operator to LIKE and enable the ‘Not’ checkbox… to effectively get ‘NOT LIKE.’