Criteria error in BPM query

Epicor ERP 10
1

So I am setting up a BPM and I have a condition by query. For some reason, using a condition filtering by a constant is giving me an error when trying to save the BPM. What am I doing wrong?

Here’s a screen shot of the query. I I remove the criteria, it saves and works fine, it just returns more than I want (Hence the criteria). It passes validation, but gives an error when I try to save it.

image.png976×626 38.6 KB

This is the error I get when trying to save.

image.png1144×566 117 KB

I’ve tried adding single quotes, double quotes, using =, = with the not check, matches. It all comes out the same.

Any ideas what I’m doing wrong?

2

Double quotes should do it, the Query here is no SQL but LINQ

3

Thanks. I could have sworn I tried double quotes, but I guess I didn’t. It works now.