Pulling action reason from audit logs to a derived field, not showing most recent

Debra Ford

I am trying to pull a terminate action reason to show on a form.

I have this for the derived field

FHTermReasonCode is a DerivedField

            type is Alpha size 80

            for each(AuditLog) audit log records

                if (not each.audit period.Future

                and   each.TerminationDate entered

                and (each.action = "Terminate"

                or each.action = "HRISTerminate"))

                    return each.reason code

on the form I put in first FHTermReasonCode

The employee had an action of HRISTerminate, then was rehired and then had an action for Terminate.  

The form only shows the HRISTerminate reason which was before the Terminate reason.  

Any Suggestions?

Thank you

2011-10-27_CH-Stammtisch_2.pdf

Chad Dirst

There is an enhancement request to loop through the audit log in a descending fashion which would solve this problem.  (i.e. for each(AuditLog) audit log records descending), however, not sure of its current status in multi tennant environment.  Outside of that, the alternative would be to set a local variable inside of your if condition and then outside of the loop you can return the local variable which would contain the last record that matched your if condition.  This is not ideal as it has performance implications and the long term solution should be to loop through the audit logic in descending fashion once functionality is delivered by Infor.