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

    updfield decoding

    sqlprojekt Novice

      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:



      Thank you in advance

        • Re: updfield decoding
          andrelerche Novice

          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,