2017-09-22 18:50 PDT

View Issue Details Jump to Notes ]
IDProjectCategoryView StatusLast Update
0001560v3.5 Release (Development)[All Projects] Generalpublic2017-08-16 14:19
Reporteropto 
Assigned Toopto 
PrioritynormalSeverityfeatureReproducibilityhave not tried
StatusfeedbackResolutionopen 
Summary0001560: order project name lists by name, not capital/small letter
DescriptionCelltester xxy is not near celltester aaa in the list because default ordering orders by case of first letter.
First we have A...Z then a ... z instead of AaBb etc.

I don't really see any use for this type of ordering, it confuses everybody because they always have to look in two places for a project.

This definitely applies to drop down lists, I am not quite sure about general project lists.
TagsNo tags attached.
Attached Files

-Relationships
+Relationships

-Notes

~0003405

caseydk (administrator)

This has to do with mysql's sorting mechanism, we're just exposing it.. we could tweak the order by using something like:

$q->addOrder('lower(column_name)');

~0003406

opto (manager)

I think I would do that -having A-Z a-z separate feels uncommon.
On long lists one cannot see that there is a second alphabet further down.
Or can we reorder in PHP keeping the case?

~0003432

caseydk (administrator)

I've done some more research into this one..

Are you running mysql/php on Windows?

~0003683

caseydk (administrator)

*bump*

Are you running mysql on Windows?

~0003890

opto (manager)

yes, win 7 and win 10
+Notes

-Issue History
Date Modified Username Field Change
2014-05-30 00:19 opto New Issue
2014-05-31 11:48 caseydk Note Added: 0003405
2014-05-31 11:53 caseydk Project v3.2 Release => Pending Requests
2014-05-31 12:06 opto Note Added: 0003406
2014-06-10 22:30 caseydk Note Added: 0003432
2014-10-12 12:42 caseydk Note Added: 0003683
2014-10-12 12:42 caseydk Assigned To => opto
2014-10-12 12:42 caseydk Status new => feedback
2016-12-29 10:09 caseydk Project Pending Requests => v3.5 Release (Development)
2016-12-29 10:09 caseydk Category Projects => General
2017-08-16 14:19 opto Note Added: 0003890
+Issue History