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

I have a custom record that has a field that can refer to a transaction. I want to get the status-text from the transaction.
Below will only give me those records that have a Transactions in that field
```SELECT
  CR."ID",
  BUILTIN.DF(CR.status)
FROM CUSTOM_RECORD CR
  LEFT OUTER JOIN "TRANSACTION" T ON CR."TRANSACTION" = T."ID"```
Below will give me all records, but only the "A", "B".... format for the status. It seems as if BUILTIN.DF() forces an inner join?
```SELECT
  CR."ID",
  CR.status
FROM CUSTOM_RECORD CR
  LEFT OUTER JOIN "TRANSACTION" T ON CR."TRANSACTION" = T."ID"```
Any tips on how to get the status-text in this case?

I had to skip standard joins and do it like this:
```SELECT
  CR."ID",
  BUILTIN.DF(CR.status)
FROM
  CUSTOM_RECORD CR,
  "TRANSACTION" T
WHERE
  CR."TRANSACTION" = T."ID"(+)```