OK, I'm sorry, but what do you mean by "the prefix needs to be defined"? Is this something that will be available in the next release?
thanks, Bonnie MacKellar > -----Original Message----- > From: Jakob Braeuchi [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 01, 2003 5:11 PM > To: OJB Users List > Subject: Re: not exists criteria - does it work? > > > hi bonnie, > > this is possible but not yet documented because the prefix > needs to be > defined. > see QueryTest#testSubQuery4 > > public void testSubQuery4() > { > > ReportQueryByCriteria subQuery; > Criteria subCrit = new Criteria(); > Criteria crit = new Criteria(); > > > subCrit.addEqualToField("productGroupId",Criteria.PARENT_QUERY > _PREFIX + > "groupId"); > subQuery = QueryFactory.newReportQuery(Article.class, > subCrit); > subQuery.setColumns(new String[]{"count(productGroupId)"}); > > crit.addGreaterThan(subQuery,"10"); // MORE than > 10 articles > crit.addLessThan("groupId",new Integer(987654)); > Query q = QueryFactory.newQuery(ProductGroup.class, crit); > > Collection results = broker.getCollectionByQuery(q); > assertNotNull(results); > assertTrue(results.size() == 4); > } > > hth > jakob > > > Bonnie MacKellar wrote: > > >Is it true that you can't link the subquery in a not exists clause > >(Criteria.addNotExists) > >to the results in the outer query? What would be the point > of using a not > >exists clause > >if you can't do that? > > > >I have a table SuggestedPayments, which participates in a M to N > >relationship > >called CompletedBy, with a table called PaymentTxn. > > > >I need to retrieve all SuggestedPayments that have no > payment transactions > >with a paid status. > > > >The only way I can think to do this is with a not exists > clause, retrieving > >the payment transactions for a suggested payment in the subquery. > >But then I need to link the subquery. > > > >Is there another way? > > > >thanks, > >Bonnie MacKellar > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] >
