POWER TABLE background color of row

[claudio]

Hello to everybody,
I need help to set the background colour of rows of a power table object, based on the value of a specified coloumn.
I.e. if the value of the second coloumn of my power table is 1 I need to set the background colour of that row red, if the value is 10 the corrispondent row shoud be green.

Thank you in advance
Best regards
Claudio

[JordanCClark]

Named Query, Power table, Row color based off column value

To do that you would use the component scripting for the power table. The extension function configureCell. You would want to check for the value using something like: val = self.data.getValueAt(rowIndex,"column title") if val >= 0 and val <=90: return{'background': 'red'} if val >= 91 and val <=120 : return{'background': 'yellow'}

[amarks]

This is correct for a static table. How do you get the extension function to fire again after sorting?

[pturmel]

configureCell fires when the table is redrawn for the cells that need to be displayed. See this related discussion:

Bug Report: Power Table configureCell()

There’s a bug in the configureCell() extension function on the Power Table component in Vision. I tested on 8.1 and 7.9, both of which have the bug. When selecting a row from a power table, configureCell() does not execute for all cells. Instead, the cells it executes on depend on the index of the selected row. There appears to be a logical bug in how the cells are looped over. To reproduce the bug: Create a Power Table and populate it with 5 values in one column of data. The bug is present…

[amarks]

So, why then when I use the above solution for coloring the rows based on a cell value, do the colors not follow the correct rows when the table is sorted?

[JordanCClark]

Without seeing what you have done, it’s difficult to say.

That said, one thing may be to ensure you have a default config for your cell. For example:

value = self.data.getValueAt(rowIndex,"columnName"))

if value >= 0 and value <= 90 :
	return{'background': '#FF0100'}
if value >= 91 and value <=120 :
	return{'background': 'yellow'}
return{'background': 'green'} # default config

[PGriffith]

Also, note that there are two different row indices you get in configureCell- rowIndex and rowView; your code may be using the wrong index or retrieving values from the ‘wrong’ dataset (viewDataset vs data).

[amarks]

This was the issue. Thank you.

However, I don’t quite understand why rowIndex is the correct argument instead of rowView. The docstring for rowView says “(affected by sorting)” which leads me to believe that I should be using rowView.

[PGriffith]

It depends on what you’re doing. If you’re retrieving values from the viewDataset property of the table, you should be using rowView. If you’re retrieving values from the data property, you should be using rowIndex.

[jshaffer09]

This worked for me

# reference column name Status
	if colName == "Status" and value == "Maint Required":
		returnValue ["background"] = "FF4747"
	elif colName == "Status" and value == "Getting Moisture":
				returnValue ["background" ] = "FF4747"
	elif colName=="Status" and value == "OK":
				returnValue ["background" ] = "8AFF8A"
	elif data.getValueAt(rowIndex,"EquipmentID" )==0:
				returnValue["background"] = "9ACCEE"

[gregory.sachs]

Another tweak, just in case someone else wants to do this:
This will highlight the full row where the value in column x in the backing dataset changes vs the row above.
Currently sets even rows to yellow and odd to orange.

Column_I_Want_to_Monitor = 5
	#Defines what column will be configured
	#if colIndex == Column_I_Want_to_Monitor and rowIndex > 0:
	if rowIndex > 0:
	 #Checks if the column is the right one and that it's not the first row
	 	#previousCellValue = self.data.getValueAt(rowIndex-1,colIndex)
	 	previousCellValue = self.data.getValueAt(rowIndex-1,Column_I_Want_to_Monitor)
	 	currentRowValue=self.data.getValueAt(rowIndex,Column_I_Want_to_Monitor)
	 #On the Power Chart's dataset, finds the value at the previous cell
	 	#if previousCellValue != textValue:
	 	if previousCellValue != currentRowValue:
	 		if rowIndex % 2 ==0:
	 			return {'background': 'yellow'}
	 		else:
	 			return {'background': 'orange'}