What will the order of execution of archival rules be? Will it archive related records first?

Sai Kumar
ServiceNow Employee
ServiceNow Employee

‎04-25-2023 04:50 AM - edited ‎04-25-2023 09:41 PM

  1. Will it first identify related records to be archived and then archive current ones? or will it archive the parent record and then consider the child records?
  2. What is the order of execution if the Archive related records have a reference table rule that also has Archive related records?

 

0 Helpfuls
  • 595 Views
1 REPLY 1

Punit S
Giga Guru

‎04-25-2023 08:46 PM

In ServiceNow, when archiving a record with related records, the related records are archived before the parent record is archived. This ensures that all related records are properly archived and data integrity is maintained. ServiceNow achieves this through a process called cascading deletion.

Cascading deletion is a process in which the system identifies all related records and deletes them before deleting the parent record. This process ensures that all related records are properly archived and any dependent records are not left behind or orphaned. This approach is used for both archive and delete operations in ServiceNow.

In the case where Archive related records have a reference table rule that also has Archive related records, the order of execution is determined by the configuration of the reference table rule. The reference table rule determines the relationships between tables and how they are processed during archive operations.

ServiceNow provides several options for configuring reference table rules, including the ability to specify the order in which related records are archived, and to define conditions that must be met before related records are archived. This allows administrators to tailor the archiving process to meet the specific needs of their organization.

Overall, ServiceNow uses cascading deletion to ensure that related records are properly archived before the parent record. The order of execution for archive related records with a reference table rule is determined by the configuration of the reference table rule.

 

Please mark my answer as a solution/helpful in case it adds value and moves you a step closer to your desired ServiceNow solution goal.

Thanks,
Punit