Does mxiv_oentries = idmv_ovalue_basic_all

[former_member2987]

Hi Folks,

We have a small problem in our upgrade from 7.1 to 7.2 on an Oracle database.

In the 7.1 version we have the following query:

// Determine the change number of the last modification of deleted entries in *Old* entries: MXIV_OENTRIES

var oChangeNumber = UserFunc.uSelect("select max(cast(Changenumber as int)) from mxiv_oentries where mskey = " + mskey +

  " and cast(Changenumber as int) > " + previousChangeNumber + " and ChangeName = 'Delete'");

Which we have moved into 7.2 as:

var oChangeNumber = UserFunc.uSelect("select max(cast(Changenumber as int)) from idmv_ovalue_basic_allwhere mskey = " + mskey +

  " and cast(Changenumber as int) > " + previousChangeNumber + " and ChangeName = 'Delete'");

However ChangeName does not exist in idmv_ovalue_basic_all or even in idmv_ovalue_simple_all, however we did notice a ChangeType column which can have a value of 1 or 0.

Does ChangeName = Change Type? If so what value corresponds to ‘delete’? Or is there another table/view we should be referencing other than idmv_ovalue*?

Thanks!

Matt

[former_member2987 · Accepted solution]

We were able to resolve the issue, As we suspected, ChangeType is the new ChangeName, and was replaced with a numeric value. There is a table that defines these values, called mxi_changetype which has the following values:

    CHG_ID CHANGENAME                                       

---------- --------------------------------------------------

         3 Disable                                          

         4 Enable                                           

         0 Modify                                           

         1 Delete                                           

         2 Insert

Based on this we were able to adjust our queries from looking for ChangeName = 'Delete' to ChangeType = 1.