Looking at this some more, I think you would have to put whatever condition you use in a dashboard or report and not directly in the BAQ. Looking at the way the results are returned, the condition just breaks the link, causing the outer join to return every PartRev record.
--- In vantage@yahoogroups.com, "Kirstin Brandt" <kirstin.brandt@...> wrote:
>
> Try using PartRev.PartNum <> PartOpr.PartNum
>
> --- In vantage@yahoogroups.com, "michael.hutcheson@" <michael.hutcheson@> wrote:
> >
> > forgive me if I'm going to be stupid, but there is no PartOper\Character01. I checked in the data dictionary as well (put the tick in show vb fields as well). We are using 4.03.406
> >
> > --- In vantage@yahoogroups.com, "advantage" <advantage@> wrote:
> > >
> > > PartRev to PartOper left outer join will give you all Parts in the PartRev
> > > table, left outer join, but only give where PartOper.PartNum =
> > > PartOper.Character01
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> > > michael.hutcheson@
> > > Sent: Wednesday, December 09, 2009 8:19 AM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Re: Unmatched BAQ
> > >
> > >
> > >
> > >
> > > Thanks for this - how do you filter for null in a BAQ?
> > >
> > > I didn't know the ECOOpr table was a temp table - I guess everyday is a
> > > school day!
> > >
> > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> > > <epicor@> wrote:
> > > >
> > > > Select a field in ECOOpr and set up a condition that filters for it to be
> > > > null.
> > > > A trick with that is to look for ecoopr.partnum = ecpopr.character01
> > > > (assuming you are not using character01)
> > > >
> > > > Why are you looking in the ECOOpr table versus PartOpr table? The ECOOpr
> > > > table is just a "temp" table when parts are checked out to the engineering
> > > > workbench.
> > > >
> > > > Bruce
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
> > > Behalf Of
> > > > michael.hutcheson@
> > > > Sent: Wednesday, December 09, 2009 5:33 AM
> > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > > Subject: [Vantage] Re: Unmatched BAQ
> > > >
> > > > that will return all rows regardless if one matches or not. I'm after
> > > where
> > > > the Part Number exists in the ECORev table but the same Part Number does
> > > not
> > > > exist in the ECOOpr table.
> > > >
> > > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> > > advantage@ wrote:
> > > > >
> > > > > Left outer join?
> > > > > Sent from my Verizon Wireless BlackBerry
> > > > >
> > > > > -----Original Message-----
> > > > > From: "michael.hutcheson@" <michael.hutcheson@>
> > > > > Date: Wed, 09 Dec 2009 10:34:17
> > > > > To: <vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com>
> > > > > Subject: [Vantage] Unmatched BAQ
> > > > >
> > > > > Hey folks,
> > > > >
> > > > > Using a BAQ, is it possible to perform an unmatched query like in MS
> > > > Access. For example, I want all Parts that have no ops. So its all Parts
> > > > from the ECORev table that have no matching field in the ECOOpr table. How
> > > > do you do this in a BAQ though?
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Michael
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > [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. <http://groups.yahoo.com/group/vantage/files/.>
> > > yahoo.com/group/vantage/files/.
> > > > (2) To search through old msg's goto:
> > > > http://groups. <http://groups.yahoo.com/group/vantage/messages>
> > > yahoo.com/group/vantage/messages
> > > > (3) To view links to Vendors that provide Vantage services goto:
> > > > http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
> > > yahoo.com/group/vantage/linksYahoo! Groups Links
> > > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>