How to create a map reduce script from saved search to delete records.

AI generated answer (using internal Slack threads):

To create a Map/Reduce script from a saved search to delete records, you can follow these steps: 1. Create a new Map/Reduce script in NetSuite. 2. In the

getInputData

stage, load the saved search that contains the records you want to delete. This will be the data that is passed to the Map stage. Here is a sample code snippet:

javascript
function getInputData() {
    var searchId = 'customsearch_my_saved_search'; // replace with your saved search id
    return search.load({id: searchId});
}

3. In the

map

stage, you will receive each record from the saved search. You can then delete each record using the

record.delete

method. Here is a sample code snippet:

javascript
function map(context) {
    var searchResult = JSON.parse(context.value);
    var recordId = searchResult.id;
    var recordType = searchResult.recordType;

    try {
        record.delete({type: recordType, id: recordId});
    } catch (e) {
        log.error('Error deleting record', e.toString());
    }
}

4. The

reduce

stage is not needed in this case, so you can leave it empty. 5. In the

summarize

stage, you can log the total number of records deleted. Here is a sample code snippet:

javascript
function summarize(summary) {
    log.audit('Number of records deleted', summary.inputSummary.count);
}

6. Deploy the script and schedule it to run. Remember to always test your scripts in a sandbox environment before running them in production. Deleting records is a permanent action and cannot be undone. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******