I've migrated thousands of issues from Rally to JIRA, now seeing many in the JIRA backlog.
I see the backlog query is showing like this:
project = CVE AND status in ("10100", "3", "11600", "10002", "11603") AND (cf is EMPTY OR cf not in openSprints()) AND issuetype in standardIssueTypes() AND issuetype != "10000" AND NOT status in ("11600") ORDER BY Rank ASC
From https://rbcjira.devfg.rbc.com/rest/api/2/field, I see cf is Sprint. How can I find out what's the name for the ids in the status?
That's quite a complex query, and if it is viewing "too many" issues on the board, I would say there is something not quite right with the OR parts.
Decompose it, and try to simplify. Do you really mean
My best guess is that the second clause is grabbing vast swathes of issues from other projects.
I would simplify:
I would use
Thank you so much for the detailed explain. I think I missed something here.
See the attached screenshot. I simply access the Backlog from the menu left. The query was showing when I click the icon looks like a CPU. I was assuming the backlog is generated by a fix query in JIRA, but seems like the query is generated by looking at issues in Backlog (the other way round)?
The backlog is
The backlog absolutely is generated by the board filter, not the other way around. Your filter is complex and long.
Can you try going to "board configuration" to see what we're really looking at? Should be some ellipses (...) near the top right
Ah, I think I know part of the answer.
That blue icon you are clicking is being injected by one of your apps, and it's doing heck-knows-what. None of the Cloud or Server (or the DC) installs I've got access to have it.
I think we need to find out where that is coming from and what it is supposed to be doing.
Ah, that has just kicked me in the memory! Thank you so much.
It absolutely is coming from ScriptRunner. It is there to try to give you the option to see the sprint, or backlog, that is currently in front of you.
But I think the complexity and an oversight is misleading us here. I have certainly mis-read one of your screenshots.
I think the second thing I've missed is the Sprint field. If an issue is in a sprint, it will be grouped within that sprint, and will not be in the backlog section as shown in your screenshot. There are two ways to get a display like what you have there and you may be suffering one or both!
First, you have "backlog" named (with 1442, then the ScriptRunner icon) on the top line. Whilst this looks like a backlog, you might get that display if you have a sprint named "Backlog". I do not know if you have done that, but if you have, please don't. "Holding sprints" break all sorts of things.
Second, if you look at the second line in the display of the three issues, they start with none/sprint 2/sprint 2. This does not look like the Sprint, it looks like a (probably custom) field that holds some options (obviously, one of which is "Sprint 2"). But not the actual Sprint field. This makes me think that when we go back to your original question, there's a problem. You say "cf is Sprint" which is accurate, but also misleading (by Jira, not you!). It would be better to say "cf is a field called Sprint which is just a text or select field, not the actual Sprint"
So, more digging needed. Two questions
Can you go to Admin -> Issues -> Custom Fields and use ctrl-f to look for "Sprint". How many hits do you get? (I'm looking for an answer of "3", but it might be translated - the more complete search is that I am looking to check that you have one, single, field called "Sprint", which is "locked", has a type of "Jira Sprint Field" and a description of "Jira Software sprint field".
Can you go to Issues -> Search, and run the advanced search of "Sprint = Backlog"? Do you get any results, or an error?
Thank you so much for your input. Unfortunately the answer to all your questions are no.
1. There is no Sprint called Backlog.
2. There is only 1 Sprint in the custom field, and the id is 10004.
3. There is no issue with "Sprint = Backlog"
Please note: now when I create a new board "Jirong", the Backlog shows right. The query shows:
project = CVE AND status in ("10100", "3", "11600", "10002", "11603") AND (cf is EMPTY OR cf not in openSprints()) AND issuetype in standardIssueTypes() AND issuetype != "10000" AND NOT status in ("11600", "10002", "11603") ORDER BY Rank ASC
Compare to the query in the bad board, the difference is later added two more status, and If I use this new query to replace the one in the bad board, the result is the same. So the question is still: how this query is generated?
Another issue I found is the Sprint Report doesn't shows a chart, not sure if it's related. It's even the same in the newly created board "Jirong". Also I couldn't change the Sprint Complete Date. This is how I migrate these issues from Rally.
1. Create all Sprints (maps to Iterations in Rally) with startDate, endDate.
2. Import all issues from Rally, map the Iteration Names to Sprint IDs.
3. Use a loop to Start and Complete all Sprints, using REST API. Because of this, the Sprint Complete Date shows the date I run the REST API. I tried to update it through REST API but doesn't work. That's why in the chart, the end date is this month.
4. Note that "Issue added to sprint after start time".
That query is generated by jira. The contents of the query is nothing to do with us. We're just surfacing it so that you can view the backlog issues in the issue navigator. That is the actual query jira is using to show the issues in the backlog on the planning board.
> The weird thing is when I look at our JIRA PROD server, the query for Backlog is simple as:
project = CVE and sprint is empty ORDER BY Rank ASC
You must have an older version of SR4Jira, this was changed as part of https://productsupport.adaptavist.com/browse/SRJIRA-3954?jql=project%20%3D%20SRJIRA%20and%20text%20~%20%22backlog%20query%22.
Although now I look I see there is a follow-up and a new issue: https://productsupport.adaptavist.com/browse/SRJIRA-3366. I haven't properly investigated that yet.
Either way, check the version of the plugin you have and see if either are before 5.6.8.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event