[CORE-65] Ontology term sorting order is case sensitive (should be case insensitive) Created: 14/May/12 Updated: 02/Oct/14 Resolved: 18/Sep/14
|Project:||i2b2 Core Software|
|Reporter:||Lisa Miao||Assignee:||Janice Donahoe|
|Original Estimate:||Not Specified|
|Developer Notes:|| Fixed in Navigate Terms and Find by Name
Find by Code not easy to fix bec. sql includes UNION and cant change order by upper(c_name) in UNIONs
|Testing Notes:||Tested with build 1.7.0004 and it appears to be working correctly.|
The Ontology term tree sorts the term by alphabetical order. What should happen is that it should be case *insensitive*. But right now it is case *sensitive*.
|Comment by Lori Phillips [ 05/Aug/14 ]|
This has been fixed for Navigate Terms and Find by Name.
Find by Code cant be fixed easily (has UNION in sql and cant change order by to upper(c_name) when there are UNIONs)
|Comment by Janice Donahoe [ 13/Aug/14 ]|
sorting appears to be different between Oracle and SQL databases.