Re: In criteria in PersistenceBroker.getCount(query)

Hi Tadeus,

Tadas Garsva wrote:
> Hi,
> 
> It seems to me that inCririteria is ignored  if I use it in query to get 
> number of elements. For example:
> 
> Query q=QueryFactory.newQuery(clazz,criteria,true);
> int n=getBroker().getCount(q);
> 
> where criteria has a inCriteria
> 

Because of failing details how your inCriteria look like I setup a 
complex test with an inCriteria to reproduce your problem.
I use the latest version of OJB from SVN (OJB_1_0_RELEASE branch!).

Class Project and Person use a m:n relation:

Criteria crit_in = new Criteria().addLike("firstname", "tom")
         .addOrCriteria(new Criteria().addLike("firstname", "john"));
Query in_query = QueryFactory.newReportQuery(Person.class, new 
String[]{"id"}, crit_in, true);
Criteria crit = new Criteria().addLike("title", 
name).addIn("persons.id", in_query);
QueryByCriteria q = QueryFactory.newQuery(Project.class, crit);
int count = broker.getCount(q);

The generated sql:

SELECT count(*) FROM PROJECT A0 INNER JOIN PERSON_PROJECT A1 ON 
A0.ID=A1.PROJECT_ID INNER JOIN PERSON A2 ON A1.PERSON_ID=A2.ID WHERE 
(A0.TITLE LIKE '_testCountWithInCriteria_1178384142125_') AND A2.ID IN 
(SELECT DISTINCT B0.ID FROM PERSON B0 WHERE B0.FIRSTNAME LIKE 'tom' OR 
(B0.FIRSTNAME LIKE 'john'))

This works for me! So if possible please try the SVN version.

regards,
Armin

> Best regards,
> 
> Tadeus Garsva
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
> 
>