Create custom configurations (optional)- To customize your temporal database table's maximum date & time stamp in the psp_valid_to column, add the directive shown below within the <temporal> tag, replacing the red text with any value you would like to assign for custom configuration.
<max_datetime>2030-12-31 00:00:00</max_datetime> NOTE: If records already exist in your temporal database table and then the <maxdatetime> value is changed, any records that were previously timestamped in the psp_valid_to column will not be updated to reflect the newly entered <max_datetime> value. - You can customize the column names for the psp_valid_from and psp_valid_to columns by modifying the values within the <column type="from"> and <column type="to"> directives, respectively.
Show If |
---|
| - You can also setup precision fractional seconds for your temporal columns timestamps. In your agent.xml in the temporal tag, add the attribute precision_size. For example, <precision_size="3"> will result in a timestamp similar to "2018-09-08 17:51:04.123" whereas <precision_size="4"> will result in a timestamp similar to "2018-09-08 17:51:04.1234".
|
- As of Fluorine Plus Patch 9 (version 4.8.9), you you can choose to skip inserting duplicate entries by adding directive directive <skip_duplicates/> inside inside the <temporal> directive. Note that this With the <skip_duplicates/>, the Agent will check if the new record has the same updated (sys_updated_on) datetime as the latest record and if so, skip inserting that record into the table.
NOTE: This may affect the agent’s Agent’s performance as it checks with the database and does a comparison every time a message comes in. |