How to use parent grid data in linked child grid calculation?

[WindForce]

Hi all
My simplified scenario is as follows:
In a parent grid component, i have a TourID field. This grid component has a linked child grid with Location and BasePrice fields.
I have a table with TourID, Location and Price fields.
I would like, if possible in the OnBlur of the Location field, to calculate the price and put it in BasePrice, how do i do this?
Also, if the user changes the TourID in the parent grid, how can i have the linked child grid rerun that code in order to refresh the price?

Thanks
Jaime

[Selwyn Rabins]

Re: How to use parent grid data in linked child grid calculation?

there are methods of a grid that allow you to get a pointer to the parent grid id. once you have the parent grid id you can read any value from the parent grid using the standard .getValue() method.

[WindForce]

Re: How to use parent grid data in linked child grid calculation?

Hi Selwyn
thank you for your help! will search for it. I guess there are also methods to get the linked grids id's as well?

Jaime

[Selwyn Rabins]

Re: How to use parent grid data in linked child grid calculation?

in a Grid, getting the id of your parent (using the {grid.Object}.getParentObject() method) is very easy because, obviously, a grid can only have one parent.

on the other hand, getting the Id of your child Grids is substantially more complicated because a grid can have an unlimited number of children.

it is possible to extract the ids of the child grids that are in a linked content section by examining the DOM in Firebug. You will see that we register the child Grid names. I don't recall offhand where in the Grid Object this information is stored, but using Firebug, you can easily poke around in the grid object and find it.

that being said, the most common technique is to simply have the child grids store their ids in some agreed upon global variable (i.e. a variable in the browser's 'window' object).

when a child grid is opened, in the onGridInitializeComplete event, it would store its ID in a variable. for example:

window['_childGrid1'] = '{grid.componentName}';

then when the parent grid wanted to execute a method on the child grid, it would do:

var childId = window['_childGrid1'];
window[childId + '_GridObj'].methodNameGoesHere();