It's all about the answers!

Ask a question

query result sorted on Story Points displays unexpected order


2 answers



permanent link
Kevin Ramer (4.5k6177196) | answered Jan 25 '13, 4:17 p.m.
Also, if you've been bitten by added entries to complexity you'll recall that their ID are numeric strings.  Even when sorting those they don't order correctly (unless converted to integer values).

                <enumeration attributeTypeId="complexity" name="complexity">
                    <literal default="true" id="0" name="0 pts"/>
                    <literal id="1" name="1 pt"/>
                    <literal id="2" name="2 pts"/>
                    <literal id="3" name="3 pts"/>
                    <literal id="5" name="5 pts"/>
                    <literal id="8" name="8 pts"/>
                    <literal id="13" name="13 pts"/>
                    <literal id="20" name="20 pts"/>
                    <literal id="40" name="40 pts"/>
                    <literal id="100" name="100 pts"/>
                </enumeration>

sort alphabetically is: 

0
1
100
13
2
20
3
40
5
8



Comments
Andrew Codrington commented Jul 30 '13, 10:19 a.m.

Just hit this wall/obstacle/speedbump. Following links to see if there's a workaround.


permanent link
Lionel Li (23111216) | answered Jan 25 '13, 1:41 p.m.
JAZZ DEVELOPER
 

This kind of issue is caused by sorting feature is sorting by id instead of name. 

Comments
sam detweiler commented Jul 30 '13, 10:35 a.m.

well, its really cause the sorting is alphabetical, and not numerical. Both id and name would produce improper sorting as compared to numerical.

Your answer


Register or to post your answer.