Using the Boolean chart

The Issue Tracker query page allows you to define your search parameters by all fields in the Issue database. To limit your search to a specific set of values in those fields, you can use the "Boolean chart" at the bottom of the page.

Each Boolean chart can contain one or more terms - the fields/values to search by and how each should be treated - and Boolean operators - either AND or OR.

To define a term, select an item from each pulldown box, specifying the field and the type of match, and enter a value in the data field. For example, if you select Issue # from the first pulldown, equal to from the second pulldown, and enter 001 in the data field, you will see only issue #001 in your search results.

Note: The charting allows you to specify queries 'where X is not Y', such as 'where RESOLUTION is not CLOSED'. This operation works best with single-valued fields. When a field has multiple values, like the CC, comments and attachment description fields, the resulting query statement is 'where at least one entry for X is not Y'. For example, if you query on 'CC does not contain user x', the results will contain issues in which at least one of the users in the CC field is not 'user x'.

The Boolean operators, i.e. the And button and the Or button, allow you to search by multiple terms.

Clicking the And button allows you to define a new term and have the result of the query include anything that matches both of the terms.

Clicking the Or button allows you to define a new term and the result of the query will be anything that matches either of the terms.

You can add as many terms as you like by clicking the And or Or button after each term. You can also use both And and Or in a single query. Terms separated by Or are treated as a single statement. Terms separated by And are treated as separate statements. For example, you could search for all P1 and P2 issues with a status New or Pending. Your Boolean chart would look like this:

Status Equal to New OR Status Equal to Pending

AND

Priority Equal to P2 OR Priority Equal to P1

You can use the Add another Boolean chart button to search for multiple instances of a field that can have several entries associated with a single issue. For example, all of the changed... match types and fields like IssuesThisDependsOn, Comments, and CC, can have several entries in a single issue. If you have multiple terms in your search that refer to one field and appear in the same chart, they will always return the same instance.

For example, if you search for "Priority changed to P5 And Priority changed by person@addr," your results would include only issues where the person@addr changed the Priority to P5. However, if you want to find all issues for which person@addr changed the priority, and for which the priority was changed to P5 by anyone, you would put the two terms in two different charts that would look like this:

Priority Changed by person@addr

Priority Changed to P5