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.
-----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