I'm trying to use r/Query to find all purchase orders pending receipt. I can do it in a Workbook just fine, but in suitescript when making a Transaction query, although the

status

column displays letters from A to H (with 'B' being pending receipt), if I try to use a query condition of

{ fieldId: 'status',  operator: query.Operator.ANY_OF, values: ['B'] }

I get 0 results. I have also tried the value 'PurchOrd: B' to no avail. Why does it work as a query column, and in the workbook, but not as a condition? Do I need different syntax? Idk what else to try out.

The status to use is

PurchOrd:B

Ohh i think i had a space between the : and B