Cleanup Add New Rule Table

The table at the top of the screen contains the area where new rules are added. An explanation of the fields are as follows:

Field

Description

Modules

The name of the module you wish to cleanup. Select from drop down list of values.

Field label

Fields contained within a module, selected using a drop down list of values. This allows which field within a module is used to run the cleanup query against.

Operation

Argument used for the query:

  • Is Null: Contains no data whatsoever.
  • Is Not Null: Contains data of any kind.
  • Case Sensitive Equals: Contains the same data as the Input Value. Text is case sensitive.
  • Case Insensitive Equals: Contains the same data as Input Value. Text is not case sensitive.
  • Less than: Can be used for numeric or date fields.
  • Less than or Equal to: Can be used for numeric or date fields.
  • Greater than: Can be used for numeric or date fields.
  • Greater than or Equal to: Can be used for numeric or date fields.
  • Not Equal to: Exclude records that have this value set.
  • Case Sensitive Like: Contains data that begins with the Input Value. Text is case sensitive.
  • Case Insensitive Like: Contains data that begins with the Input Value. Text is not case sensitive.
    NOTE: All operation arguments are subject to Web Service support.

Input value

Numeric or text value used for the query. This field is only used if the cleanup with query option has been selected. Value must match the field type, for instance text cannot be searched for if the field is in a numeric format.