H5 Script - Get All Data from Column

Legacy Contributor

I am creating a H5 script and I need to get all of the data from the "Net r" (Name: PNCA, Index: 13) column from the table pictured below. I need each value from each row in the column. I have attempted to use `ListControl.ListView.GetValueByColumnIndex(13, this.controller);` but that returns an empty array (same with GetValueByColumnName) I assume because this might be connected to a selected row as suggested by `ListControl.ListView.SelectedItem()`. I am not trying to get a singular row, I need data from each row. Any ideas, pointers, or questions are appreciated.

Legacy Contributor

With a few tweaks I was able to utilize your function here for my case.

let list = this.controller.GetGrid();
let data = list.getData();
let column = "C14";

for (var i = 0; i < data.getLength(); i++) {
     let val = data.getItem(i)[column];
}

A few pointers for anyone's reference:

getData().length returned undefined, getData().getLength() returned the number of rows in the table/grid.

The columns are identified by "C" I presume for column and then their index number, i.e. "14" .... "C14". To get this information, console.log(this.controller.GetGrid().getData()) will return an array of the columns and their respective data/items.

val in this instance returns the item/string in column "C14" for each row i.