Iterate over table columns in script

matthjes

Hi,

I'd like to hide rows in my table which are entirely empty. As there seems to be no standard solution for this (like an option in the property editor) I thought of doing this via a script. So what I want to do is:

For each row:
1. Iterate over all columns of a table
2. Test if current cell is empty
3. If all cells are empty, hide the row

Is there a better way to do this? I already tried adding code to the onCreate method of a table row (get the row data via this.getRowData(), then the column count and column values via this.getRowData().getColumnCount(), however, this only let me iterate over all bindings and not over table columns) but this did not work.

EDIT: Btw, I expected that when I add this.getRowData().getColumnValue(this.getColumn()) to the onCreate method of a cell I would retrieve the current value of this cell...but this does not seem to work. How do I get the value of a specific table cell using indices?

kclark

I was able to hide an empty row in a table from the onCreate() using the following script<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>var columnCount = this.getRowData().getColumnCount()
isNull = false;

for(i=1;i<columnCount;i++) {

var temp = this.getRowData().getColumnValue(i)
if(this.getRowData().getColumnValue(i) == "") {
isNull = true;
}else{
isNull = false;
i = columnCount+1;
}
}

if(isNull == true) {
this.getStyle().display = "none"
}</pre>
<br />
Let me know if this works for you