Repairing Existing Queries Automatically

A record definition that is used in a query may change. When this occurs, PeopleSoft Query automatically repairs the query when it is opened. A warning message informs you about the problem and what actions were taken.

The following table lists the problems and their corresponding actions.

Problem	Action
Field deleted from the record definition is a selected field.	The field is removed from the selected list. If the field is the only field selected, the query cannot be saved.
Field deleted from the record definition is used in a prompt.	No action taken. This does not affect the prompt unless the field has been completely removed from the database, and the prompt label is either a short or long translate.
Field deleted from the record definition is used in an expression.	The field is removed from the expression. This may result in an invalid expression, but the query can be saved.
Field deleted from the record definition is used in a criterion.	The criterion is removed. If criterion is a subquery criterion, all lower subqueries are deleted.
Record deleted is the first record in the query.	Error returned. The query cannot be repaired.
Record deleted is not the first record in the query.	The record and all fields are removed. Note: The actions specified previously for deleted fields apply.
Record deleted contains hierarchy joins below it.	Record and all records joined below are removed. Note: The actions specified previously for deleted fields apply.

Note:

If a record has been deleted, the query no longer appears in the list of queries because you no longer have access to all of the records in that query. To open such a query, you need to use Query API.