GetRows on PO BO E10

I'm using the BO and yes I want to get to a particular Line/release

On May 12, 2016, at 4:14 PM, Jose Gomez jose@...<mailto:jose@...> [vantage] <vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>> wrote:



Are you using the BO or the Adapter? Syntax is different for each are you trying to get a particular release within the PO?

On Thursday, May 12, 2016, Jose Ortega jortega@...<mailto:jortega@...> [vantage] <vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>> wrote:


I’m trying to invoke a GetRows and this particular BO can take up to 9 different whereClauses. I’m able to pass the first where clause which is PoNum = 10000 and I get data back but I don’t know how to pass it more.

In the BL Tester I can put in PoNum = 10000 and POLine =1 and “ PORelNum= 1” In the respective fields and get the correct data back but I’m not sure how to translate that into C#. I tried inserting empty strings for the whereclauses where I don’t want to specify anything with no luck. I’m not sure if I’m supposed to pass it all 9 different whereclauses separated by commas or build a string and pass that to the BO that but I’m not sure what the correct syntax would be.

The GetRows looks like so GetRows(String whereClausePOHeader, String WhereClausePOHeaderAttch, String whereClausePODetail, String whereClausePODetailAttch ……….. )


Any help would be appreciated.

Thanks




--

Jose C Gomez
Software Engineer


T: 904.469.1524 mobile
E: jose@...<mailto:jose@...>
http://www.josecgomez.com
[http://www.josecgomez.com/images/linkedin.png%5d<http://www.linkedin.com/in/josecgomez> [http://www.josecgomez.com/images/facebook.png%5d <http://www.facebook.com/josegomez> [http://www.josecgomez.com/images/google.png%5d <http://www.google.com/profiles/jose.gomez> [http://www.josecgomez.com/images/twitter.png%5d <http://www.twitter.com/joc85> [http://www.josecgomez.com/images/wp.png%5d <http://www.josecgomez.com/professional-resume/> [http://www.josecgomez.com/images/rss.png%5d <http://www.josecgomez.com/feed/>

Quis custodiet ipsos custodes?

I’m trying to  invoke a GetRows and this particular BO  can take up to 9 different whereClauses. I’m able to pass the first where clause which is PoNum = 10000  and I get data back but I don’t know how to pass it more.

 

In the BL Tester I can put in PoNum = 10000 and  POLine =1  and  “ PORelNum= 1” In the respective fields and get the correct data back  but I’m not sure how to translate that into C#.  I tried inserting empty strings for the whereclauses where I don’t want to specify anything with no luck.  I’m not sure if I’m supposed to pass it all 9 different whereclauses separated by commas or build a string and pass  that to the BO that but I’m not sure what the correct syntax would be.

 

The GetRows looks like so    GetRows(String whereClausePOHeader, String WhereClausePOHeaderAttch, String whereClausePODetail, String whereClausePODetailAttch  ……….. )

 

 

Any help would be appreciated.

 

Thanks

 

 

Are you using the BO or the Adapter? Syntax is different for each are you trying to get a particular release within the PO?

On Thursday, May 12, 2016, Jose Ortega jortega@... [vantage] <vantage@yahoogroups.com> wrote:

Â
<div>
  
  
  <p>

I’m trying to  invoke a GetRows and this particular BO can take up to 9 different whereClauses. I’m able to pass the first where clause which is PoNum = 10000  and I get data back but I don’t know how to pass it more.

Â

In the BL Tester I can put in PoNum = 10000 and  POLine =1  and “ PORelNum= 1” In the respective fields and get the correct data back  but I’m not sure how to translate that into C#. I tried inserting empty strings for the whereclauses where I don’t want to specify anything with no luck. I’m not sure if I’m supposed to pass it all 9 different whereclauses separated by commas or build a string and pass  that to the BO that but I’m not sure what the correct syntax would be.

Â

The GetRows looks like so   GetRows(String whereClausePOHeader, String WhereClausePOHeaderAttch, String whereClausePODetail, String whereClausePODetailAttch  ……….. )

Â

Â

Any help would be appreciated.

Â

Thanks

Â

Â

</div>
 


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


--

Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?