How to log record deletions?

Maybe the implementation by the programmers is simply inconsistent from one table to the next. :man_shrugging:

Epicor programmers would never be inconsistent.

Wow this thread went for a spin.

Alright so @klincecum and I are seeing the ChangeLog records deleted, ie no longer present. I’m looking in SSMS, and this is specifically for LaborHed & LaborDtl records.
@JasonMcD says the ChangeLog records are not deleted…

Perhaps there is a setting somewhere?? Or maybe the ChangeLog functions differently for the PartRev table?

And could I get an answer to my above question:

Any reason I can’t just add a change log record directly via BPM? The record will be orphaned I suppose; is that an issue? And yes I’d still need a BAQ to see them.

I’m pretty sure he was saying you could “infer” the record in the main table was deleted
in the specific case where a new record would be created.

As far as I can tell, unless there is some type of custom programming somewhere,
when a record is gone, so are it’s logs.

(Any custom logic would have to be done on Epicor’s side, because you can’t write directly to the ChgLog table. At least I haven’t been able to.)

And let me twist it once more, improved logging is a part of this early Epicor Idea.

1 Like

Cool I just voted for the idea. I think you meant this one:
https://epicor-manufacturing.ideas.aha.io/ideas/ERP-I-1875

Oh, I meant the 3 digit one. :grinning:

I want to add a sink for out of the database and not just update the current one. I like the immutability. :person_shrugging: