Developing School Application Lookups Pages

Complete Oracle ADF 12c Course for Beginners Create a Complete ADF Application
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.28
List Price:  €96.12
You save:  €28.84
£55.93
List Price:  £79.91
You save:  £23.97
CA$98.01
List Price:  CA$140.02
You save:  CA$42.01
A$107.87
List Price:  A$154.11
You save:  A$46.23
S$94.42
List Price:  S$134.90
You save:  S$40.47
HK$544.78
List Price:  HK$778.29
You save:  HK$233.51
CHF 62.22
List Price:  CHF 88.89
You save:  CHF 26.67
NOK kr779.46
List Price:  NOK kr1,113.56
You save:  NOK kr334.10
DKK kr501.79
List Price:  DKK kr716.88
You save:  DKK kr215.08
NZ$119.98
List Price:  NZ$171.41
You save:  NZ$51.43
د.إ257.07
List Price:  د.إ367.26
You save:  د.إ110.18
৳8,402.58
List Price:  ৳12,004.20
You save:  ৳3,601.62
₹5,911.93
List Price:  ₹8,445.97
You save:  ₹2,534.04
RM312.68
List Price:  RM446.70
You save:  RM134.02
₦118,358.68
List Price:  ₦169,091.08
You save:  ₦50,732.40
₨19,451.98
List Price:  ₨27,789.74
You save:  ₨8,337.75
฿2,421.30
List Price:  ฿3,459.15
You save:  ฿1,037.85
₺2,419.75
List Price:  ₺3,456.94
You save:  ₺1,037.18
B$406.81
List Price:  B$581.19
You save:  B$174.37
R1,266.21
List Price:  R1,808.95
You save:  R542.74
Лв131.43
List Price:  Лв187.77
You save:  Лв56.33
₩98,455.31
List Price:  ₩140,656.47
You save:  ₩42,201.16
₪260.61
List Price:  ₪372.31
You save:  ₪111.70
₱4,125.84
List Price:  ₱5,894.31
You save:  ₱1,768.47
¥10,813.84
List Price:  ¥15,449
You save:  ¥4,635.16
MX$1,432.62
List Price:  MX$2,046.69
You save:  MX$614.07
QR256.35
List Price:  QR366.23
You save:  QR109.88
P959.91
List Price:  P1,371.36
You save:  P411.45
KSh9,063.70
List Price:  KSh12,948.70
You save:  KSh3,885
E£3,476.67
List Price:  E£4,966.88
You save:  E£1,490.21
ብር8,762.26
List Price:  ብር12,518.05
You save:  ብር3,755.79
Kz63,877.12
List Price:  Kz91,256.94
You save:  Kz27,379.82
CLP$68,152.06
List Price:  CLP$97,364.26
You save:  CLP$29,212.20
CN¥507.37
List Price:  CN¥724.85
You save:  CN¥217.47
RD$4,236.71
List Price:  RD$6,052.70
You save:  RD$1,815.99
DA9,355.50
List Price:  DA13,365.57
You save:  DA4,010.07
FJ$159.32
List Price:  FJ$227.62
You save:  FJ$68.29
Q542.77
List Price:  Q775.43
You save:  Q232.65
GY$14,710.67
List Price:  GY$21,016.15
You save:  GY$6,305.47
ISK kr9,775.50
List Price:  ISK kr13,965.60
You save:  ISK kr4,190.10
DH703.21
List Price:  DH1,004.63
You save:  DH301.41
L1,276.61
List Price:  L1,823.81
You save:  L547.19
ден4,112.73
List Price:  ден5,875.58
You save:  ден1,762.85
MOP$563.70
List Price:  MOP$805.33
You save:  MOP$241.62
N$1,272.29
List Price:  N$1,817.64
You save:  N$545.34
C$2,573.53
List Price:  C$3,676.63
You save:  C$1,103.10
रु9,461.06
List Price:  रु13,516.38
You save:  रु4,055.32
S/267.08
List Price:  S/381.56
You save:  S/114.48
K283.05
List Price:  K404.37
You save:  K121.32
SAR262.80
List Price:  SAR375.44
You save:  SAR112.64
ZK1,938.90
List Price:  ZK2,769.98
You save:  ZK831.07
L334.76
List Price:  L478.25
You save:  L143.49
Kč1,707.89
List Price:  Kč2,439.96
You save:  Kč732.06
Ft27,663.65
List Price:  Ft39,521.19
You save:  Ft11,857.54
SEK kr779.03
List Price:  SEK kr1,112.95
You save:  SEK kr333.92
ARS$70,272.32
List Price:  ARS$100,393.34
You save:  ARS$30,121.01
Bs485.83
List Price:  Bs694.07
You save:  Bs208.24
COP$310,661.31
List Price:  COP$443,820.90
You save:  COP$133,159.58
₡35,743.76
List Price:  ₡51,064.70
You save:  ₡15,320.94
L1,776.85
List Price:  L2,538.46
You save:  L761.61
₲551,865.53
List Price:  ₲788,413.13
You save:  ₲236,547.59
$U2,996.30
List Price:  $U4,280.61
You save:  $U1,284.31
zł292.33
List Price:  zł417.63
You save:  zł125.30
Already have an account? Log In

