Use Bind Variables in ADF Application Part 4

Advanced Oracle ADF 12c Course Model|Groovy Expression, Bind Variables and Overriding Methods
14 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, let's continue to come about to bind the variable in the view criteria, we have created to view criteria in Zimbabwe view and we created two methods. For each of you criteria. One method will get the parameter from us from a method in the model and from getting value from session scope. And other one we will since a variable and it will filter resemble we view criteria depending on the view criteria condition. In this video, I will show you how you can call these two methods or to view criteria necessary to view and build missiles from the back pain. As I told you, we can expose this as a client surface method and you call it in your back pain by calling the method or I already described this before and I show you before how to do this but in this video, I will show another way.

You can go directly to this. We believe you Ember class and call this two methods So now in the login here we have let's surround this. This is a belief you want now this view object will return all in buoy. So let us now add some change in this beach. I will surround this has been the collection because it give me more face it for toolbar, I can add the toolbar bottom and this bottom I need to call the fairest methods which should filter which you should call the view criteria and we'll filter the main view in between the object with the department which is stored in the session scope. So I will add a button here.

Get In this for depth, we can display here is a variable which is stored in the session scope, you know the variable is user depth, so, you need to display it here if you want. So, you can go to expression builder and you need to in the JSP object, you will find here session scope, session scope dot and give the variable name. So here I need to say get an mp4 department ID I will display the value which is stored in the session scope. This is we'll call the first method. second method we need to add input tickets the user will as a salary and then press a button to filter is a view object called a second view criteria and filter this view object adds a secondary toolbar. And in this toolbox, I will add Ben in the out horizontal and here I need to add a multicast and a button Okay, we can add space or between both of them and this is I will call it salary and this photon let's execute Okay.

So, the first port on should call the finish method which equals the first few criteria. second button should call the second method we should call the secondary criteria and both of them should fail towards the main mbv view object depending on the condition which is written in the view query view corrector. So let's action here. Because we will not navigate to any beach we can just add action listener. Bizarre okay, but I prefer if I will navigate a button will navigate to another page. So I need to go to action.

If not, I like to be in the action listener with dipped here I would say filter is Laurie I will find this to get the value sorry input text okay so let's go to the been here now I need to go to the MVP view Ember class I will go to the View object first at the from the view object I will go to same believe you open as I told you before, that to go to the View object you can go to throws a traitor So, I will just as a binding function here which I will go to the binding and from the binding I can go to the iterator or kill binding and it is important in pointing contiguous does well. So, it has been bought by in the context. So, now I need from filter by dip towards mint lettuce first to get citrate or so, this year three to finding we should import this year iterator binding ater equal bindings dot dot get and we will say now's a treat or name, a treat or name should get it from A beach definition is a movie.

So, it is quite a big definition you will find it when we want a traitor exists here so I will take it copy and I will pass to DCA three. So now we connect to the binding and we get site straighter after we get a traitor we can get the view object and we can cost the view object to the image we believe you and will because this view actually is a view object. So I will take the name of this clause, because we need to go to this clause. Here I will write m vo equal I traitor dot get If you object and it should be caused to this loss like this. So, now we connect to the binding getting a traitor from the traitor I get the view object which is mapped to this a traitor which is in between view you can cause this view object to the view inbuilt class, but you have to generate a view on the class should be generated like this after that.

You can get it from back being like this. Once you get it you can just easily dot you can call it and you will find Sam methods Phil, what's the method name? We created here get Emma's for dipped. So let us here right get them this for Dept. So now I will call this get M's for depth which will go here and it will cause a few criteria and filters if you object we can do the same for the filter with salary. So, we will do the same here we'll copy this but before we publish it with this we need to get to Saturday so I will call object salary equal you salary it would take years to get a value.

So, I will first get the value of the salary after that I can get the traitor and get the name believe you embel but instead of I call this get embers for dip, I will call the get amps by salary and I will send the salary so double bar double string dot value of salary okay so now we get that salary from Ember test connectors are binding gets a traitor from a trader gets a view object and a cost it to a view object The Emperor clause and from the object in the clause I call my method and this method will receive a salary. And once this method receives a salary, it will set a bind variable with this salary and to call this view criteria and execute the query and should filter that. So, this is how you can call methods from the view MB from back pain to So, this is now try to log in So, to run the login and this but before doing this actually we need to add a partial trigger because this pause button should filter this.

So, let us add here the partial trigger or bottom It was run and test Okay. So now let us sit the department to be for example 30 and this value should be stored in the session scope. But actually the employee should not be filter because currently we didn't use it so it will display all the in between. Here you will find get employees for department and the reads the value from the session scope. So once you press this button, this button should code the method in the view embed clause and quotes a view criteria and it gets this value from the session scope and filter this so let's try it is press on it. Now we will find it is filtered the view criteria boys a value which is two in this session in scope.

So it goes a few criteria boss bind variables and executes the query The value is of a query is filtered like this for the salary for example, if I need to get a salary which is greater than 10 K and execute, you will find the good old salary which is greater than 10 or equal to 10 k if we say for example, sir his returns then 15 So, it will get all surrogates as 15. So, this is how you can call a method is a few ambit and this missile should get the view crew specific view criteria and since the bind variable, so, this is a good way you should know about it in EDF, how you can create view correctly I was bind variable and how you can set the bind variable to this view criteria and how we can call this from your back beam.

This is how you can deal with bind variables in nikka surveyed you Just go quickly through some overriding missiles. So and 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.