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

Why does the following code produces [] instead of [{"id": 12612}]?

``` // Test tranid of 'SO0000073'
      var sql = `SELECT id FROM transaction WHERE tranid='${tranid}'`;

      var result = query.runSuiteQL({
        query: sql,
        params: []
      }).asMappedResults();```

maybe a permission-related thing, depending on what user/role access the script is running in
(seems fine to me otherwise though)

Are you passing tranid to the query? Your parameters option is an empty array

I usually find it easier to make up the sql statement using + to join variables together, then pass that statement to the runSuiteQL function

I passed the tranid into the params option and used + to combine variables.

``` var result = query.runSuiteQL({
        query: 'SELECT id FROM transaction WHERE tranid = ?',
        params: [tranid]
      }).asMappedResults(); ```
Expecting below after running the SQL statement:
```[
  {
    "id": 12612
  }
]```
I'm receiving an empty object.

<@U3VNY94VB>, I updated the permission for sales orders and that worked!