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 shou…

[image] Named Query, Power table, Row color based off column value Ignition 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…

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

configureCell fires when the table is redrawn for the cells that need to be displayed. See this related discussion: [image] Bug Report: Power Table configureCell() Ignition There’s a bug in the configureCell() extension function on the Power Table component in Vision. I…

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?

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 <=1…

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).

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.

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.

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": retur…

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…

Hi! How are you? I still don't understanding why rowView is not affected by sorting when retrieving values from data property... Also, the rowIndex is affected by sorting too but the only difference is it's not written in its description?

POWER TABLE background color of row

Ignition

JordanCClark December 1, 2018, 12:58pm 2