Hello, last video we add a detail on as a teacher we need to do the same in the student. In the student actually we have we should add like, the detail will have two things like what is the result of this student and what is the current class in this student. So, if you have a look in the data control the student let's have a look at detail you will find only we have the result, student result as a detail, but we can't know what is student class. So we should add like a link or view link between students and the student class so that you will be able to display the current student class. This is a good chance for us to make a view link and see how we can do it again if you forgot it. So let's now create a link between the student and the student class.

So as I said here in the view, you can add a new View link, student link student glass. So, I would select the student as a master student ID and they will open student class. And so, Nick the student foreign key as a detail Nick is Nick just just finish. So, now we added student and student to class link, but it will not appear here still, if you open the student here you will not find student kalasa beer because you have to add it in there a application module you have to open application module, data model you will find here student you should find sites you didn't student to class. So you have to shut out student class inside Students like this that case if you expense student you will find student class. So, once we drag this you can splay what is the classroom this classroom and what if you want to see the grade as well.

So, this is a good chance as well to make some changes see for for the classroom, there are a class a room number and grid number. So, here you have classroom foreign key. So, you will know which class room the student but you will not be able to know which grade this student would be. So, actually we need to add in the Student class here, another field to tell me what is there Great for this classroom or what you can do is you can create like a link between class room, student to class and classroom to get the room number. So, there are two options you can do, I will make one option we already know how to create a link, but I will do something new here I will create like a transient attribute as a grid number and I will get the grid number from the classroom using SELECT statements.

This is like a way how you can write select a statement inside the code. So, let's now go to the student class view here. Attribute so here we have the student and the classroom but I need to get the grade number which is related to this classroom. So I will add here a new attribute it is not from entity it is new attribute it called transit attribute. I will see T for transit as a prefix t grade number okay. This is a ticker ID number by default because it is transient it is not updatable.

The user can set it if you want to use a rule set this grid number you can select it almost, but actually we will make it like we will just make the guitar but if you make it almost no problem, it will not causing an issue. So, now insert guitar was it attribute I need to get the grid number from this classroom 4k. So, this is something we can do it programmatically from Java class, I will extend a row include accessors to get the old attributes setter and the getter. So, I will accept an if clause illustrated clause view row and row by row. So, here I will find the getter of the gate t grade number, this is the guitar get the grade number. So, here I need to get the grid number depending on the class foreign key.

So, what we will do here, we will call the selected statement, select the grid number from classroom with room equal the class room foreign key. So, here is the model util. You remember in the model we have in the common we create a model util is only return I will add here is a function which you can send an SQL statement to it Let's import Kasia SQL and the results let's see what the actual is this method will do you will see the select statement SQL statement and it will execute the Select a statement and it will return the first attribute from the select statement. So, so let us know call this method get at SQL description. From here we can say return common utility tell our common sorry it is more than your chin model you do okay we will import our module From the common package, dot get a sequel description.

Here we will write the select statement and here we'll say get DB transaction DB transaction. That's all but from here we have to write select. Let's have a look on the table. It is cool. Tables classroom. So I will select a grade grade underscore number from class rooms where a room number equal And we should get it clause wrong pulling key.

This is how you can run a select statement to get some data and how you can create a transit attribute and in how to can get the value to this transit attribute. This is a new thing I need to simulate, maybe you will need it somewhere in your application. So here I can either select grid number from classrooms where a roll number equal and it will get the get the current classroom foreign key. And we will send it to this function and this function will execute the query and return a string of one one, it means it will return a great number. So let's now back here You'll find here inside the student student class and sensor clause you'll find the ID number and the classroom. So, Nicosia video, let us add the detail for student which you will have a student to class and to the result so see you next video