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:
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.
|