Activate logging migration script for changes

Overview

This guide shows you how to activate migration script logging.

Important:
You need to have an ID server configured for this to work! If no ID server is configured in “System Config” then you will not see the checkbox.

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
;

View source file on GitHub.com