[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.
|