Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,359,799
Community Members
 
Community Events
168
Community Groups

Need to exclude components for a specific project but I'm pulling results for all projects. How come

Hello there,

I'm looking to build a filter that excludes a whole bunch of components for my specific project from users who go through Service Desk, our Jira front end ticketing solution. So I only want to pull tickets that are opened by customers ("Customer Request Type" is not EMPTY), excludes all those components listed below, and be only my specific project (BBT)

What's happening though is I'm pulling in results from projects throughout the company. Curious why that is and also how can I clean this JQL up? Thank you.

JQL:
project = BBT AND component is EMPTY OR component != "Data Science" AND component != "Analytics Library" AND component != "DEU" AND component != "Product Configuration" AND component != "Call Library" AND "Customer Request Type" is not EMPTY

1 answer

1 accepted

0 votes
Answer accepted

Hi @Kevin R 

I think the only problem is missing parentheses.

project = BBT AND (component is EMPTY OR component != "Data Science") AND component != "Analytics Library" AND component != "DEU" AND component != "Product Configuration" AND component != "Call Library" AND "Customer Request Type" is not EMPTY

Something so simple. Thank you very much.

Like Avatar likes this

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira

Online AMA this week: Your project management questions answered by Jira Design Lead James Rotanson

We know that great teams require amazing project management chops. It's no surprise that great teams who use Jira have strong project managers, effective workflows, and secrets that bring planning ...

167 views 1 6
Read article

Atlassian Community Events