Converting Saved Queries to Enhanced Queries

Locate the SQ records that you want to convert by accessing the User Overrides (P98950) application.

1. On the Work With User Overrides form, enter SQ for the UO Type, and then click the Find button.

   Note: You can use any combination of UO Type, User/Role, and Form to locate SQ records. Searching for records with only the UO Type equal to SQ displays all of the SQ records.

2. If you do not want to convert all SQ records, determine the User ID/Role, application, or form for which you want to run the conversion. You can use any combination of these three values to select the records to be converted.

   If there are no records with a UO Type of SQ, you do not have any records to convert.

Converting SQ Records to AQ Records

Enter BV in the Fast Path to access the Batch Versions (P98305W) application.

1. On the Work With Batch Versions form, enter R95SQAQ in the Batch Application field and click the Find button.

2. Click the XJDE0001 Version to convert SQ to AQ batch version.

3. From the Row menu, select Processing Options.

4. On the Processing Options form, enter the appropriate information to convert the desired records.

   Note: You can leave any or all of the processing option fields blank. If you do not specify a User ID, application, or form name, all SQ records will be converted to AQ records.

5. Click OK.

6. On the Work With Batch Versions - Available Versions form, click the Select button.

7. On the Batch Versions Prompting form, click the Submit button.

   A conversion report is automated generated after the conversion.

8. Review the conversion report.

   The report lists the number of records in F98950 and F98950D tables that were converted to the new AQ format. Because the old records with UO Type equal to SQ are not deleted by the conversion process, you must delete them manually.

Manually Deleting Saved Query Records

After you confirm that the correct Saved Query records were converted to Enhanced Query records, you can delete the appropriate SQ records from the User Overrides (P98950) application.

Access the P98950 application.

1. On the Work With User Overrides form, enter SQ for the UO Type, and click the Find button.

   Note: You can use any combination of UO Type, User/Role, and Form to locate SQ records. Searching for records with only the UO Type equal to SQ displays all of the SQ records

2. Click each row with an SQ record that you want to delete, and then click the Delete button.