I just started exploring grocery crud. I want list the values from multiple tables linked. As per their guide/tutorials I tried to figure out the solution, but couldn;t able to find solution. Expected query and solution is on this link http://sqlfiddle.com/#!9/0c5faf/3
$crud = $this->generate_crud('admin_users_groups');
$crud->where('group_id','3');
$crud->columns('user_id','DistID');
$crud->display_as('user_id','user');
$crud->set_relation('id', 'dist_info', 'ref_idkey');
//$crud->set_relation_n_n('groups', 'users_groups','groups','user_id','group_id','description');
//$crud->set_relation('user_id', 'admin_users', '{username} - {first_name}{last_name}');
//$crud->set_relation_n_n('DistID', 'admin_users','dist_info','id','id','ref_idkey');
//$crud->set_relation('user_id', 'admin_users', 'email');
//$crud->set_relation_n_n('id', 'admin_users_groups', 'admin_users', 'id','dist_id', 'name');
//$crud->set_relation_n_n('groups1', 'admin_users_groups', 'admin_groups','user_id', 'group_id', 'name');`
Can any one help me to reach to desired solution?