Edit Query Options

These steps explain how to edit Query options.

If you ever add a file to or remove a file from a Query that you have automated, be sure to update the Query automation setting.
The term "file" can also be referred to as "table" in the context of Queries. For details, refer to the online course CMS 100 - Report Builder: Canned Query.

Launch Tool #100 CU*BASE Report Builder (Query).
In the Option drop-down menu, select 2=Change.
In the Name field, enter your report name.
In the Location field, enter the location of the Query you'd like to edit (QUERYXX, CUBASEQ, etc.).
Click the forward arrow.
From the Report Builder - Main Menu screen, make the needed changes.
When finished making changes, click the back arrow to save and run your Query.
From the Exit this Query window, click Preview Report to view your Query results.
Click the forward arrow to return to the Exit this Query window.
Click the forward arrow again to exit.

Learn More