Re: Fetching Relation Empty
Re: Fetching Relation Empty
- Subject: Re: Fetching Relation Empty
- From: "Oliver Egger" <email@hidden>
- Date: Fri, 21 Sep 2007 13:06:36 +0200
hi
check out the message:
http://lists.apple.com/archives/webobjects-dev/2004/Nov/msg00158.html
i suspect this is still the same problem/bug ...
cheers
oliver
On 9/21/07, Daniele Corti <email@hidden> wrote:
>
>
> 2007/9/20, Oliver Egger <email@hidden>:
> > hi
> >
> > did you try to specify the relationship as an left outer join?
> > otherwise it will not
> > be working (the join will not return any results). not all database
> > plugins however
> > support left outer join as far as i know ...
>
> I tried but It doen't work good!
>
> let me give the example:
>
> I have two Objects GWSLicense and GWSStock with the relations
>
> stock>
> GWSLicense <<--------> GWSStock
> <licenses
>
> I want the stocks that doesn't have any license associaed or that all the
> licenses associaed are invalid (GWSLicense.isValid = 0)
>
> I try to ut two Key value qualifier:
>
> keyvaluequalifier = new EOKeyValueQualifier("licenses",
> EOQualifier.QualifierOperatorEqual,
> EOEnterpriseObject.NullValue);
>
> keyvaluequalifier = new EOKeyValueQualifier("licenses.isvalid",
> EOQualifier.QualifierOperatorNotEqual, new Integer(1));
>
> in a EOOrQualifier
>
> I get this:
>
> SELECT t0."idConfiguration", t0."idStock", t0."serialNumber" FROM
> "_SYSTEM"."GWS_STOCK" t0, "_SYSTEM"."GWS_LICENSE" T1 WHERE ((t0."idStock" is
> NULL OR T1."isValid" <> 1) AND t0."idConfiguration" = 6) AND t0."idStock" *=
> T1."idStock"
>
> of course this is absurd because t0.idStock is the primary key of GWS_STOCK
>
> I don't know if this is possible, also because I don't know how the SQL
> query should be...
>
>
> > cheers
> > oliver
> >
> >
> >
> > On 9/20/07, Daniele Corti <email@hidden> wrote:
> > > Hi all,
> > > I was looking for a way to fetch an object that have empty relations
> > > using EOQualifiers
> > >
> > >
> > > I used this qualifier:
> > >
> > > keyValueQualifier = new
> EOKeyValueQualifier("activations",
> > > EOQualifier.QualifierOperatorEqual ,
> > > EOEnterpriseObject.NullValue );
> > >
> > > but it doesn't seem to work. activations is a toMany relation of the
> fetched
> > > object
> > >
> > > --
> > > Daniele Corti
> > > AIM: S0CR4TE5
> > > Messenger: email@hidden
> > >
> > > --
> > > Computers are like air conditioners -- they stop working properly if you
> > > open
> > > WINDOWS
> > >
> > > --
> > > What about the four lusers of the apocalypse? I nominate:
> > > "advertising", "can't log in", "power switch" and "what backup?"
> > > --Alistair Young
> > > _______________________________________________
> > > Do not post admin requests to the list. They will be ignored.
> > > Webobjects-dev mailing list (email@hidden)
> > > Help/Unsubscribe/Update your Subscription:
> > >
> > >
> > > This email sent to email@hidden
> > >
> >
> >
> > --
> > oliver egger
>
> --
>
> Daniele Corti
> AIM: S0CR4TE5
> Messenger: email@hidden
>
> --
> Computers are like air conditioners -- they stop working properly if you
> open
> WINDOWS
>
> --
> What about the four lusers of the apocalypse? I nominate:
> "advertising", "can't log in", "power switch" and "what backup?"
> --Alistair Young
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden