Hello, last video we have finished the search teachers. So, this video let us work with the search student it will be same like what we did in search teachers. So I will quickly go through this. So I will go here for search student, we have created view criteria as a student as well for search a student. So this is a student's view named criteria you will find search student I will drag it here as query if query banner with table. So this is a table or your sorting filtering row.

Okay and the race okay. So we will associate students this so here is a Bennett query We can Berens here we can mark this as a hidden, hidden. Let's have a look on how many fields we are searching for. So we will go to the student view view criteria. This is search a student to see how many 12345678 So, I will maybe make this as two row four columns. We can actually remove this pennant hitters key for us.

Because anyways, if query has a title, so they need no need for us, but in order to have a title if you have a look and search, a teacher Yes, look and see which teacher Okay, we need to rerecord it again so anyway I will have a look in the search feature what's the difference between the bandleader or not so he have here a pedal query he will table I will surround this table was bent in connection. State is rich with table will be rich with because I add a pendant collection now the eighth who really can't reach to the table unless we change the result component ID. So I will point again to the table this is the table they will make column stretchable which One up the address for so appearance, appearance here from search for K, and n column here with its 14.

All through, I guess you should be able to do all of this and you should be understand what I'm doing now. This is just for display a clear filtering icons column. Okay, all looks now. Okay, so let's add export and we can add it into toolbar here too or I will just turn, no tick just popped with icons. This is Adobe Under short description we can add Export to Excel and insights is put on I will add the export connection listener and I will point to the table which we need to export which our table exists here and the file name will be two plus two in this students. So now we finish just export it as a table.

It's a brand new collection. We are just in a free query. We can add here a number of row number four we can add like from status it will add our tickets just to display sorrow There's a number of rules so we can write rules like this and say this we go to the binding student I traitor, estimated row count and we need this output tickets to be refreshed if the user search from if a query or from the table It's okay, so let's run now and have a look how this page now looks like. Okay as you can see here, the eight fields which we need to search it is in the fourth column. Here you have a number of rows, we can change the color again from as we did in the teachers. Search teacher we have here's a style Okay copies here and it is a student okay so as I told you I remove here the best hitter because they give a title let's see what's the difference between student and teacher teacher here you will find there are two search the two labels teachers for the button and search we can remove this because it takes space so here is a student, it is now only search we can write search a student.

So here we can write soosh students so students so we can hear, search with the students. If you can search you get off to students and number four, you can export it to the Excel file. here so looks okay. So now I think everything is okay because here's the agenda as I told you how you can display this instead of m and F, as the values these values so we can drag against gender, see gender zigzag it here as a normal column, and we can remove this output thickest, from the gender and at the select one choice can remove this column and Mark is added on the only true we just replace our tickets with select one choice so now we Have sex, gender is male and female correctly address and they will think you can search here by maybe name, student to search you will get the student to reset and search to retrieve all that again.

So now I can see we finished all lookups and we finish the search screen. So next which we will talk about that transaction for the next two videos. So see you naked stivity