Find the number of jira issues assigned to a person.

[Balu All]

I am looking for a JQL solution only (no widgets or Jira add-ons) to find the number of jira issues assigned to a person.

I am looking for something like this:

issueFunction in aggregateExpression("Velocity", "StoryPoints.sum()")

But, I need an aggregate value of total issues assigned. Thanks for your help.

[Brant Schroeder · Accepted solution]

@Balu All 

You can use a a filter and the following JQL assignee = UserName  this will return a full count of the issues assigned to that user.  

If you are going to be doing this often I would suggest using a dashboard to get this information.  You can use JQL to get all of the issue that are pertinent to what you are trying to do in a filter an save the filter.  Then create a dashboard to display the filter information.  A pie Chart or two dimensional gadget would work.  Then you can then just pull up the dashboard and see the assignments for all the users.

• https://support.atlassian.com/jira-software-cloud/docs/create-and-edit-dashboards/ 

[Balu All]

Thanks, Brant for your response.

Pie chart/Filter won't work because I am going to have to use a JQL in an excel macro code (via a REST call) to return "a number" as response.

For example, if I used this JQL -  issueFunction in aggregateExpression("Velocity", "StoryPoints.sum()"), I'd get one number as response.

[Brant Schroeder]

@Balu All I am suggesting that you use delivered features.  Not sure why you would need to use a function to get the issue count.  

[Balu All]

I understand what you are saying. Thanks, I fixed my code accordingly without  a function.