Flex SQL - obtain a previous value

Hi,

I'm writing a post-update trigger on R5Orders and it'd be really handy to know what the previous ORD_STATUS was.

I've considered using R5AUDVALUES or storing the value in a User defined field and updating to being the 'previous' status every time the status changes (another Flex!) , but is there a recommended way to do this?

Thanks

Find more posts tagged with

EAM Development

Accepted answers

Legacy Contributor

R5AUDVALUES is the best way to record previous value for use with Flex. You can also use a UDF to hold previous value. Or, you can us Extensible Framework and process what you need done on the Client Side. EF is also useful for moving the last status to a UDF. Infor cautions against putting a Flex on R5AUDVALUES, so be sure the flex is on R5ORDERS.

All comments

Legacy Contributor

Thanks Michael. That's some good advice.

Given it's rare that I need to know previous value, EF would seem to be my preferred method.

Legacy Contributor

ps , is that infor caution against reading from R5Audvalues using flex? I must admit I've seen instances where Aud values doesn't seem to caputre events in exactly the right order. But I sort of can't believe what I'm seeing so just need to be cautious.

Legacy Contributor

Do not put a Flex on R5Audvalues … it really slows down the system. But, you can sure read the values. You should be able to look for the last Status change in your flex.
Again, if you can use EF for the Business Rule … you do have access to the current value and the last value.

Original and Current Value:

vFormPanel = EAM.Utils.getScreen().getCurrentTab().getFormPanel();
vOrigValue = vFormPanel.getOriginalFldValue(iName);
vValue = vFormPanel.getFldValue(iName);

Copyright © 2025 Infor. All rights reserved.