JDeveloper version : 188.8.131.52.0
WebLogic Server version : 10.3.5 with patches
impact level : low
why : annoying
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 || '%') )
((Employees.LAST_NAME LIKE (:bindLN || '%'))
The query is executed with the missing where clause parts!
This is running in 184.108.40.206.0 and 220.127.116.11.0 (did not check 18.104.22.168.0).
(See also my blog http://tompeez.wordpress.com/2012/04/05/jdeveloper-case-insensitive-search-and-performance/)