It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,882
×6,035
×324

question asked: Jun 13 '12, 8:20 p.m.
question was seen: 4,741 times
last updated: Jul 03 '12, 3:30 p.m.

Related questions

Why doesn't the result of drilling into a work items query match the statistics on the report?

0
1
Qi Li (13●5●17●18) | asked Jun 13 '12, 8:20 p.m.
JAZZ DEVELOPER
edited Jul 03 '12, 3:30 p.m. by Geoffrey Clemm (30.1k●3●30●35)
Hi,

I created a report  "Work Item Count by Category" that can drill into work items query, but find that the drilled work items don't match the the bar chart statistics on the report 

BTW, I choose the WorkItem_State to plot the main data set, 

the hyperlink is:

var serverURL = reportContext.getAppContext().get("SERVER_URL");
if (serverURL == null) serverURL = "";
result = serverURL + "#action=com.ibm.team.reports.viewWorkItems";
projectArea = params["ProjectAreaName"];
if ((projectArea != null) && (projectArea != ''))
result += "&parameterName=ProjectAreaName&parameterValue="+projectArea;
teamArea = params["TeamAreaName"];
if ((teamArea != null) && (teamArea != ''))
result += "&parameterName=TeamAreaName&parameterValue="+teamArea;
result += "&parameterName=Category&parameterValue='"+row["CATEGORY_NAME"]+"'";
result += "&parameterName=Type&parameterValue='"+row["WI_TYPE"]+"'";
result;

Anyone can help me? Thanks in advance

Qi Li

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
James Moody (3.3k●2●4) | answered Jun 18 '12, 9:04 a.m.
JAZZ DEVELOPER
Hi,

One way in which these can differ is related to archived work items, that is, work items in archived team areas, assigned to archived categories, belonging to archived users, etc. In some cases the report query works differently than a regular work item query in that respect.

Can you describe the difference? Which one contains more? Is one a subset of the other? The usual way to debug is to identify a single work item which is in one of these but not the other, and look for what is "special" about that work item - that gives us a clue.

james

Comments
Vladimir Amelin commented Jul 03 '12, 10:46 a.m.

In 3.x reports behaviour regarding archived artifacts is confusing users. I hear questions about such mismatches every day) I guess "include archived" checkbox should be on by default.

Your answer

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