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 PROTECTED]> wrote: > > > 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 > > -- > > 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] > _______________________________________________ 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]
