Hello, in this video I will continue talking about bind variable. last two videos I took about bind variable in the main query level, but this video I will talk about the bind variable in zap view correctly. So, first let us the main query return all rows now, we don't want any bind variable. So, let us delete the bind variable. So, now the query will return all and you can remove evens override methods. So, this is the main query which will return all in GUI and I need to create view criteria and this view criteria we can get the MBE depending on any condition.

So, this is fine fine to view criteria one will For example in Malawi, for dept, one view criteria, I will need to send a department ID and I need to receive a bill we have this department. So, I need to filter the mean query with a specific department. So, I will add a view criteria and I will say the department ID equal to bi and variable. So, here I will define bind variable in the view query criteria level. So, I will call here view criteria dept ID parameter okay integer and this is one of the view criteria and I need to another one government employees for all employees by salary okay and I need to get For example, in BGP, which has salary greater than or equal to bind variable as well and they will create view criteria salary. Okay.

So now we have to view criteria each of these two view criteria has its own bind variables and I need to call this view criteria anywhere in my application and I should get this a need to get a specific result depending on the view criteria condition. To do this, there are two ways. One way is you can define a method in view imbel clause which you will get the view criteria and you can Suppose dismissal is the client interface or you can call this view criteria in your back pain and you can filter this in your back pain. So, I will do both ways. The first way is we we can go to the View in bulk loss here and I will create a function here public void filter or get employees for department. This is the method so, in this method I need to get the view criteria, which call it MVP for dipti vehicle metiria Xin I need to set this parameter.

So, how you can do this you can define here view Croix tyria Vc and can import this Oracle two GB oh did view criteria equal there because of we are in that view and the view object itself. So, we just tried get view criteria and it will receive the view criteria name. So, now, I get to view criteria and I send the view criteria name and it returned back here after that we can need to set the parameter. So, to two sets a parameter you will find here setter for the depart. There's a bind variable here you will find set depth ID parameter. So, what you will do is just to call this set depth ID parameter okay and it will take the parameter I will call in trigger to parse integer and I will get the department's from the session scope from the model util dot, get user department ID.

Okay, so, this is the way you can sit there. You can put the view criteria and you can sit the bind variable using the setter of the bind variable. After you do this, you should apply the view criteria. So, I will apply view criteria by view criteria then I will execute query. So, anyone now will call this method this method will get the department ID from the session scope and will filter the view creator will fit as a view using this view created. We can do the same for the salary one but instead of getting the value from the session scope, I need the user to send it So, I will create another one, but I will get the view criteria.

The second one which is a belief by salary Here we can call it in Beuys by salary and I will write here double the salary, you should send the salary and you should sit, sit, sit, sit, LVC salary barometer. And it is of type bigdecimal. So I will try you be this email and I will sit there, it's in the salary, apply and execute. So now, again, I wish I could read it to view criteria. Each of you correctly has a point variable. I get to the view, am I correct To method for this these few criteria, first one, I will get the finished review criteria and I said sub barometer from session scope method Enza clause which will get the value from the session scope.

And second one the user will send it and wants to use a sentence and execute query to automatically filter the view using the view criteria condition. You have two ways now to call this you can expose this as a class client interface method or from back being you can straightaway Go and call this missus. I will show you how you from back being you go straight away and call this because the client or fifth misses you already know it I exhibited before. This is a new way how you can call method instead View ml from Beck been straightaway was calling the method. So next video, I will show you how you can call these two view criteria to filter the mean in the UI view option. So see you in activity