Edit a query

This exercise shows you how to edit an existing query.

You must complete the Create a query exercise before beginning this exercise.

To edit the NotClosedorResolved query:
  1. Navigate to the query in the Personal Queries folder of your workspace.
  2. Right-click the NotClosedorResolved query and select Edit.
  3. In the Fields pane, double-click the Submit_Date field to add it to the Fields pane.
  4. Click Next twice until you reach the Define Display Fields window.
  5. Click the Sort column box to set the sort order as ascending.
  6. Enter 5 in the Sort Order cell to set the order for displaying the records that the query returns.
  7. Click Run Query from the toolbar and view the results. Notice that the results set now includes the Submit_Date column.
  8. Click Finish > Save to save the modified query.
Parent topic: Overview of queries
Previous topic: Set a query to run at startup
Next topic: Import and export a query