How to get a set for rows from UD100 table based on some filters

Yahoo Archive
1
BOReader is much faster if you only need a few fields.

*John Driggers*
**
*Chief Data Wrangler*
*
*
*I have an Epicor blog <http://usdoingstuff.com/>. How useful is that?*
*
*:: 904.404.9233
:: waffqle@...
:: http://www.usdoingstuff.com <http://www.usdoingstuff.com/>

*

*



On Thu, Oct 25, 2012 at 3:04 PM, yzou79 <yzou79@...> wrote:

> **
>
>
> Thanks for the tip.
>
> The code is part of form customization. Most of the customization use BO
> to access data. If possible, I would like to stick with BO.
>
>
> --- In vantage@yahoogroups.com, Karen Schoenung <kschoenung@...> wrote:
> >
> > <ext_1:GetRowsRequest xmlns:ext_1="
> http://Epicor.com/UD04Service/GetRowsRequest">
> > <ext_1:CompanyID>FBBI</ext_1:CompanyID>
> > <ext_1:whereClauseUD04>Key1 = 'PM3596' AND Key2 = '400082' AND Key3 =
> '10/24/2012' AND Key4 = 'RCK25' AND Key5 = 'PLASTIC
> TUBS'</ext_1:whereClauseUD04>
> > <ext_1:pageSize>1</ext_1:pageSize>
> > <ext_1:absolutePage>0</ext_1:absolutePage>
> > </ext_1:GetRowsRequest>
> >
> >
> > Hello,
> >
> > Above is the way this is done in Service Connect using web services.
> This should help you out...For Service Connect, there is a GUI that shows
> the parameters you can provide are:
> >
> > Company ID, whereClauseUDTableNo, whereClauseUDTableNoAttch, pageSize
> and absolutePage
> >
> > As you can see, we do not use the second where clause...
> >
> > FYI,
> > Karen Schoenung
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of yzou79
> > Sent: Thursday, October 25, 2012 11:28 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] How to get a set for rows from UD100 table based on
> some filters
> >
> >
> >
> > I am trying to get all rows back in a dataset with CheckBox01 field is
> not checked in UD100 table. Tried to use GetRows, but could not figure out
> the parameters needed to pass over. Here is the section of code:
> >
> > Epicor.Mfg.BO.UD100DataSet ds = new Epicor.Mfg.BO.UD100DataSet();
> > Epicor.Mfg.Core.Session mySession =
> (Epicor.Mfg.Core.Session)EndActForm.Session;
> > Epicor.Mfg.BO.UD100 myUD100 = new
> Epicor.Mfg.BO.UD100(mySession.ConnectionPool);
> >
> > bool outParam = true;
> > ds = myUD100.GetRows("","","",0,0,out outParam);
> >
> > It seems that GetRows takes six parameters. the first three are string
> and then two int and the last one is bool.
> >
> > Could someone advise me what those parameters are? Thanks
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
2
I am trying to get all rows back in a dataset with CheckBox01 field is not checked in UD100 table. Tried to use GetRows, but could not figure out the parameters needed to pass over. Here is the section of code:


Epicor.Mfg.BO.UD100DataSet ds = new Epicor.Mfg.BO.UD100DataSet();
Epicor.Mfg.Core.Session mySession = (Epicor.Mfg.Core.Session)EndActForm.Session;
Epicor.Mfg.BO.UD100 myUD100 = new Epicor.Mfg.BO.UD100(mySession.ConnectionPool);

bool outParam = true;
ds = myUD100.GetRows("","","",0,0,out outParam);

It seems that GetRows takes six parameters. the first three are string and then two int and the last one is bool.

Could someone advise me what those parameters are? Thanks
3
The BL Tester is a very useful tool for things like this...


Here are the paramaters in order,


whereClauseUD100:
whereClauseUD100Attch:
whereClauseUD100A:
pageSize:
absolutePage:
morePages:



________________________________
From: yzou79 <yzou79@...>
To: vantage@yahoogroups.com
Sent: Thursday, October 25, 2012 12:28 PM
Subject: [Vantage] How to get a set for rows from UD100 table based on some filters

I am trying to get all rows back in a dataset with CheckBox01 field is not checked in UD100 table. Tried to use GetRows, but could not figure out the parameters needed to pass over. Here is the section of code:


Epicor.Mfg.BO.UD100DataSet ds = new Epicor.Mfg.BO.UD100DataSet();
Epicor.Mfg.Core.Session mySession = (Epicor.Mfg.Core.Session)EndActForm.Session;
Epicor.Mfg.BO.UD100 myUD100 = new Epicor.Mfg.BO.UD100(mySession.ConnectionPool);Â Â Â Â Â Â Â Â Â
      Â
bool outParam = true;
ds = myUD100.GetRows("","","",0,0,out outParam);

It seems that GetRows takes six parameters. the first three are string and then two int and the last one is bool.

Could someone advise me what those parameters are? Thanks



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links



[Non-text portions of this message have been removed]
4
I would maybe use the BOReader. It seems like it would be a lot less code.

