I am new to Perspective after working in Vision. I have a button on a Perspective popup view that is designed to execute a named query and then close the popup. The named query ("Clear Replacements Table") empties a table in the database.
When I have just the script event configured on the action, it works fine. When I have both the script event and the popup event configured, it closes the view but doesn't run the query. I have tried organizing the actions both ways - once with the script event running first, once with the popup event running first. This did not impact the results.
I attached screenshots of my configurations. Any support would be great! Thank you
Script event configuration:
Popup event configuration:
I seem to remember this coming up before in the forum.
Try closing the popup in the script rather than in a separate action.
Tip: remove the Vision tag from your question. It is nothing to do with Vision.
Assuming "Clear Replacements Table" is the path of your named query:
system.db.runNamedQuery(system.util.getProjectName(), "Clear Replacements Table" )
Remember to Save *
Actions configured for an Event run asynchronous, so there is no guarantee as to when each will complete. There's a very good chance the closing of the Popup occurs before the query script completes. If you need guaranteed synchronous behaviors, you must put everything into a single script Action.
In general, the only time you should configure multiple Actions off of a single Event is when there is no distinct order in which the Actions begin or complete.
Closing the popup within the script worked. Good to know about the asynchronous timing! (Working code pasted below)
def runAction(self, event):
system.db.runNamedQuery("Clear Replacements Table")
system.perspective.closePopup('')
