I have a requirement where a custom field(u_sub_state_timestamp) should show the timestamp of the last change in another field(u_sub_state). For this I have created a business rule which updates the u_sub_state_timestamp with current date and time when the u_sub_state changes and it is working as expected. However I also need to update u_sub_state_timestamp field for older record by fetching the latest timestamp for u_sub_state from sys_audit table. The count of older records is close to a million.
What is the safest approach to acheive this.
