Automation Script to test for Attribute Change of Value

Question

I am trying to write an automation script using javascript to test if the vendor was changed on a PO when the user tries to save it. I have seen some examples of testing for previous values when it was changed within the script but is there a way to test if it was changed before the script was executed? We use SQL Server and we had a trigger that would check the inserted and deleted tables to see if there was a change made but not sure how to do that here. I want to see if the values are different. Sometimes the user will change the value but before they save it they will change it back. Thanks for any advice given here.

Thanks,
Randy

Accepted Answer

While you can pull from the database, there is no need to do that here. The MboValue exposes an initial value that doesn't change.

vendor=mbo.getMboValue("VENDOR")
if vendor.getInitialValue().asString()!=vendor.getCurrentValue().asString():

That should let you know what it was read from the database compared to what it is currently.

Maximo Open Forum