217920_zh-TW

liliconcom

運行腳本時阻止對象顯示

我正在嘗試自動創建JMP圖表。我正在創建一個應用程序。當腳本運行時，它會顯示查詢和報告的輸出。然後它將報告保存為HTML文檔。完整腳本有4種不同的查詢和報告。有沒有辦法在不顯示任何內容的情況下運行腳本？我打算讓應用程序顯示一個彈出窗口，說明報告正在運行，但不希望顯示實際的工件。附件是一個示例腳本。

 

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：防止對像在運行腳本時顯示

您應該能夠指定在“後台”中運行查詢。  在SQL Query下的Scripting Index中查看“Run Background”。  對於控製圖，您始終可以指定“不可見”選項。

Re：防止對像在運行腳本時顯示

謝謝你的回复。我能夠通過使用“私有”選項隱藏表格（因為我不想在完成後關閉它們）我沒有看到在生成圖表時我將使用隱形選項：

 

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：防止對像在運行腳本時顯示

ppnP = 控製圖 （不可見，
示例標籤 （ ： ReleaseMonth ） ，
階段 （ ： 階段 ） ，
樣本大小 （ ： 名稱 （ “Sum-Total” ） ） ，
KSigma （ 3 ） ，
圖表字符 （ ： OnTimePct ， P （ Phase Level （ “1” ） < SPAN class =“token punctuation”style =“box-sizing：border-box ;顏色：＃000000; font-family：Consolas，Monaco，＆amp; quot; andale mono＆amp; quot;，＆amp; quot; ubuntu mono＆amp; quot;，monospace; font-size：14px; font-style：normal; font-variant：normal; font-weight：300;字母間距：正常;孤兒：2; text-align：left; text-decoration：none; text-indent：0px; text-transform：none; -webkit-text-stroke-width：0px;白空間：pre;字間距：0px;“>， 相位級別 （ “2” ） < SPAN class =“token punctuation”style =“box-sizing：border-bo X;顏色：＃000000; font-family：Consolas，Monaco，＆amp; quot; andale mono＆amp; quot;，＆amp; quot; ubuntu mono＆amp; quot;，monospace; font-size：14px; font-style：normal; font-variant：normal; font-weight：300;字母間距：正常;孤兒：2; text-align：left; text-decoration：none; text-indent：0px; text-transform：none; -webkit-text-stroke-width：0px;白空間：pre;字間距：0px;“>） ） ，
按 （ ： 名稱 ）
） ;

 

Re：防止對像在運行腳本時顯示

該腳本指南有一節如何使平台看不見 。

Re：防止對像在運行腳本時顯示感謝您及時的回复。完美的工作。