Re: Fetching Relation Empty
Re: Fetching Relation Empty
- Subject: Re: Fetching Relation Empty
- From: "Daniele Corti" <email@hidden>
- Date: Fri, 21 Sep 2007 11:12:00 +0200
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:
email@hidden
>
--
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@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