Version: 7.6.6
OS: Win7
I have a table bound to a SQL query that works great.
SELECT ID, STRING, t_stamp
FROM TFL{Root Container.CP FAULTS.Line}CPFAULTS
WHERE t_stamp > '{Root Container.CP FAULTS.Date Range.startDate}' AND
t_stamp < '{Root Container.CP FAULTS.Date Range.endDate}'
I’d like to add an additional dynamic column to simply number the rows and getRowsInViewOrder() appears to be the solution. I’ve attempted to implement a “propertyChange” event script on the table to add this column.
if event.propertyName == "data":
system.dataset.addColumn(event.source.data[0], [b]Type PySequence[/b], "Error", [b]Type PyType[/b])
getRowsInViewOrder()
I’m not sure how to obtain the appropriate PySequence and PyType arguments in the addColumn function. Maybe there’s an easier way?