Wrong Pagination If Using "together" For Relationship

Hi Guys - I’m having an issue, I have analyzed it and seems like if we use “relationship” with “together”=true in CDBCriteria than the paging results are not correct. How to correct those as I can’t use lazy loading.

Please suggest something guys…


Is this possibly a SQL join issue? What is the sql query being generated?


Hi Matt - How i can see the Generated SQL query? I’m using CDBCriteria in “CActiveDataProvider”. Please suggest

Use ‘joinType’=>‘INNER JOIN’ in with().

change the following lines in your config/main.php

// uncomment the following to show log messages on web pages






That problem is discussed in the following wiki: Displaying, sorting and filtering HasMany & ManyMany relations in CGridView

It also has examples on github. :)