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

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

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

It's all about the answers!

Related questions

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

One answer

Your answer