Purging Group Results

These topics provide an overview of the group results and discuss how to:

Page Name

Definition Name

Usage

Group Results Purge Page

RUNCTL_GBP004

Delete (purge) the results of a previous version of a group from the Group Results Table.

Unusable Group Results Purge Page

RUNCTL_GBP005

Delete the results from all of your groups from the Group Result Table.

You must have saved the group you want to purge before using this page.

Each time you generate and execute a group, the system stores the results in the Group Result Table. The next time you execute the same group, the system checks to see if the group's definition and date parameters have changed since the last time you ran the group. If they have, the system deletes the old results from the Group Results Table and saves the new results.

Use the Group Results Purge page (RUNCTL_GBP004) to delete (purge) the results of a previous version of a group from the Group Results Table.

Image: Group Results Purge page

This example illustrates the fields and controls on the Group Results Purge page. You can find definitions for the fields and controls later on this page.

Group Results Purge page

The Group Results Purge process deletes usable groups —groups with results in the Group Results Table that are still in sync with the current group definition and can potentially be retrieved by the system.

Field or Control

Definition

Group ID

Enter the ID of a group whose results you want to purge. The system deletes the results from the Group Build results table GB_GRP_RES_TBL.

Use the Unusable Group Results Purge page (RUNCTL_GBP005) to delete the results from all of your groups from the Group Result Table.

You must have saved the group you want to purge before using this page.

The Unusable Group Results Purge process deals with unusable groups—groups that were generated when the group definition was different from what it is now, and the results that are stored on the Group Results Table no longer match the group definition. Group results become unusable when any of the following items change:

  • The developer's query definition.

  • The Group Results Table, where the group results are stored.

  • The group definition.

  • The user's query definition.