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;
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?
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:
WHEN HIST_CREATE_DATE > '2021-04-28'
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;
Hope it helps.
Thanks Aditya, it worked.