How to update rank of multiple work items ?
![]()
Hi
Is there anyway to massively update the rank of multiple work items? Or is dragging and dropping the work items in the backlog plan the only option? Can the massive update be done in a programmatic way ? The solution does not have to involve Excel. I will consider any option. Regards Naveen |
3 answers
![]()
Ralph Schoon (63.3k●3●36●46)
| answered May 22 '12, 3:15 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
In general ranking is something manual, to provide a custom order in a plan. So it is a manual process. The attribute value is calculated by the plan.
In 4.0RC1 I was able to rank work items and create a query that displays the coumn "Rank (relative to priority)". The column values look like: priority.literal.l11 O00005 You could try (on a test system) to export to CSV, modify the rank and re-import with update. If that does not work the only chance I see is using the plain java client libraries and try to write a tool that modifies the rank, if possible. |
![]()
Hi Ralph,
Thanks for the suggestion! I work with Naveen Arora. I tried to update ranks by importing them from Excel, but it did not work in our current RTC version 3.0.1.1. Could you please provide more information about the java client libraries that you mention in your post? Thanks, Lee Gemma Fu-Sun CA technologies APM Shared Services Associate Configuration Management Engineer Tel: +1-650-534-9555 Mobile: +1-415-335-5629 Gemma.Fu-Sun@ca.com |
![]()
Ralph Schoon (63.3k●3●36●46)
| answered May 24 '12, 2:58 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hi Lee,
the article https://jazz.net/library/article/807 talks about using the plain Java Client Libraries. https://jazz.net/wiki/bin/view/Main/ProgrammaticWorkItemCreation talks about programmatic work item creation. There is a code example to be used with the plain java client libraries. If you use that as a starter and modify it you would change the WorkItemInitialization inner class to something like:
And call it like this:
I have not tested this code! You need to look up the attribute ID for RankByPriority (if it exists as attribute), there is no direct setter. |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.