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

Query results questions

I currently have the following questions regarding creating query results

* Is there a way to include the parent item id when querying work items?
* Is there a way to include item in the quick information (related, blocks, subscribers) in the query result?
* Is there a way to configure the unit of time in the time fields (estimate, corrected, spent) to use hours and not translate them into day formats?

I am hoping there are out of the box ways to do these without hitting the database. Thanks.

ciao!

0 votes



3 answers

Permanent link
* Is there a way to include the parent item id when querying work
items?
* Is there a way to include item in the quick information (related,
blocks, subscribers) in the query result?

In the "Work Items" view menu, there's an entry "Relationships...". This
opens a dialog to select the relationships to be shown, such as the
parent work item, related and blocked work items. However, I'm not aware
of a feature to show the subscribers.

* Is there a way to configure the unit of time in the time fields
(estimate, corrected, spent) to use hours and not translate them into
day formats?

This is currently not possible. While the values are always stored using
the same unit of time, they are formatted as a string using an
automatically determined unit of time.

--
MikeS
Jazz Agile Planning team

0 votes


Permanent link
* Is there a way to include the parent item id when querying work
items?
* Is there a way to include item in the quick information (related,
blocks, subscribers) in the query result?

In the "Work Items" view menu, there's an entry "Relationships...". This
opens a dialog to select the relationships to be shown, such as the
parent work item, related and blocked work items. However, I'm not aware
of a feature to show the subscribers.


Is there a way to have this information exported into HTML/CSV as well?

This is currently not possible. While the values are always stored using
the same unit of time, they are formatted as a string using an
automatically determined unit of time.


I will log a request for enhancement then. Thanks!

ciao!

0 votes


Permanent link
Hello everyone,

In RTC 3.0, is there a way to configure query results to show estimates in days rather than hours?

Thanks
Sunil

0 votes

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.

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

Question asked: Sep 10 '08, 12:54 a.m.

Question was seen: 6,904 times

Last updated: Sep 10 '08, 12:54 a.m.

Confirmation Cancel Confirm