217920_en-US

liliconcom

Prevent Objects From Displaying When Running Scripts

I'm trying to automate my JMP chart creation. I'm creating an application.As the script runs it displays the output of the query and the report. It then saves the report as an HTML document. The full script has 4 different queries and reports. Is there a way to run the script where it doesn't display anything? I plan on having the application show a pop-up saying the report is running, but don't want the actual artifacts displaying. Attached is a sample script.

 

planetQ <SPAN class="token operator">=</SPAN> <SPAN class="token function">New SQL Query</SPAN><SPAN class="token punctuation">(</SPAN>
 Connection<SPAN class="token punctuation">(</SPAN>
  <SPAN class="token string">"CONNECTION INFO HERE"</SPAN>
 <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
 QueryName<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"ON_TIME_SPC_PLANET"</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
 Select<SPAN class="token punctuation">(</SPAN>
  <SPAN class="token function">Column</SPAN><SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"ReleaseMonth"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">"t1"</SPAN><SPAN class="token punctuation">,</SPAN> Numeric <SPAN class="token function">Format</SPAN><SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"m/d/y"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">"-1"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">"NO"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">""</SPAN> <SPAN class="token punctuation">)</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
  <SPAN class="token function">Column</SPAN><SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"PLANET"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">"t1"</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
  <SPAN class="token function">Column</SPAN><SPAN class="token punctuation">(</SPAN>
   <SPAN class="token string">"On-Time"</SPAN><SPAN class="token punctuation">,</SPAN>
   <SPAN class="token string">"t1"</SPAN><SPAN class="token punctuation">,</SPAN>
   Alias<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Sum-On-Time"</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
   SavedJMPName<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"On-Time"</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
   Aggregation<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Sum"</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
   JMP Name<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Sum-On-Time"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token number">0</SPAN> <SPAN class="token punctuation">)</SPAN>
  <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
  <SPAN class="token function">Column</SPAN><SPAN class="token punctuation">(</SPAN>
   <SPAN class="token string">"Total"</SPAN><SPAN class="token punctuation">,</SPAN>
   <SPAN class="token string">"t1"</SPAN><SPAN class="token punctuation">,</SPAN>
   Alias<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Sum-Total"</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
   SavedJMPName<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Total"</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
   Aggregation<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Sum"</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
   JMP Name<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Sum-Total"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token number">0</SPAN> <SPAN class="token punctuation">)</SPAN>
  <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
  <SPAN class="token function">Column</SPAN><SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Phase"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">"t1"</SPAN><SPAN class="token punctuation">,</SPAN> Analysis <SPAN class="token function">Type</SPAN><SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Nominal"</SPAN> <SPAN class="token punctuation">)</SPAN> <SPAN class="token punctuation">)</SPAN>
 <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
 From<SPAN class="token punctuation">(</SPAN> Table<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"ON_TIME_SPC"</SPAN><SPAN class="token punctuation">,</SPAN> Schema<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"dbo"</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN> Alias<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"t1"</SPAN> <SPAN class="token punctuation">)</SPAN> <SPAN class="token punctuation">)</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
 Group By<SPAN class="token punctuation">(</SPAN>
  <SPAN class="token function">Column</SPAN><SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"ReleaseMonth"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">"t1"</SPAN><SPAN class="token punctuation">,</SPAN> Numeric <SPAN class="token function">Format</SPAN><SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"m/d/y"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">"-1"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">"NO"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">""</SPAN> <SPAN class="token punctuation">)</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
  <SPAN class="token function">Column</SPAN><SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"PLANET"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">"t1"</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
  <SPAN class="token function">Column</SPAN><SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Phase"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">"t1"</SPAN> <SPAN class="token punctuation">)</SPAN>
 <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
 Order By<SPAN class="token punctuation">(</SPAN>
  <SPAN class="token function">Column</SPAN><SPAN class="token punctuation">(</SPAN>
   <SPAN class="token string">"ReleaseMonth"</SPAN><SPAN class="token punctuation">,</SPAN>
   <SPAN class="token string">"t1"</SPAN><SPAN class="token punctuation">,</SPAN>
   Numeric <SPAN class="token function">Format</SPAN><SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"m/d/y"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">"-1"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">"NO"</SPAN><SPAN class="token punctuation">,</SPAN> <SPAN class="token string">""</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
   Order<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Ascending"</SPAN> <SPAN class="token punctuation">)</SPAN>
  <SPAN class="token punctuation">)</SPAN>
 <SPAN class="token punctuation">)</SPAN>
