on-change expression

[Sukh Khehra]

I am trying to do this in my dbconfig file but it doesn't work. I am trying
to use one audit-trail-format for the "State" field if the "Priority" field
has changed and a different one when its not. But it appears that no matter
what, I get the first on-change action executed. any ideas?


field "State" {
...
on-change "Priority == oldpr:Priority" {
        add-audit-trail
        audit-trail-format {
                format "---------------------------------\n\
Change-Date: %s\n\
Changed-By: %s\n\
%s-Changed-From-To: %s->%s\n"
                fields { "$CurrentDate" "$EditUserEmailAddr" "$FieldName"
"$OldValue" "$NewValue" }
        }
}

on-change {
    add-audit-trail
        audit-trail-format {
                format "%s-Changed-From-To: %s->%s\n"
                fields { "$FieldName" "$OldValue" "$NewValue" }
        }
}
}



The information contained in this message is confidential and protected 
by law. If you are not the intended recipient, please contact 
the sender and delete this message.

Any unauthorized copying of this message or unauthorized distribution
of the information contained herein is prohibited.