Add data to query based table

Ignition
,
1

I'd like to add a row to query based perspective table. The data is stored in MS SQL server, what would be the simplest way to accomplish this?

2

Here's how I'd start ...

  1. Create two custom properties with bindings to the two named queries that provide the main table data and the additional row. Set the polling rates to something sensible.
  2. On the table create an Expression Structure binding on the data property. Add the two custom properties to the structure.
  3. Add Transform. I would choose a script transform to merge the two datasets but I would have a niggly feeling in the back of my mind that it can be done much more quickly with an expression transform. I'll see if I can find it.

The advantage with this approach is that if either of the data sources changes it will trigger the expression structure to reevaluate and update your table.