Hello, last video I talked about cascade list of value in this video I need to implement this cascaded list of value so we need to follow these five steps. So the first step is create all view object which will be used as a list of value. So let's go to the developer okay. So let us now create new application I will create ADF application can guess key it will be application okay kitty Louis application Nicolas Nicolas okay finish Are you with create new business component just take out each our database okay. query this is T department entry in buoy location region dot EEO Okay. So now, let's see what we can do here.
Here for example, in the employee or in the department view, you will find here that our location Id actually the The region is a Muslim one and region will filter the country if you open the country, you will find here the region it so the region like Africa like as here, Europe So, this is the regions. So, once a user selects a region, it should filter the country depending on this region and once the user select country, the location will be filtered by country. So, we have master one is region in region will filter countries, some countries will filter location. So, I will go for now with the department which has a location I will add now to transient attribute I will call with see what is the type of the region primary key here. region primary key has a big decimal and the country has is a string.
So, in the department here I need to add a new attribute I will call it region ID and then we create this to value in this attribute read from the region is a big dessima and it should be almost updatable because I just need to see you and the example and I will add a new attribute for the can threes sorry can three already okay. So close. So we have now view object this view object has location region and country three attribute. Now I need to implement at least of value for each of this attribute, this is the create all view object which will use this is what we already did now we create the object region, which will fill the region ID. We have location view, which fill location ID and we have country view which will fill country ID so, We can read it all to view object which will fill our list of value.
Second step is curried view criteria in all view object which will be filtered In our example, region will filter country. So, the country should have your current area and the country will filter location. So, the location should have a free view criteria. So, let us go to the country, which will be filtered depending on the region. And they will go to the View criteria and I will create a view criteria. And this view criteria I should boss region ID and it will filter by region ID.
So, it will receive as a region ID equal to binding a variable so, I will create a bind variable. This point variable i will send the selected region ID and the view criteria will receive this parameter and the filters the countries with the selected region ID. So the region ID will equal to by Variable I will create create a bind variable called region parameter okay. So, here I create a binding variable and I will ascend this selected region to this point variable and it will filter the view the countries with the selected region Okay I will do the same in the location because location will be filtered depending on the country because if you take one country ID, so, I need to create a view criteria here is the location and I will say the country ID will equal to finding a variable and I will create country okay.
So, now, insert view object which we will filter it We create view criteria and the take is a barometer which will filter this view. So, for location, I will send the country and the country will filter the location in the country, I will send the region and the region will filter my country, the region is the master one no filter, so, I will not create any new criteria for this, this is the second step create view criteria. Third step is create lists of value over each attribute and the boss parameter, I will show you how you can boss now the parameter between the list of values. So, now, I will start with the now our mean view of the department. So, in the region our master one I will create a list of value this list of value I will read it from region view object Okay, so, I would select a region view and a C region ID and the combo region name this is simply because this is the Master Master one okay.
So, this is a list of value or the region the second one is the country the country should read from a country view. So I will go for the country view Okay I will select country ID as a control ad and I will display country name this is simple destroy value okay the last one is the location. So, I will add as well as location which will read it from the location view and they will take the location ID And I can display maybe city name okay and brace okay okay now we have created all this value on three parameter s3 attribute, but where I can send a parameter now so I need once the user selects a region I need to select the cell send as a selected region to the country and once the user select country I need to send the Send as a selected country to the location to do this sending barometers you go to the accessors after you of course create a list of value for each release to where you have created if you go to two accessors you will find or these two values you are create map to which you view object Okay, so the region view will not be filtered okay because this is a muscle one This is one secondary view will be filtered by rows by region.
So, you select this country and the bris widget Here you will find your country view criteria you just select country view criteria on short exists it means I need to use a view criteria to get the list of country okay. It will ask us there is a parameter called region parameter, what is the value of this parameter you can say the value will get it from the region ID. So, once the user selects the region ID it will send it to the region parameter and it will filter the view criteria and the criteria will filter the country view this is first parameter, second parameter in the location same what we did in country we will do in the location. So, I will edit the location I will find the view criteria which we defined So, I will Select this weaker area it will ask me what is the country from where I can get the country?
I say it can you can get it from the country ID and bris okay. Okay, so this is how you can send the barometers between lists of value. This is our third point carry these two value over each attribute and the boss parameter to the view criteria. And I'll show you how you can do this forces tip is sitting out from it and dependency in the view object attribute. Actually is this is tip is important if you will use this department view as a search page. So in that case, you will need to do that.
What actually this will do as you know, the region ID will filter the country so the country is dependent isn't it? pendency between both of them. So, the region ID I will set it as submitted through here you can go to to the select the region ID in the UI hint you will find here what submit make it be true okay. And the country ID in dependency, I will say it the Ctrl D is dependent on the region ID. So, I will shorten the region ID. This is how you can implement refresh in the model layer.
So, in the region, which will filter the country will sit in submit to be true for country I say it is depending on the region, but the same time the country will filter the location in that case I have to say it also may be true for the country. And location ID will be dependent Is there a dependency between location ID and secondary ID okay. That's all So, you need to sit in location ID to automate because location ID will not filter anything region will filter country. So region will be submitted through will country will be dependency in the region country will filter location so the country will be automated through and location will dependency with country this is how you can implement it submit or refresh in the view object level. We will do the same in zip h 11 which is step number five step number five it is almost the same like a step number four but step number four is the refresh will happen in the view object layer but number five will happen in say she is if bitch layer So now let us create one beach Okay.
We'll call this the soap okay. So I will open my department here, which we configure this to value. And I will edit here as for Okay, we'll find even here, set this to value for location, we can order it we need set region first, then we need country since neither location okay so the last step we need to make the refresh between this this value. So the region ID I would select the region ID And I will set an auto submit through okay. So, I will go to the property called submit I will make it through and I will take the ID of the regionally and I added in the boresha trigger of the country, I think you should be able to know how to implement this Bosch habitual rendering or objects or refresh component in ADF. So, you just take the ID of the component which will be used to filter and SIDS also may be true and things Id of this component and add it in the other component is abortion.
Same for the country the country will feel thirsty location so, I will say that old submit of the country Be through and I will take the ID of the country I will add it in as a basa trigger of the location you should actually be able to know you should be you should know how to do this actually. So, this is how you can make a refresh between lists. So, this is now ready let us try to run the page and see how it will looks like. Okay, so now we have a can region, country and location. This is the region Europe America, if you select Europe, you'll find the country is changing. Okay, if you select the United Kingdom, the kingdom you'll find location getting secondary if you select for example, series or land you will find here so it's a land if you select America you will find here filtered by America.
So, if you check the boxes here you will find here location. So, you can now select a region, the country will be filtered, select the country, the location will be filtered. So, no city for here, so you can speak to us here for example, China here. So this is how you can implement cascaded list of value. As you can see, we didn't throw it in here good, old just configuration and you can implement these features. So, this is one of the good feature in EDF that you can implement cascaded list of value.
So that so next video will go to that another feature so to Nick activity