Recently I came across a requirement where we needed a report which shows all the Incidents ever updated by a specific user. We needed a capability to filter those incidents by User, showing the changes which was made with date.
I achieved it using a database view using sys_audit and incident table and wanted to share it here. We can use any table we want to audit(change, problem etc). Below are the steps:
1. Create a Database view something similar to below
2. Add the required fields to both the tables.
3. Configure a list view something like below:
Please note that the user field is a string field so you may need to enter the user ID rather selecting from references.
