How to change Color of Row in a table if an specific column are filled

Ignition
1

Hello

I´m registering the datetimes of the faults,assistence and datetime of repair for some machines in a MYSQL DB and displaying in a table

imagen
imagen996×504 64.3 KB

here is the conditions to fill the columns of the same table:

  • when the maintenance personnel arives to diagnose the fault he register the assitence and the row of the event in the table is updated with the datetime.

  • when the Maintenance personnel start to fix the fault

  • when the maintenance personnel complete to fix the fault.

is there a way to change just the rows that contain datetime "Assisted,"other color for “inProgress” ?

regards

2

Yes. If you create a view and drop a new table component onto it you can examine the default data. You'll find that it starts like this and that the city of Folsam is highlighted in orange.

[
  {
    "city": {
      "align": "center",
      "editable": true,
      "justify": "left",
      "style": {
        "backgroundColor": "#F7901D",
        "classes": "some-class"
      },
      "value": "Folsom"
    },
    "country": "United States",
    "population": 77271
  },
  {
    "city": "Helsinki",
    "country": "Finland",
    "population": 635591
  },
  etc.
]

Observe that the dictionary for Helsinki has only one level but that the structure for Folsom has been altered to include the desired style.

To do this you need to create a script transform on the table query binding and modify the value passed back to the table. Set the initial binding to return a DOCUMENT rather than a dataset.