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