Wrong Pagination If Using "together" For Relationship

Yii 1.1 General Discussion
1

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…

Thanks,

2

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

Matt

3

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

4

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

5

change the following lines in your config/main.php




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

				

				array(

					'class'=>'CWebLogRoute',

				),
6

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

It also has examples on github. :)