Query the incident number from 'incident_temp' table based on removed Incident Number record from '

SAHITHIN
Tera Contributor

- Create a business rule 'Remove Temp Incident Rule' , This should execute only whenever any record removed from 'Incident' table. - Query the incident number from 'incident_temp' table based on removed Incident Number record from 'Incident' table - Remove the corresponding incident record from 'Incident_temp' table 

1 ACCEPTED SOLUTION

Vrushali  Kolte
Mega Sage

Hello @SAHITHIN ,

 

You can create a new before delete Business Rule on incident table : System Definition > Business Rule.

This BR will execute every time when the record will get deleted from the table.

You can write the script to remove the related record from incident_temp table as shown in below images.

 

VrushaliKolte_0-1716270155711.png

VrushaliKolte_1-1716270179347.png

 

If my answer solves your issue, please mark it as Accepted ✔️ and Helpful 👍 based on the impact.

 

View solution in original post

3 REPLIES 3

Kieran Anson
Kilo Patron

Hi,

Please don't just post a user story; it doesn't help us to help you. What are you stuck on that you need assistance for?

Vrushali  Kolte
Mega Sage

Hello @SAHITHIN ,

 

You can create a new before delete Business Rule on incident table : System Definition > Business Rule.

This BR will execute every time when the record will get deleted from the table.

You can write the script to remove the related record from incident_temp table as shown in below images.

 

VrushaliKolte_0-1716270155711.png

VrushaliKolte_1-1716270179347.png

 

If my answer solves your issue, please mark it as Accepted ✔️ and Helpful 👍 based on the impact.

 

It is not deleting the same record whichever we are deleting in the incident table.