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

How to display Time Remaining in RTC Query result ?

Hello ,

When i click on the query i want to display a result set containing the columns like work item ID,owner,status and also "time remaining" . Can you please help how to add this particular column ? I checked the layout section of create query, but i don't see any Time Remaining attribute, but there is a Time Spent column.

Is it true that this column(Time Spent) displays Time Remaining value when we change the Track Progress value to 'Time Remaining' in Estimate attributes (Project area-project configuration- configuration Data-Planning) ?

Is there any other solution ?

Thanks...Johnson

1 vote



4 answers

Permanent link

Hi Vince,

The function is not supported yet. Please see enhancment WIs:

https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=80128

https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=118325

Regards,

Lily

2 votes


Permanent link
Hi Johnson,

I can answer part of your question.  The query results can have columns which represent built-in or custom attributes.  Does your work item have a time remaining attribute?  If not, you could create a custom attribute for your work items that calculates the time remaining.  Then you would be able to add the time remaining column to your query.

0 votes


Permanent link
Lauren, Time Remaining is a default field that appears in the 'Task' work item type (and perhaps others), so it is odd that is does not show up as an option for either a condition and result layout.  It is settable, so it does not appear to be automatically calculated when someone looks at the record.  I am interested in an answer to this as well, as I was just asked the same question.

-Vince

0 votes

Comments

Thank you Lily!  That second link helped by adding some information I didn't have before.  Time Remaining is automatically calculated when presented in the work item view.  And it does not look like this will be added any time soon.


Permanent link
 I know this is an old thread and i know i'm not going to get anything out of this.  Not being able to query time remaining out of a tool that describes itself as  "IBM Rational Team Concert (RTC) is a lean collaborative lifecycle management solution providing agile and formal planning, project reporting, process, work item, source code and build management."

but when you can't run simple queries most of the value is lost.


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
× 6,128

Question asked: Mar 07 '13, 6:26 a.m.

Question was seen: 7,296 times

Last updated: Dec 22 '16, 8:04 a.m.

Confirmation Cancel Confirm