Table Query Data

Ignition
1

I have a script that runs from a property change…

po = event.source.value

data = system.db.runNamedQuery("BOM/PoDetails",{"po":po})

event.source.parent.getComponent('Table3').data = data

Will populating the table in this manner allow me to manipulate and change the table data without affecting the db data that was queried?

2

Yes, the content of your Table’s onCellEdited extension function is the sole determinant of how edits will be processed. If you just update the component’s table data (as shown in the example script) without issuing an update query, your database table data will remain the same.

3

That’s what I thought, but I wanted to make sure. Thanks!