Administration › Archive and Purge › Archive and Purge Rules › Search the Archive and Purge Rule List › Archive and Purge Rule Search Fields

Archive and Purge Rule Search Fields

You can use the Archive and Purge Rule Search fields to filter your search to display only the rules of interest.

Note: All search fields that allow text entry support use of the % wildcard character.

Rule Name

Specifies a unique identifier for the rule.

Status

Indicates whether this rule is active. The inactive rule runs only once, even if it is scheduled for a recurrent process.

Schedule

Specifies a workshift during which the rule should be in effect.

Archive File Name

Specifies the name of the file where you want to store the historic records. Enter the file name that you have mentioned while defining the archive and purge path. For more information, see the Define the Archive and Purge Path topic.

Operation Type

Specifies one of the following types of operation that the rule must execute:

Archive/Purge

Archives the historic records to a file and purges the archived records from the database.

Purge Only

Purges historic records from the database, but they are not written to the archive file.

Archive Only (Test Run)

Writes historic records to the archive file without purging them from the database. Use this option to test a newly created or edited archive and purge rule.

Config. Object Name

Specifies the name of the database object this rule can archive and purge. The Object Name field is automatically populated according to your selection in the Config. Object Name field.

Days Inactive

Specifies the number of days a record is inactive to be eligible for the archive and purge from the database.

Additional Query

Archives and purges specific inactive records among the existing inactive records. Use this field when you want to create different rules for archiving and purging the subsets of expired records for the same object. Use the same syntax as you use for stored queries.

The following query archives and purges only assigned inactive request records with a priority of 1:

priority = 1 AND (assignee IS NOT NULL OR group IS NOT NULL) and active = 0

The following query format archives and purges records based on time-span:

close_date < EndAtTime(\'LAST_YEAR\')

Note: You can click the More icon to display the Additional Search Arguments field. This field is intended only for expert users who understand SQL and Majic and can use it to specify search arguments that are not available in the standard search filter fields. You can enter a SQL WHERE clause in this field to specify an additional search argument.