I have a custom filter written in JQL with several consecutive AND statements combined with != due to the required field to search does not support list use like (A,B,C).
I need to add another AND condition but that condition must also contain another AND operator. Something like:
... AND (component != R AND type != S) AND...
The above is for reference to what I'm trying and is not valid JQL.
Is this possible?
status = Open AND component in ("A", "B", "C", "D", "E", "F", "G", "H", "I") AND cf != CUSTOMER1 AND cf != " CUSTOMER2" AND cf != " CUSTOMER3" AND cf != " CUSTOMER4" AND cf != " CUSTOMER5" AND cf != " CUSTOMER6" AND cf != " CUSTOMER7" AND cf != " CUSTOMER8" AND cf != " CUSTOMER9" AND cf != " CUSTOMER10" AND cf != " CUSTOMER11" AND cf != " CUSTOMER12" AND cf != " CUSTOMER13" ORDER BY created DESC, key DESC
I need to add an “AND not equal” for something that will look at cf AND another custom filed for TYPE of certain criteria and not display those.
The error you recieve when trying to do "cf != (A,B,C,D,etc.) is that the field does not support list values.
it is a Select List (Single Choice) Field of Global Type
as note, the second custom field I'm looking to combine with "Customer14" is also a Select List (Single Choice) Field of Global Type
was that the right answer?
Also, I only want to address the second field (which does appear on all other tickets) for Customer 14. If I try to add another operator for the second custom field, it eliminates ones for customers I want to see.
It was pretty close, I added an AND status = OPEN statement to the CUSTOMER14 section after the OR statement, and that reduced the display a bit as well.
Also, I made sure to include the CUSTOMER14 name in the first statement for "not equals", then also used CUSTOMER14 after the OR statement to say to include that customer name with the AND for priority, and it worked!
THANK YOU SO MUCH!!!!!
Here is the final JQL:
cf not in (CUSTOMER1, CUSTOMER2, CUSTOMER3, CUSTOMER4, CUSTOMER5, CUSTOMER6, CUSTOMER7, CUSTOMER8, CUSTOMER9, CUSTOMER10, CUSTOMER11, CUSTOMER12, CUSTOMER13, CUSTOMER14) AND status = Open AND component in(A, B, C, D, E, F, G, H, I) OR cf = CUSTOMER 14 AND priority = “P1” AND status = Open ORDER BY created DESC, key DESC
I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event