Hello. In this video I will continue talking about the view object. View object, as I said is one of the ADF business components and it is one of the most important business components you will work with. I talk about view object attribute and the query and the view criteria. last video, I said Vickery, Toria has three usage, you can use it for three reasons. First one is to filter the main view data.

You have multiple view criteria, each of the criteria has its own condition. And you can call this view criteria from application module or problematic. Second usage is you can use it as a search page. If you want to search only in some specific fields. Like if you want to search by department ID a name, you can just write what you want and department names should be contained or greater than or equal or whatever you can add the condition here and in the UI hint you can say if it is queried automatically or not. If you want to show match all and match any or not in advance it model basic mode so you can make some configuration in the view page and ice show it in the last video.

In this video, I will talk about the type of the view object after we talk about the type of subject we will go again to the weaker area to discuss the third usage of the view criteria which is a list of value. So now let's create a view object and talk about usage of all the tables of view option so let's create a new view object. Okay. As you can see, there are entity and we know what is the entity view object is an entity. It means if you wish to get all the configuration in the entity and the A user can create or delete or insert data to the table using this view, there are custom SQL query or we can say read only query. You can use this type if you want to only to display some query some tables a bitch, but the user will not create or or delete or update any information just for display.

Or you want to create lists to value based on the query. So now here is the department view. We have. For example, location ID, this location ID, is should be used to value read from the location table. So let's create like a read only view. Just we'll get a list of location like location, ID and street address both good city and the state and country.

So you can just write a location like street address and the postal code city all this kind of information. So let's say I will create a view object and this object will be only secure I can say in movie location and it will select star from locations. You can just query successfully. Okay, next, next it will get all the attribute next naked. Okay. I don't want anything.

I don't even know why we just like a view object. return some data Select star from location and this is attribute. So, this is the second type of view it is like Read Only if you will the entity it will not have any entity based so it is just a query. In that case if you use this view object insert page. So, user will not be able to create row or update or delete row from the table database. So, this is just used for list of value or using for display some data in the page without any data manipulation DML This is the second one of the list of value.

So, the third one is to create one called programmatic view object. You can see program in this program You will create zero at runtime. So, you can say I will create a programmatic and you will define the attribute like I say I will, I will say car ID car It has a string, okay. car model car you should be into her, you can define what attributes you want. Next, okay, you can just add like a key I can see caller IDs are a unique key, I don't want any programmatic nicus case to finish this is this view if you use is a page it will be empty. There is no data at all.

This is a programmatic. You should Certain debts are on time this is called programmatic view object, but you will not use it much actually. So, we will use the last one is static, if you have some static value and you will you want to use this static value a in multiple places the page like what what what is a example of a static list you can for example, say gender type okay male and female gender ID maybe and gender type string naked ID will be here Here you will add a static value. For example, if it is M and F So, it is just like a second value you will need to use it. So, you find static male and female for example, and the finish. So, in that case there is no query you will find here there is no tap called query like in the read only view object or entity based view object programmatic as long as there is no query and settings there is no query just setting values.

This is a four types most of the time you will use is a maybe setting as may be used and of course, read only an entity. This is a three type of the view object which you will use most of the time. These are the four types of the view object. Next video, I will show you how you will be able to create lists of value and how to deal with the list of value so, see your knickers to visual