Power Table ConfigureCell/ConfigureEditor

[PGriffith]

@michael.walter, I moved this post out to a new thread.

I would encourage taking a look at my post in another thread, solving essentially the problem you're describing:

Force configure cell update in power table

The much more efficient solution is to embed a custom editor, which will lookup the datasets dynamically whenever it’s appropriate. I’ve got a very simple example of this below; the project has an editable ‘Options’ dataset, and the available options in column B in the editable table will be dynamic based on the value in column A. The relevant code is here: root = self from javax.swing import JComboBox, DefaultCellEditor, DefaultComboBoxModel class CustomCellEditor(DefaultCellEditor):…

Note that, as @pturmel (correctly) likes to point out, you would not want to do something blocking like system.db.runPrepQuery directly in a frontend call - those scripts block the event dispatch thread, meaning your client will hang up entirely if that query ever returns slowly.