Skip to Main Content
Forums

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Question on cascading LOV

Jose ArósteguiMar 16 2017 — edited Mar 17 2017

Hi experts,

I'm using Jdev 12.2.1.0 and I'm implementing 4 selectOneChoice with cascading dependencies.

It works fine by now as soon as you select values in order from 1 to 4, as the values are narrowed down:

screen1.png

But my problem is if users goes directly to value 4:

screen2.png

My requirement is that the list of field 4 is empty unless all previous 3 fields are not empty.

Thanks a lot,
Jose.
This post has been answered by Ashish Awasthi on Mar 17 2017
Jump to Answer

Comments

Cvele_new_account

try to set Disabled property for that fourth SOC, to be false _only if first three SOC attributes are set to non-null values...

OR, make 4.th SOC ;disabled property to be false only if 3.-th SOC value are set, then the same for 3. SOC (depends on 2. SOC), then the same for 2. SOC, etc... got a point?

Jose Aróstegui

Excellent idea!

Can you help me please a bit to build the expression?

I don't know how to reference the fields as they are inside a Query Panel based on a View Critera.


BR

Ashish Awasthi

This 4th Lov is dependent on all 3 lovs?

If you are using view cirteria then uncheck "Ignore Null Values" Check box in criteria to not show any data in case of no value is selected in other 3 lovs

Ashish

Jose Aróstegui

Thanks a lot for your help Ashish.

This 4th Lov is dependent on all 3 lovs?

2nd Lov depends on 1st

3rd Lov depends on 2nd

4th Lov depends on 3rd

If you are using view cirteria then uncheck "Ignore Null Values" Check box in ...

Ignore null values is not editable:

screen3.png

I've tried your solution Igonre null values in viewCriteria -Jdeveloper 12c (Not a bug but a change) – Ashish Awasthi's Blog (Jdev/ADF) but It didn't activate the checkbox either.

Regards,

Jose.

Ashish Awasthi
Answer

Hi Jose

It'll not activate checkbox , you just need to add GenerateIsNullClauseForBindVars="false" under viecriteriItem tag like this and then check

<ViewCriteriaItem

    Name="DepartmentId"

    ViewAttribute="DepartmentId"

    Operator="="

    Conjunction="AND"

    Value=":BindDeptId"

    IsBindVarValue="true"

    Required="Optional"

    **GenerateIsNullClauseForBindVars="false"**/>

After this 4th lov will not show any data untill 3rd one is selected

SnapShot.jpg

Ashish

Marked as Answer by Jose Aróstegui · Sep 27 2020
Jose Aróstegui

It works fine. I was confused and was setting the value to true:

screen4.png

Thanks a lot!

1 person found this helpful
Ashish Awasthi

Jose that post was not about this problem , It was about chnaging it's value only

Anyway you solved it  

1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 14 2017
Added on Mar 16 2017
#application-development-in-java, #jdeveloper-and-adf
7 comments
1,243 views