Append or concatenate parameters for DB export

Existing Functionality

In DB export, only one optional parameter per table column could be exported.

For example: If Db export configuration is done with database table “db_export” having columns col1, col2, col3, then in col1/col2/col3 only one optional parameter could be exported.

New Functionality

User can now append two or more parameters to be exported from the UI in single table column.

For example: If Db export configuration is done with database table “db_export” having columns col1, col2, col3, then user can append two or more parameters say “BATCHCLASSID” & “BATCHINSTANCEID” to be exported in a single column.

Impacted Areas

  • Export Batch: If a batch is exported using DB_Export plugin in export module, then this functionality will help in exporting concatenated optional parameters.
  • Schema Changes: Two new tables “optional_index_field_parameters” and “optional_table_column_parameters” have been added in database.

Process

  • Add a connection in System Configuration stating the details of database where batch is to be exported.
  • Add DB_Export Plugin in batch class and switch on DB_Export Switch.
  • Add DB Export Configuration in respective batch class.
  • Optional Parameters can be concatenated by selecting the parameters to be concatenated, right click and select “Append” from context menu.

C:\Users\lipsysingla\Desktop\Capture.PNG

Note:

1) The order in which the fields will be appended will be same as the order in which they are selected from list of available parameters.

2) If a parameter has been added as an exported parameter, then it will not be removed from list of available parameters.

3) While removing any of the exported parameters, user will remove it by drag n drop the parameter to be removed in available parameter list, but that parameter will not be added again in available parameters list, as this list will always be the same.

C:\Users\lipsysingla\Desktop\2.PNG

  • Apply the changes.
  • Now execute a batch in this batch class.
  • Batch details with configured optional parameters should be present in database table.

Was this article helpful to you?

wikiadmin