Implement Shared LOVs

Advanced Oracle ADF 12c Course Model|Shared List of Values (LOVs)
15 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$69.99
List Price:  $99.99
You save:  $30
€67.24
List Price:  €96.07
You save:  €28.82
£55.68
List Price:  £79.55
You save:  £23.86
CA$100.66
List Price:  CA$143.82
You save:  CA$43.15
A$111.82
List Price:  A$159.75
You save:  A$47.93
S$94.88
List Price:  S$135.55
You save:  S$40.66
HK$543.79
List Price:  HK$776.87
You save:  HK$233.08
CHF 62.67
List Price:  CHF 89.54
You save:  CHF 26.86
NOK kr792.28
List Price:  NOK kr1,131.89
You save:  NOK kr339.60
DKK kr501.55
List Price:  DKK kr716.53
You save:  DKK kr214.98
NZ$123.71
List Price:  NZ$176.74
You save:  NZ$53.02
د.إ257.07
List Price:  د.إ367.25
You save:  د.إ110.18
৳8,328.16
List Price:  ৳11,897.89
You save:  ৳3,569.72
₹5,958.01
List Price:  ₹8,511.81
You save:  ₹2,553.80
RM314.25
List Price:  RM448.95
You save:  RM134.70
₦108,236.03
List Price:  ₦154,629.53
You save:  ₦46,393.50
₨19,398.69
List Price:  ₨27,713.60
You save:  ₨8,314.91
฿2,394.21
List Price:  ฿3,420.45
You save:  ฿1,026.24
₺2,465.01
List Price:  ₺3,521.60
You save:  ₺1,056.58
B$426.13
List Price:  B$608.79
You save:  B$182.65
R1,290
List Price:  R1,842.93
You save:  R552.93
Лв131.30
List Price:  Лв187.58
You save:  Лв56.28
₩101,582.03
List Price:  ₩145,123.41
You save:  ₩43,541.37
₪254.54
List Price:  ₪363.65
You save:  ₪109.10
₱4,098.92
List Price:  ₱5,855.86
You save:  ₱1,756.93
¥10,967.38
List Price:  ¥15,668.35
You save:  ¥4,700.97
MX$1,406.50
List Price:  MX$2,009.38
You save:  MX$602.87
QR254.06
List Price:  QR362.96
You save:  QR108.89
P963.25
List Price:  P1,376.14
You save:  P412.88
KSh9,053.20
List Price:  KSh12,933.70
You save:  KSh3,880.50
E£3,568.78
List Price:  E£5,098.48
You save:  E£1,529.69
ብር8,687.63
List Price:  ብር12,411.43
You save:  ብር3,723.80
Kz64,250.82
List Price:  Kz91,790.82
You save:  Kz27,540
CLP$69,297.02
List Price:  CLP$99,000
You save:  CLP$29,702.97
CN¥510.87
List Price:  CN¥729.84
You save:  CN¥218.97
RD$4,243.89
List Price:  RD$6,062.96
You save:  RD$1,819.07
DA9,435.69
List Price:  DA13,480.14
You save:  DA4,044.44
FJ$162.05
List Price:  FJ$231.51
You save:  FJ$69.46
Q536.99
List Price:  Q767.16
You save:  Q230.17
GY$14,580.66
List Price:  GY$20,830.41
You save:  GY$6,249.74
ISK kr9,757.30
List Price:  ISK kr13,939.60
You save:  ISK kr4,182.30
DH701.41
List Price:  DH1,002.06
You save:  DH300.64
L1,291.33
List Price:  L1,844.84
You save:  L553.50
ден4,135.36
List Price:  ден5,907.91
You save:  ден1,772.55
MOP$557.92
List Price:  MOP$797.07
You save:  MOP$239.14
N$1,283.07
List Price:  N$1,833.03
You save:  N$549.96
C$2,564.57
List Price:  C$3,663.83
You save:  C$1,099.26
रु9,479.94
List Price:  रु13,543.35
You save:  रु4,063.41
S/259.51
List Price:  S/370.75
You save:  S/111.23
K282.61
List Price:  K403.75
You save:  K121.13
SAR262.99
List Price:  SAR375.71
You save:  SAR112.72
ZK1,928.73
List Price:  ZK2,755.44
You save:  ZK826.71
L334.62
List Price:  L478.06
You save:  L143.43
Kč1,690.23
List Price:  Kč2,414.72
You save:  Kč724.49
Ft27,882.67
List Price:  Ft39,834.10
You save:  Ft11,951.42
SEK kr772.23
List Price:  SEK kr1,103.23
You save:  SEK kr331
ARS$71,547.27
List Price:  ARS$102,214.77
You save:  ARS$30,667.50
Bs481.59
List Price:  Bs688.02
You save:  Bs206.42
COP$305,890.51
List Price:  COP$437,005.17
You save:  COP$131,114.66
₡35,162.35
List Price:  ₡50,234.08
You save:  ₡15,071.73
L1,769.11
List Price:  L2,527.41
You save:  L758.30
₲543,432.39
List Price:  ₲776,365.26
You save:  ₲232,932.87
$U3,131.93
List Price:  $U4,474.38
You save:  $U1,342.44
zł286.59
List Price:  zł409.44
You save:  zł122.84
Already have an account? Log In

Transcript

Hello, in this video, I will start for implementing the shared list of value, I will go step by step. So the first step is create a custom application was one model project and this application will hold all list of values. So let's go to the developer and start for implementing this tip. Okay. So now I will create a new application because of I need only one project, so I will create a custom application I will call it my L O V. Share. We can see my sure Lu v. application.

Okay, Nick, Nick. Yes, I would do it you component inside this next finish. So, this is my application which I need to create all lists of values query here. For example, I will create a list value for department list and the movie list. So under you I will use this view object as a list of value in my main application. So, I will create here new business components from tables.

I will go for HR okay. Okay so we can add department and mb k So we can add as well. location and I would add this as an eo This is as vo, K and my application module. However, I need only in this project to have only view objects, which I need to use as a list of value. But this is will make it easy to create a view object with an entity to write a query automatically for you. So here a data control I would say sure So, actually this project should have only view object with a query like select the department ID and department name from departments.

So, it just as a list of value, but I just create an entity object such as the view object will automatically created with a query here if you want to see the query on cigs this solution so, you will see the Query SELECT department ID name manager from the departments. So, this is the department and the employee and location. So we can use this departmental view and in believe you and the location view a list of value in my main application. So this is the first thing so seconds Feddersen is critical custom application, second sim is create all view object which will be used for list of value. As you can see here we create all this of all views which will be used as a list of value. As I said no need for all Linkous and no need for entity just all we need is a view object and application modules and application module should have called the view object which we need to even we don't need any master detail.

We just need simple views for list of value like this workmen in between and location Okay, so, this is the second step, third step define data source for the application module. So, I will go for the application module and I will configure the data source Which will read data from so I will be charged this each artist and actually show this is the data source which we already created in the first feature. So we have already This is short this okay so since the thing force step is kureta application module instance for project purposes so, after you create your view objects and Edison's application modules and defines a data source, you should go to the project properties, double click or right click Properties and you go to for a business component if module instance. So, this is your module application module who just shuttered this application module, in essence here and it will be carry cash live it will be in septic Live in so this is what we need to do it will be as his application live and we can call this shirt it'll movie up much okay we'll be like shared a movie application module and his application This is the most important step now this okay so now we can finish point number four number five and six same what we did is official number one so I will generate it if library jar then I will add this jar file to all my main project.

So this back again here and as I told you in the first feature is the deployment you will find automatically there is if libraries are created for you. So all you need is just right click in the project, deploy my shirt deploy to ADF library Next and Finish deployment tab you will find Sir George okay. So, it takes a pass copy. So now it is as your file is ready, I will create a new application okay. As I said a for each feature I will create its own application individually. So you can download all of this applications so by feature I will carry it if my mean if application for share a movie okay Because just because I could do it by default Okay, in the middle layer I will create a database normal HR database which I have Okay I will create entity object I will create view object and I will create application module.

Okay so now we have my main application and I need to now implement as a list of value on some attribute but before I implement this I will add a short file in the morning project as they sit here in the last step at this jar file to the model project in your main if application. So, this is my main EDF application and this is my model project, I will go to the library and class bus and I will etcher foil sin, I will go to my shared list of your application. Okay. Okay, so now I add all shared list of value queries. And as I show you the innocence of the application module is in the application level. So now I will go to the View object, and I need to implement the list of value for some buttons and believe you believe you if you find here, we need this value for the department.

So I would kill you now In this overview of the department. I think you should To be able to know how you create this value in general. So, I will add here list of value for the list data source here we will bris add, but in the end, I will use here before if you see my step by simple to begin a free course for beginners I use view definition and I select one of the existing view object, but for the shared application module, you will find it is automatically select your shirt application module and it display your view object. So, this is how you can create shared lists of values. So, you will find here view usage is shared application module is by default automatically read your ADF library is a jar file and he finds our shared this value application module. And it states all view object which we already defined in our shared list of valuable applications.

So, for the department I will select this department to view okay. And I will select department ID and department name. So this this value now is read from the shared application module. It means the query behind this which is select star from the departments will invoke only once a time in the whole application lifetime. Okay, so it's the same as a manager we can create another list of value. What is that claim I need to share but I need in the employee and I will select employee ID as a manager and I can display first name and last name Okay.

So now let us create a dummy application a dummy page sorry just to display it, we can call it amps blank Okay. Okay. So in the data control now, you will find your application module data control, you will find your employees view object you add here as a form for example, you will find the error measure the workmen as a list of value and press ok okay so it's safe or And run a beach okay. So, now you will find here the department is coming here and the query behind this is invoked and the manager ID as well. So, this data is coming because we defined each order the source which we defined in the shared application. So, it connects to the database and reaches if any user now invoke and invoke this speech again, this query in the database living will not be executed because it is already executed only one time.

And this data now is cached in the application level. So, while it is cached in application level, this is because in our shared list of value, we say here Application module. This is will be cached delivered in the application level. So here we a cache the result of the list of variables a query is the application level. And we get the data from the database using the source code is shortest, which we defined already in our embedded WebLogic. This is how you can implement share the list of value in the application level.

So if you have a page with 10, lists of values and 10 user will invoke the page the queries of this will invoke only one time. So this will increase the performance of the page if you have a lot of these values and the query behind list of values is bit heavy. So this will improve the performance. This is the second feature is shared list of value in some motion. Next video I will move to the third feature. So see you next activity

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.