Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-65

Ontology term sorting order is case sensitive (should be case insensitive)

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.6.02
    • 1.7.04
    • Ontology Cell
    • None
    • 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
    • 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
          lisamiao Lisa Miao created issue -
          jmd86 Janice Donahoe made changes -
          Field Original Value New Value
          Workflow classic default workflow [ 10188 ] i2b2 Issues [ 10285 ]
          jmd86 Janice Donahoe made changes -
          Workflow i2b2 Issues [ 10285 ] i2b2 Issues Workflow [ 10436 ]
          mem61 Mike Mendis made changes -
          Fix Version/s 1.7.03 [ 10100 ]
          mem61 Mike Mendis made changes -
          Assignee Mike Mendis [ mem61 ] Lori Phillips [ lcp5 ]
          jmd86 Janice Donahoe made changes -
          Component/s Ontology Cell [ 10054 ]
          Component/s Ontology Cell [ 10001 ]
          Fix Version/s 1.7.03 [ 10156 ]
          Fix Version/s 1.7.03 [ 10100 ]
          Key LEOPARD-105 CORE-65
          Project i2b2 [ 10000 ] i2b2 Core Project [ 10034 ]
          Affects Version/s 1.6.02 [ 10143 ]
          Affects Version/s 1.6.02 [ 10060 ]
          lcp5 Lori Phillips added a comment -
          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)
          lcp5 Lori Phillips added a comment - 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)
          Permalink
          lcp5 Lori Phillips logged work - 05/Aug/14 12:48 PM
          • Time Spent:
            0.5d
             
            <No comment>
          lcp5 Lori Phillips made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          lcp5 Lori Phillips made changes -
          Worklog Id 10005 [ 10005 ]
          Remaining Estimate 0d [ 0 ]
          Time Spent 0.5d [ 14400 ]
          lcp5 Lori Phillips made changes -
          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
          Status In Progress [ 3 ] Ready to Test [ 10001 ]
          lcp5 Lori Phillips made changes -
          Assignee Lori Phillips [ lcp5 ] Janice Donahoe [ jmd86 ]
          jmd86 Janice Donahoe made changes -
          Status Ready to Test [ 10001 ] Testing [ 10002 ]
          jmd86 Janice Donahoe added a comment -
          sorting appears to be different between Oracle and SQL databases.
          jmd86 Janice Donahoe added a comment - sorting appears to be different between Oracle and SQL databases.
          jmd86 Janice Donahoe made changes -
          Status Testing [ 10002 ] Reopened [ 4 ]
          jmd86 Janice Donahoe made changes -
          Fix Version/s 1.7.04 [ 10160 ]
          Fix Version/s 1.7.03 [ 10156 ]
          jmd86 Janice Donahoe made changes -
          Assignee Janice Donahoe [ jmd86 ] Lori Phillips [ lcp5 ]
          lcp5 Lori Phillips made changes -
          Status Reopened [ 4 ] In Progress [ 3 ]
          lcp5 Lori Phillips made changes -
          Status In Progress [ 3 ] Ready to Test [ 10001 ]
          lcp5 Lori Phillips made changes -
          Assignee Lori Phillips [ lcp5 ] Janice Donahoe [ jmd86 ]
          jmd86 Janice Donahoe made changes -
          Status Ready to Test [ 10001 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Testing Notes Tested with build 1.7.0004 and it appears to be working correctly.
          Status Testing [ 10002 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Build Number (Fixed) 1.7.04.0001
          Resolution Fixed [ 1 ]
          Status Testing [ 10002 ] Resolved [ 5 ]
          jmd86 Janice Donahoe made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

          People

            jmd86 Janice Donahoe
            lisamiao Lisa Miao
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 0.5d
                0.5d