I’m implementing a business case, where a patient resource should be deleted.
My question: Is there a way to obtain a list of all resources having a reference to this patient ?
I don’t want to turn off referential integrity, but neither I can’t query each single resource type that can have a reference to a patient. (60, 70?)
Yes, there is a cascading delete option, but to be honest, cascading delete is something that gives me always a queasy feeling.
Also, I could run a transaction and check the outcome, but that doesn’t help me in identifying the references.
Thanks in advance