We are reporting off a historic RPS feed. We've just noticed that when a object deletion is recorded in the SQL database, all the fields are set to null. It would be preferable for our reporting to have the state of the object immediately prior to deletion.
For example if we have an Owner class and a Child class (with a myOwner property) where the owner has a collection of children, then a SQL query along the lines of
Select * from Child where Child.myOwner = "0123.456"
will not include the delete entries for any child that have been deleted as their myOwner column is set to null.
Has any one encountered this previously. I wonder if we can do a custom RPS mapping, but I'm not sure at what stage the JadeRpsDataPumpIF::updateCallback method is called. I would assume this is called immediately prior to the Commit Transaction in which case accessing the object that will be deleted will result in a Invalid Object Reference. Can anyone confirm this?
Thanks
Torrie