hi, I am trying to create a message (email) showing what has been changed when an update is made to the Vendor Bank file. I have the condition to determine it there are changes, I am able to send an email with the changed data, however, I cannot figure out how to show the original data.
Help!!
Thank you
Hi Wayne.
I cheated. I wrote a BPM on the ChgLog table which contains the before and after values and send the email from there. It’s important to quickly exit the directive since data directives are called often for ChgLog.
Hi Mark, I tried looking at this, however, ICE.ChgLog only shows what field was changed and what it was changed to. Chglog.LogText =
whaire 14:35:11
RowMod: → U
Address3: → test Address 3
Hi, Never mind – I found it – looks like it is not there because
I changed from empty string to something - so old value is empty
Right. If you only want changes, add a condition for changed rows only. You may want to know the initial value too, of course.