Hello, I will continue talking about view object. last video I show you what the tables view object and how you create the view object. In this video, I will go back again to the view criteria and see how we can use view criteria for creating list of values. Now we have here is a department it is a location ID, this location ID should have a list of values which read from the location view. Get it from the location view, so we need to create lists of value by going to this location to you how you can do this. You can select the attribute go for lists to value and bris at Kia.

They're listed as a source I will get it from where the data will come From where this leads to value, it will come from view, call love, list of value, location view. Okay? This is the main source of the data of this list. So value, this is why we create this view object. So it's okay. And what is the key ID which will return this location ID, the location ID of the list of value will map to the location ID of the department, the value will come to here.

The third one you can select how you want you would like this list to value it. Let us talk about all this kind of sync. So let's say select choice list and I just want to display maybe, street address and city. Okay. And if you want to see if it is going to include blank on the first or no, you can select it here and press OK. Let's now run before you run you should see if you can create here a new tab. They were created for example with forms Okay, so let's drag the view object again here as a form PDF as a PDF form you'll find here location becomes select one choice, because we defined it as a list of value.

So once you drag it as a form you'll find it will get the same component which you are accommodated. So, let us now have a look in this forms. You will find here The location is display location, address the street and the city The restaurant value Okay, this one type of the list of value, we can see different type like here you can select it is not sure is this we can say input tickers lists to value here it will create like lists of value or colorable attribute I will show you two now and you can make it query list automatic so this is as input list of value now you know what this drop down list is this symbol let's drag it again once you drag it again here for you will find here become list to value in but instead of select one choice before it will select one choice now is this to value him but Okay, so let's have a look on this list of value for Here, you will find here like a search, you can open a pop up that you can able to search who is location and once you select this locations ID it will return back to the location here, but now you search by all this you will search by all this attribute.

So, we just want once the list of values open to search only by location ID and city, we don't want to search by all of this kind of things. So, what you can do is that case you can use view criteria this was the third use issues of view criteria is the list of value which I need to get the data from. I will create a view criteria then I can see a list of value in Ovi Word meant okay and I will say I need only to search by city and location ID and location ID will be okay equal or city we can can say can contain okay query magically undo I don't want to see show much and any okay so now we create a view query theoria in z location this value view this record theory has only location ID and city is that case I need to use this view criteria when I create this value.

So, I will back again to the list of value here and I want to go into this view criteria it will come here So, you will find your view criteria I will select this instead of all horrible attribute I need my view criteria Okay, press OK. And so now once we open the list of value, I should be able to see only to fill this overzealous with value, I can see only these two fields location ID and city which I need to search for. If you want to add the location ID as an attribute here as a column here, this column will be controlled is the list of value definition here on spec, I get to the list of value. Here I say I just display Street and city, Street and city. So I need to display as well location ID and be the first one.

Okay. So here you can control if you control the width of this location ID and city. Okay, so this now either location ID is fine. So if you want to come to The width the width will come in is attribute. For example, you use search by location ID and city. So I would say the question ID and the width I will, for example, at 20 and city as well I will add 20.

Okay, so I search why this tool, let's now run and see how it looks like in the four search, you'll find here is a location ID a beer and the location A city has the same width which is 20. So once you select this double click it will come here. So this is a list of value based on a view criteria which we are created for list of value. So this is the third usage of the view criteria. So back again and quickly talk about the criteria because it's one of the most important feature is a view object. We can use it the view character in three situations the first one if we need to filter the main query with a specific data, so we'll define a view criteria with a specific condition.

This condition can be literal value or can be based on binding variable. The second usage is if you want to create a searchable basis of equality as a speaker this search is based in V Korea. The last usage is for list of values. This is the main usage of lists of value. There's one last thing I need to talk about in the view object to finalize a view object, which is a transit attribute. I will talk about it is dedicated to video see you nicus dividual