Details

    • Target Version:
    • QA Status:
      PASS
    • Previous Issue Keys:

      Description

      The new search functionality implemented in GRBK-485 works on MySql but not Oracle. MySQL queries are case-insensitive, but in Oracle, the search parameters must match the case of the values in the database table. This can be fixed in the HQL for the search criteria by converting both values to lower case (or upper case). Here's an example of the HQL for the search criteria that works in MySQL but not Oracle:

      builder.append("and user.").append(searchField).append(" like :searchCriteria ");

      This works in both if changed like this:

      builder.append("and lower(user.").append(searchField).append(") like lower(:searchCriteria) ");

        Issue Links

          Activity

          Hide
          Jim Eng added a comment -
          This could also be solved using the hibernate Restriction.ilike() method.
          Show
          Jim Eng added a comment - This could also be solved using the hibernate Restriction.ilike() method.
          Hide
          Thomas Amsler added a comment -
          Merged UMICH patch into:
          - trunk
          - branches/1.5.x-test

          Created https://source.sakaiproject.org/contrib//gradebook2/tags/1.5.1-b2/ tag containing this change.
          Show
          Thomas Amsler added a comment - Merged UMICH patch into: - trunk - branches/1.5.x-test Created https://source.sakaiproject.org/contrib//gradebook2/tags/1.5.1-b2/ tag containing this change.
          Hide
          Nancy Wilkison added a comment -
          how do I test this one?
          Show
          Nancy Wilkison added a comment - how do I test this one?
          Hide
          Jon Gorrono added a comment - - edited
          search for students using upper and lower case.... should end up with the same results regardless.
          Show
          Jon Gorrono added a comment - - edited search for students using upper and lower case.... should end up with the same results regardless.
          Hide
          Nancy Wilkison added a comment -
          DEV
          SmartSite@UCDavis - 2.7.2-rc1 - Sakai 2.7.1 - Server "ucddev1"
          gradebook2 v1.6.0-a7

          TEST PROCESS -
          used Find to search for students using a variety of upper case only, lower case only and mixed case criteria.
          found the same students in all instances.

          QA RESULTS -
          pass

          if that's all I had to do:)
          Show
          Nancy Wilkison added a comment - DEV SmartSite@UCDavis - 2.7.2-rc1 - Sakai 2.7.1 - Server "ucddev1" gradebook2 v1.6.0-a7 TEST PROCESS - used Find to search for students using a variety of upper case only, lower case only and mixed case criteria. found the same students in all instances. QA RESULTS - pass if that's all I had to do:)

            People

            • Assignee:
              Unassigned
              Reporter:
              Beth Kirschner
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: