Implement and Use Programmatic View Object Part 1

Advanced Oracle ADF 12c Course Model|Programmatic View Object
12 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 show you how you can use a programmatic view object in your ADF application. So here in it just create a simple ADF application called programmatic view object application with one entity, one view object. So here I need to create one programmatic view object and I need to use it in if page in a JSF page what I need to do I need to make the user to enter multiple departments and he will should see what is the departments he entered. And after that he bris insert and it will take all departments which he inserted and insert it straightaway in the database. So I will just create a simple programmatic view object so I will right click new view object I will I will create a normal view object Okay I will can see I can say for example, this is me we programmatic a report mints view and I will select the source to be programmatic Okay.

Next here it will ask you about what to enter what is attribute you want in this programmatic view object. So I will select here new and I will see called here it dept ID and this is of type integer and we can see the name and it is a string that's enough all you need is just to enter knows ID and Name you can enter measure or location and any number of attributes you want. Then I have written against this department he asked you if you want to key Okay I will be otherwise it will ask you if you want to make a key so I will can make this department ID as a key attribute you can ignore it if you don't want it okay generate view embedded under Europe euro embedded okay next, I need to edit in the application module okay I will select my application module to insert this view object, take an insert and insert it to the application module, Next and Finish.

Okay. So this is if you back here to the steps, we create new view object and select the data source programmatic greeting our attribute so in the third step, so we should change the database to be always so I will go here attribute you will find two attributes which we defined I will say makes a bit of work to be always here and this is I will make it to be okay let's the sips is Java tab I will select the Java MB and run the Rubik loss and I will change the extended programmatic bureau image to be centered funeral emblem. So, here after you define this, I will go to the Java they will find Java embed and throw embed. So I will select in view and here you will find it is extended programmatic view object ml I will remove this programmatic and they will just select an extended view object ml and he will ask me to insert it on boarded Okay, so I will import or placebo server then I will remove this collection and all this stuff, I want it to be simple like this.

This is for programmatic. This is for those of you and they will do the same as if you embed it in programmatic I will make this seem like a living revision by default is like this. And I like this way. I don't want any complication. I just want to add my own rows. So I will remove as well, this three that's all okay.

So now, our view object is ready to be used. So, in the application module, I just will double check it is existed here, okay as instance. So now, let us create that View JSF page okay and we can work with this programmatic view object. Okay, so in this page I just need to let the user enter department ID and Name and the insert department name and insert and actually it will insert in the programmatic view object and after that, the user will press Save and it will take all inserted departments and save it all in the database. So I will here add for normal for it is not from the binding just in multicast it will not map to any thing so I will add here banner for the output and the benefits Do it we can surround it with Ben group. And inside suspended form I will add in both tickets as a department and that input text as a department name.

So here you'll see it D okay and I needed to be required and it dipped in name on the record and then use the footer to have an bottom to say See or no save insert Okay, this is just a symbol for as to input text and one bottom okay so let us know you have two option to get the data from this info tickets from ziplock bean you can add the value here define the variable in the bag bean and add it here or you can bind this component and delete it from the component we can do this binding so I will bind both of them and the back pain so I will define back pain. Okay, I think you should be able to do this. They will add into a package called bean and this is a request scope. Okay, this is about pain and I will Define property name will be the ID component okay and here I will define point.

So the name okay. So is that I am in the back been I will be able to get this component and tickets a value, which is a user will enter it in the insert I need to add an action listener insert okay. After the user press insert tip what I need to do I need to insert is a value which is a user entered here in the programmatic view or object and clears the value so that he will be entered the second department and so on. So I will drag the department programmatic departments here as a table, read only table as a read only TF table. For the programmatic don't enable any filtering because there is no query. Okay, and even no sorting.

Don't need any of this because if you make any sorting, sorting, sorting or filtering, it executes the query which is there is no query so it will filter it will clear the data from the programmatic view object. So I just want you to be read only and single, single row selection and read only table is a programmatic object if you get the view object in xebec. Bean and write re execute query if you execute a query, the programmatic view object will be cleared If you invoke or rollback the programmatic view options will be clear as well. So here's this is a table I just want to make some space between them. Or you can send show into this was banner box and you're in certain depths okay. And this will be insert tips if you want to remove any of the inserted one if you want to delete it, you can add here a column and I will drag here, operation, delete as a bottom to delete says okay normal view object with the same operation create delete in the programmatic view object.

However, this programmatic object is not mapped to any query or any table or anything, just at runtime. So user can insert some row or delete some rows from this view object. Okay, so now I need once a user, enter the value here and press insert, this value should be inserted in this programmatic view object. And we can add here one button call, save, and it will take all see, so again, what actually we need to implement. In this. I need the user to enter department ID and department name and the person search what happened, what will happen.

The data from this input tick is to insert it here in the programmatic view object and the value here will be clean. Clear the user enter another department ID and Name press insert, the data will be inserted new one here. So, the user will see all departments which he already inserted. And once the user is happy, he can delete any of the inserted departments or he can say once he please save, all the departments in this programming object should be inserted into the database. And this programmatic job should be clear. This is what we will do is an activity.

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.