Why is the Confluence Jira issues macro not returning items from the correct sprint?

I'm a Confluence/JIRA admin and I seem to remember that when using the Confluence JIRA issues macro, the search box would autocomplete my JQL just as if I was in JIRA.  But it's not working today ... am I misremembering?  I only noticed it because I found another (seemingly new) problem when linking a page to an agile sprint's list of issues: 

I have two JIRA sprints in different projects.  They are labeled "2015.1.1" and "ABC2015.1.1" (not real name).  Note the first is a substring of the second.  If I search

sprint = 2015.1.1

in JIRA it converts to

sprint = 107

and returns the correct items.  But if I use the Confluence JIRA issues macro, the doesn't convert to the numeric sprint value and the macro returns all items from both sprints.  Looking back at all my historical sprint wiki pages, the macros now list all items from pairs of sprints with similar names!


Jira: 6.2

Confluence: 5.4.3


Only recent config change I can think of is that last week I set up the 10 user version of Fisheye and linked it to JIRA (it's working fine).


Thanks in advance.

1 answer

It seems like JIRA is converting your String value to the correct Sprint ID.

At first, using a JQL statement like this one:

sprint = "2015.1.1"

should retrieve all issues that are currently assigned to this specified sprint.

However, if JIRA is having trouble parsing this data, for whatever reason it might be (you can also try a re-index, maybe), then, you can use the search to reference directly the Sprint ID instead of the Sprint's name, as per this doc:

I should retrieve the correct issues.

If by any means you still face any problems while querying for your issues, please do not hesitate to contact Atlassian Support at support.atlassian.com.


Thanks and hope it helps!

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Feb 06, 2019 in Confluence

Try out the new editing experience

Hi team, I’m Avinoam, a product manager on Confluence Cloud, and today I’m really excited to let the Community know that all customers can now try out the new editing experience and see some of the ...

844 views 41 6
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you