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) ");

        Gliffy Diagrams

          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: