Le 03/02/2016 09:57, Yannick Martel a écrit :
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]
Can you provide the piece of code that produced this query? -- Brendan Le Ny, Code Lutin bleny@codelutin.com (+33) 02 40 50 29 28