Managing Queries

You can open, copy, and delete saved queries.

Opening Queries

You can open and modify queries. You must open a query before you can run it.

To run a query:

  1. Select the Query tab and choose a query.

  2. Click Open toolbar button. to open the selected query.

  3. Click the tabs to modify the query parameters, and then click Run query toolbar button. to run the query.

Copying Queries

To copy a query:

  1. Select the Query tab and choose a query.

  2. From Queries, select Copy.

  3. Enter a new name and description for the query.

  4. From Object Access Group, select a custom group or one of the following:

    • User––Personal objects that are only available to an individual user to view and run.

    • Standard––Public objects that are available to all users to view and run. Only Data Manager users can create and modify standard compares.

    • System––Restricted objects that are only available to Application Administrator role users to view and run.

  5. Click OK.

Moving Queries

You can move a query from one object access group to another.

Note:

The move action is only available to users with Manage Object permission for the group.

To move a query:

  1. Select the Query tab, and then choose a query.

  2. From Queries, select Move.

  3. From Object Access Group, select a different group, and then click OK.

Deleting Queries

To delete a query:

  1. Select the Query tab, and choose a query.

  2. From Queries, select Delete.

    Note:

    If the query is used by another object, you get a prompt with a list of objects that use the query. You can choose to continue with the deletion or cancel it.