Data Table entry from 2 sessions of the same project on different views

Ignition
1

I have a data entry page set up to enter data into the database and a table bound to that database to display it. This is on one page of the project. On another page in the same project I have a table bound to the same database so an operator can see the data entered. I had no problems setting it up so the data shows on both sessions but I have a column with a Bool data type I want the operator to use to acknowledge the incoming data. I want the first screen to see the bool column change when the operator acknowledges it. I tried having a runPrepUpdate on the editCellCommit

def runAction(self, event):
	valueToSet = event.value    
	self.props.data = system.dataset.setValue(self.props.data, event.row, event.column, valueToSet)

	
	# Get the updated value and the row ID
	
	row_id = self.props.selection.selectedRow
	

	
# Define the query
	query = """ Update EVISDATA

	Set Inspected = 1

	where id = ?

	"""
	db = "POC_Ignition_Plant_SCADA"
# Execute the query

	system.db.runPrepUpdate(query,[row_id],db)

This executes without error but still no change on the first screen.

Any help would be appreciated!

2

You need to send a message from the update script to all clients to refresh the table binding.

3

Even if I have polling on for both tables? Wouldn't sending a message to refresh do the same thing?

4

One would imagine it would. I never use polling so you'll have to wait for someone else.

If I wanted to check if the polling was running I might add a UNION line into the query and put the SQL NOW() function to return an extra row (with the same column names) with the time inserted in a suitable column. That should be visible in the table.

5

was able to figure it out. Need to make some changes to my code. Thanks for the help anyway @Transistor

New code for reference

if self.props.selection.selectedColumn == "Inspected":
		isEnabled = not self.props.data.getValueAt(event.row, 'Inspected')
		if isEnabled == True:
			setEnabled = 1
		else:
			setEnabled = 0 
				
	id=self.props.data.getValueAt(event.row, 'id')
	
	
	
# Define the query
	query = """ Update EVISDATA

	Set Inspected = ?

	where id = ?

	"""
	db = "POC_Ignition_Plant_SCADA"
# Execute the query

	system.db.runPrepUpdate(query,[setEnabled,id],db)
	
	self.refreshBinding("props.data")