217920_zh-CN

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：防止对象在运行脚本时显示感谢您及时的回复。完美的工作。