Hello in this video we will continue adding some changes here and let's review what we will do here I will add export data to excel, I need to add the content of the results results of zero and I need to change this instead of the value should display that text. So to start first with the first thing which is export to Excel I think you should now be able to do that. So I will add a toolbar here inside the population toolbar face it and I will add a button we can add we can no need to add any tickets we can just add icons to the enough and from this table I will export the action listener support it will point to my Here is okay and that can cause here teacher dot exe s t shirt. Okay, so this is simple and easy okay let's just have a refresh and see Is it too long No It is okay if you want to add like to tooltip or a hint here once the user puts a mouse over it, we can add it here is a beat on short description we can add Export to Excel.

So, once you refresh this, as the most here you find export to accept tickets does appear. Once you bring in it, you should be able to Okay, so this feature is good and working fine. So let's go for the second thing for the gender. If you have a look here in the teacher gender, you'll find it It displays our tickets, okay, this table actually coming from the main teacher, if you go to for the binding here with the binding It is coming from the teacher we want a traitor. So, from this teacher, we want to try to point to the teacher view. So, we are talking about this view.

So, you can just drag again the teacher gender again, as a column, normal column, you will find here it is like select one choice. So you can just use this column but you can just mark this as a read only Read on through. And you can read this we don't want this but we be when you just need to add this sortable on filterable. So you can just drag this component here and move this component and roses to just display this component. here instead of our tickets it should be as select one choice and the read only be true. So let's have a look here.

Now we display male and female instead of m and F. He said lift me you will get all made and if you made you get sold female, so now we have to conclude it from here. Now the third thing we need to do here is we need to add the account or the result. We can add it somewhere here is abandoned collection. minute collection at some face it cool status bar is the status bar. Anything you would add the status bar, it will add In this area, so in the status bar, I will just add toolbar and say toolbar I will add, I would put tickets to displays number of zero control, I would take this here I will need to display how many roll in sizes a traitor or the surgeries have to come. So to do that, you can open the exhibition builder here, I can right here rows and between two brackets I need to add the number of rows.

So number four, we can get it from the binding and the getting from the iterator itself. If you open the iterator, teacher iterator you'll find here estimated row count symbol expression, you just go to the binding select goods avoiding a traitor and ride with estimated row count. Race okay We can just give like style one it may be, I like this color. Okay. And the weight as well we can. Okay, the last thing we need is we need to refresh this old book tickets to once a query is executed or once the table is filtered.

So in that Ben Barstow trigger of this output tickets, I will add the ID of the query as a table to that any change in the query or the table it will filter the count also to update the count, so I will just go into the query and the table here. So it changes the query or the table. It will update or refresh this output text Let's have a look. As you can see he's here rows is four because this four row if I select as a female you will find row one. If you see me two three, if you cleared for row four, same if you added from here if you get address us It will return one row, UK on row Ireland to roll so you have here the number of the counter flow. If you make search from the query Bennett or from the table it will refresh our tickets with the correct row count.

So I can see here, the search page for the teacher. All this done. So see you next video.