Hi. I am looking for a way to get a list of all that currently do NOT have anything in "In Progress"I am stuck creating the JQL
Hi @[deleted],
Thanks for posting and welcome to the community.
Could you please try like this to filter out with JQL and let me know if that helps ?
We need to phrase the status In Progress if it has other spellings.
Project = XXX and status not in (In-progress, "In Progress")
Hello @[deleted]
Welcome to the community.
You say you are trying to get a list of "all" that have nothing in progress. "all" what? All the people who have no in progress issues? All the projects that have no in progress issues?
JQL is for getting a list of issues, not lists of other things (people, projects, ...)
The JQL provided by @Suvradip Paul would provide you with a list of all the issues in Project XXX where those issues are not set to the statuses specified between the parentheses.
Thanks @Trudy P Claspill for pointing it and clarifying. I would be eager to hear from @[deleted]to assist in right direction.
Sorry, I mean all the people. Would probably use a subset of people, not the whole org. I would like to get a list of people not having anything in e.g. "In Progress" so I can verify what they are actually working on
You cannot get such a list with the native JQL functionality in Jira Cloud. As I said, the functionality is designed to provide you with a list of issues, not a list of users or other types of entities that exist in Jira.
If you are working with projects where there are Agile boards set up, those boards have a built in feature for showing you the users with Assigned issues. You could use those filters to see if those users have any in progress work. If a user is not shown in the filter area, that is an indication that they don't have any work assigned to them within the scope of that board.
This applies only to the context of issues in that particular agile board, though.
Are you trying to find users that have no issues assigned to them at all, or users with not issues that are in progress (users may have issues that are not in progress)?
What would you do with that list of users if you had it?
I'm trying to understand the core problem you are trying to solve to see if there is an alternate solution.
Hi Kristian - Welcome to the Atlassian Community!
You might start by creating and saving a filter like this:
statusCategory = "In Progress"
Then create a dashboard and add a gadget for Issue Statistics
Use the filter you created for the basis of the gadget
Group your filter by using Assignee for the Issue Statistic
The result should be a grouping with a count by assignee for all In Progress issues.
Then you can see who is not on the list since the filter will not show 0 (zero) in the list.
It shows like in the below image. The statuses are shown two times and the order is not identifiable.
@Bhagyalekshmi S
Welcome to the Atlassian community.
Do you use Team Managed projects in your Jira system? If so, the Status values in those are considered unique status values even when they are named identically to other status values. Because each status value is unique, it will show up as a separate statistic in that gadget.
Hi Trudy,
I am not using team managed project. Please suggest a way to find out the assignees who are not having or having less than two tasks in the in-progress status.
It looks like you're new here. Sign in or register to get started.
