monarc-project
Change creator and updater fields values usage
Currently in the database we store creator / updater field values as text based on the logged in user first + last names. The challenge of this approach is that in case users change their names the tracking history is lost.
The solution is use the logged in user ID instead. In order to make the system modification work without any issues, we need to provide backward compatibility by adding those 2 fields to the database and keep the old fields. After a developed migration script will be executed and all the system will be consistent, we can add a new migration to remove the old string fields/
Additional context We need to prepare a migration script to update all new creator_id, updater_id field values with determined by first + last name users' IDs. In case if user name is complex (2 and more words), make some workaround (e.g. try to find by part of the name) and log those cases and log in a file cases, when we could not find a user to fix it manually later.
The creator and updater values are taken from the logged in email address of user for the most of the entities.