I have two tables on a page and based off the selection of table ‘A’ I retrieve some data and then I need to filter the data for table ‘B’. I am doing so with the following code on ‘PropertyChange’ but after a selection or two on table ‘A’ the page becomes useless and freezes for a very long time. With the code removed the page works fine. Any suggestions?
I do not have access to modify the stored procedure that calls for the data of table ‘B’ that is why i am trying to filter on my side.
table = event.source.parent.getComponent('B') data = table.data unwanted =  if data.rowCount > 0: for row in range(data.rowCount): if data.getValueAt(row, "ItemType")=="02": unwanted.append(row) newData = system.dataset.deleteRows(data, unwanted) table.data = newData