Ignore null values in ViewCriteria -Jdeveloper 12c (Not a bug but a change)

Sharing is Caring

Hello All,
In JDeveloper there is some change in viewCriteria design window, there is a checkbox to ignore null values in criteria, in 11g release it was enabled for all values in criteria item.but in 12c it is disabled for all values of ViewCriteria bind variable

Ignore null values

there is two different section for creating bind variable in 12c
1. ViewCriteria Bind Variable
2. Query Bind Variable(Required)
So when you create a bind var of string type in query variables.

and use it in viewCriteria, only then this ‘ignore null values’ checkbox will be enabled

and when you use viewCriteria bind variables it is disabled  but sometimes you need to change it, so can change it using ViewObject XML source

  • Select ViewCriteria and go to the source
  • Now change GenerateIsNullClauseForBindVars=”false”  to true

 Cheers 🙂 Happy Learning

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *