Query

Action

Action Before Release 11.1.2

Action for Release 11.1.2 and Later

Viewing and managing queries

You can view and edit queries that are specific to a user.

Any user can view standard queries, but only a Functional Admin user type or higher can manage them.

You can view and edit queries that are specific to a user.

Any user can view standard queries, but only a user with the Data Manager role can manage them.

Only users with the Application Administrator role can view and manage system queries.

Selecting a query type

You can create and select global property queries from the Tools-Global Property Query menu.

You can create and select local property queries from the Tools-Property Query menu.

Saved global and local queries are listed separately.

Global and local property queries are created/selected from the Query task group.

Saved global and local queries are listed together and grouped by object access (User, Standard, System).

Defining return properties

Properties displayed in columns for query results are controlled by settings in the Tools-Options menu.

In each query, you can optionally include criteria properties to display as additional columns.

When you run the query, you select properties to display in columns for query results.

In each query, you can optionally include criteria properties to display as additional columns.

Displaying query results

You can display query results in a hotlist or in a marked tree in an open hierarchy window.

You can display query results in a list or in a marked tree on a separate Query tab.

Saving and printing results

You can print query results or save to a text file.

You can download query results to a CSV, XLS, RTF, or PDF file for saving or printing.