Access deleted projects, assignment and tasks

[kernel]

I need determine if a project and any of its assignments or tasks have been
modified, deleted or inserted. Using PSI I see how to access inserted and
modified but not deleted. Can I use the shadow database or reporting database
to determine if a task, assignment or project has been deleted?
Other suggestions to solving this?

 

[Bryant Likes]

I need determine if a project and any of its assignments or tasks have been
modified, deleted or inserted. Using PSI I see how to access inserted and
modified but not deleted. Can I use the shadow database or reporting
database
to determine if a task, assignment or project has been deleted?
Other suggestions to solving this?

The *_SHADOW tables is the best way to solve this. That is what I use in the
solution I'm working on.

 

[kernel]

But can I count on the data being in the shadow table? i.e. Is the shadow
table purged on time time interval?

 

[Bryant Likes]

But can I count on the data being in the shadow table? i.e. Is the shadow
table purged on time time interval?

I'm not sure on if/when it is purged. I know it is there prior to the
published event. So what I do is on the saved event I create a tombstone
record for every item in the shadow table that has the deleted_rev_counter
equal to the project's mod_rev_counter. Then on publish I delete the task in
my tracking database.