Showing posts with label How to track history or audit or changes done to specific table or form.. Show all posts
Showing posts with label How to track history or audit or changes done to specific table or form.. Show all posts

Tuesday, June 12, 2018

How to verify what are all the changes made on a specific table or form

This is a very common requirement to verify who and what all are the changes being done on a specific table or form.

For eg: I wanted to see what are all the changes made on Problem or Problem Task for last two weeks

- Run this list in application navigator  sys_update_xml.list
- Filter the data by Target Name, Table Name, Application, etc..  This will give you information about what are all the update sets loaded and by whom.

-If you need to identify all the changes on form layout, then
                        Select Type = =Form Layout
         Go through each entry payload and search for the specific field that you are looking for.
       


How to enable Audit at table level?

- System Definition -> Dictionary
- Filter the data by the table name, and modify 'Audit' field to 'true'