Hello. So now let's start developing the dashboard. As we show last video we have already created a query. So let's now try to create the read only view object in the model layer and I will use this view object to display the graph as the data in the view layer. So, I will take the first query which will give us all the current and all the statistics we need in the left hand sidebar in the dashboard. So I will take this query and I will go to the model and I will create a new view object and this object will be read only it is not based on the entity it is just a query.

And I can name it start with our Oh as a read only. Okay. dash board statistics for you. And we can edit in the auto package not the vo package as a read only. So, are all dashboards 360 view it is query and I will just paste my query here you should just remove this comma so select star from so that's just if there are any error in the query it will give you error no binding variable to will give you all column name here. Next, Nick is Nick is he asked because it is Nokia up Do you want to specify key?

No, I don't want you want to generate a row embl or reviewable? No I don't I just read neither of you objects that's all. Next if you want to add it to the occasion module or not, we will add it later then finish. So, this is the first view object which has the number of teacher number of students number of class was for grade 123456 and the number of was students and failed students. All this we will display in the left hand side in the left hand side in the dashboard. So, this is the first view object.

Let's take the graph on query okay. So, this is number count of students in classroom so let us carry it another in the in the baggage distance package right click new view object we can say it is custom query and it will be row number of children Glass you Okay, next and I will post a query nickers nickers nickers nickers nickers No, we don't. Next, next finish. You can Justin's attribute here. This is the query will select the current This is the current so we can see this is the count as a label the classroom Okay, so go for the graph to query new view object Custom and this would be all teachers in stroke view custom Nick is basic query name just naked pictures, no. Finish here so these attribute will be here count Okay, so they're the one are all Average he was sued in its view.

Custom query average Yes. Only one that's really good. We can see average pass. Okay, so now we have a last one is a query shift in So, you you object are co co in great view Okay, so this is going to postulate no i think is a bit wrong one. You can you can if you want to test it you can I will cancel it now you can open the connection You can run it and see the result. how it looks like.

But it looks Yes, something wrong and because it is not on average, where the Cintiq is I think it is wrong in the selected code of student clause. This is a correct query. Okay, so let's just run it. Yes, it may give you a student in each grade. So this is our correct query. There's something wrong here.

So in total, Control V. I just searched it out. So let's now create last one new UI object To the Delete view and we add our query Nick is Nick is no finish heroes attribute I see this current here grade number. So all now all modal view which we need to use in to build this dashboard is ready now, but as you know it will not be appear here unless you add this in application module. So, we have to add this is application module so, it has open application modules that Sam Walton and you'll find our own package, which have all our all view I will shuttle one by one, this is the first one to lift here, select View select module to lift the view module that also we shuttle all we add all views or overuse which we created for dashboard is application module.

So it means it will be displayed all here. So, now, the modern layer is finished we will move now to the dashboard page and we will start for developing zap page itself. So see you negativity