	Related Topics:
	Query Utility

Specifying the Query Criteria

The table on the Criteria tab of the Query utility displays all of the properties that can be included in the query results. Most of these properties can also be used as criteria to limit the query results. You can use the options above the table to specify whether the query results should match the criteria from all rows in which criteria are specified (i.e., AND) or from any row in which a criterion is specified (i.e., OR). The properties that are displayed in this table depend on the query type that you have chosen from the drop-down list above the tabs. In addition, the available properties depend on the interface style that has been defined for the project.

To select a property for inclusion in the query results, select its check box in the Include in Results column. You can use the check boxes that correspond to category headings to select or clear all of the subordinate properties (e.g., select the check box for the Action Properties heading to show all available action properties in the query results).

Note: Each query to the database can include a maximum of 225 fields. If your query exceeds this number, you will see a message that notifies you of the issue and asks you to reduce the number of fields and try again.

Note: When searching for actions or controls along with other record types (such as cause records), you may see multiple copies of an action/control. However, if you are searching only for actions or only for controls, then the query will return only one copy of the record.

For example, the Query utility shown next searches only data associated with Subsystem A.1 in the project. The results will include items where the Task Description value is not "None" AND the Status value is "Assigned," and they will show the following properties:

Task Description
Type
Status
Assigned Interval