JQL query, where one field should contain something and other field should not contain something.

Vladimir Sumilin

For example: 

project = "ACC" and "Roles with direct authority[Checkboxes]" in ("IT Director", "QA/RA Director", "Development Director") and !("Main Responsible Role[Checkboxes]" in ( "IT Director", "QA/RA Director", "Development Director")) ORDER BY created DESC

This query is not working, but I wanted to make it so that in one field you have precisely these matches and in another, you will not have them. 

So, is there a way I can do that? 

 

Best regards,

Vladimir

Seifallah Bellassoued

Hi @Vladimir Sumilin

JQL propose a "not in" option. Can you try the folowing:

project = "ACC" and "Roles with direct authority[Checkboxes]" in ("IT Director", "QA/RA Director", "Development Director") and "Main Responsible Role[Checkboxes]" not in ( "IT Director", "QA/RA Director", "Development Director") ORDER BY created DESC

 

Best Regards,

Seif,