https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292013-10-13T18:24:21ZRedmineRedmine - Defect #15041: Issues list bad ordering by Subjecthttps://www.redmine.org/issues/15041?journal_id=525052013-10-13T18:24:21ZJean-Philippe Langjp_lang@yahoo.fr
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Closed</i></li><li><strong>Resolution</strong> set to <i>Invalid</i></li></ul><p>I guess you have a space before Cy... in the issue subject. If you edit the issue, you should see it.<br />Then you have non-alphabetic characters, that's OK.<br />The Se in not the start of the subjet (starts with [<a class="issue tracker-2 status-1 priority-4 priority-default" title="Feature: Support different units in "Attachment max. size" field. (New)" href="https://www.redmine.org/issues/2614">#2614</a>]... but the line is wrapped)<br />Then you have alphabetic characters in ascending order.</p> Redmine - Defect #15041: Issues list bad ordering by Subjecthttps://www.redmine.org/issues/15041?journal_id=525252013-10-14T00:50:31ZMischa The Evil
<ul></ul><p>Jean-Philippe Lang wrote:</p>
<blockquote>
<p>I guess you have a space before Cy... in the issue subject. If you edit the issue, you should see it.</p>
</blockquote>
<p>FTR: there actually isn't any space before it. See for yourself in the subject of <a class="issue tracker-1 status-1 priority-4 priority-default" title="Defect: Cyclic recursion redirects (New)" href="https://www.redmine.org/issues/12161">#12161</a>, since this is based on info from redmine.org. I actually can't see why this issue is placed there by sorting on subject.</p> Redmine - Defect #15041: Issues list bad ordering by Subjecthttps://www.redmine.org/issues/15041?journal_id=525352013-10-14T06:10:25ZVictor Sinceac
<ul><li><strong>Status</strong> changed from <i>Closed</i> to <i>Reopened</i></li></ul><p>There is also a second bad sorting case in the same case study (see image in attachments): the order in the bottom part of the list is Y, X, W. <br />About the JPL comment on "space before Cy": if the system would let leading spaces in subject, then this should be another issue: leading spaces shall be trimmed for such a field...</p> Redmine - Defect #15041: Issues list bad ordering by Subjecthttps://www.redmine.org/issues/15041?journal_id=525372013-10-14T06:25:29ZVictor Sinceac
<ul></ul><p>New case, raised by the request: <a class="external" href="http://www.redmine.org/projects/redmine/issues?sort=subject%2Cid%3Adesc">http://www.redmine.org/projects/redmine/issues?sort=subject%2Cid%3Adesc</a><br />The page 1/164 shows A, C, E, H, j, N, s, ", which cannot be a "desc" ordering on the first page...<br />The same, for the last page (<a class="external" href="http://www.redmine.org/projects/redmine/issues?page=163&sort=subject%2Cid%3Adesc">http://www.redmine.org/projects/redmine/issues?page=163&sort=subject%2Cid%3Adesc</a>), one can see: ΒΆ, A, C. Which cannot be a desc ordering on a last page.<br />Is this related somehow to the character encoding?</p> Redmine - Defect #15041: Issues list bad ordering by Subjecthttps://www.redmine.org/issues/15041?journal_id=525382013-10-14T06:26:41ZVictor Sinceac
<ul><li><strong>File</strong> <a href="/attachments/10608">Issues - Redmine 2013-10-14 06-17-50.png</a> <a class="icon-only icon-download" title="Download" href="/attachments/download/10608/Issues%20-%20Redmine%202013-10-14%2006-17-50.png">Issues - Redmine 2013-10-14 06-17-50.png</a> added</li></ul><p>Desc ordering, fist page</p> Redmine - Defect #15041: Issues list bad ordering by Subjecthttps://www.redmine.org/issues/15041?journal_id=525392013-10-14T06:27:17ZVictor Sinceac
<ul><li><strong>File</strong> <a href="/attachments/10609">Issues - Redmine 2013-10-14 06-19-12.png</a> <a class="icon-only icon-download" title="Download" href="/attachments/download/10609/Issues%20-%20Redmine%202013-10-14%2006-19-12.png">Issues - Redmine 2013-10-14 06-19-12.png</a> added</li></ul><p>Desc ordering, last page</p> Redmine - Defect #15041: Issues list bad ordering by Subjecthttps://www.redmine.org/issues/15041?journal_id=525762013-10-14T10:00:51ZJean-Philippe Langjp_lang@yahoo.fr
<ul><li><strong>Assignee</strong> set to <i>Jean-Philippe Lang</i></li></ul><p>Oh, I did't even notice that it was on redmine.org!<br />There was no space before Cy... indeed but the C was not an ascii C (maybe some kind of cyrillic C?. I've replaced it with a regular C and it's now properly sorted.</p>
<blockquote>
<p>the order in the bottom part of the list is Y, X, W.</p>
</blockquote>
<p>That's OK for a reverse ordering</p>
<blockquote>
<p>The page 1/164 shows A, C, E, H, j, N, s, ", which cannot be a "desc" ordering on the first page...</p>
</blockquote>
<p>These ones had a leading space (I've checked it). I've removed the spaces and they are now properly sorted.</p>
<blockquote>
<p>The same, for the last page</p>
</blockquote>
<p>This is also fixed.</p>
<p>The sort is done by the database, so it should be OK in most cases. But yes, issue subjects should be stripped automatically by Redmine.</p> Redmine - Defect #15041: Issues list bad ordering by Subjecthttps://www.redmine.org/issues/15041?journal_id=564492014-05-23T12:46:31ZStanislav German-Evtushenko
<ul></ul>I've noticed that sorting by subject groups issues by parent tasks, for example:
<table>
<tr>
<th>Subject (sorting)</th>
<th>Parent</th>
</tr>
<tr>
<td>task1</td>
<td><code>#1</code></td>
</tr>
<tr>
<td>task5</td>
<td><code>#1</code></td>
</tr>
<tr>
<td>task3</td>
<td><code>#2</code></td>
</tr>
<tr>
<td>task4</td>
<td><code>#2</code></td>
</tr>
<tr>
<td>task2</td>
<td><code>#3</code></td>
</tr>
<tr>
<td>task6</td>
<td><code>#3</code></td>
</tr>
</table> Redmine - Defect #15041: Issues list bad ordering by Subjecthttps://www.redmine.org/issues/15041?journal_id=564502014-05-23T12:47:49ZStanislav German-Evtushenko
<ul></ul><p>Update: Redmine version is 2.5.1</p>