Developing School Application Lookups Pages (cont.)

Complete Oracle ADF 12c Course for Beginners Create a Complete ADF Application
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, last video we finished the classroom page so in this video, let's try to develop a teacher page. I felt that last video I explain it a bit quickly. So in this video we'll try to be slow as much as I can. So let's now go to the teachers page. We can have a look at the teacher view it has all this column so we can make the table is reachable all the beach because it has a lot of columns so we can do it like this. No need to put it in the center like we did in the classroom.

So we can make it like street show. So here I will add a straightaway Bennett collection the Hello As I said in my previous videos that if you need to add a table, it's better to add inside bender collection because when the collection will give a built in function like you can hide some column you can make detach the table to be full screen you can have some fields that you can add some bottom inside some face it so it has some some features built in you can wrap the column so it have some face it as you can see. So now we just add suspended collection and to make this pendant collection searchable. So you can add here in style class if it's rich with this is a predefined style class in PDF library. So once you make like this it will stretch the bundle collection so we can track There was a teacher inside the spending collection.

The table sorting filtering, single row, show ID name all looks okay. So, back to the page here. We can as well add this if switch with as well to the table. And we can insert appearance here to make the tables stretch as well to make the last column to be stretched because b b is a Bennett collection will be stretched here, but by default, the column widths will be 100 pixels 100 and this is a default with so you can find your table only stop here. If you want to make it stretchable like this, like here so you can Select the table and you can see I need to stretch a specific column like for example, teacher name or teacher address, I need to be more spiritual, it will fit the old width rabbinic width. So, we can see this is a C for the ID of the address column is c four.

So, if you want to make this column, stretchable, you can select the table and in appearance, column stretching I would select c four Okay, teacher ID as we configured in the entity level it is auto generate. So this is should be as a read only. So in the behavior, I will make it read only be true because the user should be able to update this teacher ID would like a standard for any table you should add a query The beginning here will appear with with his 14 small weights and row hitter make it through this is we'll add a clear filter icon in the beginning as I showed you in the last video. So, this is editable you can do standard and as well in the appearance here or sorry in the behavior auto hide make it minus one otherwise zero it will sit the width depending on the number of the column I can show you this.

So okay it is make it zero and I will show you what is the difference between zero and minus one for auto hydro. This is a table. So let's now working in the operations. So when where we can put the operation we have here, the face it called secondary toolbar. I like to add as a bottoms inside This secondary toolbar so here and standard toolbar, you will insert here a toolbar and inside this toolbar, you will should add all bottoms. So I will add this is be sure this operation taken from the teacher view, yes.

So you take the Create insert here as abort, delete and operation back as we can see here, create a certain key add icons I can add like add delete see cancel, so all this icons actually coming because we have the image icons we added here so we can read it from here straightaway. So this is now the all operation as I said my previous video in the commit and rollback you can remove the disable. We always enable we can add one more thing here how to export this table to excel file. This is a good feature without writing any code you can do it. So in the toolbar here, I will add a button This button will export the data of this table. So how we can do this?

We can add a button. Okay we can right here Excel Okay or export to Excel and I think I have icons here already for this yes this icons. So how now we This button will export the table. So to make a button export any table you can you can add inside this button you can add in a physics component called export collection action this so export collection action listener This is an IF component will be added inside this button here till you ask you to add the ID of the table which you want to be supported. So here I will point to my table in somebody's face it okay T one so it as a T one here you can get it sit away and wrote it here and hear it will be if you want to export as a CSV file or Excel file this simple and easy without writing any code so let's now try to run and see this page how it is hopefully I explained this peach bit slower slower than my previous speech.

So let's now run it and see how it looks like you will expect as all labels over the column will be okay because we already wrote this in the entity objects or lists of value should be already defined. So all the work which we did in the model, it will help us a lot while we are developing the page. Okay, as you can see the table is stretchable and it is stretched out This as you can see to fill the rest of space, because here is the table, we set in the appearance column, which is column C four, and you will find c four is a teacher address. So, we are told the table please export see for so if you want to increase some column here to reduce a little bit of others we can for example, increased name, phone date of birth. So, to increase the width of a specific column you can select a column for example table name by default as it is 100.

We can do it make it 200 we can increase the phone number as well to be 200 and we did have birth to be 150. This is just to make the table looks good now we increase this looks okay. So now we can find here the toolbar and have four columns. Here's the Export to Excel, this is coming from the Bennett collection as I told you you can make the order you can show or hide some column if for example, if you do want to see the teacher ID, you can remove it like this. If you want to add it you can add it like this, he likes to attach it will make the table as fullscreen here to hide and place filters. All this coming with bedding collection, we can add now row you will find here by default.

So teacher ID is getting from the entity. Here you start entering some data let's see what is required you just receive and see is that insolvency require nothing required. So this is wrong. We can mark is a name to be required and maybe address to be required also zip. So, you can in the name here behaviors that are required you can remove this and say here required through and maybes address as well. Moses and you can write here cool because this column should be almost if you try to save now it will ask you to enter the name and address.

So here for example, teacher, one Ireland if you want to select a date of birth For example maybe thing exists and by default it is made because we see it as a default as a main. safe. Okay we can add another teacher okay. Teacher to UK and a female so you can add any church as you can see if you want to export this data to excel you can do this now since it will export the teacher okay well it is not obon as an accent I will tell you why so little speck again Here you will find here it's about collection. If you wrote if you didn't write the file name or file name, it will not download was correct. It's a extension.

So let's now try to see say it will be teachers dot exe, S details teachers. So this is a filename. So it will know this is an Excel file. So let's now try to download it again or support this that again. So we will explore now which is export as Excel you can open straightaway because it knows what is the file name? Yes.

So it will export the data as you can see, you can add some data because we will need it Teachers three in the US anything okay add more you can edit it and receive only one time teacher for me Okay, that's enough so now this page almost finished as you can see as well if you select for example teacher salary and the bridge studied, it will do teacher city but you have to receive otherwise you have if you just cancel it will return back again. Because the video I will show you how once you press Delete, you can ask for a question. information like are you sure to delete or not? If these are see okay, it will delete otherwise it will not so next video I will continue working on this for just showing you how you can add a confirmation confirmation message who wants to use or try to delete a row.

So see you Nick 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.