Advanced compare condition boolean

[Robert DelFave]

I am wondering if/how this can be built within the advanced compare condition using boolean. I am attempting to change the request type of new issues when the description contains "missing" and "article, or "include" and "hit". 

Is this possible?

[Alex Koxaras _Relational_ · Accepted solution]

Hi @Robert DelFave 

This was the most interesting question I've read today! It got me real psyched, and for the last 30-60mins I was reading about regex and testing on my instance!

Now, the bad news is that I didn't accomplish anything with the regex, since I've read that regex lack of the AND operator!! Having said that and after trying none the less some of my own regex (based on my imagination), I kinda really wanted to find a solution for your problem!

So it took me less than I expected to solve this without regex and from my tests it seems that it works! You only have to pick the JQL condition (instead of advanced) and write your JQL statement (replace my words to yours):

(description ~ cat AND description ~ dog) OR (description ~ tom AND description ~ jerry)

The rule would look something like this:

Let me know if that was what you were looking for!

[Robert DelFave]

Hi @Alex Koxaras _Relational_,

Thank you for taking a look! Utilizing JQL does work but only for basic searches. Unless my boolean is incorrect, the below throws an error:

((description ~ "miss*” OR description ~ “did not capture” OR description ~ “not appearing” OR description ~ “did not filter in” OR description ~ “not in*”) AND ((description ~ "article*”) OR (description ~ “post*” OR description ~ “mention*” OR description ~ “source*”)))

Any idea?

[Alex Koxaras _Relational_]

Yes, I've got one :)

Looking at your JQL it appears that you have two different types of quotation (check this on  "miss*”). So you've got:

1.  " 
2.  ” 

JQL doesn't support the 2nd one. This is the correct JQL

((description ~ "miss*" OR description ~ "did not capture" OR description ~ "not appearing" OR description ~ "did not filter in" OR description ~ "not in*") AND ((description ~ "article*") OR (description ~ "post*" OR description ~ "mention*" OR description ~ "source*")))

[Robert DelFave]

That's it! Thank you Alex!

[Alex Koxaras _Relational_]

No problem @Robert DelFave !

Kindly mark my answer as accepted to help others in the community to find the right answers :)

Cheers!