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; } } }

Search for issues except for issus in one project.

Erik Bredevangen

I'm trying to create a JQL that will give me a list of issues assigned to a group of users, but issues in one Project should not be part of the result.

I have tried several ways, but this is the one that is closest to give me the result.

project != "Project1" AND assignee in (User1,User2,User3) and Status not in (Closed, Resolved,Done) and issuetype in (story,task, Sub-task) ORDER BY project

Since I'm logged in with User1 it only returns issues that belongs to User1.

Is there a better way of doing this?

Thanks.

Accepted answers

Milan Chheda [INFOSYSTA]

As @Sreenivasaraju P mentioned, instead of `!=`, you can use `not in` and recommended to use membersOf() instead of adding each user.

Secondly, you should be able to see all issues and not just assigned to you, only if you have the permission to view other issues. So the query is correct,. you probably need to check the permission so as to view issues assigned to other users.

All comments

Sreenivasaraju P

Query look fine.

Alternatively you can use project not in (project1) . It may help helpful in future , if you want to exclude more projects.

If possible you can use assignee in membersOf("groupname") . If all assignees are part of any group.

Milan Chheda [INFOSYSTA]

As @Sreenivasaraju P mentioned, instead of `!=`, you can use `not in` and recommended to use membersOf() instead of adding each user.

Erik Bredevangen

Project not in gives the same result.

Erik Bredevangen

If I just remove "project != "Project1" AND"

Then I get a list of issues for the 3 users, but for every project that we have.

Sreenivasaraju P

Yes. It will give the same result.

Sreenivasaraju P

There requests , which you are getting for other users is from Project1 or from any other project.

If it is from Project 1, there may be 2 scenarios

Only Projects requests are assigned to Other users. There are no tickets assigned to them from other projects.
Other projects may have issue security like only current assignee can view those requests.

Please check

Erik Bredevangen

The result is from several projects, allso Project1

Erik Bredevangen

@Suchi Abram wrong community?

Erik Bredevangen

@Jimmy Seddon @Milan Chheda [INFOSYSTA] @Sreenivasaraju P Thanks for all the help.

Milan Chheda [INFOSYSTA]

Happy to help and glad that your problem got resolved!

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-server