Part.GetRows Blank Title 99159

I think that what you need to do is include the PartNum AND the Plant on the Plant whereClause.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Waffqle
Sent: Monday, March 28, 2011 8:51 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Part.GetRows

If 'plant' is the only criterea you're using you're going to pull every single part for that plant. I don't know about you, but for us that would be a massive dataset. It may be that you're just trying to pull too much data and it's taking too long.



On Mon, Mar 28, 2011 at 10:59 AM, rossh777 <ross.hughes3@...> wrote:

>
>
> I have used GetRows quite a bit filtering on the primary part table
> and in many other different tables. This works fine. What I would like
> to do is to filter on one of the related tables with Part.GetRows
> (partplant in this case). Does anybody have a working example of this?
>
> When I try the BL Tester using whereClausePart (e.g., PartNum =
> "MyPartNum") it works perfectly.
>
> If I try using only the whereClausePartPlant (e.g., Plant = "MyPlant")
> it will run for 5 minutes and error out.
>
> When I apply the same logic with following, I get the same results:
>
> opts.NamedSearch.WhereClauses.Add("Part","PartNum = '" & MyPartNum & "'") '
> This works fine
>
> opts.NamedSearch.WhereClauses.Add("PartPlant","Plant = '" & MyPlant &
> "'") ' This runs 5 minutes and times out.
>
> What am I missing?
>
> Thanks,
> Ross
>
>
>


