FROM THE BLOG

ADF Tips: JDeveloper 12.c – How to ignore null values in ViewCriteria

This is a short one while we find what is the real issue; when you are creating a view criteria in JDeveloper 12.c, there is an option to ‘Ignore Null Values’. Unfortunately, this option seems to be disable all time, what makes your View Criteria useless unless you specify a value for your binding variable. Let’s see;

adf bc view criteria jdeveloper 12c null values

If you want to check this, you can do it modifying directly the source;

adf_bc_vc_null_value_true_source

After this, you will be able to ignore the null values for your bind variable.

Here is the explanation of why this option is not available declaratively

1) Regarding “Ignore case”, as per the help page “This option is enabled for Strings only”.  I wont lodge a bug on this.

Regarding “Ignore case”, as per the help page “This option is enabled for Strings only”.  I wont lodge a bug on this.

Regarding “Ignore Null Values” as per the help page “This option is only enabled when Validation is set to Optional and the attribute value is supplied by a required bind parameter (those defined for use in a query WHERE clause)”.  In order to test this, create a bind variable on the VO query page, then in the ViewCriteria editor you can map to this new bind variable.  At that point the “Ignore Null Values” checkbox becomes available.

More information here – https://forums.oracle.com/thread/2566068

One comment

  1. Pingback: ADF Tips: Some known issues / bugs so far for JDeveloper 12.c | Oralublog - Oralution's Blog

Leave a comment

Your email address will not be published.

Social Media

Stay up-to-date with our latest ADF and related technical posts via your favourite social network services.