getInputData can't chew through enough of the reco...
# suitescript
c
getInputData can't chew through enough of the records via a cache dataset, chokes, dies
m
SuiteAnswers 40768 may help. you can contact NetSuite support and they can enable Mass Deletion for you.
👍 1
e
What about returning less records from your saved search? Just add a couple of filters in your saved search. Then run multiple times your map/reduce as needed.
c
Unfortunately it’s abstracted as I can get it from filtering.. so I might just dynamically chunk it (only do even/odd internal IDs 😂)
d
if you have the BFN SuiteApp "SAFE" guide for reference, there is a section Using Parent-Child Relationships to Perform Mass Create/Update you can potentially use similar "hack" of creating dummy parent-child relationship to execute mass delete in bulk as well (where only involves adding/removing Custom record as children to dummy parent, so is much less governance and I assume quicker performance in theory) just threw together a mock script in demo account, created 10K custom records in ~1.5min and deleted them in ~1min just via script debugger using this method, but individual account performance might vary
c
Great idea for a future implementation
Can’t use it now because the schema is already set
d
gotcha guess I would have to understand whole usage of the custom rec, but seems could still temporarily tie it to a dummy parent without being invasive or really affecting anything else during bulk delete execution - but I totally get situations where cannot have full control :)
b
I would try outputting the list of internal IDs to delete to a CSV using the Task Module and then load it in script and read line by line to delete each record