Skip to end of metadata
Go to start of metadata

Query Builder is used to create and modify search filters and is opened whenever you want to create or modify a query.

Filters consist of several conditions linked together by the logic operators: AND, OR (NEITHER), and NOT.

Below is the description of these operators:

AND

To search for the bugs that simultaneously meet two conditions, use the AND operator to connect these two conditions. For example, the filter "Updated Today AND Priority in P1" will return all bugs with priority P1 that were updated today.

OR

To search for bugs that satisfy at least one of two conditions, use the OR operator to connect them. For example, the filter "Updated Today OR Priority in P1 will return all bugs which have priority P1 and also all bugs that were updated today.

NOT

To exclude some bugs from the filter results, use the NOT operator in front of the condition that selects these bugs. For example "NOT Priority in P1" will return all bugs that have priority different than P1.

NEITHER

To search for the bugs that satisfy none of the two conditions use the NEITHER operator. NEITHER works like the combination of NOT and OR. At first the bugs which satisfy at least one if the two conditions are found and then they are excluded from the set of bugs, on which the search is running.

Two conditions connected by the AND or OR operators can be considered as one new condition which you can connect with another condition.

Each condition is represented as certain constraint on the selected field. The types of these constraints are listed in the table below:

Icon

Description

Search for bugs with specific words in a text field (for example, Comments)

Search for bugs with a numeric field value within a specified range (for example, Votes).

Search for bugs with date field value within a specified time range (for example, Submit Date).

Search for bugs with a single selection field value in the set of selected values (for example, Priority).

Search for bugs with a multiple selection field value in the set of selected values (for example, Keywords)

To create a filter:

  1. Open the Query Builder (Query Builder opens when you create a new query or modify a query).
  2. In the Field list select the bug field on which you wish to put a constraint. Depending on the selected field type the constraint area will show different controls for specifying constraints.
  3. Specify the constraint for the selected field.
  4. If you need to add more conditions to your filter, click the logic operator you want to use to connect it to the already specified condition.
  5. Select the field on which you want to put a constraint and specify the constraint.
  6. To exclude the bugs that satisfy some condition from the search results, select this condition in the Filter area and click NOT.
  7. As you add more conditions they are organized into hierarchy displayed in the Filter area. Each operator shows conditions, which it connects as its children.
  8. If you wish to add a constraint to a group of conditions already connected with some operator, select this operator and then click one of the operators on the toolbar. Then select the field and specify the constraint.
  9. If you select the OR operator in the hierarchy and click NOT, the operator will be changed to NEITHER.
  10. Repeat steps 4-8 to add more conditions to the filter.

Once you have added conditions to the filter you can modify the filter by dragging the conditions within the Filter area in the Query Builder.