And while I have not tested this out based on the docs I think it should be easy enough to get the "initial values" when auditing is turned on.
REF: Form-App-Objects-710.pdf, pg. 390 " The AR System audit feature lets you keep track of changes to data in a form. Any create, update, merge, or delete actions for data in a main form can be recorded in an audit form or log form. ... " So I think you could turn on auditing for the form. Then "Merge" all the data back into the form with the "Replace existing" option during the merge. If you were to do that for each and every record in the form then I would expect that to fill out the audit log data for the existing data. Maybe a tool like RRRChive could be used to do the "Merge in place" activities? Not that it would be a trivial time/processing investment (depending on your data volumn), but it sounds easy enough to do. (If it works as I expect it to work. ... testing needed...) -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On Fri, Dec 4, 2009 at 10:48 AM, LJ Longwing <[email protected]> wrote: > Alan, > As others pointed out, you aren't missing anything....but what you can do is > have auditing turned on, this will capture the first modification of a field > at submit. Then create a 'self join' of the audit form joining two > subsequent entries of each other....the first entry will contain the 'old > value', the second entry will contain the 'new value', and you won't need to > create workflow to get this information. To create the self join you may > need to use an SQL View...but the premise is basically the max(original > request id) where original request id is < original request id....this gives > you the last entry created for this record... > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of R. Alan Monroe > Sent: Thursday, December 03, 2009 6:19 PM > To: [email protected] > Subject: Am I not understanding auditing? > > I was experimenting with the built-in auditing for the first time on a test > server, in log mode. Unless I'm missing something really obvious, it seems > to just record the same thing in both the regular record and the log. For > example, if I change a serial number from 123 to 123a, I see 123a recorded > in both the record of the main form and the corresponding entry in the log > form. This seems completely worthless to me since I very much want to record > the FORMER value during audit, not the CURRENT value. What am I missing? > > Alan _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
