I have a table named “AreaOfExpertiseAOE” that contains the following columns:
AOE (type ref)
ProductLevel (type EnumList)
Depending on what is chosen from the AOE the ProductLevel is populated with the appropriate products.
What I am trying to do is record all the changes that happen when editing AOE and ProductLevel fields for a particular Employee.
I have set up an “Action” to “Data: Add a new row to another table using values from this row” from “AreaOfExpertise” table to a table called “Edits”.
Set these columns:
UniqueID = UNIQUEID()
Employee_ID = [Employee_ID]
LastName = [LastName]
FirstName = [FirstName]
I am unsure how to capture the changes to AOE and ProductLevel fields. I have tried using the following in Expression Assistant.
AOE = [_THISROW_BEFORE].[AOE]
ProductLevel = [_THISROW_BEFORE].[ProductLevel]
However, when I do that the system displays the following error "Unable to find column ‘THISROW_BEFORE’
Could you please provide guidance on how I capture the previous values of the AOE and ProducLevel fields for a particular employee?