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

Is there any simple way to return a suiteQL query from a map/reduce getInputData without having to iterate through data?

IIRC, you can return an object like `{ suiteql: 'query'}`

<@UD4BG0THC> This might help: <https://timdietrich.me/blog/netsuite-suiteql-mapreduce-script/>

<https://netsuite.custhelp.com/app/answers/detail/a_id/91329>

<@U856E2SEA> that example looks like it's running the query manually which is what I thought <@UD4BG0THC> wanted to avoid?

If you scroll down, the suiteanswer I linked above has an MR example - my memory wasn't quite right on the format but indeed you can just return a plain object reference to a SuiteQL query from `getInputData()`

from their example:
``` return {
            type: 'suiteql',
            query: suiteQL,
            params: [271]
        };```
where their query string is in the `suiteQL` variable.

Thanks both. <@U5375UUJ2> that's exactly what I was after. I thought there was probably a method, but it's not documented in the main getInputData help file.

Like many things NetSuite, I have no explanation as to why that's not part of the main `getInputData` documentation.

you can also feed `getInputData` a reference to a saved `query.Query` object (analytics workbook).
See below and <https://system.netsuite.com/app/help/helpcenter.nl?fid=section_4412447940.html#:~:text=query.Query%20Object%20Reference|NS Help: getInputData(inputContext)>
```return {
    type: 'query',
    id: 'custworkbook237'
}```