Need to build a query to show work items started last week - please help!!
Maria Victoria Martinez Torino (149●2●45●59)
| asked Aug 14 '13, 11:53 a.m.
retagged Aug 14 '13, 6:14 p.m. by Ralph Earle (257●3●9)
Hi
I'm trying to build a custom query to show work items started during last week (lets say an action set from New to In Progress within the last 7 days, including today). So far I could figure out one of the query conditions: + Status is [Unresolved] + Type is [Action] Unfortunately, I don't know how to configure the condition to set the dates. Do you know if there is some OOTB feature for this? I am using RTC v4.0.2 Thank you! Victoria |
2 answers
Millard Ellingsworth (2.5k●1●24●31)
| answered Aug 15 '13, 5:34 p.m.
FORUM ADMINISTRATOR / JAZZ DEVELOPER
Hi, Maria!
Based on some research, I don't think this is currently possible using a query. I think you could create a plan view that would let you do this, albeit in a more round-a-bout way.
Background: Looking at this work item, it seems there exist both a Start Date and Actual Start Date. I'm querying the Tracking and Planning team about Start Date as it seems to be a built-in attribute that would be user-controlled (like Due Date) but I can't find a way to create an editor presentation that would allow me to set it. It's possible it is not meant to be visible (deprecated but not removed?). I tried creating several queries using Start Date and could not get any items returned.
If you edit a plan view, you will see a field called Actual Start Date. This field can be added to a plan column and does indeed seem to capture the moment at which the item was changed from New/Open to In Progress. You can also use this field in the Exclude filter in a plan view. I was able to create a plan view that excluded items that were not "In Progress" and were not started in the last 7 days (today-7). It's not as clean a solution as a query, but used in a sufficiently high-level plan should lasso the work items you are looking for.
Assuming picture posting will work, here is what my plan view looks like:
Comments Update: The Planning Component Lead confirms that the Start Date attribute is unused and unusable. I will follow up with a work item to hide or remove it. Actual Start Date is a planning-computed value not available to Work Items (at least at this time), so the solution above may be the best you can do for now.
An alternative (available now, hinted at by Ralph) would be to add a "Started Date" attribute to your work items and a CalculatedValue provider for it that records the transition from New to In Progress. If you feel the need to go that way, there are a variety of good discussions in the forum about calculated value providers and date fields and attribute customizations in general.
Geoffrey Clemm
commented Aug 16 '13, 11:21 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
I've created work item Obsolete "start date" property should not be exposed in query condition and result pages (276772) to get this attribute hidden/removed.
Sorry, Geoffrey, my bad. I should have added that I re-opened https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=90394 to get this fixed.
Geoffrey Clemm
commented Aug 16 '13, 12:28 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Thanks Millard ... I should have scrolled down further in the work item search results (given that this work item had the phrase "start date" in its summary, it's rather strange that it only got a 62% "search score" :-). And I was amused to note that I was the one who submitted 90394! (Although in my defense, it was 4 years ago, tomorrow, that I submitted it :-).
|
As far as I know, out of the box, there is no way to set a time constraint on a status change (ie, from New to In Progress). A couple of possible solutions that would give you part of what you need are to set a "Creation date" or "Modified date" condition as "after (including) 7 days ago".
Comments Hi Ralph,
Victoria, that's a good idea to use the Start date attribute. Since we don't generally track it in my project, I hadn't thought of it. In the query editor, you would click on "Add Condition" and select "Start date" from the list of attributes. Set it as "after (including) 7 days ago" (or the appropriate time interval). If you want to display the start date in your query results, select the column display tab in the query editor, click on "Add column," and select it from the list of attributes.
If you want to go further, you can add attributes to your existing work item types, or change which attributes display. These processes are described in the help topics. Here are the URLs in the 4.0.3 help: for the Web client http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m3/index.jsp?re=1&topic=/com.ibm.team.workitem.doc/topics/t_customizing_work_items_web.html or the Eclipse client: http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m3/index.jsp?re=1&topic=/com.ibm.team.workitem.doc/topics/t_customizing_work_items.html Hi Ralph, I tried using the "Start Date" attribute but it seems not to be working or maybe I am missing something else here. I set the query config as follows:
|
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.