Selecting Fields for a Condition

You can add any fields available in the table that you are creating the report against, but your privileges determine whether results are returned based on your search filter.

Use the following information when selecting a field for a condition:

The field or filter you select from the Fields list controls the options available to you in the Operator and Field Values lists. For details, refer to Condition Operators and Selecting Field Values for a Condition.
You can override the Report Project setting on the report form by creating a condition that contains the Project field and specific projects. If you selected the Include Sub-projects check box on the report form, the setting is recognized in your Project condition. Remember that privilege checking for running reports is always based on the project selected on the report form and that project view privileges are always checked for every user when the report is run.
You can search all Text fields that are enabled for keyword searching by your administrator by using the Text Fields With All Keywords or Text Fields With Any Keywords options. The Text Fields With All Keywords option allows you to search for a match to all the keywords you specify. The Text Fields With Any Keywords option allows you to search for a match on any of the keywords you type.
The Item Type Prefix option allows you to search for items by their prefix if the Item Type field is enabled for searching by your administrator.
Select (Filters) to use a predefined report filter as a condition.

Note: Field-level dependencies are available on the Advanced Search page. If both the independent and dependent fields of a dependency are placed on the Advanced Search page, the dependency as established in the selected project is honored. In addition, a check box enables project- and field-level dependencies during report creation, as long as all fields in the dependency are added to the report's search criteria.

To select a field for a condition:

In the Search Filter area of the form, select the Use Basic Conditions option.
Click Add to show Field Specifications.
From the Fields drop-down list, select a field or report filter that you want to include in your condition. Field are listed in alphabetical order. To find a field, type the first letter of a field name to select the first field in the list that begins with that letter. Type the letter again to select the second field in the list that begins with that letter; continue to type the letter until the field you need is selected. When you select (Filters), a list of available report filters appears under Field Values. Select one or more report filters, or use them in combination with field conditions.

Selecting Fields for a Condition

Related Topics