Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Generating tree structure of Work Items for export

Questions
Tags
Users
Badges
Matthew Petty
(16●2●3) Jul 30 '14, 6:39 p.m.
We are using Work Items to represent Configuration Items in our hardware/software system. They are in a hierarchy, using the parent/child relationship link mechanism. There are multiple levels of links, up to a maximum of about 5.

I need to generate a report, or some kind of exportable data, that would show the structure of our system with its parents and children, with the multiple levels.

Is this possible in RTC?

I've seen a lot of answers in this forum relating to planning and viewlets and tree-view, but we are not using those parts of the system at this time. We're not using planning, just the Work Item mechanism for CM. I realize this may be an issue.

I would be very grateful for any assistance, even to tell me where to start looking.

1 vote

3 answers
6,513 views
1 vote

3 answers

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (63.9k●3●36●48) Jul 31 '14, 3:14 a.m.
Matthew,

You can export to CSV, with links, but it is probably hard to limit the export with a query.
You could try to use the Rational Publishing Engine to create a report. I am not an expert for the RPE, so I can't tell the effort.
It would be possible to use available API to create any kind of export format you want. This is a slightly higher effort. I am not sure in which way you want the data. Let me know if you consider this and I can point you to resources with at least some API examples.

0 votes

Permanent link
Matthew Petty
(16●2●3) Aug 01 '14, 7:29 p.m.
Ralph,
I just want to be able to view the structure of the system as defined by Parent/Child links, or by WI attributes. A collapsible tree structure (like a folder structure) would be great. If I could nicely format it and print it, that would be even better.
We don't have RPE, and I'm loathe to climb that particular learning curve right now.
(By the way, given that RTC is running on SQL Server, is there a way to report on data using a third party tool like Crystal Reports?)
Please explain more about the API.
Thanks for your help,
Matthew

0 votes

Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Aug 04 '14, 2:16 a.m.

Matthew,

Eclipse allows to create all sorts of extensions like tree views.The SDK should also have various classes, that you might be able to use. However it is not trivial to use and has a steep learning curve. Here would be my suggestions to get started:

https://rsjazz.wordpress.com/2013/03/14/what-apis-are-available-for-rtc-and-what-can-you-extend/
https://rsjazz.wordpress.com/2013/02/28/setting-up-rational-team-concert-for-api-development/
https://rsjazz.wordpress.com/2013/03/20/understanding-and-using-the-rtc-java-client-api/
https://rsjazz.wordpress.com/2013/01/02/working-with-work-item-attributes/
https://rsjazz.wordpress.com/2012/09/19/the-rtc-workitem-link-api-linking-workitems-to-other-elements/

1 vote

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Aug 04 '14, 3:34 a.m.

I forgot to answer the other part. I don't think Chrystal Reports is an option. A lot of the data in CLM is not stored as a readable attribute in a relational database, but as blobs. In addition, the data structure is based on EMF. You may try, but you might not be able to access the data you want.

Permanent link
Darrell Reich
(9●5●9) Oct 16 '18, 4:11 p.m.

WBS layout in Plan view allows you to see the hierarchy in the current sprint however it does not show complete or back log items at the same time. RTC should add a view work item tree mode to show Epic-Story-task nested work items.


Looking at the top or bottom work item, the links tab shows the children or parent one level up or down.

I was able to add "children" field to my query and export the work items to csv but then had to get out post-it notes to make my own tree from the data that looks like id, children; 1234, #1240 #1241 showing 1234 has two children.

We're using RTC 6.0.4. There are lots of view but it seems like please add a work item tree view should get voted up for an upcoming release?

We're not looking to purchase additional reporting software at this time. Like planning mode, we are looking for an interactive view to be able to edit the tree as needed, reassign the tasks to others, etc.

0 votes

Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Oct 17 '18, 2:25 a.m.

Create an request for enhancement here: https://www.ibm.com/developerworks/rfe/execute?use_case=changeRequestFAQ#jazz


Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,019
× 369
× 3

Question asked: Jul 30 '14, 6:39 p.m.

Question was seen: 6,513 times

Last updated: Oct 17 '18, 2:25 a.m.

Confirmation Cancel Confirm