How do I access linked grid Parent Field > Child Field linking values in child grid?

[TheSmitchell]

I have a grid that I want to access the "Parent Field links to Child Field" values set by the linking definition. I need to get those values for populating a dropdown list in the linked grid. I only need to populate the list once for the whole grid --- all dropdown options are going to be the same. But they need to be filtered and the values I need to use to filter the dropdown are in the linked fields. I see that the values I need appear to be stored in Request.variables.__placeHolderValues:

placeHolderValues.png

Is this where I go to get at those values? Or is there a better method?

Thanks!
---
Sarah

[TheSmitchell]

Re: How do I access linked grid Parent Field > Child Field linking values in child gr

I have a grid that I want to access the "Parent Field links to Child Field" values set by the linking definition. I need to get those values for populating a dropdown list in the linked grid. I only need to populate the list once for the whole grid --- all dropdown options are going to be the same. But they need to be filtered and the values I need to use to filter the dropdown are in the linked fields. I see that the values I need appear to be stored in Request.variables.__placeHolderValues:

[ATTACH=CONFIG]33251[/ATTACH]

Is this where I go to get at those values? Or is there a better method?

Thanks!
---
Sarah

For it to work in Live Preview, you need to use __vp__placeHolderValues, not __placeHolderValues.

/end ARRRRGGGHHH

---
Sarah

[TheSmitchell]

A better parser?

For it to work in Live Preview, you need to use __vp__placeHolderValues, not __placeHolderValues.

/end ARRRRGGGHHH

---
Sarah

I'm parsing __vp__placeHolderValues using the word() function --- which took a right long time to find. I was wondering if anyone had a better solution for parsing data in the form:

some_field=some_value||some_other_field=some_value

Every additional field=value pair is separated by a ||. I only pass in one value now, instead of 2, to my linked grid. There were... complications. So I used word(__vp__placeHolderValues, 2, "=") to get the value from the pair. This seems pretty easy, though I am wondering if there isn't already a function that you can say, "Hey, function. Give me the value for field THE_FIELD". Like, my_val = foo("my_field")?
---
Sarah

[jmsilva]

Re: How do I access linked grid Parent Field > Child Field linking values in child gr

I have used {grid.object}.getValue many times and it work very well, here are examples from the builder.

//Read value in 'LASTNAME' field from the Grid part, row 4. Note that field name must be uppercase.
var lname = {grid.object}.getValue('G','LASTNAME',4);
//read value in 'LASTNAME' field from the Grid part, 'current row'. 
//Note that field name must be uppercase.
var lname = {grid.object}.getValue('G','LASTNAME',{grid.rowNumber});

Note that {grid.rowNumber} cannot be used in client-side Javascript or Global Javascript functions. 
Instead, you must use the _selectedRow property of the Grid object to get the current row. For example: 
var rn={grid.object}._selectedRow;
var lname = {grid.object}.getValue('G','LASTNAME',rn);

//Read value in 'LASTNAME' field in the Search part.
var lname = {grid.object}._getValue('S','LASTNAME');
//read value in 'LASTNAME' field in the Detail View part.
var lname = {grid.object}._getValue('D','LASTNAME');
//Getting value of 'range' fields in the Search part. You can't use .getValue(). You have to use low level Javascript.
var val1 = $('{grid.componentname}.S.STARTDATE').value;
var val2 = $('{grid.componentname}.S._TO.STARTDATE').value;

[TheSmitchell]

Re: How do I access linked grid Parent Field > Child Field linking values in child gr

I have used {grid.object}.getValue many times and it work very well, here are examples from the builder.

//Read value in 'LASTNAME' field from the Grid part, row 4. Note that field name must be uppercase.
var lname = {grid.object}.getValue('G','LASTNAME',4);
//read value in 'LASTNAME' field from the Grid part, 'current row'. 
//Note that field name must be uppercase.
var lname = {grid.object}.getValue('G','LASTNAME',{grid.rowNumber});

Note that {grid.rowNumber} cannot be used in client-side Javascript or Global Javascript functions. 
Instead, you must use the _selectedRow property of the Grid object to get the current row. For example: 
var rn={grid.object}._selectedRow;
var lname = {grid.object}.getValue('G','LASTNAME',rn);

//Read value in 'LASTNAME' field in the Search part.
var lname = {grid.object}._getValue('S','LASTNAME');
//read value in 'LASTNAME' field in the Detail View part.
var lname = {grid.object}._getValue('D','LASTNAME');
//Getting value of 'range' fields in the Search part. You can't use .getValue(). You have to use low level Javascript.
var val1 = $('{grid.componentname}.S.STARTDATE').value;
var val2 = $('{grid.componentname}.S._TO.STARTDATE').value;

I was building a variable dropdown list, which needs to be defined server-side in the OnGridInitialize event. The Javascript "getValue" is not available here. And I don't need it. The linking value defines what can go in my dropdown, so getting it from __vp__placeHolderValues works fine. What I need is an xbasic string parsing function that will return me a value wherein I pass the name "my_field" and the function returns the value "some_val". __vp__placeHolderValues is a "||" delimited list of name-value pairs separated with an '='. EG:

? Request.variables.__vp__placeHolderValues
= "fieldA=12||my_field=some_val||some_other_field=pi"

? get_value(Request.variables.__vp__placeHolderValues, "my_field", "||")
= some_val

[jmsilva]

Re: How do I access linked grid Parent Field > Child Field linking values in child gr

Sound like a very simple xbasic procedure, send me example input and output strings to [email protected]. I will try to get it done.