Outer Join BAQ - Return only unmatched rows

Yahoo Archive
1
Nice and easy trick I'm sure I can make use of! I tried it with a count on Number01, it returns a count of 0 for all items that don't match. Hope it works for Kevin!

Sue

--- In vantage@yahoogroups.com, "Kirstin Brandt" <kirstin.brandt@...> wrote:
>
> Can you add the table as an outer join summary table and create a count field on your BAQ. Then filter out anything where the count is >0 (or not null or whatever the data ends up looking like) in your grid?
>
> --- In vantage@yahoogroups.com, "simstrak" <simstrak@> wrote:
> >
> > I've got a BAQ where one of the tables is an outer join. I want to return only those rows that DONT match (hence the outer join). Can I do this in the BAQ.
> >
> > Alternatively, I'm using this BAQ in a form using the dynamic query adapter. When I assign the results of that BAQ to my grid datasource, can I somehow clear out values at this point?
> >
> > The end product, I've got a grid showing Sales Order information, and I want it to only show the rows that are not allocated. I'm linking PartAlloc to OrderRel.
> >
> > Thanks.
> >
> > Kevin Simon
> > SimsTrak Consulting
> >
>
2
I've got a BAQ where one of the tables is an outer join. I want to return only those rows that DONT match (hence the outer join). Can I do this in the BAQ.

Alternatively, I'm using this BAQ in a form using the dynamic query adapter. When I assign the results of that BAQ to my grid datasource, can I somehow clear out values at this point?

The end product, I've got a grid showing Sales Order information, and I want it to only show the rows that are not allocated. I'm linking PartAlloc to OrderRel.

Thanks.

Kevin Simon
SimsTrak Consulting
3
Sorry, I was thinking abut something else.
As far as I no, you can't do this in a BAQ

--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> >return only those rows that DONT match
>
> Criteria on the table with the open join has worked for me sometimes
>
> Field Name ISNULL
>
> --- In vantage@yahoogroups.com, "simstrak" <simstrak@> wrote:
> >
> > I've got a BAQ where one of the tables is an outer join. I want to return only those rows that DONT match (hence the outer join). Can I do this in the BAQ.
> >
> > Alternatively, I'm using this BAQ in a form using the dynamic query adapter. When I assign the results of that BAQ to my grid datasource, can I somehow clear out values at this point?
> >
> > The end product, I've got a grid showing Sales Order information, and I want it to only show the rows that are not allocated. I'm linking PartAlloc to OrderRel.
> >
> > Thanks.
> >
> > Kevin Simon
> > SimsTrak Consulting
> >
>
4
Can you add the table as an outer join summary table and create a count field on your BAQ. Then filter out anything where the count is >0 (or not null or whatever the data ends up looking like) in your grid?

--- In vantage@yahoogroups.com, "simstrak" <simstrak@...> wrote:
>
> I've got a BAQ where one of the tables is an outer join. I want to return only those rows that DONT match (hence the outer join). Can I do this in the BAQ.
>
> Alternatively, I'm using this BAQ in a form using the dynamic query adapter. When I assign the results of that BAQ to my grid datasource, can I somehow clear out values at this point?
>
> The end product, I've got a grid showing Sales Order information, and I want it to only show the rows that are not allocated. I'm linking PartAlloc to OrderRel.
>
> Thanks.
>
> Kevin Simon
> SimsTrak Consulting
>