Forum Stats

  • 3,826,740 Users
  • 2,260,701 Discussions
  • 7,897,066 Comments

Discussions

Question on cascading LOV

Jose Aróstegui
Jose Aróstegui Member Posts: 1,350 Silver Badge
edited Mar 17, 2017 7:36AM in JDeveloper and ADF

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.

Ashish Awasthi

Best Answer

  • Ashish Awasthi
    Ashish Awasthi Oracle ACE Member Posts: 3,388 Bronze Crown
    edited Mar 17, 2017 5:59AM 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

Answers

This discussion has been closed.