It's all about the answers!

Ask a question

RTC: Is it possible to export the "Work Progress" attribute to CSV?


Clement Liu (1.5k54249) | asked Aug 28 '13, 9:34 a.m.
edited Aug 28 '13, 10:15 a.m.
The "Progress" attribute on work item. Is it possible to include it to the CSV export? Thanks.

 

Comments
Pavithra Kasturirangan commented Aug 26 '14, 3:27 a.m. | edited Apr 03 '19, 12:03 a.m.

 Hi , Were you able to get the Work Progress value ? I have created an attribute of type Small string and use "Calculated Value" 

I'm trying the simple script as below.
While configuring the calculated value on the new attribute created, i'm unable to find Workprogress or Progress as dependent field.

Please let me know if I'm doing something wrong.

dojo.provide("com.ibm.rukbs.ProgressCopy");
(function() {
    dojo.declare("com.ibm.rukbs.ProgressCopy", null, {
        getValue: function(attribute, workItem, configuration) {
                 var ProgressValue = workitem.getValue("Work Progress");
        return ProgressValue;
console.log("Progress Value is : " + ProgressValue);
        }
    });
})();


Eric Jodet commented Aug 26 '14, 3:52 a.m.
JAZZ DEVELOPER

 Hello,

 "Work Progress" is not defined as an attribute,
so I think your script will not return any value.

On the other hand, you may calculate it (hrs spent vs estimate / corrected estimate).

Eric


Pavithra Kasturirangan commented Aug 26 '14, 4:02 a.m. | edited Aug 26 '14, 5:33 a.m.

 Thank you, Eric


Unfortunately that's not straightforward as i have only Story points attribute on the Enhancement level. I need to fetch all the children and do this calculation :)

Accepted answer


permanent link
Eric Jodet (6.3k5111120) | answered Sep 03 '13, 4:44 a.m.
JAZZ DEVELOPER
 Hello Clement,
my understanding is that Progress is a calculated attribute (hours spent vs estimate)
and this work is done by the PlanRestService.
So I don't think it can be CSV exported.

As a workaround, you may want to add a hidden (no presented) and read-only custom attribute,
which value might be set by a custom js in that would fetch the value of the progress attribute.
This custom attribute could be CSV exported.


Hope it helps.
Eric.


Clement Liu selected this answer as the correct answer

Comments
Clement Liu commented Sep 03 '13, 10:09 a.m.

Eric, thank you.  

Your answer


Register or to post 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.