Purging specific data sets

[derekalmond]

Has anyone done any work on purging data for a specific entity and all its relations.

ie, we store data for a fixed period of time, after which we purge the "case" and need to remove all its audit records including a fairly deep set of nested relations.

not everything is stored for the same period, so it's not just a case of deleting old entries - the cut off is defined by a specific action on each case which is extremely variable