Searching in summary line to include CTM

Question

Hi Everyone I am trying to search for all issues associated to specific projects within specific parameters. This is the search and works fine at the moment. Search 1 project in (LVONE, LVTWO, INF, ITS, LVTHREE) AND status in (Resolved, Closed) AND reporter in (membersOf(jira-ctm)) AND resolved >= 2013-04-01 AND resolved <= 2014-05-30 ORDER BY key ASC, updated DESC Where I am having problems however is that I want to search for all issues still in these projects but that include 'CTM' in the summary line but the reporters could not be members of the jira-ctm group. It's almost like I am trying to put two searches into one. If I try AND Summary ~ "CTM" in different parts these are the results. Search 1, 607 issues Search 2, 126 issues project in (LVONE, LVTWO, INF, ITS, LVTHREE) AND Summary ~ "CTM" AND status in (Resolved, Closed) AND reporter in (membersOf(jira-ctm)) AND resolved >= 2013-04-01 AND resolved <= 2014-05-30 ORDER BY key ASC, updated DESC Search 3, 60976 project in (LVONE, LVTWO, INF, ITS, LVTHREE) OR Summary ~ "CTM" AND status in (Resolved, Closed) AND reporter in (membersOf(jira-ctm)) AND resolved >= 2013-04-01 AND resolved <= 2014-05-30 ORDER BY key ASC, updated DESC Search 4, 1947 project in (LVONE, LVTWO, INF, ITS, LVTHREE) AND status in (Resolved, Closed) AND reporter in (membersOf(jira-ctm)) OR Summary ~ "CTM" AND resolved >= 2013-04-01 AND resolved <= 2014-05-30 ORDER BY key ASC, updated DESC I think the actual result should be somewhere between the results of search 1 and 4. Any help would be greatly appreciated. Thanks, Andrew

Andrew Riley1 · Answer

Thanks Nic. Greatly appreciate your explanation here. I'll give it a try.

Nic Brough -Adaptavist- · Answer

This is a classic example of humans thinking in human speak and actually being quite fuzzy about their searches - you know what you mean, and when you say it out loud, you're unconsciouly emphasising and punctuating what you're saying in a way that makes it perfectly clear to another human.  But a computer needs absolute clarity, and it probably doesn't help that the rules on how "and" and "or" work in a query are as clear as mud to us.

I usually find it best to think in clauses and then do a complete-overkill approach to it with probably far too many braces to make sure the and/or stuff does exactly what I want.

So, from "all issues still in these projects but that include 'CTM' in the summary line but the reporters could not be members of the jira-ctm group"

This bit is clearly right:

project in (LVONE, LVTWO, INF, ITS, LVTHREE) AND Summary ~ "CTM"

Then I think you need

reporter NOT in (membersOf(jira-ctm))

Then, I think the "still" in your question probably refers to the status, so

AND status in (Resolved, Closed)

And to combine those clearly, try

(project in (LVONE, LVTWO, INF, ITS, LVTHREE) AND Summary ~ "CTM" ) AND (reporter NOT in (membersOf(jira-ctm)) )  AND (AND status in (Resolved, Closed) )

In other words, I've landed with your query 2, with more brackets and a NOT statement.  The brackets will help if you decided to start compounding your query more - you don't need them if every clause is going to be joined with AND