Query to compare OITM and AITM to find UDF updates/changes

[Former Member]

I need to check when a certain UDF in the OITM was changed. Therefore I would like to receve help to build a query to link the OITM to the AITM and compare a UDF value.

[vasileiosfasolis]

Hi

you can try this in alerts

select * from aitm where updatedate=getdate() or

select a.ITEMCODE

,a.UDF

,b,UDF 

from OITM a

inner join AITM b on a.ITEMCODE =b.ITEMCODE

where a.UDF != b.UDF

instead of * you can insert the field (UDF) you want to check

[Former Member]

HI

Put this query as Alert and kepp the frequency as '2 minutes'

select t0.Itemcode,t0.udf1 as 'Value Changed',t1,udf1 as 'Previous Value' from oitm t0 inner join AITM t1 on t0.ItemCode = t1.ItemCode

where t0.udf1 <> t1.udf1