Hi all, FYI, there is a useful SuiteQL function for casting NS booleans:

BUILTIN_RESULT.TYPE_BOOLEAN()

Thanks to @Clay Roper we know it returns 3 statuses: 1.

true

for 'T' 2.

false

for 'F' 3.

null

for field being never set

Thanks for sharing! I notice that it still has the behavior of reporting as

null

instead of false for the value of a custom Check Box field on a record when the record hasn't been edited and saved since the introduction of the custom record into an environment, so you can wind up with three states: true / false / null. Good ol' Netshoot...

Thanks for confirming behavior of this scenario! NS inconsistency is legendary.

Oh ---- that’s actually kinda GREAT. NULL is better than FALSE for not being set. In SuiteScript you get false (I think? or ‘F’) which is NOT the same thing as “never set”.

@jen I often get 'T', 'F', or null in SuiteScript Edit - I'm tired and just realized you might mean via the record API such as

record.getValue()

...