Resseting every cell in a Table to being blank after a specific time, Ignition Perspective

Ignition
1

Hello,
I am back again with an idea I want to execute on a test table I made but I am not sure how to do it. I currently have a table named TestTable which is connected to a memory tag dataset called TestData. I have 3 columns in this dataset: name, value, and date. The overall goal I have is to reset all the cells under the value column to 0 once the time is 12:00 am. For test purposes though I am trying to reset it every 10seconds, so I don't have to wait. Anyway, my idea was to create a python script in the project library that would reset the cells in the second column to 0. However, I'm not sure how to execute it. Here is the code for reference:

def reset():
    
    table_names = ["TestTable"]
    
    for table_name in table_names:
       # Reset all cell values except the first column
       table = self.getSibling(table_name)
       data = table.props.data
       
       # Reset all cell values except the first and last columns
       for row in range(data.getRowCount()):
       		for col in range(1, data.getColumnCount() - 1):
       			data.setValueAt("", row, col)
reset()
system.perspective.schedule(reset_table_cells, 10000)

All help is appreciated!
Thanks!

2

You are trying to edit the cells in place. Datasets are immutable in practice. Just create a new dataset with the desired empty cells, from scratch, and write it to the table's props.data.