Developing School Application Search Pages

Complete Oracle ADF 12c Course for Beginners Create a Complete ADF Application
8 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 after we finished the old look of speech Let's now move to the search page we will start with search teachers. So search will search which you need if is simple and easy no need for any code. We just need to create a view criteria which will be used for a search we actually create this view criteria oil. configuring the view object if you remember here in the viewport area, we call it a search teacher view criteria which have some attributes which we can use for searching. So now this view criteria will be available inside the view object here in the name decorator you will find here see the search teacher. So in the search teacher beach here, what we can do simply is drag this criteria to the body here.

As a query, if query, Bennett was tabled, this would create a query panel velocity will as a result, if you select query button only it will display only the query but there is no table for the result. So you can select a UDF query panel with table this is the table in the result we can enable sorting filtering okay single row and press OK. So now let's have a look in there search teacher how it looks like it had been a vertical says it's been a vertical tourists query, the teacher and this is that he would this no just run the page like this. So making anything of course we need to enhance the beach. layout and interface but I just want to show you without making any think what the page will looks like okay. So, as you can see here, there is a field which we decide to see what we can search for here with the research you will find the result coming here.

So, what actually thing is we can try to do here is we can try to make this in maybe is a 123456. So, it means a three column, each column has a row so that we can give a space here. Second, we can add like a Bennett collection as we as I said, with this threshold, we can stretch the address. We can remove this if you want to receive search. So, let's make some few things like this. So to that ranges this field search field here, what you can do, you can select Save query here and appearance you will find here throws and the maximum column.

So I see we need only two rows and maximum columns can be three. So it should be like six fields. 123456 is six field. So now this is how to arrange this, if you want to remove the Save, save query mode this if you want, we don't want it now, so we can just make a tie hidden. Okay, if you want to remove this advance search, you can you can find here a mood change if it's a well you can set forth but we can keep South bonds. I wish What is this advance?

This is a search thickest, okay so this looks okay. Second thing we can do is we can write this as a stretch width if you want to make it with more width. And as I said you can boost this insight bender collection as I told you the table prefer to be inside panel collection and we can see as well is rich with Okay, so because of you at the table and said bensel Bennett collections a query. Here's a result component which can see now this it can see the result ID because it is now beside better connection so you can re point to the table again. This is how the Relation between a query and the table come from. So we can select it like this, this is the result of the component in a query to boyens a query to as a result of the table, you can select the table ID here is a result component ID, so that the result of this query will appear in this table.

So, now let us make maybe teacher address which is this ID, I see four as a stretchable. So I will go for the appearance, column stretch, and I will select this as a spiritual teacher name, I can increase the width. I think you now know how to do all these kinds of things. If you want to add a initial column here, with with 14 and the row hidden through two displays next year, our clear filter icons Okay, so let's now try to refresh the page and see how it looks like. Now it looks much better you have here the table you have the collection you have some some fancy booty moves to save. Now we have the fields in three columns.

So if you search for teacher three, you will get search two yes there is no three is one. Okay you can reset to get it all and search okay there is no three I become one. So, you can search for anything if you want to search by main search you will get the old me he may search with a few Okay you can reset and search to get a good What is that once I once it will give you more option like I said by default each ID is equal if you want to make like this then between if you want me Date of Birth not equal if you want to be in between, so it will open from an to date it is like advanced option you can add you can add some more fields what actually I add all fields so there is no hidden fields because if there is no hidden fields you can add in hidden fields.

So, here's the Advanced Mode module give you more options for searching. You can to back it into a basic what we need to do here we need to add the exported data to excel blast we need splays account or search because in the search we care about how many role will be coming or returning from Going one more thing we need to add to make change in this table as you can see here gender is m f is a value we need to display it as like male and female. I will show you how you can do this. Now. So, because the video that makes some enhancement exists, like adding support splay here, the male and the females introduces a value I need to split tickets. Last we need to add the count of this role.

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.