cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
Stefan_Moser
Level III

Window popup for SQL query that gives user feedback on #rows fetched

Working in JMP 18. I'm having a challenge recreating what I thought used to be a feature when pulling data from a database. 

 

I am working in a workflow, and the first step is pulling data from one of our internal databases. The JSL was pulled directly from query builder. 

 

The desired behavior is that the user runs the step, and while the query runs (it takes a few minutes), a window pops up giving the user feedback on the # of rows fetched. The workflow should wait until the query completes and the output table is present before proceeding. I have been unsuccessful in getting the pop-up window to show up, although I seem to remember this working in the past. What I've tried:
1. Use 'run foreground' - runs and workflow continues running once query is complete, but 'freezes' JMP while the query runs

2. Use 'run background' - runs and doesn't freeze but doesn't have a popup window with the rows fetched and breaks the workflow since it tries to proceed to the next step before the data loads

3. Use' run background' and add a JSL loop that checks if query is done before proceeding to next step - runs, doesn't freeze, and only progresses in workflow once the query is complete, but again there is no user feedback showing the 'rows fetched' window

3 REPLIES 3
jthi
Super User

Re: Window popup for SQL query that gives user feedback on #rows fetched

With option three you won't get as "clean" rows fetched with this but you could maybe use Running Queries window

Main Menu("View:Running Queries");

jthi_0-1759949268029.png

 

-Jarmo
Stefan_Moser
Level III

Re: Window popup for SQL query that gives user feedback on #rows fetched

yeah I considered that but it's a bit clunky for a tool I'm building for a large team... do you know about the 'fetching rows' window I'm talking about? I somehow can't get it to pop up again no matter what

jthi
Super User

Re: Window popup for SQL query that gives user feedback on #rows fetched

I assume you mean this one (I'm not sure if it is possible to display that when using << Run Background):

jthi_0-1759985645963.png

You could maybe build your own utilizing Running Queries and custom New Window where you pick the values from Running Queries window and update the custom window inside your loop.

-Jarmo

Recommended Articles