Business Rule Delete

[Avinash Dubey2]

Create a Business Rule which will trigger when record is deleted in Incident table then delete a record in Customer Incident table for that incident.

[Voona Rohila]

Hi Avinash

Did you try anyhting so far?

You can query the customer incident table which matches your current incident and delete the record.

use below logic in your business rule.

var gr = new GlideRecord('customer_incident'); //enter customer incident table name
gr.addQuery('parent_incident', current.sys_id); //modify proper field name.
gr.query();
if (gr.next()) {
	gr.deleteRecord();
}

[Avinash Dubey2]

Hi Rohila,

In this :

gr.addQuery('parent_incident', current.sys_id); //modify proper field name.

I have to add the incident table field ?

[Voona Rohila]

parent_incident - this is the customer incident table field which stores incident value.

[suvro]

So you can create an after delete Business rule and you can then GlideRecord the customer incident table to delete the corresponding table

var cInc = new GlideRecord('<nameof the table>');

clnc.get('<field_name_referencing_incident_record>', current.sys_id);

clnc.deleteRecord();