2007/9/20, Oliver Egger <[EMAIL PROTECTED]>:
>
> 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 PROTECTED]> 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 PROTECTED]
> >
> > --
> > 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 protected])
> > Help/Unsubscribe/Update your Subscription:
> >
> http://lists.apple.com/mailman/options/webobjects-dev/oliver.egger%40gmail.com
> >
> > This email sent to [EMAIL PROTECTED]
> >
>
>
> --
> oliver egger
>
> neu seit 17.9.2007: bertastrasse 4, 8003 zürich
> http://www.egger-loser.ch
> mobile +41765795005
>
--
Daniele Corti
AIM: S0CR4TE5
Messenger: [EMAIL PROTECTED]
--
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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
