Question on cascading LOV

Jose Aróstegui

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:

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

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

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

Ashish

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:

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

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

Ashish

Jose Aróstegui

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

Thanks a lot!

Ashish Awasthi

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

Anyway you solved it