@David Durst NetSuite record and search apis don't provide any kind of batch processing or updating. The only way to update is record-by-agonizing-record. You'd have to do a two-part solution: A search or query to implement the WHERE clause filter, then update all of the results in a loop, using the record.load/save or record.submitFields.

Soo....... a map reduce script 😞

pretty much, yes. i keep asking for batch processing, but they don't seem to care about that.

Do you know of a method of combining ResultSets for the getInputData stage of a MR?

I want that exact same thing. But no, not really. However, for some use cases you can use the ne Query API to create a workbook (pre-defined or dynamic) that can do multi-level joins. It cannot combine record types that don't have a shared parent or child relationship, or a direct parent-child relationship.

😱

I usually have to resort to SuiteAnalytics Connect for complex data-combination queries like this, then load them into a Map/Reduce script and process the results. Definitely not an automated solution, though