The report POWL_D01 deletes derived or user defined POWL queries from the cache, based on application ID, and/ or user. This report is intended mainly for POWL developers and system administrators to delete any existing query cache.
It performs the following operations:
- Display user defined queries based on application ID and/ or user.
- Delete the user defined queries or derived admin queries.
- Delete relevant query personalization.
Selection
You enter an application ID, and/ or user. The report runs a check matching this selection and displays the corresponding list of queries.
Additionally, you can also decide if you want to display the results of your selection, or delete them. The Display Only checkbox is used for this purpose.
Output
The output of this report provides the following options:
- Display list of queries with query ID, POWL type, and GUID.
- Delete one or more queries based on your selection.
