Child pages
  • Query Builder

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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, which 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 which 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, which 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.

...

  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.

...