Modify data retention policy for ATF test results

Modify the Auto Flush data retention policy, which designates how long the system retains data, and referencing data, for test and test suite results. You can change the frequency of flushing for the sys_atf_test_result or sys_atf_test_suite_result base tables. This setting controls how far back in time test result data is available.

Before you begin

Role required: atf_test_admin

About this task

The system regularly flushes data in the sys_atf_test_result and sys_atf_test_suite_result base tables, (and optionally, referencing data). By default, the system deletes test and test suite results data 30 days after creation. This task enables you to modify the Auto Flush retention policy for data stored in a specific base table (sys_atf_test_result or sys_atf_test_suite_result).

Procedure

  1. Navigate to All > Automated Test Framework > Administration > Table Cleanup.
    The system displays a list of the retention policies (Auto Flushes) it maintains for automated testing results tables.
  2. Select the retention policy (sys_atf_test_result or sys_atf_test_suite_result) to modify.
    The system displays the record for this retention policy.
    Note: The Tablename field displays the name of the table to which the selected Auto Flush retention policy applies. Selecting another tablename in this field compromises the integrity of the Auto Flush record. Leave the tablename on existing ATF policies at the base system (default) value so it does not adversely affect ATF data retention behavior.
  3. Specify how the system should determine the length of time for retention of data, and referencing data.
    1. In the Matchfield field, enter the field you want the system to use to monitor duration.
      For example, to specify that you want to delete data x amount of time after the system created it, leave Matchfield set to its default value of sys_created_on.
    2. In the Age in seconds field, enter the amount of time (in seconds) the system must wait before deleting the associated data and referencing data.
  4. If you want to apply the policy to the specified data (for example, sys_atf_test_result), and to any data that references it, select Cascade delete (default value).
    Affected referencing data is stored the following tables: sys_atf_test_result_item, sys_atf_test_result_step, and sys_attachment (when table_name = sys_atf_test_result). If you want the policy to simply flush data in the selected table (for example, sys_atf_test_result), and skip flushing of the referencing data, then clear Cascade delete.
  5. In the Conditions field, specify the filter conditions to use for selection of data (and optionally, referencing data) for this Auto Flush retention policy.
    The default is Retain indefinitely is false, because the Test results record also contains a Retain indefinitely check box that allows opting out of the auto flushes for specific test results.
  6. Click Update.