Need a JQRY for adding story points within a sprint

[anna_erba]

I want the query to count the number of story points in a sprint and then I will have one for each label.

[Hannes Obweger - JXL for Jira]

Hi @anna_erba

as Clark said, this isn't really what JQL is made for; JQL is for querying issues that match certain conditions, and doesn't by itself do any kind of aggregation or sum-ups.

If you're open to solutions from the Atlassian Marketplace, you'll find options there. E.g., this would be easy to do using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for issue grouping by any issue field(s), and sum-ups. With these, you can create a view like this in just a couple of clicks:

As you can see above, your report is fully interactive, meaning that you can work on your issues directly in JXL - but you can also trigger various operations in Jira, or export your data with just one click.

Any questions just let me know,

Best,

Hannes

[Hannes Obweger - JXL for Jira]

I just realised that you've tagged your question for Jira Server: As you may have heard, apps sales have ended for Jira Server. Are you planning to migrate to Data Center or Cloud? I'd strongly recommend that. If you need some more time, JXL is perfectly compatible with Jira Server; it's just that we need to generate a license for you. If the above looks interesting, just let me know, and I'll happily start a free trial.

[Clark Everson]

Hi @anna_erba 

This isn't something you can do with JQL. On a board, under backlog, you can click the 3 donts next to the sprint members and it will show workload by assignee and the total for the sprint.

But this is not searchable in JQL without a scritped custom field and you would need a plugin to do this like scriptrunner

Best,
Clark