This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

if I have an item select field, can I get the text value of that field without joining to the item?
Can't find it in the docs, but my intuition would be something like:
```SELECT
    customrecord_example.id,
    customrecord_example.custrecord_itemfield.text
FROM
    customrecord_example```

`BUILTIN.DF(customrecord_example.custrecord_itemfield)`

AHA! thanks, I'd seen that around but didn't know what it was for

<https://system.netsuite.com/app/help/helpcenter.nl?fid=article_161950565221.html|SuiteQL Supported Built-in Functions>

<https://timdietrich.me/blog/netsuite-suiteql-built-in-functions-revisited/>