JQL query to find out team members that aren't working on any user stories, tasks or sub-tasks

Abdul Kader Broachwala

Hello Everyone,

I hope everyone is doing good.

I would appreciate it if anyone could please help me the below JQL query.

I would write a JQL query to find out which team members aren't working or any user stories, tasks or sub-tasks in the current sprint.

Lastly, once I have this query in place any suggestion which gadget should I be using to populate this data?

Thank you in advance.

Trudy P Claspill

You can't actually write a JQL query like that.

JQL is intended to return a list of issues based on criteria. It does not support returning lists of other entities (user, projects, etc.) 

There is no way to construct criteria for an issue such that you get a list of users who are not assigned to anything.

There is a work around suggested in this post:

https://community.atlassian.com/t5/Jira-questions/JQL-Can-I-list-users-who-don-t-have-any-issues-assigned-to-them/qaq-p/384607