Unable to sort WI based on Status
I am using RTC 4.0.1 Eclipse Client and found that I am unable to sort work items based on Status,
or more precisely, the sort order is not the one I would expect.
Steps I used:
1. Use any OOTB process template ( I tested with FMP or Scrum) and create a new PA
2. Create new Tasks, set it to different Statuses
3. Create a Query to list all Tasks and choose Status to be displayed in Columns to Display
4. Choose Status as Selected Sort Columns
5. Run the query to see the Tasks, the list is not sorted as per the Status label
It seems that sort order is not using label, as I would expect.
Is this a defect?
or more precisely, the sort order is not the one I would expect.
Steps I used:
1. Use any OOTB process template ( I tested with FMP or Scrum) and create a new PA
2. Create new Tasks, set it to different Statuses
3. Create a Query to list all Tasks and choose Status to be displayed in Columns to Display
4. Choose Status as Selected Sort Columns
5. Run the query to see the Tasks, the list is not sorted as per the Status label
It seems that sort order is not using label, as I would expect.
Is this a defect?
2 answers
No - enumerations are currently sorted based on value ID's and not labels.
This feature will be implemented with sort of enumeration should based on name rather than id (175676)
I can check the value id's by looking the Project Area source.
Example for the Resolution attribute:
(...)
<resolution icon='processattachment:/workflow/reject.gif' id='r5' name='Invalid'/>
<resolution icon='processattachment:/workflow/works.gif' id='r4' name='Works for Me'/>
<resolution icon='processattachment:/workflow/wontdo.gif' id='r3' name='Works as Designed'/>
<resolution icon='processattachment:/workflow/duplicate.gif' id='r2' name='Duplicate'/>
<resolution icon='processattachment:/workflow/close.gif' id='r1' name='Fixed'/>
<resolution icon='processattachment:/workflow/unresolve.gif' id='r0' name='Unresolved'/>
<resolution icon='processattachment:/workflow/close.gif' id='r8' name='Fixed Upstream'/>
(...)
which will result in this order:
<resolution icon='processattachment:/workflow/unresolve.gif' id='r0' name='Unresolved'/>
<resolution icon='processattachment:/workflow/close.gif' id='r1' name='Fixed'/>
<resolution icon='processattachment:/workflow/duplicate.gif' id='r2' name='Duplicate'/>
<resolution icon='processattachment:/workflow/wontdo.gif' id='r3' name='Works as Designed'/>
<resolution icon='processattachment:/workflow/works.gif' id='r4' name='Works for Me'/>
<resolution icon='processattachment:/workflow/reject.gif' id='r5' name='Invalid'/>
<resolution icon='processattachment:/workflow/close.gif' id='r8' name='Fixed Upstream'/>
This feature will be implemented with sort of enumeration should based on name rather than id (175676)
I can check the value id's by looking the Project Area source.
Example for the Resolution attribute:
(...)
<resolution icon='processattachment:/workflow/reject.gif' id='r5' name='Invalid'/>
<resolution icon='processattachment:/workflow/works.gif' id='r4' name='Works for Me'/>
<resolution icon='processattachment:/workflow/wontdo.gif' id='r3' name='Works as Designed'/>
<resolution icon='processattachment:/workflow/duplicate.gif' id='r2' name='Duplicate'/>
<resolution icon='processattachment:/workflow/close.gif' id='r1' name='Fixed'/>
<resolution icon='processattachment:/workflow/unresolve.gif' id='r0' name='Unresolved'/>
<resolution icon='processattachment:/workflow/close.gif' id='r8' name='Fixed Upstream'/>
(...)
which will result in this order:
<resolution icon='processattachment:/workflow/unresolve.gif' id='r0' name='Unresolved'/>
<resolution icon='processattachment:/workflow/close.gif' id='r1' name='Fixed'/>
<resolution icon='processattachment:/workflow/duplicate.gif' id='r2' name='Duplicate'/>
<resolution icon='processattachment:/workflow/wontdo.gif' id='r3' name='Works as Designed'/>
<resolution icon='processattachment:/workflow/works.gif' id='r4' name='Works for Me'/>
<resolution icon='processattachment:/workflow/reject.gif' id='r5' name='Invalid'/>
<resolution icon='processattachment:/workflow/close.gif' id='r8' name='Fixed Upstream'/>
