Has anyone figured out a way to create BAQ criteria similar to “Not Like” or “Does Not Contain” for a string? We are SaaS, so can’t write the SQL code.
As an example, we have some part descriptions that contain the string “OBS” for obsolete and I’d like to exclude them from a number of queries. It would be easy if I could mark them as Inactive parts, but some still have inventory.
It can be something like:
select
[Part].[PartNum] as [Part_PartNum],
[Part].[PartDescription] as [Part_PartDescription]
from Erp.Part as Part
where (not Part.PartNum like ‘001%’)
I came across your post regarding excluding part numbers that contain specific text. I have the same situation. I’m trying to exclude certain part numbers that contain certain text. It’s interesting that you can do it with grid filters but, I can’t figure out how to do it in the BAQ criteria. We are also SaaS on 10.2.600.
Were you ever able to get it to work in the BAQ criteria?
Have a look at this link. These SQL wildcards drive the LIKE statement:
Thank you fine sir! The answer was there.