[Non-text portions of this message have been removed]



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

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/.
(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
I have used GetRows quite a bit filtering on the primary part table and in many other different tables. This works fine. What I would like to do is to filter on one of the related tables with Part.GetRows (partplant in this case). Does anybody have a working example of this?

When I try the BL Tester using whereClausePart (e.g., PartNum = "MyPartNum") it works perfectly.

If I try using only the whereClausePartPlant (e.g., Plant = "MyPlant") it will run for 5 minutes and error out.

When I apply the same logic with following, I get the same results:

opts.NamedSearch.WhereClauses.Add("Part","PartNum = '" & MyPartNum & "'") ' This works fine

opts.NamedSearch.WhereClauses.Add("PartPlant","Plant = '" & MyPlant & "'") ' This runs 5 minutes and times out.

What am I missing?

Thanks,
Ross
If 'plant' is the only criterea you're using you're going to pull every
single part for that plant. I don't know about you, but for us that would be
a massive dataset. It may be that you're just trying to pull too much data
and it's taking too long.



On Mon, Mar 28, 2011 at 10:59 AM, rossh777 <ross.hughes3@...> wrote:

>
>
> I have used GetRows quite a bit filtering on the primary part table and in
> many other different tables. This works fine. What I would like to do is to
> filter on one of the related tables with Part.GetRows (partplant in this
> case). Does anybody have a working example of this?
>
> When I try the BL Tester using whereClausePart (e.g., PartNum =
> "MyPartNum") it works perfectly.
>
> If I try using only the whereClausePartPlant (e.g., Plant = "MyPlant") it
> will run for 5 minutes and error out.
>
> When I apply the same logic with following, I get the same results:
>
> opts.NamedSearch.WhereClauses.Add("Part","PartNum = '" & MyPartNum & "'") '
> This works fine
>
> opts.NamedSearch.WhereClauses.Add("PartPlant","Plant = '" & MyPlant & "'")
> ' This runs 5 minutes and times out.
>
> What am I missing?
>
> Thanks,
> Ross
>
>
>


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

I wondered about that, too. The plant has <20K parts. When I use the PartPlantSearchAdapter it returns all 20K parts in 5-10 seconds. I am not sure if I should expect the same performance/behavior from the PartAdapter.

Also, I would like to subfilter on three of four whereClauses but I can't seem to get it to response beyond the root table.

I have tried to filter the partwhse table with warehousecode = "mycode" and it errors out there too. This should only return 1000 parts.

Ross

--- In vantage@yahoogroups.com, Waffqle <waffqle@...> wrote:
>
> If 'plant' is the only criterea you're using you're going to pull every
> single part for that plant. I don't know about you, but for us that would be
> a massive dataset. It may be that you're just trying to pull too much data
> and it's taking too long.
>
>
>
> On Mon, Mar 28, 2011 at 10:59 AM, rossh777 <ross.hughes3@...> wrote:
>
> >
> >
> > I have used GetRows quite a bit filtering on the primary part table and in
> > many other different tables. This works fine. What I would like to do is to
> > filter on one of the related tables with Part.GetRows (partplant in this
> > case). Does anybody have a working example of this?
> >
> > When I try the BL Tester using whereClausePart (e.g., PartNum =
> > "MyPartNum") it works perfectly.
> >
> > If I try using only the whereClausePartPlant (e.g., Plant = "MyPlant") it
> > will run for 5 minutes and error out.
> >
> > When I apply the same logic with following, I get the same results:
> >
> > opts.NamedSearch.WhereClauses.Add("Part","PartNum = '" & MyPartNum & "'") '
> > This works fine
> >
> > opts.NamedSearch.WhereClauses.Add("PartPlant","Plant = '" & MyPlant & "'")
> > ' This runs 5 minutes and times out.
> >
> > What am I missing?
> >
> > Thanks,
> > Ross
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
The part adapter will likely be a great deal slower as the part dataset is
much larger than the partplant dataset.

Unfortunately I don't have any advice on the issue with multiple where
clauses. You may want to try preceeding the field names with the table name.
(i.e. partwhse.whsecode) .Progress will usually give you an 'ambiguous
reference' error if that's the issue. However, depending on where you're
putting that code, the error may not be making it all the way to you.

On Mon, Mar 28, 2011 at 12:00 PM, rossh777 <ross.hughes3@...> wrote:

>
>
>
>
> Thanks for the response.
>
> I wondered about that, too. The plant has <20K parts. When I use the
> PartPlantSearchAdapter it returns all 20K parts in 5-10 seconds. I am not
> sure if I should expect the same performance/behavior from the PartAdapter.
>
> Also, I would like to subfilter on three of four whereClauses but I can't
> seem to get it to response beyond the root table.
>
> I have tried to filter the partwhse table with warehousecode = "mycode" and
> it errors out there too. This should only return 1000 parts.
>
> Ross
>
>
> --- In vantage@yahoogroups.com, Waffqle <waffqle@...> wrote:
> >
> > If 'plant' is the only criterea you're using you're going to pull every
> > single part for that plant. I don't know about you, but for us that would
> be
> > a massive dataset. It may be that you're just trying to pull too much
> data
> > and it's taking too long.
> >
> >
> >
> > On Mon, Mar 28, 2011 at 10:59 AM, rossh777 <ross.hughes3@...> wrote:
> >
> > >
> > >
> > > I have used GetRows quite a bit filtering on the primary part table and
> in
> > > many other different tables. This works fine. What I would like to do
> is to
> > > filter on one of the related tables with Part.GetRows (partplant in
> this
> > > case). Does anybody have a working example of this?
> > >
> > > When I try the BL Tester using whereClausePart (e.g., PartNum =
> > > "MyPartNum") it works perfectly.
> > >
> > > If I try using only the whereClausePartPlant (e.g., Plant = "MyPlant")
> it
> > > will run for 5 minutes and error out.
> > >
> > > When I apply the same logic with following, I get the same results:
> > >
> > > opts.NamedSearch.WhereClauses.Add("Part","PartNum = '" & MyPartNum &
> "'") '
> > > This works fine
> > >
> > > opts.NamedSearch.WhereClauses.Add("PartPlant","Plant = '" & MyPlant &
> "'")
> > > ' This runs 5 minutes and times out.
> > >
> > > What am I missing?
> > >
> > > Thanks,
> > > Ross
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]