This exercise shows you how to edit an existing query. Complete the Create a query exercise first.
To edit the
NotClosedorResolved query:
- Navigate to the query in the Personal Queries folder
of your workspace.
- Right-click the NotClosedorResolved query and select Edit.
- In the Fields pane, double-click the Submit_Date field
to add it to the Fields pane.
- Click Next twice until you reach the Define
Display Fields window.
- Click the Sort column box to set the sort order
as ascending.
- Enter 5 in the Sort Order cell
to set the order for displaying the records that the query returns.
- Click Run Query from the toolbar and view the results.
Notice that the results set now includes the Submit_Date column.
- Click to save the modified query.