Dave, I know Misi has already guided you to one of her tools for achieving this, but I wanted to point out your qualification 'TR.Priority' != 'DB.Priority' will always be evaluated as true when DB.Priority is NOT NULL when there is no change to the Priority value when the DB.Priority value is NOT NULL, reason being TR.Priority will be NULL when there is no change and DB.Priority will be NOT NULL.
Joe D'Souza -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Dave.ARSList Sent: Thursday, October 04, 2007 4:44 PM To: arslist@ARSLIST.ORG Subject: HelpDesk Audit Hello listers, Is there a way to get a list of all the fields you are currently auditing on any given form? Possibly details of what you are auditing? Also, let's say you are auding certain things on HPD:HelpDesk form; If i un-audit some of those fields, would it affect the existing audit-records? I mean would it drop all those columns or keep the previously-audited columns and insert null now as you are not auditing them anymore? How does it work? Any help would be greatly appreciated. I's confusing because here's what we have on Audit tab of form properties of HPD:HelpDesk Audit Style: Log Enabled: Yes Log Form: HPD:HelpDesk_AuditLogSystem Qualification: 'TR.Priority' != 'DB.Priority' When i opened HelpDesk_AuditLogSystem form in user client: it only has one drop-down-> Staus! So does it mean the auditing is not enabled proper? Or should it be logging to HelpDesk_Audit form instead? How do I make sure what fields are being audited and where they are being logged and everything? Thank you, Dave. P.S: I've already voted :p No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.488 / Virus Database: 269.14.1/1051 - Release Date: 10/5/2007 12:27 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"