Hi guys !
I've found a problem with pagination in Topia, when I use
AbstractTopiaDao#findPage with a request containing join statement.
During the "count" operation, this uses "topiaid" to count, but this is
ambigous when request contains several tables.
This is an exemple of generated request failing :
select count(topiaId) FROM
fr.ifremer.coselmar.persistence.entity.Question Q INNER JOIN
Q.participants CUG WHERE ( ( Q.privacy = :privacy0 ) OR ( Q.privacy
= :privacy1 AND :members0 in elements( CUG.members ) AND :clients0 in
elements( Q.clients )) ) AND ( 1=1 AND Q.status != :status0) */ select
count(topiaId) as col_0_0_ from question questionim0_ inner join
coselmarUserGroup coselmarus1_ on
questionim0_.participants=coselmarus1_.topiaId where
(questionim0_.privacy=? or questionim0_.privacy=? and (? in (select
members2_.members from coselmarusergroup_members members2_ where
coselmarus1_.topiaId=members2_.coselmarUserGroup)) and (? in (select
clients3_.clients from clients_question clients3_ where
questionim0_.topiaId=clients3_.question))) and 1=1 and
questionim0_.status<>? limit ? [90059-190]
Best regards
--
Yannick Martel
Code Lutin <http://www.codelutin.com/>
+33 2 40 50 29 28
