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

How do I add "Planned Start Date" to the list of attributes I can use to build a work item query?

After creating a Traditional project plan and creating a snapshot to get "Planned Start Date" established I want to be able to create a query of Task work items ordered by "Planned Start Date". 

Currently "Planned Start Date" is not one of the attributes listed that can be selected for "Conditions" or "Display" when creating a query.

I can create a query where I can use "Ranking" as a way of sorting but using "Ranking" is not accurate when you have "predecessor/successor" relationships. I really need to be able to use "Planned Start Date".

In the web client I can create a plan "view" that does what I want but a user would have to "switch" back and forth between eclipse and the web to get the "complete picture".  As they work primarily in eclipse a query that can produce the same results as the "view" is what is really needed.

1

1 vote

Comments

We need this kind of information too. The Formal Project support in RTC atm is quite poor due to this issue. Developers in Eclipse and VS cannot just run a query to see their work assigned for the week or in a Planned Start/End Date ordering. They must go into the plan for every release/project that they are assigned to and then calculate what their focus and effort should be applied to. Avoiding this is the primary reason that we purchased RTC and we expected this kind of support for Formal Projects out of the box. It does not exist.


We have heard that it may be possible to create a report that would give a developer their assigned tasks in planned start/end date order, but we have not been able to figure that out yet. Finding examples for how to manage Formal Project plans online is also extremely difficult. There are a couple really basic articles on jazz.net, but they do not talk about the most important parts of doing formal project planning and the areas that we need answers on are just not addressed at all.


Accepted answer

Permanent link
Hi Donald, as far as I can tell, that data "lives" in the plan snapshot. It is calculated in the plan and only available in the plan. It is not available in the work item as real attribute. Therefore it is also not available in work item queries. I think this was true for the ranking attribute in the past too, until it was elevated.
Ralph Schoon selected this answer as the correct answer

1 vote

Comments

1 vote

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
× 12,016
× 239
× 201

Question asked: Mar 06 '13, 5:36 a.m.

Question was seen: 5,592 times

Last updated: Jun 18 '13, 6:16 a.m.

Confirmation Cancel Confirm