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

Hey! Can you help me with my SuiteQL request. Now I can get Sales Orders with transaction status for customer:
```SELECT
    * Transaction.Status, BUILTIN.DF( Transaction.Status ) AS Status_Description
FROM
    transaction
WHERE
    type = 'SalesOrd' AND entity = 1
ORDER BY
    trandate DESC```
But I don't know how to get Project name for these orders. Can you help me?

I did it, here an example:

```SELECT
    *,
    BUILTIN.DF(t.status) AS status_description,
    j.entitytitle AS project_name
FROM
    transaction t
LEFT JOIN
    job j ON t.entity = j.id
WHERE
    t.type = 'SalesOrd'
    AND t.entity = 1
ORDER BY
    t.trandate DESC;```