Find a deleted business rule

Shivani Khedek1
Giga Contributor

I have a Custom task table containing a field 'OWNER', on which I have applied a Business Rule which was supposed to mark a State to 'Closed Complete' as soon as if any change occurs in 'OWNER' field. By some reason I deleted this business rule and wrote another business rule similar to this for another field 'APPROVAL', then too I don't kmow how bt my old business rule is also working.

I searched for it into Business Rules table but as i have deleted it previously so i couldn't find it.

Can somebody help me to find its location and so delete it? 

Thank you,

Shivani

10 REPLIES 10

Chalan B L
Giga Guru

Any deleted records will be in the deleted records table.

Left Navigation --> Deleted records

Apply this filter -- sys_updated_by - contains - your name

Once deleted no longer it will be work please check if any other logic is working.!!!

 

Please mark the answer as correct if it helped you..!!

 

Regards,

Chalan

Priyanka136
Mega Guru

Hi Shivani Khedekar,

Check your "deleted records" on the "sys_audit_delete" table.

You could also check your update set or the default one if you did not create one, then you should be able to find the business rule you deleted, and in that find the script for the business rule.

You have to manipulate the XML and re import it, but I would rather:

1. If you have the business rule on another instance, import that one. If any changes have been made on the business rule, copy over those changes from the XML in the update set.

2. If you do not have the business rule on another instance, I would simply re-create it based on the XML information in the update set.

Business rule scripts are stored in "sys_script" table and by default system does not track deletion from tables which starts with prefix "sys" unless you add the table name in system property "glide.ui.audit_deleted_tables".

Therefore, if above property value in your instance does not include "sys_script" then you won't find it in deleted records and unfortunately cannot restore.

Let me know if you have any questions.

Please mark it Correct or Helpful, if it works based on impact....!!!!

Warm Regards,

Priyanka

find_real_file.png

www.dxsherpa.com

 

Pranay Tiwari
Kilo Guru

Hi,

Deleted BR will not work only Active & Current version BR Work.

so all BR which will work on your Form field will see when you open  configure BR,

Here you can see all BR which will affected.

and Field Watcher is also a good approach.

 

This custom table is extended by any other table??

because parent BR also affected

Priyanka136
Mega Guru

Hi Shivani Khedekar,

If you found my answer worthy, Please close this thread and mark it correct or helpful. So other can refer it easily.

Thanks,

Priyanka

find_real_file.png

www.dxsherpa.com

Shivani Khedek1
Giga Contributor

thank you all, issue is resolved.