nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL - Writing AND statements that require another nested AND?

Tyson Neil Taber

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?

Accepted answers

Josh Steckler

Can you post the whole JQL? Nested segments and all. Feel free to obscure field names/values.

Also is there more to the error for invalid JQL?

All comments

Josh Steckler

Can you post the whole JQL? Nested segments and all. Feel free to obscure field names/values.

Also is there more to the error for invalid JQL?

Tyson Neil Taber

status = Open AND component in ("A", "B", "C", "D", "E", "F", "G", "H", "I") AND cf[11802] != CUSTOMER1 AND cf[11802] != " CUSTOMER2" AND cf[11802] != " CUSTOMER3" AND cf[11802] != " CUSTOMER4" AND cf[11802] != " CUSTOMER5" AND cf[11802] != " CUSTOMER6" AND cf[11802] != " CUSTOMER7" AND cf[11802] != " CUSTOMER8" AND cf[11802] != " CUSTOMER9" AND cf[11802] != " CUSTOMER10" AND cf[11802] != " CUSTOMER11" AND cf[11802] != " CUSTOMER12" AND cf[11802] != " CUSTOMER13" ORDER BY created DESC, key DESC

I need to add an “AND not equal” for something that will look at cf[11802] AND another custom filed for TYPE of certain criteria and not display those.

The error you recieve when trying to do "cf[11802] != (A,B,C,D,etc.) is that the field does not support list values.

Josh Steckler

What type of custom field is it for this part:
cf[11802] != (A,B,C,D,etc.)

You might be need the Not In () operator if you're using a select field or similar and want to exclude several options.

Tyson Neil Taber

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-core

jql

jira-core-cloud