How to create a cascadingLOV. 

step1:

We need to create the Location & countryEO’s,VO’s.

step2:

In the location VO we have the countryId so now we need to create the LOV for that.

step3:In the UI hint we need to select the countryName.




step4:Next we need to create the  new View object based on the queryVO.


step5:In this we need to select the stateprovince & then click on OK.



step6:Now in the query we need to write the query 
where country_id=:p_country
step7:We need to define a variable.
step8:Just click next –next---finish.

For the statesprovince we need to create the LOV.


step9:Save & run the AM.




step10:Now we need to create in jsf page

àlocationView Drag & drop from the Data control to jsf page.


step11:Select the Country Id as autosubmit true

step12:For the stateProvince we need to create the partial trigger dependency.,of CountryId

save & run the application.

select the stateProvince and click submit















  













Comments

Popular posts from this blog

Programmatically invoke a Popup to create a new row.

POJO(Plain Old Java Object) - Editable Data - DataControl.dcx

Dynamic Tabs in ADF