[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

Status: Closed
Project: i2b2 Core Software
Component/s: Ontology Cell
Affects Version/s: 1.6.02
Fix Version/s: 1.7.04

Type: Bug Priority: Major
Reporter: Lisa Miao Assignee: Janice Donahoe
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: 0d
Time Spent: 0.5d
Original Estimate: Not Specified

Rank: 0|i000u7:
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.
Participant/s:

 Description   
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*.

Thanks,

lisa.

 Comments   
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.
Generated at Fri Jun 05 16:14:37 UTC 2020 using JIRA 7.6.3#76005-sha1:8a4e38d34af948780dbf52044e7aafb13a7cae58.