Can we use custom body field as a filter?

Can you elaborate on this question?

I have a custom field on the sales order.

If the custom field type is Document, you will have issues. SuiteQL doesn’t seem to allow Document fields in either the select or where clauses yet

It is Integer

that should not usually be a problem

SELECT * FROM salesOrdered WHERE custbody_external_id = 1234;

what about

SELECT * FROM transaction WHERE type = 'SalesOrd' AND custbody_external_id = 1234

👆

Yeah, that was the problem.

I did nothing but am happy to take half credit 😉