topic Re: Opening Running Queries from script in Discussions

Opening Running Queries from script

jthi — Tue, 09 Jul 2019 09:14:45 GMT

I'm trying to create UI where sql query can be run on foreground when user presses a button and this button may be pressed multiple times. I would like to the user how many queries are currently running. If possible I would like to use Running Queries which can be found from View menu. Can this be opened directly from script?

Re: Opening Running Queries from script

briancorcoran — Tue, 09 Jul 2019 11:48:04 GMT

Hi,

If you run the query in the foreground, you are only going to have one query running at a time. However, to answer your question there currently is no scripted way to get access to the View->Running Queries dialog. There is an open suggestion for an enhancement to do this.

Brian Corcoran

JMP Development

Re: Opening Running Queries from script

jthi — Tue, 09 Jul 2019 12:05:07 GMT

Oopss. Meant to say background instead of foreground...
Thank you for information, I'll create some kind of custom New Window temporary (waiting of enchantment) to give information to user that queries are being ran in background.

Re: Opening Running Queries from script

briancorcoran — Tue, 09 Jul 2019 12:09:40 GMT

One option just occurred to me. It does not allow interaction or asking for information from the Running Queries window, but if you just want to pop it up you can use:

Main Menu("Running Queries");

In your script and the Window will at least be presented to users.

Brian Corcoran

JMP Development

Re: Opening Running Queries from script

jthi — Wed, 10 Jul 2019 05:53:59 GMT

This is exactly what I was looking for. Couldn't just find the Main Menu() function. This should be enough most of the time for my script. Thank you!