Hello, in this video I will talk about the table selection listener. The table is one of the most important component in EDF application. Knowing if application has no tables in a way, I think you should have a table in any ADF application. So the default behavior of the ETF application was once you drag the view object in a table, you enable the selected row. What does it mean? It means once a user once a user selects a row, like this, say three two behind this table now, we'll mark is selected row as a current row so that you will be able to work with the selected row from back pain you can get a select row or you have a master detail.

Once you select a row, the detail will be filtered depending on the selected row. So so this is the most behavior thing set. Once you drag a view object in the page you marked as single rows in addition to that, once the user selected this row In this iterator, the tree to mark is a selection rule as a current talk will actually this is set and how you can override this because sometimes you need once as a user, select a row, you want to mark this row as a selected row, but you want to execute some other code not only just to market to as a control, but you want to do some other other check. So in this example, what I will show I will display is the department table. And once you select a row, it will mark is this as a current row, and it will invoke the database and get a count of the MBE behind this department and display it in the message.

This is what we will we do. So let's go back to the jdeveloper. Now I need to drag a department's view In the page, insert table selection as a table. Okay, sorting filtering, zero is only here, zero selection is, if you sit numb, it means the user will not be able to select in a row. If you make it single row, so user will be able to select only one row. And by default, the table will sit this selected row as a current row.

If you select multiple rows, it means the user will be able to select multiple row if you use Ctrl and select it will select multiple row. But of course, the selection listener will not be marked as a selected row as a control because you will be able to select multiple rows. So the default behavior which we are doing is we mark as a single draw. It means the user would be We'll select our single row and then a traitor will mark is the selected row as a current row. So that you will be able to work with the selected row from the back being if you want to get the current row, you get value from the row you set the value you will you have master detail you can do anything you want to do. So, here I will mark this as a single row.

And let us have a look on the selection listener of this table. What happened once we mark this table as as a single row selection go to behavior. It does go to the selection listener. This is selection listener. You will find here it is pointing to the binding department view will live in connection modern to make current As you can see, to me current, what does it mean? It means once a user select a row, it will invoke this selection listener and selection listener will make the selected row as a current throw.

In that case, you will be able to in the back pain, you can get the current through and deal with this elected role. But what I need to do is I need to override this solution listener. So, if I remove this listener, and I will add my custom method the table selection listener So, now once the user select zero That a three two roll note mark the selected row as a current row, how we can test this let us surround this panel group and let us at MVP as a detail to this table okay. So we have here master detail Let us now try to if you want to make like a Refresh to be sure it is refreshed so in before I would add it in here as a default should go into the table. So once the user select a row here now I override the default value in the solution listener it means it will not make the selected row as a current row.

So if you have a master detail table we will not be filtered because the current row is editable is not changed. Okay, so we need to go to the table selection. Okay, you will find here is the department and here's the employee so it says select any other department. You will find them below V is not changing. Select another department. Some big V is not change it.

Why Because the selection listener now will not make the iterator to mark as a selected row as a current row. So if you in the programmatic insert code, if you get to the bottom int iterator to get a current row, it will get us the first row, all those devices, even you select any row, it will return the first row. Because the solution was this row will not mark the traitor to be current row. So what I need to do, I need to keep to make current row selection listener to make current throw blocks, I need to make some other code as well. So in this example, I need to return the back again, the selection listener to mark the selected row as a current row. Blessed I need to do other code like I will invoke to the database, I will go to the base, sending the selected department to the database gets a number of human UI and display a message I can do whatever I want.

So it does two different things. element is this and they will show you how you can implement this. So, now I went I will go to here insert table listener and I will copy the code or the binding expression which was exist in the solution listener. This binding expression, which will make the selected rows a control we need to invoke this expression from the beam, how you can do this to execute this exhibition in your Intertek pin, you should use the Java x expression language library to do this. So, you should write this expression. Here you will walk you you will invoke the invoke of separation You will write your expression all submissions will be this.

So, I will write here our exhibition which we need to invoke, and we will send XSL event here, what is this invoke method I created here invoke method, which will take the exhibition, which you want to invoke. And here it will call the exhibition language Kentucky's, and we create Mr. exhibition, and it will invoke the exhibition. So, this function actually, you can use to overwrite the selection listener of the table by sendings expiration, which was exist in the selection listener here. Do you remember here in the selection listener? It was this exhibition was here. This exhibition was in the selection listener To mark a selected row as a current row, so, we remove this and put it here to invoke it Enza backbeat.

So, once the user select a row, it will go to the selection listener. So, it will come here and it will execute this exhibition, it means it the current the selected row become a current row. After that you can write any code you want. For example, I need to get the current department and I need to get the department ID we wrote it here before to get the department ID. So, I will just copy this because now I know that this exhibition will make the selected row as a current row. So, if I get the department view and iterate or to get a control, I am sure now the selected row is current role if I didn't run didn't invoke this make current.

If I say get a control it will be almost gets a first row, even you select any other row it will be always gets a first row, but lists you more because the selected row as a current row. Now, if I get a three to two current row, it will get the selected row, then it will get mother department ID. After that, we need to display a message. I add here show successful message and I will since the mission message number of employees. For this select the board cement This is a message for example, and we can write the selected department. Here tip ID This and we need to invoke a database and it gives a count of the department the roll get function I created, get an employee count and I will send the department ID.

So here I generate kid named Bill we count we can write this as an object. Okay. And this getting current in when we get an employee count, I will send the department ID and it will select the count from limbal. We will at the bottom into the equation, just the center department ID and after that it will return the result of the MVP. This is a function we just edit from the previous lecture. So this is the source which will connect to the database and this is a successful message which I write to display a message from setback B So here again, once a user selects a row in the table, it will invoke this function selection listener.

And the first thing we'll do it will execute this expression, which will make the current selected row as a current row. After that, I will get the department view on I traitor, because the current row it should be the selected row. After that I will get the department ID then I will show some message number of MB we have selected what is and I will call Secretary MPV count and it will invoke the database and to get the count of same bill we for the selected department. So this now, try to run and check this but before we run, we can add both of them in the horizontal instead of scrolling up and down. So I will just change the bending globally Are we here to be or horizontal to be beside each other Okay, so it has now run and just Okay, so let's now take a look at the table solution you will find here is the department and here's the in between.

Now once I select that department here, you will find the employees refreshed and number of embroidery facilities row is one. This is try to select another department to use will find number of inventory is six. So now the selection listener, mark the selected row as a control. This is why the detail table is is filtered and error messages appear corrected. This is how you can overwrite the table selection listener to make the selected row as a current through and at the same time you can write any code you want. As you can see in our example, we connect to our database, getting some information from the database and display it in Savage.

This is what things you should know about it. Next video, I will go for this to value listener. So see you next video.