Why doesn't the result of drilling into a work items query match the statistics on the report?
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 += "¶meterName=ProjectAreaName¶meterValue="+projectArea;
teamArea = params["TeamAreaName"];
if ((teamArea != null) && (teamArea != ''))
result += "¶meterName=TeamAreaName¶meterValue="+teamArea;
result += "¶meterName=Category¶meterValue='"+row["CATEGORY_NAME"]+"'";
result += "¶meterName=Type¶meterValue='"+row["WI_TYPE"]+"'";
result;
Anyone can help me? Thanks in advance
Qi Li
One answer
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
