Can the boolean option be used to run two separate queries at the same time in the issue tracker querying?

Yes. The Boolean option can be used to run two separate queries at the same time based on AND and OR operator logic.

Issue Tracker queries use the Boolean chart to allows you to define search parameters by all fields in the issue database. To limit your search to a specific set of values in those fields, 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
• field/value parameters
• the AND or OR operator

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

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 (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 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 New or Pending status. 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, etc. can have several entries in a single issue. If you have multiple terms in your search that refer to one field, they will always return the same instance unless the terms appear on different charts. 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