JQL query with multi status

[Anthony Pignatiello]

Hi

I am trying to create a JQL query and it not working. 

project = CAMSMT
Field = "Intake Request Type" in "Solus eDM request" and "Email booking request"

But I want all status of the "Solus eDM Request" and only the DONE status of "Email booking request"

It might seem really easy but I can't get this query to work. 

The below is saying its not valid. 

project = CAMSMT and "Intake Request Type" in "Solus eDM request", ("Email booking request" with status = done)

[Fernando Eugênio da Silva · Accepted solution]

@Anthony Pignatiello 

Try to use the operator 'OR' to separate your value results. Something like this:

project = CAMSMT AND "Intake Request Type" = "Email booking request" AND status = Done OR project = CAMSMT AND "Intake Request Type" = "Solus eDM request"

You can guilde yourself using this doc: https://support.atlassian.com/jira-service-management-cloud/docs/use-advanced-search-with-jira-query-language-jql/

[Anthony Pignatiello]

 @Fernando Eugênio da Silva You are awesome! Thank you. I'll take a look at the guide also!

[Nic Brough -Adaptavist-]

Be very careful with that query, it's not going to do what you think.

[Rilwan Ahmed]

Hi @Anthony Pignatiello ,

Please try this JQL

(project = CAMSMT AND ("Intake Request Type" = "Email booking request" AND status = Done)) OR (project = CAMSMT AND "Intake Request Type" = "Solus eDM request")

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

You're really close, but, whilst JQL is absolutely not SQL, it has the same grammar.  It is one or many true/false questions joined together with either And or Or.

Your project = CAMSMT and "Intake Request Type" in "Solus eDM request", ("Email booking request" with status = done) works fine most of the way but breaks down because the clauses within the parentheses are not JQL and are not joined to the main query.

I find it useful to revert to a human language and then rebuild:

Show me issues in the CAMSMT project, where the field "Intake request type" has a value of "Solus eDM request", or it is an "email booking request" that is done.

Note the second , in that sentence.  I've used the Oxford comma there to make it very clear where the lists of clauses or objects are.  (I don't know where you might stand on Oxford commas, but the reality is that computers need them to understand what humans are saying to them to them.  They can't intuit it like we can)

Taking the first step to translating it into JQL, we need to break up the clauses, grouped by the punctuation, and the boolean logic.  The parenthesis indicates groups. 

Show me issues in project CAMSMT (where the field "intake" is "Solus" OR (the the field intake is "email" AND the issue is done) )

And the next step is JQL:

project = CAMSMT and ( ( "Intake Request Type" = "Solus eDM request") or ("Intake Request Type" = "Email booking request" and status = done) )