Improve comments search for issues with multiple comments

Here's the initial problem. We have an issue with comments saying "Comment One" and another saying "Comment Two". When trying to exclude that from a search, we can say "Do not include issues where the comment has 'Comment One' in it" using the !~ option, but the second comment does not match this so the issue is not excluded. Ideally we'd want a "comments" JQL option that searches all the comments and treats them as one block.

Originally logged as a bug, here's the steps to reproduce this behaviour:

• Create a new project;
• Create one issue with the summary "Issue One";
  • Create a comment in this new issue with the content "Comment One";
• Create one issue with the summary "Issue Two";
  • Create a comment in this new issue with the content "Comment Two";
• Create one issue with the summary "Issue Three";
  • Create two comments in this new issue. One with the content "Comment One" and one with the content "Comment Two";

Now go to the Issue Navigator using the advanced search and do the following JQL's:

comment !~ "\"Comment One\"" AND comment !~ "\"Comment Two\""

This should return zero results, but it brings the Issue Three!

comment !~ "\"Comment One\""

This should return the Issue Two, but it brings the Issue Two and the Issue Three!

comment !~ "\"Comment Two\""

This should return the Issue One, but it brings the Issue One and the Issue Three!