Export Utility help left outer join

Yahoo Archive
1
At 11:24 AM 12/4/2002 -0800, you wrote:
>I think we both need to thank Wayne Cox, because he helped me a couple of
>months ago with this issue. See thread: "Need help with Export Utility".

Glad to help. But it was actually Tim Ligas (or someone??) at Epicor that
originally replied to my inquiry back in 2000-ish :) And it does only work
at >= 4.0. There were a bunch of other enhancements to the Export Util
then, but I'd guess this was something that came with Progress 9.0.

-Wayne
2
I am trying to create an open job export that will show all open jobs. I
want to link to the OrderHead table for those jobs that are linked to Sales
orders. What operator do I use for a left outer join for the OrderHead to
JobProd tables?

for each JobHead Where JobHead.Company = cur-comp
and JobHead.JobComplete = no no-lock,
each JobProd Where JobProd.Company = JobHead.Company
and JobProd.JobNum = JobHead.JobNum no-lock,
each OrderHed Where OrderHed.Company = JobProd.Company
and OrderHed.OrderNum = JobProd.OrderNum no-lock
BY JobHead.JobNum

TIA

Dan Shallbetter
States Electric Mfg.
3
Use "outer-join" before "no-lock".
> and OrderHed.OrderNum = JobProd.OrderNum outer-join no-lock

Mike Tonoyan / All American Products Co.
E-mail: miket@...


----- Original Message -----
From: "Dan Shallbetter" <dans@...>
To: <Vantage@yahoogroups.com>
Sent: Wednesday, December 04, 2002 6:21 AM
Subject: [Vantage] Export Utility help left outer join


> I am trying to create an open job export that will show all open jobs. I
> want to link to the OrderHead table for those jobs that are linked to Sales
> orders. What operator do I use for a left outer join for the OrderHead to
> JobProd tables?
>
> for each JobHead Where JobHead.Company = cur-comp
> and JobHead.JobComplete = no no-lock,
> each JobProd Where JobProd.Company = JobHead.Company
> and JobProd.JobNum = JobHead.JobNum no-lock,
> each OrderHed Where OrderHed.Company = JobProd.Company
> and OrderHed.OrderNum = JobProd.OrderNum no-lock
> BY JobHead.JobNum
>
> TIA
>
> Dan Shallbetter
> States Electric Mfg.
>
>
> 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/links
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
4
At 08:21 AM 12/4/2002 -0600, you wrote:
>What operator do I use for a left outer join for the OrderHead to JobProd
>tables?

Try adding an "outer-join" keyword next to the "no-lock" like:

each OrderHed Where OrderHed.Company = JobProd.Company
and OrderHed.OrderNum = JobProd.OrderNum outer-join no-lock
BY JobHead.JobNum

IIRC, that's only available in Vantage 4.0 and up.


-Wayne Cox
Twenty Three - Information Technology Consulting
828-685-2338
5
Thank you Mike,

I was trying to learn about writing an Open Query statement that the
Progress tutorial said was required in order to use an outer-join. Your
solution works great.

Dan Shallbetter
States Electric Mfg.


-----Original Message-----
From: Mike Tonoyan [mailto:miket@...]
Sent: Wednesday, December 04, 2002 10:19 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Export Utility help left outer join


Use "outer-join" before "no-lock".
> and OrderHed.OrderNum = JobProd.OrderNum outer-join no-lock

Mike Tonoyan / All American Products Co.
E-mail: miket@...


----- Original Message -----
From: "Dan Shallbetter" <dans@...>
To: <Vantage@yahoogroups.com>
Sent: Wednesday, December 04, 2002 6:21 AM
Subject: [Vantage] Export Utility help left outer join


> I am trying to create an open job export that will show all open jobs. I
> want to link to the OrderHead table for those jobs that are linked to
Sales
> orders. What operator do I use for a left outer join for the OrderHead to
> JobProd tables?
>
> for each JobHead Where JobHead.Company = cur-comp
> and JobHead.JobComplete = no no-lock,
> each JobProd Where JobProd.Company = JobHead.Company
> and JobProd.JobNum = JobHead.JobNum no-lock,
> each OrderHed Where OrderHed.Company = JobProd.Company
> and OrderHed.OrderNum = JobProd.OrderNum no-lock
> BY JobHead.JobNum
>
> TIA
>
> Dan Shallbetter
> States Electric Mfg.
>
>




[Non-text portions of this message have been removed]
6
I think we both need to thank Wayne Cox, because he helped me a couple of months ago with this issue. See thread: "Need help with
Export Utility".

Mike Tonoyan / All American Products Co.
E-mail: miket@...

----- Original Message -----
From: "Dan Shallbetter" <dans@...>
To: <vantage@yahoogroups.com>
Sent: Wednesday, December 04, 2002 8:47 AM
Subject: RE: [Vantage] Export Utility help left outer join


> Thank you Mike,
>
> I was trying to learn about writing an Open Query statement that the
> Progress tutorial said was required in order to use an outer-join. Your
> solution works great.
>
> Dan Shallbetter
> States Electric Mfg.
>
>
> -----Original Message-----
> From: Mike Tonoyan [mailto:miket@...]
> Sent: Wednesday, December 04, 2002 10:19 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Export Utility help left outer join
>
>
> Use "outer-join" before "no-lock".
> > and OrderHed.OrderNum = JobProd.OrderNum outer-join no-lock
>
> Mike Tonoyan / All American Products Co.
> E-mail: miket@...
>
>
> ----- Original Message -----
> From: "Dan Shallbetter" <dans@...>
> To: <Vantage@yahoogroups.com>
> Sent: Wednesday, December 04, 2002 6:21 AM
> Subject: [Vantage] Export Utility help left outer join
>
>
> > I am trying to create an open job export that will show all open jobs. I
> > want to link to the OrderHead table for those jobs that are linked to
> Sales
> > orders. What operator do I use for a left outer join for the OrderHead to
> > JobProd tables?
> >
> > for each JobHead Where JobHead.Company = cur-comp
> > and JobHead.JobComplete = no no-lock,
> > each JobProd Where JobProd.Company = JobHead.Company
> > and JobProd.JobNum = JobHead.JobNum no-lock,
> > each OrderHed Where OrderHed.Company = JobProd.Company
> > and OrderHed.OrderNum = JobProd.OrderNum no-lock
> > BY JobHead.JobNum
> >
> > TIA
> >
> > Dan Shallbetter
> > States Electric Mfg.
> >
> >
>
>
>
>
> [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/links
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>