Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Map Reduce to process more than 4000 search results
Hi There
I am trying to update 42000 project tasks using a map reduce.
I can't seem to find much online of how to modify the get input stage so that it processes more than 4000 search results.
So far, I have the following script
/** * @NApiVersion 2.x * @NScriptType MapReduceScript */define(["N/search", "N/record", "N/log", "N/runtime"], function ( search, record, log, runtime) { function getInputData() { var scriptObj = runtime.getCurrentScript(); // var projectName = scriptObj.getParameter({ // name: "custscript_project_name", // });
var projecttaskSearchObj = search.create({ type: "projecttask", filters: [["custevent_prj_tsk_exp_category", "anyof", "@NONE@"]],
columns: [ search.createColumn({ name: "id", label: "ID" }), search.createColumn({ name: "title", label: "Name" }), search.createColumn({ name: "company", label: "Project" }), search.createColumn({ name: "custevent_prj_task_item", label: "Item", }), search.createColumn({ name: "custevent__prj_tsk_exp_category", label: "Expense Claim Category", }), ], }); var searchObjPagedData = projecttaskSearchObj.runPaged({ pageSize: 1000, });
Tagged:
0