Saving Queries in Reports

Saved Queries is now available to give financial users the ability to save routinely used queries for a number of reports. Instructions for saving, loading, and deleting reports are below.

Saving and Loading Queries

Users can save and load custom queries using the Load Prompts and Save Prompts buttons at the bottom of the main report prompt screen.

Report prompt screen footer showing the Load Prompts and Save Prompts buttons
Both buttons appear together in the footer area of the prompt screen.

To save a query, simply set up the report with the desired search options, and then click the Save Prompts button. You'll be asked to provide a name and optional description for your query. Saved queries are unique to your UCInetID. For any report and user, the query name must be unique. Sharing queries is planned for a future development phase.

Save Prompts dialog box with fields for entering a unique query name and an optional description
The query name is required and must be unique per report and user; the description field is optional.

A confirmation window will be displayed, and will automatically be dismissed after a few seconds.

Save query confirmation window indicating the query was successfully saved
No action is required to dismiss this window; it closes on its own after a few seconds.

After saving a query, it can be loaded at any time by clicking the Load Prompts button and clicking the name of the query.

Load Prompts panel displaying a list of previously saved queries available for selection
All queries saved under your UCInetID for the current report appear in this list.

Once you select the query, your query will be automatically populated into the report. After the query has loaded, you may can run the report.

Saved queries do not expire, and users can delete queries if they're no longer needed.

How to Delete Queries

You can delete queries by clicking on the Load Queries button and selecting Delete to the right of the query you wish to delete. You will have to confirm the query you want to delete.

Load Queries panel showing saved queries with a Delete button to the right of each query entry
A confirmation step follows after clicking Delete, so queries are not removed immediately.

Once you've selected the Delete button, a delete confirmation window will be displayed, and will automatically be dismissed after a few seconds.

Delete query confirmation window indicating the query was successfully deleted
Like the save confirmation, this window dismisses automatically and requires no additional action.

To replace the query, the user can first load the query, then delete the query. With the prompts values loaded, the user can modify the prompts values and save it using the same name (that was just deleted).

Reports Allowing Saved Queries

The following reports now allow users to save queries:

  • Account Summary
  • Fund Summary
  • Account GL Detail Ad-hoc
  • Ledger Reconciliation
  • Account Transaction

For more information on these reports, view Campus Financial Reports.