{"action":"closed","issue":{"url":"https://api.github.com/repos/yiisoft/yii2/issues/8985","labels_url":"https://api.github.com/repos/yiisoft/yii2/issues/8985/labels{/name}","comments_url":"https://api.github.com/repos/yiisoft/yii2/issues/8985/comments","events_url":"https://api.github.com/repos/yiisoft/yii2/issues/8985/events","html_url":"https://github.com/yiisoft/yii2/issues/8985","id":92655863,"number":8985,"title":"Gridview return 1 row but sql return 3","user":{"login":"rfiedler","id":1020057,"avatar_url":"https://avatars.githubusercontent.com/u/1020057?v=3","gravatar_id":"","url":"https://api.github.com/users/rfiedler","html_url":"https://github.com/rfiedler","followers_url":"https://api.github.com/users/rfiedler/followers","following_url":"https://api.github.com/users/rfiedler/following{/other_user}","gists_url":"https://api.github.com/users/rfiedler/gists{/gist_id}","starred_url":"https://api.github.com/users/rfiedler/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rfiedler/subscriptions","organizations_url":"https://api.github.com/users/rfiedler/orgs","repos_url":"https://api.github.com/users/rfiedler/repos","events_url":"https://api.github.com/users/rfiedler/events{/privacy}","received_events_url":"https://api.github.com/users/rfiedler/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/yiisoft/yii2/labels/status:to%20be%20verified","name":"status:to be verified","color":"fbca04"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-07-02T14:46:43Z","updated_at":"2015-07-03T12:56:25Z","closed_at":"2015-07-03T12:56:25Z","body":"Hi !\r\n\r\n 1 -My search in **gridview** return **1** row. **(Its the problem)**\r\n 2- **$dataprovider->totalCount**  return **3** results.\r\n 3- SQL in PGAdmin3 return **3** rows too.\r\n\r\n**What happens ?**\r\n\r\n**Problem**\r\n![search 1 result](https://cloud.githubusercontent.com/assets/1020057/8479656/8e4ae850-20af-11e5-8c3e-dc0291b40066.gif)\r\n\r\n** Pure SQL in PGAdmin3**\r\n![sql](https://cloud.githubusercontent.com/assets/1020057/8479697/bfce6af0-20af-11e5-8420-1ba6ce91bcf7.gif)\r\n\r\n** Controller Code**\r\n![controller](https://cloud.githubusercontent.com/assets/1020057/8479703/c95f4ae4-20af-11e5-830c-9e9ebe3e7cc5.gif)\r\n\r\n**Search Code**\r\n![pacientesearch](https://cloud.githubusercontent.com/assets/1020057/8479707/d08c3e8a-20af-11e5-8299-83fc0960dc71.gif)\r\n\r\n\r\n\r\n\r\nHelp please!\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n\r\n"}}