nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JMP15 Query Builder Missed the "Post Query Script"

Hello All,

I'm using JMP15 Query Builder to build some automation script, when I "Save Run(/Modify) Script to Script Window"

the outcome script missed those Scripts in "Post Query Script" Session, while this function works well in JMP14, the output script including both "New SQL query" + "Post Script Query"

Do i missed something or this is a known issue for JMP15 ?

attached a picture here : Query Builder.JPG

Thank you

Accepted answers

MikeD_Anderson

It’s a bug. I found it after code freeze. If you edit the post query script (click in the script window and hit enter to add a blank line) it will work again until you close the Query Builder. No word if it’s going to be addressed 15.1 or not. You should still report it through an email to jmpbeta@jmp.com or sending a note to tech support. It helps them get a feel for the scope of the issue.

M

All comments

MikeD_Anderson

A bug ! It's sad
Thanks Mike

MikeD_Anderson

@PIN,
A follow-up: As a workaround until 15.1, you can mark a saved Query Builder file as “Run on Open” under the LRT menu and the saved script will work. If you go this route, you’ll need to have a copy saved that doesn’t have the “Run On Open” flag turned on to show people what is in there. There are several steps to open a QB file once that flag is turned on.

M

Thanks Mike. Your advice provide us great value, at least as SE we are aware it ( possible a bug) when we facing customer's query

Have tried your different options. Just as sharing my result :

Option1 - with “Run on Open” ticked

Result: Able to capture “Post Query Script” , But will encounter error message fail to connect when re-run the saved script

Option2 - with “blank row entered” in the post query field :

Result: Able to capture “Post Query Script”, But the saved script only execute part 1 of the query script but not the part 2 - “Post Query Script”