What's the sort order on a widget displayed as a Table
I had always thought that a widget displaying work item statistics and displayed as a table, sorted by the count count of the entries lowest to highest
It seems in 4.0.5, this is now totally random The underlying queries condition has only a type selection and the display columns include Type, ID, Status and Summary. The widget is displayed as a table and grouped by Status ... This is definitely not sorting by the status or by the count per status type .. so what it is doing ? |
One answer
Ralph Schoon (63.5k●3●36●46)
| answered Aug 04 '14, 4:58 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Karen, I looked into it briefly. i think the sort occurs on the first attribute (status in your case) and depends on how these values are sorted. E.g. for priority I got high, medium, low, unassigned (Reverse order as stored, highest literal ID first). I am not sure how the sorting is implemented here. However, your state order above is almost certainly also sorted in a certain way which reflects on this statistics page. You can reorder states in the process XML. There is no setting on the statistics to order on the 2nd column I could find.
Comments doesn't seem to matter if I sort on the correct sequence in the XML - the widget when using the State just does not sort based on either the count or the state itself .. ;0(
|
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.