ExistsInRelationshipQualifier

2007-12-04 Thread David Holt
"favourites". public EOFetchSpecification getPubliclyDisplayed() { EOQualifier q1 = new EOKeyValueQualifier( "userName", EOQualifier.QualifierOperatorEqual, applicationUser.userName()); ExistsInRelationshipQualifier q2 = new ExistsInRelationshipQualifier (&q

Re: ExistsInRelationshipQualifier

2007-12-04 Thread Chuck Hill
r q1 = new EOKeyValueQualifier( "userName", EOQualifier.QualifierOperatorEqual, applicationUser.userName()); ExistsInRelationshipQualifier q2 = new ExistsInRelationshipQualifier("applicationUsers", q1); // the inverse EONotQualifier

Re: ExistsInRelationshipQualifier

2007-12-05 Thread Pierre Bernard
Artifacts that have not been specified as "favourites". public EOFetchSpecification getPubliclyDisplayed() { EOQualifier q1 = new EOKeyValueQualifier( "userName", EOQualifier.QualifierOperatorEqual, applicationUser.userName()); ExistsInRelationsh

Re: ExistsInRelationshipQualifier

2007-12-05 Thread David Holt
hat have not been specified as "favourites". public EOFetchSpecification getPubliclyDisplayed() { EOQualifier q1 = new EOKeyValueQualifier( "userName", EOQualifier.QualifierOperatorEqual, applicationUser.userName()); ExistsInRelationshipQualifier q2 = new Ex

Re: ExistsInRelationshipQualifier

2007-12-05 Thread Pierre Bernard
alifier.QualifierOperatorEqual, applicationUser.userName()); ExistsInRelationshipQualifier q2 = new ExistsInRelationshipQualifier("applicationUsers", q1); // the inverse EONotQualifier notq2 = new EONotQualifier(q2); // EOQualifier q3 = new EOAndQua

Re: ExistsInRelationshipQualifier

2007-12-05 Thread Pierre Bernard
n); mutableArray.addObject(keyValueQualifier); keyValueQualifier = new EOKeyValueQualifier( "isvalid", EOQualifier.QualifierOperatorEqual, new Integer(1)); ExistsInRelationshipQualifier existsInRelationshipQualifier = new ExistsInRelationshipQualifier("li

Re: ExistsInRelationshipQualifier

2007-12-05 Thread Chuck Hill
show all Artifacts that have not been specified as >> "favourites". >> >> >> >> public EOFetchSpecification getPubliclyDisplayed() { >> >> EOQualifier q1 = new EOKeyValueQualifier( "userName", >> EOQualifier.Qualifier

Re: ExistsInRelationshipQualifier

2007-12-05 Thread Pierre Bernard
gt;> public EOFetchSpecification getPubliclyDisplayed() { >> >> EOQualifier q1 = new EOKeyValueQualifier( "userName", >> EOQualifier.QualifierOperatorEqual, applicationUser.userName()); >> ExistsInRelationshipQualifier q2 = new >> ExistsInRelationship

Re: ExistsInRelationshipQualifier

2007-12-05 Thread Daniele Corti
gt;> > >> > >> > >> public EOFetchSpecification getPubliclyDisplayed() { > >> > >> EOQualifier q1 = new EOKeyValueQualifier( "userName", > >> EOQualifier.QualifierOperatorEqual, applicationUser.userName()); >

Re: ExistsInRelationshipQualifier

2007-12-05 Thread Pierre Bernard
have done wrong? I am trying to show all Artifacts that have not been specified as "favourites". public EOFetchSpecification getPubliclyDisplayed() { EOQualifier q1 = new EOKeyValueQualifier( "userName", EOQualifier.QualifierOperatorEqual, applicationUser.userName()

Re: ExistsInRelationshipQualifier

2007-12-05 Thread Pierre Bernard
) at com.webobjects.foundation.NSKeyValueCoding $DefaultImplementation.takeValueForKey(NSKeyValueCoding.java:1293) at com.webobjects.foundation.NSKeyValueCoding $Utility.takeValueForKey(NSKeyValueCoding.java:521) at com .houdah .eocontrol .qualifiers .ExistsInRelationshipQualifier .

Re: ExistsInRelationshipQualifier

2008-05-19 Thread James Cicenia
s". public EOFetchSpecification getPubliclyDisplayed() { EOQualifier q1 = new EOKeyValueQualifier( "userName", EOQualifier.QualifierOperatorEqual, applicationUser.userName()); ExistsInRelationshipQualifier q2 = new ExistsInRelationshipQualifier("applicationUsers", q1);

Re: ExistsInRelationshipQualifier

2008-05-19 Thread Chuck Hill
ification getPubliclyDisplayed() { EOQualifier q1 = new EOKeyValueQualifier( "userName", EOQualifier.QualifierOperatorEqual, applicationUser.userName()); ExistsInRelationshipQualifier q2 = new ExistsInRelationshipQualifier("applicationUsers", q1); // the inverse EONotQua

Re: ExistsInRelationshipQualifier

2008-05-19 Thread James Cicenia
OK - My code is the same so no changes were made. My usage: byPortfolioQualifier = new EOAndQualifier(new NSArray(new Object[] {byPortfolioQualifier, hasDocumentsQualifier()})); public EOQualifier hasDocumentsQualifier(){ ExistsInRelationshipQualifier qual = new

Re: ExistsInRelationshipQualifier

2008-05-19 Thread Chuck Hill
, hasDocumentsQualifier()})); public EOQualifier hasDocumentsQualifier(){ ExistsInRelationshipQualifier qual = new ExistsInRelationshipQualifier("documents",null); EONotQualifier not = new EONotQualifier(qual); return not; } HTH -j- On May 19, 2008, at 6:19

Re: ExistsInRelationshipQualifier

2008-05-19 Thread James Cicenia
ifier()})); public EOQualifier hasDocumentsQualifier(){ ExistsInRelationshipQualifier qual = new ExistsInRelationshipQualifier("documents",null); EONotQualifier not = new EONotQualifier(qual); return not; } HTH -j- On May 19, 2008, at 6:19 PM, Chuck Hill wrot

Re: ExistsInRelationshipQualifier

2008-05-19 Thread Chuck Hill
. My usage: byPortfolioQualifier = new EOAndQualifier(new NSArray(new Object[] {byPortfolioQualifier, hasDocumentsQualifier()})); public EOQualifier hasDocumentsQualifier(){ ExistsInRelationshipQualifier qual = new ExistsInRelationshipQualifier("documents",null); EONotQual

Re: ExistsInRelationshipQualifier

2008-05-19 Thread James Cicenia
= new EOAndQualifier(new NSArray(new Object[] {byPortfolioQualifier, hasDocumentsQualifier()})); public EOQualifier hasDocumentsQualifier(){ ExistsInRelationshipQualifier qual = new ExistsInRelationshipQualifier("documents",null); EONotQualifier not = new EONotQualifier(qual);

Re: ExistsInRelationshipQualifier

2008-05-19 Thread Chuck Hill
On May 19, 2008, at 7:38 PM, James Cicenia wrote: hmmm here is the result of my sql: WHERE (not ( EXISTS (SELECT 1 FROM project_document A0 WHERE null AND t0.row_id = A0.project_id)) that where null is interesting. Well, that IS what you asked for: ExistsInRelationshipQualifier qual

Re: ExistsInRelationshipQualifier

2008-05-19 Thread James Cicenia
)) that where null is interesting. Well, that IS what you asked for: ExistsInRelationshipQualifier qual = new ExistsInRelationshipQualifier("documents",null); The usual way to use this would be something like: ExistsInRelationshipQualifier qual = new ExistsInRelationshipQualifier(

Re: ExistsInRelationshipQualifier

2008-05-20 Thread James Cicenia
need ExistsInRelationshipQualifier in this situation. new EOKeyValueQualiier(DOCUMENTS, EOQualifier.EOQualifierEqualsOperator, NSKeyValueCoding.NULL) Should do the trick. Best, Pierre Bernard Houdah Software s.à r.l. On 20 May 2008, at 01:38, James Cicenia wrote: OK - My code is the same so no changes were