Question about reference data

[JackieZhang]

I noticed some different to delete the data for reference data. Sometimes the main table will keep the sys_id and sometimes not. So how to set it if the reference data was deleted, the main table will keep the sys_id?

[Ankur Bawiskar]

@JackieZhang 

this article explains it well

Cascade Delete 

Configure cascade delete rules 

Recommendation

-> To keep the sys_id after deletion, do not set the rule to "Delete the reference."

-> Consider user experience: seeing raw sys_ids is usually not desirable. If needed, conditionally hide or alert when the reference can't resolve after deletion.

-> To modify this behavior, change cascade rules via the dictionary of the reference field.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[JackieZhang]

there is no cascade rule for it.

[JackieZhang]

I also checked the delete recovery. It is so weird

[JackieZhang]

I just tested my PDI and got the same issue.