Can we not use NVL as part of a SuiteQL Condition?

SELECT id FROM customrecord_abc WHERE custrecord_id = 5521 AND NVL(custrecord_field_that_holds_numbers_but_is_sometimes_null, 0) <> 0

I don't know for sure, but you could drop the NVL and use WHERE field IS NOT NULL

WHERE (custrecord_field_that_holds_numbers_but_is_sometimes_null IS NOT NULL AND custrecord_field_that_holds_numbers_but_is_sometimes_null <> 0) ?

It feels like it should too, but you know - Netsuite?

what’s the error you are getting @XochisSketches ?

Yup. I think I found the problem @Clay Roper @jen. It would help if I passed the query as the right variable 😛

well yes

🍻

🍻

🍻