[CORE-65] Ontology term sorting order is case sensitive (should be case insensitive) - i2b2 JIRA

Details

Type: Bug
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: 1.6.02
Fix Version/s: 1.7.04
Component/s: Ontology Cell
Labels:
None

Developer Notes:

Hide
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

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

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.

Attachments

Activity

Ascending order - Click to sort in descending order

Lori Phillips added a comment - 05/Aug/14 12:47 PM

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)

Lori Phillips added a comment - 05/Aug/14 12:47 PM 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)

Janice Donahoe added a comment - 13/Aug/14 1:33 PM

sorting appears to be different between Oracle and SQL databases.

Janice Donahoe added a comment - 13/Aug/14 1:33 PM sorting appears to be different between Oracle and SQL databases.

People

Assignee:: Janice Donahoe

Reporter:: Lisa Miao

Participant/s:: Janice Donahoe, Lisa Miao, Lori Phillips

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 14/May/12 2:46 PM

Updated:: 02/Oct/14 1:09 PM

Resolved:: 18/Sep/14 11:14 AM

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

0.5d

i2b2 Core Software