[Robin Leigio Gulo]

Hi,

 

 

I have problems with $crud->where() and $crud->set_relation(). If i use both of them, it won't work. But it works perfectly if i only using one of them.

 

here is my code:

 

                    $crud->set_table('tbl_user');

                    $crud->columns('user_name','nik','email','contact','description','id_role','status');

                    //$crud->where('status','approved');

                    $crud->unset_read();

                    

                    $crud->fields('user_name','password','nik','email','contact','description','id_role');

                    $crud->set_relation('id_role','tbl_role','role_name');

                    $crud->change_field_type('password', 'password');

                    $crud->callback_before_insert(array($this,'encrypt_password'));

                    

                    $dataContent1['admin_content'] = $crud->render();

 

Anyone can help? why this method conflicts each other?

 

[Robert]

What is the problem i use where and relations with no problems in a loot of functions, i even extended to where_in so i can easy use arrays ...

[Robin Leigio Gulo]

Problem solved.

 

Both tbl_user and tbl_role has field 'approval status' which conflicts. To prevent this, i added tbl_name before field : $crud->where('tbl_user.status','approved');

It works perfectly now. 

 

 

  :D