1 Reply Latest reply on May 24, 2019 1:35 PM by andrelerche

    updfield decoding

    sqlprojekt

      Dear community,

       

      Is there a key to decode 'updfield' field in sql server to get to know what fields have been changed and when for the last time.

       

      Just to give an example:

      0x260000005A1B7ACCF146601B9918F246611B9918F246741B433203477B1B29F5F8467C1B29F5F846

       

      Thank you in advance

        • Re: updfield decoding
          andrelerche

          Dear Marek,

           

          please understand that I cannot go into detail. But as a good start you could enable the log of SQL statements (for example via parameter -q:stmtlog) and then in mmba, define a condition on a field of your choice with option "Compare with" equals "Last Change".

           

           

          With this condition enabled, you can see in the log u8_Base_Username.log in system/db how the function PREFIX_UpdToDt is used to extract this information from column UPD_FIELD.

           

          Best regards,

           

          Andre