Fetch Old Values from a table field using event analytics and send to Custom BOD - MT CE

Hi,

On premise there is a possibility to get the old and latest values of field(table) in event analytics rules and put them in event data and post to MEC Custom BOD.

Is there any way on Cloud MT to get the same old value and retrieve the field data in MEC.

Example :

MMS001 - Item master (MITMAS) status (STAT) is changed from 10 to 20 .

Old value = 10

New value = 20 [STAT]

Regards,

Lakshmi.

Find more posts tagged with

General Discussions

Accepted answers

All comments

unknown

Hey Lakshmi,

You might have some better feedback within the M3 community forums or user group. However, you might want to take a look at M3 and its usage & replication patterns with Data Lake. M3 is replicating all state changes (new records, updated, and even removed/deleted records) to Data Lake where you're able to run SQL queries against the replicated M3 tables and influence the behavior to return de-duplicated datasets, all variations, and so on.

Maxime Richard

Hi,

This is the same in cloud. Here is an example of a standard EventAnalytics rule for ItemMaster testing old value of field MMSTAT.

unknown

Hi Maxime,

In an bod of UPDATE event to capture old values and new values and send them may be in UserArea in M3 Cloud.

But how do we capture/Store that and send it through the Output BOD. I am mostly asking from MEC mapping and ION flow point of view.

Have you worked on this scenario. I am having this use case from the customer

Maxime Richard

Hello Shashank,

In EventAnalytics, can you try to define a virtual field like this ?:

You should get it in the EventData.

unknown

Hi Maxime,

Thanks. Yes it worked. and I logged through mec mapping as well I can see the values printed.

So I can use the old values as well in an Update Event BOD.

Copyright © 2025 Infor. All rights reserved.