It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787
×5,997
×71

question asked: Jan 25 '13, 1:41 p.m.
question was seen: 4,980 times
last updated: Jul 30 '13, 10:35 a.m.

Related questions

FAQ - How this Forum works

query result sorted on Story Points displays unexpected order

0

2 answers

Most liked answers|Newest answers|Oldest answers ↑

0
permanent link
Lionel Li (231●1●12●16) | 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.

1
permanent link
Kevin Ramer (4.5k●8●183●200) | 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.

Your answer

Register or to post 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.