We maintain CSV files of in sequence lists of standard issues that we import for each project. We also use an Agile Board with Ranking enabled, which handles multiple Projects.
The question is when we import issues into a project, how can we maintain the sequence of issues, keeping in mind that if we have multiple projects having a per project SortOrder field won't be sufficient. In any case, any ORDER BY clauses we include in the filter the Agile board is based on seems to be ignored. Eg ordering by 'key' doesn't take place:
category = "webapps" ORDER BY Rank ASC, Key ASC
I'm sure there is a way. At the moment, after importing, I'm having to manually reorder issues.
Thanks very much.
Actually, you've kind of answered your own question here.
The answer you got to the import into Greenhopper still stands. But ranking is another matter.
The key to understanding this is understanding the ranking field. Effectively, the rank field is a number which is maintained relative to all the others around it. Every issue's rank field is different and hence unique, across your entire Jira database. When you import your issues, they are given a rank as though they were new. I don't know if you can import a rank with them, but I'd simply try a number mapped on to the rank field if you can.
The reason your search doesn't appear to sort is precisely because the rank is unique. There's no further sorting to be done because every result has a different rank. In other words, the sorting IS working, and every result you are getting IS being sorted by key after rank, but the sort by key is only ever working with a single result.
You'd assume that if each issue that's imported in order gets a Rank value that puts it at the bottom of the list, then the sequence/order would be maintained. However, with either filter listed below the issues are imported out of sequence
category = "webapps" ORDER BY Rank ASC or category = "webapps" ORDER BY Rank ASC, Key ASC
I'll try seeding the Rank field in the CSV file with sequential values and post results shortly.
Same here - when I try to import the CSV with the "Rank" field, I do not see the equivalent "Rank" (Field Type: Global Rank) field in Jira. However, I can select the "Rank (Obsolete)" field which is not used anymore in the Agile templates.
If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot