You can edit queries that you create and save in the Personal
Queries folder. If you have the appropriate privilege,
you can edit queries in the Public Queries folder
as well.
Procedure
To edit a query:
- Right-click the query in the Navigator view and
click Edit.
The Select fields
to use as query filters
page of the Edit Query wizard opens.
- Add and remove fields to filter the query results. You
can create complex filter expressions by grouping filters in the Filters pane.
If you do not select any filters, all database records appear
in the query results.
- Click Next.
- On the
Define query filters
page, specify values
for the filters that you selected on the previous wizard page and
click Next. - On the
Define display fields
page, select the fields
to display to format the query results and click Finish.
Results
You can edit the filter field and display field settings
individually. To do so, expand the query in the Navigator view,
right-click Filters or Display Fields,
and click Edit. To edit a specific filter,
right-click the filter node and click Edit.
Example
When you modify a query, an asterisk appears next to the
name in the
Navigator view to
indicate that the query has been modified but not saved. To save the
query, right-click it and click
Save or
Save
As. The asterisk disappears.