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

[SAHITHIN]

- 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 

[Kieran Anson]

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 · Accepted solution]

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.

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

[Divya Ravikumar]

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