...
| Parameter Path/ Type | Description | Value | Mandatory | Default Value used if not mandatory |
|---|---|---|---|---|
Root Node: FILE_PROCESSING.XML | ||||
| RECORD_RETRIEVE_SQL | ||||
String | SQL query to load the records from the Database tables, which are to be exported into the XML file. This SQL string can contain the label <BILLING_SOURCE_ID> which will be replaced with appropriate value at run-time. If the SQL query string contains the label <BILLING_SOURCE_ID>, it will be replaced with the ID of the current source record currently being processed to create the XML file. Note: The billing source table name is configured in the column BILLING_SOURCE_TABLE_NAME of the table CDR_FILE_DEF. <BILLING_SOURCE_ID> will be replaced with the ID of the current row being processed from the table configured in the column CDR_FILE_DEF.BILLING_SOURCE_TABLE_NAME. | Example: Select vr.* from VOUCHER_EXPORT_RECORD vr where vr.VOUCHER_EXPORT_SOURCE_ID = <BILLING_SOURCE_ID> order by vr.id | YES | |
RECORD_RETRIEVE_SQL_WITH_ID_GREATERTHAN_CLAUSE | ||||
| String | SQL query to load the next batch of records with ID greater than the last loaded maximum ID, which are to be exported into the XML file. This SQL query can contain the tags <BILLING_SOURCE_ID> and <MAX_LOADED_ID> labels which will be replaced with appropriate values at run-time
| Example: Select vr.* from VOUCHER_EXPORT_RECORD vr where vr.VOUCHER_EXPORT_SOURCE_ID = <BILLING_SOURCE_ID> and vr.id > <MAX_LOADED_ID> order by vr.id | YES | |
Important Note: It is mandatory to setup both parameter tree entries RECORD_RETRIEVE_SQL , and RECORD_RETRIEVE_SQL_WITH_ID_GREATERTHAN_CLAUSE, because the File processor XML filler classes are configured to load only a maximum 10000 records in one select. If there are more records in the that database table, and we want to add them to the XML file, the reload_method column of of the relevant xml_tag_def entry must be set to 'reloadRecords'. If it is setIn that case, after printing the first set of 10000 records, the GenericXMLFiller tries to load next batch of records, having the ID greater than the ID of the last retrieved record in the previous step.
...