Maintaining sequence of project issues imported from CSV file with Agile Board ranking enabled

Prem Mariappan

A while ago I asked a similar question with Greenhopper. But if I understand correctly there have been some changes in this area with Agile Board Ranking.

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.
Prem.

Nic Brough -Adaptavist-

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.