Grid Detail Column Heading JS syntax

[mmaisterrena]

Re: Grid Detail Column Heading JS syntax

good job

BTW
In mexico we actually say "codigo postal" no "zona postal" but maybe they use that in Spain who knows

[kimhere]

Re: Grid Detail Column Heading JS syntax

For anyone interested...

The sample JavaScript code in the above link works as advertised for the grid part of a grid, but not for the detail part. Here is the difference:

GRID PART:
$('{grid.componentname}.LBL.R' + data.rowNumber + '.' + 'HRS_QTY' + '').innerHTML = vHrs_Qty_Label;

DETAIL PART:
$('{grid.componentname}.D.LBL.R' + data.rowNumber + '.' + 'HRS_QTY' + '').innerHTML = vHrs_Qty_Label;

In the above example HRS_QTY (CAPS required) is the field and vHrs_Qty_Label is the variable.

Thanks to Selwyn for clarifying this!

Dynamic Heading & Grid Sort

I need to be able to select the Grid Column to display and sort fieldnamevalue for that column based on a dynamic fields in the SEARCH PART.

From the SearchPart, the Grid Column Field name is selected, along with a value (these are done through combo/box dynamic lookups).

Is there an easier way to transform these variables into a Grid Column and Sort value?

GridColumntitle = Search defined fieldname
GirdColumn search/sort = Search defined fieldvalue

If using the Variables in the quoted example, HRS_QTYfield would be a variable that is selected from a combo/box lookup in the SEARCHpart. varHRS_QTY then needs to be become a column in the corresponding grid that is searchable based on the varHRS_QTYvalue that is also selected from a combo/box lookup in the SEARCHpart.

Thank you! appreciate all the help from everyone! Kim

[kimhere]

Re: Grid Detail Column Heading JS syntax

I have the Grid column Label working now (fairly easy to do), dynamically computed.
In the Gid Column Heading field I have:
<div id="muni_label"> </div>

And I placed the following code in
<Grid><events>AfterSearchSubmit

var muni_label = '';

window['muni_label'] = {grid.object}._getValue('S','MUNI_CATEGORY')
if(window['muni_label']) muni_label = window['muni_label'];
else muni_label=' ';

$('muni_label').innerHTML = muni_label;

NOW, if I can just get the correct fieldname & fieldvalue for the SEARCH to work on this column, grabbing the correct field from the table.

[bobalston]

Re: Grid Detail Column Heading JS syntax

Bob Moore and others.

I need to be able to change the labels in a Detail grid view based on some system defined parmeters that I have in a table. I can easily read them in xbasic and save them as session variables. How can I get these values available to me to use in Javascript? I am new to javascript and new to web apps so the "how to move data from the host to the client" is still something I don't understand well.

bob

[kimhere]

Re: Grid Detail Column Heading JS syntax

Ha ! Welcome to my world! I'm still trying to figure out the javascript stuff. Most the time I seem to accidentally stumble on to something that works, or I copy others work from here ! :))

You could modify the following for the detailview

<Grid><events>AfterSearchSubmit

var varname = '';

window['varname'] = {grid.object}._getValue('D','FIELD_NAME')
if(window['varname']) varname = window['varname'];
else varname =' ';

$('varname').innerHTML = varname;

~ Instead of the "AfterSearchSubmit" you would need to use the appropriate Event for the DetailView
~ _getvalue is a 'D' for "detailview" : this returns the VALUE of the FIELD for the 'FIELDNAME'
~ put it in a "window['varname']" to pass to other events

then, for the TITLE of your LABEL field try:

<div id="varname"> </div>

This might not be exactly what you are looking for, but maybe it will give you a start. Like I said, i'm no expert in this, just kind of stumble my way through all the javascript stuff.

[bobalston]

Re: Grid Detail Column Heading JS syntax

I am trying to get this to work for the Detail part

DETAIL PART:
$('{grid.componentname}.D.LBL.R' + data.rowNumber + '.' + 'HRS_QTY' + '').innerHTML = vHrs_Qty_Label;

Seems to me it is unclear on the single and double quotes. looks like a single double quote right before the ")". If I treat as a single double quote character, I get an error. If i treat as two adjacent single quotes, no error but it doesn't work. unfortunately the syntax is still greek to me.

Any suggestions?

bob

P.s. possible that mine is different is that the detail view is alone and is not from a grid, so the rownumber field may be wierd.

I am also confused as to why Bob Moore's technique in his video worked then but not now?????

[kimhere]

Re: Grid Detail Column Heading JS syntax

I have not directly checked the syntax for this statement, but it appears that you have an
extra ' + " ' at the end.

$('{grid.componentname}.D.LBL.R' + data.rowNumber + '.' + 'HRS_QTY' + '').innerHTML = vHrs_Qty_Label;

[bobalston]

Re: Grid Detail Column Heading JS syntax

I now have resolved the issue in my using the Bob Moore technique. I had to use a different event ( I use onGridRender) but it works great.

bob