Limit BOReader Results with BPM

system · July 16, 2015, 1:30pm

Hi John,

No I was not able to, and I really haven't spent anymore time on it.

From: "mitchelljohn@... [vantage]" <vantage@yahoogroups.com>
To: vantage@yahoogroups.com
Sent: Thursday, July 16, 2015 1:10 PM
Subject: [Vantage] Re: Limit BOReader Results with BPM

Ted,

Were you ever able to come up with a solution to hide inactive warehouses? We are moving our plant later this year and this is going to be a big request. Thanks,

John

system · April 21, 2015, 3:01pm

Hi,

Has anyone been able to filter results when they have a trace like this. I have been able to filter results when the actual BO is being called (ex. JobEntry.GetList). However, I'm struggling to find a way to filter the results with a BPM for the BOReader. I added an Inactive checkbox to the Warehse table and would like to filter out the inactive warehouses. Perhaps it's not possible.

<tracePacket>
<businessObject>Ice.Proxy.Lib.BOReaderImpl</businessObject>
<methodName>GetRows</methodName>
<returnType>System.Data.DataSet</returnType>
<localTime>4/21/2015 13:30:32:7160212 PM</localTime>
<executionTime>1995</executionTime>
<parameters>
    <parameter name="serviceNamespace" type="System.String"><![CDATA[Erp:BO:WarehseSearch]]></parameter>
    <parameter name="whereClause" type="System.String"><![CDATA[MfgSys]]></parameter>
    <parameter name="columnList" type="System.String"><![CDATA[]]></parameter>
</parameters>
</tracePacket>

system · April 21, 2015, 3:26pm

The second parameter in that call is a whereClause which you can edit if you calling the BO yourself. Now if its a dropdown there is a Filter Option in the Customization where you can add your own filter.

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Â

Quis custodiet ipsos custodes?

On Tue, Apr 21, 2015 at 3:01 PM, tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

Â

<div>
  
  
  <p>Hi,<br><br>Has anyone been able to filter results when they have a trace like this. I have been able to filter results when the actual BO is being called (ex. JobEntry.GetList). However, I&#39;m struggling to find a way to filter the results with a BPM for the BOReader. I added an Inactive checkbox to the Warehse table and would like to filter out the inactive warehouses. Perhaps it&#39;s not possible.<br><br>&lt;tracePacket&gt;<br>Â  &lt;businessObject&gt;Ice.Proxy.Lib.BOReaderImpl&lt;/businessObject&gt;<br>Â  &lt;methodName&gt;GetRows&lt;/methodName&gt;<br>Â  &lt;returnType&gt;System.Data.DataSet&lt;/returnType&gt;<br>Â  &lt;localTime&gt;4/21/2015 13:30:32:7160212 PM&lt;/localTime&gt;<br>Â  &lt;executionTime&gt;1995&lt;/executionTime&gt;<br>Â  &lt;parameters&gt;<br>Â Â Â  &lt;parameter name=&quot;serviceNamespace&quot; type=&quot;System.String&quot;&gt;&lt;![CDATA[Erp:BO:WarehseSearch]]&gt;&lt;/parameter&gt;<br>Â Â Â  &lt;parameter name=&quot;whereClause&quot; type=&quot;System.String&quot;&gt;&lt;![CDATA[MfgSys]]&gt;&lt;/parameter&gt;<br>Â Â Â  &lt;parameter name=&quot;columnList&quot; type=&quot;System.String&quot;&gt;&lt;![CDATA[]]&gt;&lt;/parameter&gt;<br>Â  &lt;/parameters&gt;<br>&lt;/tracePacket&gt;<br></p><p><span><br></span></p><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>

system · April 21, 2015, 3:31pm

I was hoping there was a way to do this without having to customize every form that has the warehouse dropdown.

From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>
To: Vantage <vantage@yahoogroups.com>
Sent: Tuesday, April 21, 2015 3:25 PM
Subject: Re: [Vantage] Limit BOReader Results with BPM

