first table : agency
id
user_id
service_id
...
...
second table: users
id
username
...
...
third table: user_profile
id
user_id
firstname
lastname
...
...
part of code
$this->grocery_crud->set_table('agency'); //working search & sort in this column $this->grocery_crud->set_primary_key('user_id','user_profile'); $this->grocery_crud->set_relation('user_id', 'user_profile', '{firstname} {lastname}'); $this->grocery_crud->display_as('user_id', 'User'); //dont working search & sort in this column $this->grocery_crud->callback_column('user_name', [$this, '_callback_agencies_team_user_name_column']); public function _callback_agencies_team_user_name_column($value, $row) { $this->load->model('dx_auth/users'); $user = $this->users->get_user_by_id($row->user_id)->row_array(); return $user['username']; }
How way I use two set_relation for one filed, for working sort & search
$this->grocery_crud->set_relation('user_id', 'user_profile', '{firstname} {lastname}');
$this->grocery_crud->set_relation('user_id', 'users', 'username');
Help me please, Thanks.