Session Variables in a GRID

[CampnJim]

I have a grid, and I'd like to set a session variable to equal the Key ID field of the grid whenever a row in that grid is clicked. I tried placing SESSION.GRIDID = {grid.Object}.getValue('G','ID',e.rowNumber) in the onRowSelect client side event but I get an error stating the 'SESSION is undefined'.

After I get this working, I'd like to use that variable to update that record with data from another grid but first things first.

Thanks,
Jim

[christappan]

Re: Session Variables in a GRID

session variables are by definition server-side, so you'll need to do an Ajax Callback.

[CampnJim]

Re: Session Variables in a GRID

I really need to start learning this new form of Greek. I'm off to the help files.

[coleresources]

Re: Session Variables in a GRID

Jim,

Go to your grid properties and find "Published Session Variables"

Enter the javascript you used to create the session variable there. It should work.

[RichCPT]

Re: Session Variables in a GRID

If you have a button on each row in the first Grid that opens the second Grid via Action Scripting and you want to pass data via a session variable then use the "Override Settings" / "Set Session Variables" property in the "Open Grid Component" properties. There, in the "Set Session Variables" window you can enter something like this:

snBrwPrsnAllSlctdPrsnID = {javascript}function(rowNum) { rval = 1 * {grid.object}.getValue('G','PRPERSON_SYSID',rowNum); return rval}(rowNum)

Notice, I don't use the "SESSION." prefix here and no ending semicolon, either! The above example sets a session variable called "snBrwPrsnAllSlctdPrsnID". The data being passed from the first grid is in the "PRPERSON_SYSID" control; it is a hidden column on the grid.

To use the session variable in the called component, you can set the "Initial" value of controls to it, like " =session.snBrwPrsnAllSlctdPrsnID".

If the data you want to pass is part of key for the secondary grid then use the "Link" property instead of trying to use a session variable. Sometimes, you have to use both methods. Or, sometimes you can use Javascript global variables accomplish what you want instead of using the troublesome session variables. see video # M43