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?
Here's how I'd start ...
- 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.
- On the table create an Expression Structure binding on the data property. Add the two custom properties to the structure.
- 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.