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 QUERY - Project key is turning up multiple projects in search results

Lily Bender

When I enter the following query" Project = "Data Science" AND issuetype = "In-Service Bundle" OR issuetype = 10000 ORDER BY key ASC, assignee ASC

I receive results from projects that are not Data Science. My results are in the thousands. What happened? I tried using Key = DS instead of project and it said The issue key 'DS' for field 'Key' is invalid. Even though that is my project code.

Accepted answers

Uday Kiran Bhaviri_cp1r58

Use the below query

Project = "Data Science" AND (issuetype = "In-Service Bundle" OR issuetype = 10000) ORDER BY key ASC, assignee ASC

Regards

Uday

Bill Sheboy

Hi @Lily Bender -- Welcome to the Atlassian Community!

Adding to the answers provided...I recommend looking at this free training from Atlassian on using JQL. It will cover introductory concepts and how to answer business questions with JQL:

https://support.atlassian.com/jira-software-cloud/docs/what-is-advanced-search-in-jira-cloud/

https://university.atlassian.com/student/activity/1225443-intro-to-jql-in-jira-software-course-description

https://university.atlassian.com/student/path/849533-gain-project-insights-through-jql

Kind regards,
Bill

All comments

Uday Kiran Bhaviri_cp1r58

Use the below query

Project = "Data Science" AND (issuetype = "In-Service Bundle" OR issuetype = 10000) ORDER BY key ASC, assignee ASC

Regards

Uday

Lily Bender

Ah that worked! Thank you so much. What do the parentheses do? For future reference.

Bill Sheboy

Hi @Lily Bender -- Welcome to the Atlassian Community!

Adding to the answers provided...I recommend looking at this free training from Atlassian on using JQL. It will cover introductory concepts and how to answer business questions with JQL:

https://support.atlassian.com/jira-software-cloud/docs/what-is-advanced-search-in-jira-cloud/

https://university.atlassian.com/student/activity/1225443-intro-to-jql-in-jira-software-course-description

https://university.atlassian.com/student/path/849533-gain-project-insights-through-jql

Kind regards,
Bill

Lily Bender

Thank you!

Uday Kiran Bhaviri_cp1r58

Start learning the difference between AND and OR operators, then combine them and use them.. then you will get the idea how they work...

If you remove the parentheses the query is looking for the issues from

Project = "Data Science" AND issuetype = "In-Service Bundle"

issuetype = 10000 ORDER BY key ASC, assignee ASC

In the second statement it is looking for issues where issue type 10000 so that's why you are getting records from multiple projects.

Welcome!

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

Quick Links

Find more posts tagged with

jira

unknown-hosting-type