I have a Power Table that displays data based on a SQL query. I’ve enabled onMousepress running this script:
data = system.dataset.toPyDataSet(self.viewDataset) self.PN = data[rowIndex]['Part ID']
Basically when the user clicks on a row, the Part ID in that row is then used to get data in a different table. It works exactly as intended, unless they filter the table! Simply just changing the order of a column will cause the onMousepress to select a Part ID from a different row than the one selected. Clearing the filters, it works properly.
So, the problem is onMousepress doesn’t work correctly if the table is filtered. Any ideas?