Activate logging migration script for changes

Overview

This guide shows you how to activate migration script logging.

Steps

1. Log in to the java back end with role “System Administrator”.
2. Go to settings.
3. Make sure “Log migration script” is ticked.
4. Make sure “Cache Windows” is NOT ticked.
   
   
5. Open window “System Config”.
6. Search for the name DICTIONARY_ID_COMMENTS.
7. In the field Value enter the label you want to log together with your changes later in the migration script, e.g., “Github Issue 123”.
8. Change something like, e.g., the name of a window.
9. Go back to the settings.
10. Hover over the “logged migration scripts” checkbox to see the path where the scripts are stored. Should be something like <your metasfresh client folder>/migration_scripts.
11. Go to the path and open the script folder.
12. You see your change in the form of an SQL statement together with your custom label, e.g., “Github issue 123”.

-- 2018-01-19T16:51:23.062
-- Github Issue 123
UPDATE AD_Window SET Name='Auftrag test',Updated=TO_TIMESTAMP('2018-01-19 16:51:23','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Window_ID=143
;