It's all about the answers!

Ask a question

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

Qi Li (1351718) | asked Jun 13 '12, 8:20 p.m.
edited Jul 03 '12, 3:30 p.m. by Geoffrey Clemm (30.1k33035)

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 + "";
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"]+"'";

Anyone can help me? Thanks in advance

Qi Li

One answer

permanent link
James Moody (3.3k24) | answered Jun 18 '12, 9:04 a.m.

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.


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.