Bug 171442

Red Hat's current Bugzilla version is 2.18. I am moving all older open bugs to
this version. Any bugs against the older versions will need to be verified that
they are still bugs. This will help me also to sort them better.

This is still present.

Thanks, it's on my radar and I should get to it later this week.

ooops, I thought this was another bug. Please ignore my last comment :)

Red Hat Bugzilla is now using version 3.2 of the Bugzilla codebase and therefore this bug will need to be re-verified against the new release. With the updated code this bug may no longer be relevant or may have been fixed in the new code.
Updating bug version to 3.2.

This is still present.

Basically platforms, op_sys, severity, priority are all ordered by sortkey which is a numerical field in each table that contains those field values, so to sort them alphabetically we either need to change the sortkey numbering to reflect the alphabetical order of the field values, or we can change the sql to order by value rather than order by sortkey which is i think not a very good solution because we are ignoring what the sortkey is for. What do you think Dave?

Noura

Yes, I agree that we should not mess with the way the SQL is using the sortkey to sort the results. 

One solution is to run a query on the bugs table and look for the counts of each arch and then order them by popularity.

mysql> select rep_platform, count(rep_platform) from bugs group by rep_platform order by count(rep_platform) desc;
+---------------+---------------------+
| rep_platform  | count(rep_platform) |
+---------------+---------------------+
| All           |              176189 | 
| i386          |               72533 | 
| i686          |               21198 | 
| x86_64        |               12828 | 
| ia64          |                4543 | 
| powerpc       |                2556 | 
| athlon        |                2471 | 
| i586          |                1999 | 
| s390x         |                1169 | 
| alpha         |                1143 | 
| ppc64         |                 972 | 
| s390          |                 917 | 
| other         |                 758 | 
| sparc         |                 497 | 
| noarch        |                 422 | 
| ia32e         |                 175 | 
| sparc64       |                  52 | 
| sh4           |                  35 | 
| sparcv9       |                  28 | 
| arm9          |                  22 | 
| parisc11      |                  21 | 
| xscale        |                  14 | 
| alphaev6      |                  14 | 
| strongarm     |                  10 | 
| arm7          |                  10 | 
| ppc           |                   9 | 
| mips32        |                   6 | 
| sparclite     |                   4 | 
| synth         |                   3 | 
| sh3           |                   3 | 
| mips64        |                   3 | 
| mipstx39      |                   3 | 
| mipsnecvr4xxx |                   2 | 
| mipstx49      |                   2 | 
| mipsrm7000    |                   2 | 
| v850          |                   1 | 
+---------------+---------------------+
36 rows in set (0.20 sec)

Andrew, would you be fine with ordering it this way?

Dave

I guess.  I still think alphabetic is better for consistency but this is better than the current ordering and maybe I'm just weird in that I look for things in alphabetic ordering by default :)

Hey Dave,

I have ordered the rep_platform values according to popularity as you suggested and agreed with Andrew, for values with same popularity i ordered them alphabetically:

select rep_platform, count(rep_platform) from bugs group by rep_platform order by count(rep_platform) desc, rep_platform asc;

it should show now in live bugzilla

Noura

Thanks!