Uploaded image for project: 'Contrib: Gradebook2'
  1. Contrib: Gradebook2
  2. GRBK-1076

Enhanced Search does not work on Oracle

    Details

      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

          Attachments

            Issue Links

              Activity

                People

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

                  Dates

                  • Created:
                    Updated:
                    Resolved: