In a linked grid, how do you pass values from parent to child?

[Rida Alhasan]

.
Hi,
Using the Properties - Linked Grids/Content - Has linked grids or
other content option, I have linked a Teachers grid to a Students
subgrid, so that when a teacher is selected in the main grid, all his
students are shown in the subgrid.

In the Students subgrid I would like to show the teacher's name
together with the number of students that teacher has, in the
Properties - Customization - 'Total records' message text area.

The Teacher's table has two fields: Teacher_id and Teacher_name.



Thank you for your help,
Felix
.

[GGandhi]

Re: In a linked grid, how do you pass values from parent to child?

hello

take a look at video 69 from v10 videos.
that may answer to your question.

[Rida Alhasan]

Re: In a linked grid, how do you pass values from parent to child?

.
Govindan,
Thank you for your help. Video 69 from Alpha Five v10 seems to fit exactly what I want
but for some reason it does not work. The child grid is at fault, but I do not know why,
since I have replicated the video (adjusted to my situation).

I'll keep on ...


Regards,
Felix
.

[Rida Alhasan]

Re: In a linked grid, how do you pass values from parent to child?

.
Thanks to Govindan, here is how it is done:

First see video 69 of Alpha Five v10.

Imagine a linked grid that links a main Teachers grid to a Students subgrid. When you select a teacher by clicking on his row, all his students are listed in the subgrid. Additionally, in the Students subgrid header (in reality, the �Total Records� message text area) the total records corresponding to that teacher is displayed. So far, as usual.

Now, what we also want is to include the selected teacher�s name in this Students subgrid�s header. There are two ways to select a row: whenever the grid is rendered it highlights/selects the first row and, second, when you click on a row.

Teachers grid (parent)
Let us suppose the teacher�s name is in the fullname field. When a Teachers row is selected, we want to get the value in that row�s fullname field and place it into a variable, say, TEACHERNAME, that we�ll later use in the child Students grid.

Every time the Teachers grid is rendered (on webpage initialization and when you navigate the grid), the first row of the grid is automatically selected. We want to get the value of the first row�s fullname field when the grid is rendered. In the Teachers component:

Properties � Javascript System Events - onGridRender:
TEACHERNAME = {grid.Object}.getValue('G','FULLNAME',1);

NOTE: G stands for grid, the fullname field must be capitalized and 1 corresponds to the first row.

You can also select a row by clicking on it (the onMouseUp event ):

Properties � Javascript Row Events � onMouseUp:
TEACHERNAME = {grid.Object}.getValue('G','FULLNAME',{Grid.RowNumber});

Student grid (child)
In our linked grid, when a row is selected in the main Teachers grid Alpha Five displays the corresponding Students in the subgrid. Because of the Javascript events we have just coded in the main Teacher grid, we have created a TEACHERNAME variable, loaded with the selected row's fullname. Let�s place this variable in the Students component�s �Total Records� message text area.

Properties � Javascript System Events � onGridRender:
$('E1').innerHTML = TEACHERNAME;

Properties � Customization � �Total Records� message text:
Students of <span id="E1"></span>:&nbsp;<strong>{Total_Records}</strong>

That's all there's to it!



Regards,
Felix
.