Reporting on when field values are updated
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-19-2017 04:15 PM
I have a requirement to produce a report of all Risk (grc_risk) records that have had the 'Description' field updated during the past month.
I could create a new date field in the table and use a Business Rule to update date it with the current date whenever the Description field changes, but I figure that there aught to be a better way. I have been told that I should be able to use a Metric to capture this information but I've not created custom Metrics before and all the examples are based on capturing a duration, not a single point in time.
Any suggestions for how to best accomplish this would be appreciated.
Regards,
Robin
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-22-2017 01:00 PM
I'm afraid that I don't quite understand. It's not the risk field that I'm trying to track, it's the description field on the table grc_risk