Intersoft Community - WebGrid Enterprise - How to get column by name (in JavaScript)

How to get column by name (in JavaScript)

handy@intersoftpt.com — Tue, 08 Sep 2009 10:47:01 GMT

You can get the column by specifying its name in GetNamedItem method.

e.g

var grid=ISGetObject("WebGrid1");
grid.RootTable.Columns.GetNamedItem("NamedColumn");

Hope this what you are looking for.

Regards,
Handy

How to get column by name (in JavaScript)

Eric — Tue, 08 Sep 2009 10:09:03 GMT

or even simpler:

function SetGridTitle(gridID,title)
{
	var grid=ISGetObject(gridID);
	grid.RootTable.Columns.GetNamedItem('Column_Name').GetElement().innerText=title;
	return true;
}

How to get column by name (in JavaScript)

Eric — Tue, 08 Sep 2009 10:03:44 GMT

I found the solution myself. The JavaScript function needed is missing somehow in the documentation, but is visible in the runtime / debugging environment. The new code now looks like this:

function SetGridTitle(gridID,title)
{
	var grid=ISGetObject(gridID);
	var ColNo=grid.RootTable.Columns.GetNamedItem('Column_Name').Position;
	grid.RootTable.Columns[ColNo].GetElement().innerText=title;
	return true;
}

How to get column by name (in JavaScript)

Eric — Tue, 08 Sep 2009 08:00:35 GMT

I used this JavaScript part:

function SetGridTitle(gridID,title)
{
	var grid=ISGetObject(gridID);
	grid.RootTable.Columns[0].GetElement().innerText=title;
	return true;
}

This crashed, because .GetElement() returned null. The problem was that I have several invisible columns in the grid, so I have to use Columns[12] instead. I don't want to hardcode the column number (12) here.

How do I get the column by its name?

I know the function wgGetCellByName, but that seems to be only for a row. I assume there is something similar for the columns. I also don't want to loop over all columns, because I assume there already exists a function for that purpose.