Auto Flush Rule on sc_request Will Not Delete the Related sc_task Due to Lack of Cascade Delete RuleIssue <!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Create a Table Cleaner rule on the 'sc_requests' table with the expectation to also delete the related record on the 'sc_req_item' and 'sc_tasks' tables. The related records in the 'sc_req_item' table are deleted. However, the related records in the 'sc_tasks' table are NOT deleted. Symptoms<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Expected behaviour: Create a sc_request recordHave a related sc_req_itemCreate a sc_task from the sc_req_itemThen manually delete the sc_request record from the UI. Observe: The sc_req_item record and sc_task record are also getting deleted when deleting the sc_request record manually. We expect this behaviour from the Table Cleaner also. Actual behaviour from Table Cleaner: Create a Table Cleaner rule on sc_requestCreate a sc_request recordHave a related sc_req_itemCreate a sc_task from the sc_req_itemThen run the Table Cleaner to delete the record with the number from sc_request.Observe: The sc_request and sc_req_item records are deleted, but not the sc_task record. This leaves the sc_req_item record orphaned. Release<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Tested in Yokohama P9 but applicable to all. Cause<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } UI deletion works correctly as it uses business rules, while Table Cleaner fails as it only follows explicit cascade rules.---Reviewing the cascade rules:The cascade behaviour we are expecting from the Table Cleaner Rule: sc_request → sc_req_item → sc_taskIn this case, when we delete a sc_request record, we will look to cascade to sc_req_item. This is present here at this link:https://<instancename>.service-now.com/sys_dictionary.do?sys_id=936632031b061010906ffc07cb4bcb2c&sysparm_record_list=nameINsc_request%2csc_req_item%2csc_task%5ereference_cascade_ruleINdelete%5eORDERBYname&sysparm_record_row=1&sysparm_record_rows=1&sysparm_record_target=sys_dictionary&sysparm_view=advanced&sysparm_view_forced=trueIn the record above for sc_request -> sc_req_item, we can see that the reference cascade rule is set to delete.In the case of the next step of sc_req_item -> sc_task (when deleting sc_req_item we look for a reference to sc_task to delete), there is no reference cascade rule setting to delete:https://<instancename>.service-now.com/sys_dictionary_list.do?sysparm_query=name%3Dsc_task%5Einternal_type%3Dreference%5Ereference_cascade_rule%3Ddelete&sysparm_view= Resolution<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Go to the dictionary record for the sc_task table and the column referencing sc_req_item. You can find the dictionary record here: https://<instancename>.service-now.com/nav_to.do?uri=sys_dictionary.do?sys_id=0c7a16f587911110cf8ba6880cbb359e%26sysparm_view=advancedGo to the Advanced view. Set the 'Reference Cascade Rule' to Delete After making this change, the cascade delete using the Table Cleaner rule will work the same as deleting a record from the UI, which is: sc_request → sc_req_item → sc_task.