<SPAN class="token punctuation">)</SPAN> <SPAN class="token operator"><</SPAN><SPAN class="token operator"><</SPAN><SPAN class="token messages"> Run Foreground</SPAN><SPAN class="token punctuation">(</SPAN><SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">;</SPAN>

planetQ <SPAN class="token operator"><</SPAN><SPAN class="token operator"><</SPAN><SPAN class="token messages"> New Column</SPAN><SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"OnTimePct"</SPAN><SPAN class="token punctuation">,</SPAN>
 Formula<SPAN class="token punctuation">(</SPAN> <SPAN class="token punctuation">:</SPAN>Name<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Sum-On-Time"</SPAN> <SPAN class="token punctuation">)</SPAN> <SPAN class="token operator">/</SPAN> <SPAN class="token punctuation">:</SPAN>Name<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Sum-Total"</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">)</SPAN>
<SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">;</SPAN>
<SPAN class="token function">wait</SPAN><SPAN class="token punctuation">(</SPAN><SPAN class="token number">1.0</SPAN><SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">;</SPAN>

<SPAN class="token function">current data table</SPAN><SPAN class="token punctuation">(</SPAN>planetQ<SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">;</SPAN>

planetP <SPAN class="token operator">=</SPAN> Control Chart<SPAN class="token punctuation">(</SPAN>
 Sample Label<SPAN class="token punctuation">(</SPAN> <SPAN class="token punctuation">:</SPAN>ReleaseMonth <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
 Phase<SPAN class="token punctuation">(</SPAN> <SPAN class="token punctuation">:</SPAN>Phase <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
 Sample Size<SPAN class="token punctuation">(</SPAN> <SPAN class="token punctuation">:</SPAN>Name<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"Sum-Total"</SPAN> <SPAN class="token punctuation">)</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
 KSigma<SPAN class="token punctuation">(</SPAN> <SPAN class="token number">3</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
 Chart Col<SPAN class="token punctuation">(</SPAN> <SPAN class="token punctuation">:</SPAN>OnTimePct<SPAN class="token punctuation">,</SPAN> P<SPAN class="token punctuation">(</SPAN> Phase Level<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"1"</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN> Phase Level<SPAN class="token punctuation">(</SPAN> <SPAN class="token string">"2"</SPAN> <SPAN class="token punctuation">)</SPAN> <SPAN class="token punctuation">)</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">,</SPAN>
 By<SPAN class="token punctuation">(</SPAN> <SPAN class="token punctuation">:</SPAN>PLANET <SPAN class="token punctuation">)</SPAN>
<SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">;</SPAN>

 

Re: Prevent Objects From Displaying When Running Scripts

You should be able to specify to run your query in "Background".  Look in the Scripting Index under SQL Query for "Run Background".  And as for the Control Chart, you can always specify the "Invisible" option.

Re: Prevent Objects From Displaying When Running Scripts

Thanks for the response. I was able to hide the tables by using the "private" option (since I didn't want to have to close them when done) I am not seeing where I would use the invisible option when generating the chart:

 

ppnP = Control Chart(
 Sample Label( :ReleaseMonth ),
 Phase( :Phase ),
 Sample Size( :Name( "Sum-Total" ) ),
 KSigma( 3 ),
 Chart Col( :OnTimePct, P( Phase Level( "1" ), Phase Level( "2" ) ) ),
 By( :name )
);

Re: Prevent Objects From Displaying When Running Scripts

ppnP = Control Chart(invisible,
Sample Label( :ReleaseMonth ),
Phase( :Phase ),
Sample Size( :Name( "Sum-Total" ) ),
KSigma( 3 ),
Chart Col( :OnTimePct, P( Phase Level( "1" ), Phase Level( "2" ) ) ),
By( :name )
);

 

Re: Prevent Objects From Displaying When Running Scripts

The Scripting Guide has a section on how to Make Platforms Invisible.

Re: Prevent Objects From Displaying When Running ScriptsThanks for the quick response. Works perfectly.