Is it possible to delete a parent record and depen...
# suitescriptn
Nicholas Penree
08/27/2021, 8:52 PMIs it possible to delete a parent record and dependents using record.delete?
j
jen
08/27/2021, 8:54 PMYou’d have to do the children first.
n
Nicholas Penree
08/27/2021, 8:55 PMgotcha, so i need to do a search for child records by parent id and then delete each of those separately, then remove the parent?
✅ 1
Nicholas Penree
08/27/2021, 8:55 PMis there a way to do that atomically?
s
Sandii
08/27/2021, 9:04 PMI don't believe there is any sort of automatic cascade deletion.
n
Nicholas Penree
08/27/2021, 9:12 PMI just don't want to leave the parent/children in an inconsistent state if one of them fails, is there a way to wrap that in a transaction of sorts
j
jen
08/27/2021, 9:20 PMnot that I’m aware of
n
Nicholas Penree
08/27/2021, 9:20 PMbummer, thanks
Nicholas Penree
08/27/2021, 9:20 PMI did get it working but it feels brittle if anything goes wrong with a single record
j
jen
08/27/2021, 9:25 PMwelcome to NetSuite
😅 1
11 Views