{"action":"closed","issue":{"url":"https://api.github.com/repos/yajra/laravel-datatables-oracle/issues/31","labels_url":"https://api.github.com/repos/yajra/laravel-datatables-oracle/issues/31/labels{/name}","comments_url":"https://api.github.com/repos/yajra/laravel-datatables-oracle/issues/31/comments","events_url":"https://api.github.com/repos/yajra/laravel-datatables-oracle/issues/31/events","html_url":"https://github.com/yajra/laravel-datatables-oracle/issues/31","id":70353170,"number":31,"title":"Search Option not working when I used Join Query.","user":{"login":"infoshahin","id":8981516,"avatar_url":"https://avatars.githubusercontent.com/u/8981516?v=3","gravatar_id":"","url":"https://api.github.com/users/infoshahin","html_url":"https://github.com/infoshahin","followers_url":"https://api.github.com/users/infoshahin/followers","following_url":"https://api.github.com/users/infoshahin/following{/other_user}","gists_url":"https://api.github.com/users/infoshahin/gists{/gist_id}","starred_url":"https://api.github.com/users/infoshahin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/infoshahin/subscriptions","organizations_url":"https://api.github.com/users/infoshahin/orgs","repos_url":"https://api.github.com/users/infoshahin/repos","events_url":"https://api.github.com/users/infoshahin/events{/privacy}","received_events_url":"https://api.github.com/users/infoshahin/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-04-23T09:06:15Z","updated_at":"2015-04-25T02:25:27Z","closed_at":"2015-04-25T02:25:27Z","body":"When I add join query Like that : \r\n\r\n$Employee = Employee::leftJoin('projects','employees.type_id','=','projects.id')\r\n                    ->select(array('employees.name','employees.type','projects.project_name','employees.join_date','employees.comment','employees.id AS eid'));\r\n         return Datatables::of($Employee)\r\n         ->edit_column('eid','\r\n         <a href=\"{{URL::to(\\'/editoffice\\',base64_encode($eid))}}\" class=\"btn btn-primary\"> <i class=\"fa fa-edit\"></i></a>\r\n         <a href=\"{{URL::to(\\'/office/destroy\\',base64_encode($eid))}}\" class=\"btn btn-danger confirm\"> <i class=\"fa fa-remove\"></i></a>\r\n         ')\r\n\t    ->make(true);\r\n\r\n\r\nDatatable work fine as well, But when I press the any key at search box it's showing error!! \r\n\r\nThe error is : \r\n\r\n\"  QueryException in Connection.php line 624:\r\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'eid' in 'where clause' (SQL: select count(*) as aggregate from (select '1' as row_count from `employees` left join `projects` on `employees`.`type_id` = `projects`.`id` where (LOWER(`name`) LIKE %t% or LOWER(`type`) LIKE %t% or LOWER(`project_name`) LIKE %t% or LOWER(`join_date`) LIKE %t% or LOWER(`comment`) LIKE %t% or LOWER(`eid`) LIKE %t%)) count_row_table)   \"\r\n\r\nWhere is my mistake I can't understand it. How can I fix the problem."}}