Transcript

Hello. So now we are ready to start developing page pages. So let's start with local pages because all that here in other pages will be dependent on the data and this lookups. So let's now start for developing class Long Beach, I would expect this is we'll have a create and delete, update and save button and this will be a table which user can be able to create a classroom. So let's now go to our classroom pages page. And in the body, we should be able to add here our a development our page.

So I will start adding actually the classroom It is only two to colo If you have a classroom view, we have only grid number and room number that's only so we will just add a table in the middle. We can make it we can make it stretch or but it will not look like good because there's only two columns. So I will carry the table in the middle of the page here. So to do that I will add here a bad group do it to what it is a center when we'll do it okay, can't go to source. Okay, so here's the Bennett probably I would and we can see in the equal center and initial line center to be in the center. We can make it vertical here and it will be in the center.

After that I will add inside this like the just spacer to add space from the top to here to make the table bit down. So maybe height will be 30 offers that I need to add. Bottoms here create delete, in save cancel in the before the table. So we can add when it grew be out again and this time this time the output will be horizontal so that we will add as a bottoms here After that we need to add a table any table you should prefer to add inside a collection. So I will add here a penny collection and I will add a table it has been a collection and we can add a spacer between subtotal and the table but the height should be ski. So let's now drag and drop the classroom here.

This has been a collection as a table we can enable sorting, filtering, it will not be read only we could because we need to insert update and it will be single row so that once you select this row, it will sit side traitor to the current row. Okay, so this only we can run number and create number Yes. Okay, so table is added here. We can insert behavior we can set the auto rule says minus one to give a fixed height. Otherwise the table height will have been the ones number of zeros or zero itself. So we get minus one, we can sit the width was a better collection.

Here you can find yours to be here so yeah, so it would be maybe 500 pixel. It's 500 pixel. Okay. We can add here, the operations which is Creating search to create a new row. We need add a delete. To delete the current row.

We need to add save and cancel. So here we can just change the tickets to be new or add to every once and we can change the gets the next icon add. Delete, okay and you can select to D commit. Okay See it's safe. See, we're back would be cancer and we are back and we can add space or between all this bottom we can add One spacer in the separator panel group layout separator face it if you adjust splitter so the spacer so especially the separator it means it will add the height and width sensor in all between all if component inside suspending probably out okay we can have a look now on this page and see how it looks like okay as you can see here is the table come in the middle here is photons and delete. Here is a table Okay, this is a better collection Okay, zero sum it changed as you can see here the column was was the label is correct because it's the entity object we already set this label so everything will be ready for you.

Okay, so let's now try to increase the table width and make the column to be stretchable to will be in a good shape. So let us take this width here and add it here. Okay, and we can can write a column stretch. Last one, and we can crease the row number. Here to be 200 whistles a columnist, see how it looks like just to finish the rich Okay, it's going to be looks much better now. We can increase a little bit through row number column so we can add here, up 300 or 250.

Okay, so now it looks okay. If you press add here to add a new row, by default grid will be grid one, this is what we sit in the entity object. Okay, so I can say a roll number one. If I didn't enter any room and I tried to save I should give. This is required, because this is our primary key. So I will add rule number one to read number one I will save so we add now one row so we can add another row number two for the same grid.

We can add rule number three for grade two For for grade two can add any number five for grid three vertical axis. So, now we we can create a delete in a row we can save if you make a change for example grid six a and you want to consider it you will find it is disabled so I prefer for save and cancel you will always remove the disabled Bertie here because we need it to be only to be always enabled. So now it is enabled so if you select the grid six and you to cancel if you cancel it will back again if you want to order because as you can see the row number 31245 if you want to make an order by by defaulted comm order by row number so you can do it in the view object level. So if you go to classroom here is a view, self insert query.

You can add here, order by row number here and you can see we need to be a cynic. Okay, now try to run it Do you find this ordered by 12345 it is order to correctly you can search here by for search 44. If you want to add like something It looks good if you want to add a clean bottom for the filter here, you can just add an empty column as a first column and in the purines mixer which will be 14 and row headers through this is we'll add like a clear icons over the first column to clear the filter. You can make this like a standard for any table use something like this. So if you still search by five, two comparisons it to clean the filter and execute the query again. If you want to Why grade three you will get grades three and so on.

Here it is view if you want to hide some columns This is by default coming with better collection because you had the banner collection you have here to detach to make it like a full screen or you can remove the filters or as the filters, dislike and predefined features once you add a table inside a collection component, so I can see now this is simple screen. And this is now okay and finished. So let's go for the next screen. So see you next video.

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.