can i use N/query in a map reduce script

AI generated answer (using internal Slack threads):

Yes, you can use the

N/query

module in a Map/Reduce script in NetSuite. The

N/query

module is used to execute SuiteQL and SQL queries in your scripts. In a Map/Reduce script, you can use

N/query

in the

getInputData

stage to run a SuiteQL query and return the results. You don't need to include the

N/query

module in your script if you're only using it in the

getInputData

stage. Here's a basic structure of how you can use

N/query

in a Map/Reduce script:

code block
/**
 * @NApiVersion 2.x
 * @NScriptType MapReduceScript
 */
define(['N/query', 'N/record', 'N/email', 'N/runtime'], function(query, record, email, runtime) {
    function getInputData() {
        var myQuery = query.create({
            // your query here
        });
        var resultSet = myQuery.run();
        return resultSet;
    }

    function map(context) {
        // your map function here
    }

    function reduce(context) {
        // your reduce function here
    }

    function summarize(context) {
        // your summarize function here
    }

    return {
        getInputData: getInputData,
        map: map,
        reduce: reduce,
        summarize: summarize
    };
});

In this example, the

getInputData

function is using

N/query

to create and run a query. The results of the query are then returned and can be used in the

map

,

reduce

, and

summarize

functions. If you want to use

N/query

elsewhere in your Map/Reduce script (in your

map

,

reduce

, or

summarize

functions), you would include the

N/query

module in your script and use it as you would in any other script type. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******