Delete a record using business rules

[BODDU SHIVA GOP]

Suppose we have two tables, table1 and table2. If we delete a record in table1, that record must be deleted in table2. please provide a javascript program for a business rule to delete a record..

[Community Alums]

Hi Shiva,

There must be a reference field on table 2 pointing to the table 1 record for the delete business rule to work.

Please create a delete business rule on Table 1

Run: Before (Delete checkbox should also be true)

Script:

(function executeRule(current, previous /*null when async*/) {

var gr = new GlideRecord("table2name");
gr.addQuery('table1referencevalue', current.sys_id);
gr.query();

while (gr.next()){
// deletes all records returned from above query
gr.deleteRecord();
}

})(current, previous);

Please let me know if this makes sense.

Thanks,

Enrique