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.
+1 to the quesy feeling. But deletion generally gives me that feeling - I recommend against ever actually deleting. (which raises a different question: should there be a cascading de-activation?)