work item statistics viewlet

From the Web interface, you can create queries that include all fields, but you can't display some of the fields and you can sort on even few fields.

For example, I wanted all work items related to my stories, so I can query on the parent work item fields, but I can only display the parent id and I can't sort on the parent id at all.

RE: Comment #1

>> but it ignores the query when it displays statistics and shows information
>> for ALL work items. It would be really handy to have it only show
>> statistics for work items returned by the query.

The viewlet does the latter by design. To verify this, create a query in the Work Items Web UI and run it. Note the result count. Configure a Work Item Statistics viewlet with the same query and save. The result count in the viewlet title should match. Also, the tallies of each of the grouped parameters should add up to the total (unless the grouping parameter is "tags", because a work item can have many tags).

RE: Comment #2

I believe you are referring to the Work Items Web UI.
I will let someone from the Work Items team comment on this one.

From the Web interface, you can create queries that include all
fields, but you can't display some of the fields and you can sort on
even few fields.

For example, I wanted all work items related to my stories, so I can
query on the parent work item fields, but I can only display the
parent id and I can't sort on the parent id at all.

These are technical restrictions. As we show only a page of the whole
result set in the Web UI, local sorting would only sort a page. Sorting on
the repository is possible only within the limits of the database/query
model.

--
Regards,
Patrick
Jazz Work Item Team

I used the same query in both a work item and a work item statistics viewlet and there should only be 4 work items in the statistics viewlet, but it shows all the work items in the repository. I will create a work item so I can attach an image. See Defect 74433.

RE: Comment #1

>> but it ignores the query when it displays statistics and shows information
>> for ALL work items. It would be really handy to have it only show
>> statistics for work items returned by the query.

The viewlet does the latter by design. To verify this, create a query in the Work Items Web UI and run it. Note the result count. Configure a Work Item Statistics viewlet with the same query and save. The result count in the viewlet title should match. Also, the tallies of each of the grouped parameters should add up to the total (unless the grouping parameter is "tags", because a work item can have many tags).

RE: Comment #2

I believe you are referring to the Work Items Web UI.
I will let someone from the Work Items team comment on this one.