Hello All,
In jdev 12c 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
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 varibles it is disabled but sometimes you need to change it, so can change it using ViewObject xml source
Cheers :-)
In jdev 12c 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
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 varibles it is disabled but sometimes you need to change it, so can change it using ViewObject xml source
- Select ViewCriteria and go to source
- Now change GenerateIsNullClauseForBindVars="false" to true
Cheers :-)
No comments :
Post a Comment