The second parameter in that call is a whereClause which you can edit if you calling the BO yourself. Now if its a dropdown there is a Filter Option in the Customization where you can add your own filter.

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Quis custodiet ipsos custodes?

On Tue, Apr 21, 2015 at 3:01 PM, tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

<div id="ygrps-yiv-1338247506yui_3_16_0_1_1429623187165_61475">
  
  
  <div id="ygrps-yiv-1338247506yui_3_16_0_1_1429623187165_61474">Hi,<br><br>Has anyone been able to filter results when they have a trace like this. I have been able to filter results when the actual BO is being called (ex. JobEntry.GetList). However, I&#39;m struggling to find a way to filter the results with a BPM for the BOReader. I added an Inactive checkbox to the Warehse table and would like to filter out the inactive warehouses. Perhaps it&#39;s not possible.<br><br>&lt;tracePacket&gt;<br>&nbsp; &lt;businessObject&gt;Ice.Proxy.Lib.BOReaderImpl&lt;/businessObject&gt;<br>&nbsp; &lt;methodName&gt;GetRows&lt;/methodName&gt;<br>&nbsp; &lt;returnType&gt;System.Data.DataSet&lt;/returnType&gt;<br>&nbsp; &lt;localTime&gt;4/21/2015 13:30:32:7160212 PM&lt;/localTime&gt;<br>&nbsp; &lt;executionTime&gt;1995&lt;/executionTime&gt;<br>&nbsp; &lt;parameters&gt;<br>&nbsp;&nbsp;&nbsp; &lt;parameter name=&quot;serviceNamespace&quot; type=&quot;System.String&quot;&gt;&lt;![CDATA[Erp:BO:WarehseSearch]]&gt;&lt;/parameter&gt;<br>&nbsp;&nbsp;&nbsp; &lt;parameter name=&quot;whereClause&quot; type=&quot;System.String&quot;&gt;&lt;![CDATA[MfgSys]]&gt;&lt;/parameter&gt;<br>&nbsp;&nbsp;&nbsp; &lt;parameter name=&quot;columnList&quot; type=&quot;System.String&quot;&gt;&lt;![CDATA[]]&gt;&lt;/parameter&gt;<br>&nbsp; &lt;/parameters&gt;<br>&lt;/tracePacket&gt;<br></div><div><span><br></span></div><div></div>

</div>
 


<div style="color:#fff;min-height:0;"></div>

system · April 21, 2015, 3:37pm

Technically it calls the GetRows / GetList of the BO you are providing so you should be able to implement your own GetRows method to filter these out. However I don't recommend it.

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Â

Quis custodiet ipsos custodes?

On Tue, Apr 21, 2015 at 3:31 PM, Ted Koch tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

Â

<div>
  
  
  <p></p><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px;">I was hoping there was a way to do this without having to customize every form that has the warehouse dropdown.<div><span></span></div>  <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px;"> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div dir="ltr"> <hr size="1">  <font face="Arial" size="2"> <b><span style="font-weight:bold;">From:</span></b> &quot;Jose Gomez <a rel="nofollow" target="_blank" href="mailto:jose@...">jose@...</a> [vantage]&quot; &lt;<a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>&gt;<br> <b><span style="font-weight:bold;">To:</span></b> Vantage &lt;<a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>&gt; <br> <b><span style="font-weight:bold;">Sent:</span></b> Tuesday, April 21, 2015 3:25 PM<br> <b><span style="font-weight:bold;">Subject:</span></b> Re: [Vantage] Limit BOReader Results with BPM<br> </font> </div><div><div class="ygrps-yiv-856863035h5"> <div><br><div>

The second parameter in that call is a whereClause which you can edit if you calling the BO yourself. Now if its a dropdown there is a Filter Option in the Customization where you can add your own filter.

Jose C Gomez

Software Engineer