Thanks Misi. I tested, I tried setting the field to NULL and it did not capture "Value changed from A to ". As I would still like to capture when value changes from value to a null value. Although, it did capture "Value changed from to A".
I only want to exclude this from Audit Log - "Value changed from to ". Thanks! On Tuesday, December 4, 2012 2:19:03 AM UTC-8, Misi Mladoniczky wrote: > > Hi, > > The string you suggested tracks ALL changes, regardless of API or client: > 'field' != 'DB.field' > > If you want to skip the situation where a field is set to NULL, just do: > 'field' != 'DB.field' AND 'field' != $NULL$ > > My recommendation is actually to NEVER use the 'TR.field' value, except in > very rare circumstances. And definitely not if you are looking for changes > to a field. 'TR.field' has NOTHING to do with changes. > > Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) > > Products from RRR Scandinavia (3 x Best R.O.I. Award at WWRUG10/11/12): > * RRR|License - Not enough Remedy licenses? Save money by optimizing. > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. > Find these products, and many free tools and utilities, at http://rrr.se. > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
