How to change the log module table

How to change the log module table

After creating the Scriptcase log module, it is possible to change the table.
When making this change, a new table will be created from scratch with no records. The records in the previous table must be migrated to your database.

How to edit log schema to change your table

1 - Access the menu: Modules > Log> Create / Edit Log module.


2 - Click on the icon highlighted in the image below to edit the logging scheme.


The log module edit screen will be displayed.


3 - In the log schema edit screen, enter a new name for the table in the Table field and click save.


4 - Then, the creation confirmation screen will be displayed.
Click the button, Close to save schema, to confirm the creation of the table and the change in the schema.


With this change, the log module will start saving data in the new_tb_sc_log table.

Changing table in the Log Report application

In the module> log menu, it is possible to create a grid application based on the log table.
If the application is already created, before changing the module table, it will be necessary to change the SQL or create a new application, so that the report is displayed correctly.

To change the SQL, follow the steps below.

1 - Access the application settings and click on the SQL menu, as highlighted in the image.


2 - In the SQL settings just inform the name of the new table and click on generate source code.
This change is possible only because both tables have the same field structure

    • Related Articles

    • Use of the log in Scriptcase

      We proceed to create a security module to use the log. 1 - Follow this tutorial to create a security module: https://www.scriptcase.net/docs/en_us/v9/manual/10-modules/02-security-module/ 2 - Proceed with the log in the top menu option Module > Log > ...

    • Change user "admin" permissions

      Many times it happens that we modify the permissions of the admin user, and when wanting to verify some configurations or when wanting to modify some characteristics of the ScriptCase we can not have access since the permissions were changed. So what ...

    • How to change the application's state in run time

      To change the properties of application execution, changing their form of execution than initially planned, Scriptcase has a macro called sc_apl_conf. The macro should be used as follows: sc_apl_conf ( Application , property , value ) ; So, we can ...

    • Update of the security module synchronization application

      In order to improve security in our projects, we made several changes to the application files. One of these changes affected a crucial file that tells applications how to sync. To ensure that the synchronization continues to work correctly, we made ...

    • Adding new columns in the table for Calendar

      If your calendar application is already created, we must add the fields below in the table so that the new functionalities work correctly: category int id_api varchar(255) id_event_google varchar(255) recur_info varchar(255) event_color varchar(255) ...