Can I query the "+1" or "+2" etc, value on the Sprint field in my JQL?

[Olga Frias-Basta]

Issues that carryover from sprint to sprint have a +1 or +2, etc, for the # of times they've carried over. Can I access that value in my JQL?  Trying to report on stories that have carried over more than one sprint for a given time frame.

[Mikael Sandberg]

No, JQL doesn't allow you to do that. You could use automation and a custom field, and every time you start a sprint you could update it with the number of sprints each issue has in the sprint field. The smart value would be something like this:

This example only logs the size in the audit log for the automation, but you could use a component that edit the issue and sets the value of the custom field to ((issue.sprint.size}}

[Hannes Obweger - JXL for Jira]

Hi @Olga Frias-Basta

if you're open to solutions from the Atlassian Marketplace, this would also be easy to do with the app that my team is working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view 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 so-called “smart columns” that aren’t natively available, including the number of sprints (along with many other sprint-related data). 

This is how this looks in action:

Once you've narrowed down your list of issues, you can work on your issues directly in JXL, trigger various operations in Jira, or export your issues with just one click. You can also use the all sprint-related columns across JXL's advanced features, such as support for issue hierarchies, issue grouping, sum-ups, or conditional formatting.

This all "just works", so there's no scripting whatsoever required.

Any questions just let me know,

Best,

Hannes