Compare two columns in a monitor

Hi,

I want to make a monitor that compare two columns from a M3 table, as opposed to a static value.

Specifically I want to check if there is a mismatch between the purchase price (PUPR) of a order line and the confirmed price (CPPR), and count the lines where this is the case in a monitor like this:

I was trying to find a way to make a custom API and filtering on a virtual field that checks for my condition, but I haven't found a widget that can filter the results of an API. I also looked for a query to use in the EXPORTMI.Select API.

Is there a query for enterprise search that can check for this, or does anyone have another suggestion on how this can be solved?

Find more posts tagged with

Infor Homepages

Accepted answers

All comments

Rene Bottern

I suggest to take a look at creating a 'Search API' instead using CMS015.

Calculated fields are easily created in CMS010 / AHS100.

fredrik

I did try this, but if I'm not mistaken you cannot search on that calculated field?
I also cannot find a way for the monitor itself to filter on this field or make a condition based on it, so it ended up just showing all of the results.

Maxime Richard

Hello,

Not sure you can achieve this easely.

I would have another approach:

create "something" that triggers anytime M3:MPLINE:U occurs (filtered on HasChanged(IBPUPR) OR HasChanged(IBCPPR))
This "something" updates a free field in MPLINE (IBUDNx, new numeric field) with the result of IBPUPR - IBCPPR value if and only if IBPUPR - IBCPPR <> 0. Update through PPS200MI/UpdLine should work even if the user is using PPS201 on the given PO line
Use your standard API to build your monitor by checking IBUDNx <> 0

This "something" could be an IEC mapping.

Rene Bottern

How about creating a Birst Widget against DataLake then?

You can also create a Widget in Mongoose, there you can build in almost any criteria you like for Filtering etc.

Copyright © 2025 Infor. All rights reserved.