4 Replies Latest reply on Apr 29, 2021 4:18 AM by Arun Kumar

    Event before and after in IDD History

    Arun Kumar Guru

      Hello,

       

      One of the column value got overwritten in our BO tables and i can see those in IDD History tab as Event Before and After. Is there a way to see this from the back end tables? If so which table i can access? I need to see the specific column value changed before and after and date changed.

       

      Thanks,
      Arun

        • 1. Re: Event before and after in IDD History
          Aditya Mandal Active Member

          Hello Arun -

           

          Do you want to see history of any column value for any golden records (BO) from the backend ?

          If yes, you will get the details from history table:

          Select * from <BO_TABLE>_HIST

          WHERE ROWID_OBJECT='<>'  ORDER BY HIST_CREATE_DATE DESC;

           

          If you want to see the history for any specific source record, you will get the details from HXRF table

          Select * from <BO_TABLE>_HXRF

          WHERE ROWID_OBJECT='<>' AND PKEY_SRC_OBJECT='<>'

          ORDER BY HIST_CREATE_DATE DESC;

           

          Regards,

          Aditya

          • 2. Re: Event before and after in IDD History
            Arun Kumar Guru

            Hi Aditya,

             

            Thank you for the Information. If i go by Row Id, i need to select one record at a time. We have over 2000 records (guesstimate) that are overwritten on a certain date.

            I need to see the before and after value of a field named Category for that particular date.

             

            Is that possible?

             

            Thanks,
            Arun

            • 3. Re: Event before and after in IDD History
              Aditya Mandal Active Member

              Hello Arun - Yes, that is possible. You will need to write sql query to fetch the required details from the database.

              Here is one sample query:

              Select HIST_CREATE_DATE,ROWID_OBJECT,ORGANIZATION_NAME,

                   CASE

                        WHEN HIST_CREATE_DATE > '2021-04-28'

                                   THEN 'AFTER'

                                ELSE 'BEFORE'

                   END STATUS

              FROM C_PARTY_HIST

              WHERE ROWID_OBJECT IN ('1','2')

              AND HIST_CREATE_DATE BETWEEN '2021-03-02' AND '2021-04-29'

              ORDER BY ROWID_OBJECT,HIST_CREATE_DATE DESC;

               

              Output:

              screenshot

               

              Hope it helps.

               

              Regards,

              Aditya

              • 4. Re: Event before and after in IDD History
                Arun Kumar Guru

                Thanks Aditya, it worked.