Friday, July 9, 2010

Making View Criteria Case Insensitive.

When you create view criteria you can easily set in each string criterion if it should be Case sensitive or not by checking or unchecking 'Ignore Case'.

Yet the default view criteria used in LOVs or criteria of fields added in advanced search are always Case Sensitive and you cannot declaratively change that.

I found a realy old post of Steve Muench for similar case in very old release of jdeveloper

and managed with little changes to apply it in latest release also:

Now all view criteria for string fields are case insensitive.

Note that this implementation will override any criterion you have set as Case Sensitive.
You can add this code to your base view object so that all view objects work like that.

test case:

No comments:

Post a Comment