--- In vantage@yahoogroups.com, Ted Koch <tkoch77@...> wrote:
>
> The BL Tester is a very useful tool for things like this...
>
>
> Here are the paramaters in order,
>
>
> whereClauseUD100:
> whereClauseUD100Attch:
> whereClauseUD100A:
> pageSize:
> absolutePage:
> morePages:
>
>
>
> ________________________________
> From: yzou79 <yzou79@...>
> To: vantage@yahoogroups.com
> Sent: Thursday, October 25, 2012 12:28 PM
> Subject: [Vantage] How to get a set for rows from UD100 table based on some filters
>
> I am trying to get all rows back in a dataset with CheckBox01 field is not checked in UD100 table. Tried to use GetRows, but could not figure out the parameters needed to pass over. Here is the section of code:
>
>
> Epicor.Mfg.BO.UD100DataSet ds = new Epicor.Mfg.BO.UD100DataSet();
> Epicor.Mfg.Core.Session mySession = (Epicor.Mfg.Core.Session)EndActForm.Session;
> Epicor.Mfg.BO.UD100 myUD100 = new Epicor.Mfg.BO.UD100(mySession.ConnectionPool);Â Â Â Â Â Â Â Â Â
> Â Â Â Â Â Â Â
> bool outParam = true;
> ds = myUD100.GetRows("","","",0,0,out outParam);
>
> It seems that GetRows takes six parameters. the first three are string and then two int and the last one is bool.
>
> Could someone advise me what those parameters are? Thanks
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
> [Non-text portions of this message have been removed]
>
5
<ext_1:GetRowsRequest xmlns:ext_1="http://Epicor.com/UD04Service/GetRowsRequest">
<ext_1:CompanyID>FBBI</ext_1:CompanyID>
<ext_1:whereClauseUD04>Key1 = 'PM3596' AND Key2 = '400082' AND Key3 = '10/24/2012' AND Key4 = 'RCK25' AND Key5 = 'PLASTIC TUBS'</ext_1:whereClauseUD04>
<ext_1:pageSize>1</ext_1:pageSize>
<ext_1:absolutePage>0</ext_1:absolutePage>
</ext_1:GetRowsRequest>


Hello,

Above is the way this is done in Service Connect using web services. This should help you out...For Service Connect, there is a GUI that shows the parameters you can provide are:

Company ID, whereClauseUDTableNo, whereClauseUDTableNoAttch, pageSize and absolutePage

As you can see, we do not use the second where clause...

FYI,
Karen Schoenung
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of yzou79
Sent: Thursday, October 25, 2012 11:28 AM
To: vantage@yahoogroups.com
Subject: [Vantage] How to get a set for rows from UD100 table based on some filters



I am trying to get all rows back in a dataset with CheckBox01 field is not checked in UD100 table. Tried to use GetRows, but could not figure out the parameters needed to pass over. Here is the section of code:

Epicor.Mfg.BO.UD100DataSet ds = new Epicor.Mfg.BO.UD100DataSet();
Epicor.Mfg.Core.Session mySession = (Epicor.Mfg.Core.Session)EndActForm.Session;
Epicor.Mfg.BO.UD100 myUD100 = new Epicor.Mfg.BO.UD100(mySession.ConnectionPool);

bool outParam = true;
ds = myUD100.GetRows("","","",0,0,out outParam);

It seems that GetRows takes six parameters. the first three are string and then two int and the last one is bool.

Could someone advise me what those parameters are? Thanks



[Non-text portions of this message have been removed]
6
Thanks for the tip.

The code is part of form customization. Most of the customization use BO to access data. If possible, I would like to stick with BO.



--- In vantage@yahoogroups.com, Karen Schoenung <kschoenung@...> wrote:
>
> <ext_1:GetRowsRequest xmlns:ext_1="http://Epicor.com/UD04Service/GetRowsRequest">
> <ext_1:CompanyID>FBBI</ext_1:CompanyID>
> <ext_1:whereClauseUD04>Key1 = 'PM3596' AND Key2 = '400082' AND Key3 = '10/24/2012' AND Key4 = 'RCK25' AND Key5 = 'PLASTIC TUBS'</ext_1:whereClauseUD04>
> <ext_1:pageSize>1</ext_1:pageSize>
> <ext_1:absolutePage>0</ext_1:absolutePage>
> </ext_1:GetRowsRequest>
>
>
> Hello,
>
> Above is the way this is done in Service Connect using web services. This should help you out...For Service Connect, there is a GUI that shows the parameters you can provide are:
>
> Company ID, whereClauseUDTableNo, whereClauseUDTableNoAttch, pageSize and absolutePage
>
> As you can see, we do not use the second where clause...
>
> FYI,
> Karen Schoenung
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of yzou79
> Sent: Thursday, October 25, 2012 11:28 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] How to get a set for rows from UD100 table based on some filters
>
>
>
> I am trying to get all rows back in a dataset with CheckBox01 field is not checked in UD100 table. Tried to use GetRows, but could not figure out the parameters needed to pass over. Here is the section of code:
>
> Epicor.Mfg.BO.UD100DataSet ds = new Epicor.Mfg.BO.UD100DataSet();
> Epicor.Mfg.Core.Session mySession = (Epicor.Mfg.Core.Session)EndActForm.Session;
> Epicor.Mfg.BO.UD100 myUD100 = new Epicor.Mfg.BO.UD100(mySession.ConnectionPool);
>
> bool outParam = true;
> ds = myUD100.GetRows("","","",0,0,out outParam);
>
> It seems that GetRows takes six parameters. the first three are string and then two int and the last one is bool.
>
> Could someone advise me what those parameters are? Thanks
>
>
>
> [Non-text portions of this message have been removed]
>