adfemg
  1. adfemg
  2. ADFEMG-13

JDeveloper 11.1.2.1.0 don't show correct query in ViewCriteria editor

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Labels:
      None
    • Environment:

      Win7 64Bit, JDK 1.6.0, JDev 11.1.2.1.0

      Description

      JDeveloper version : 11.1.2.1.0
      WebLogic Server version : 10.3.5 with patches
      impact level : low
      why : annoying
      summary :
      JDeveloper don't show the correct query or where clause in the ViewCriteria editor when defining or editing a ViewCriteria for a ViewObject.
      When you create a new criteria both check boxes 'Ignore Case' and 'Ignore NULL Values' are checked (for applicable attributes). However, the 'View Object Where Clause' omits the parts of the where clause once you close the dialog and open it again.
      The where clause of a typical ViewCriteria with 'Ignore Case' should read like
      (UPPER(Employees.LAST_NAME) LIKE UPPER( :bindLN || '%') )
      but reads
      ((Employees.LAST_NAME LIKE (:bindLN || '%'))

      The query is executed with the missing where clause parts!

      This is running in 11.1.1.4.0 and 11.1.1.6.0 (did not check 11.1.1.5.0).
      (See also my blog http://tompeez.wordpress.com/2012/04/05/jdeveloper-case-insensitive-search-and-performance/)

        Activity

          People

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

            Dates

            • Created:
              Updated:
              Resolved: