Hi, I am trying to edit join table column, but is unsuccessful with error Unknown column 'phone' in 'field list'.
Table A (a_id, name, email, role)
Table B (b_id, a_id, phone)
Table A is used as main table and Table B is joined to Table A.
Below is the codes:
$tableColumns['phone'] = array(
'display_text' => 'Phone',
'perms' => 'EVTQSF',
'display_mask' => 'b.phone',
'input_info' => 'size="20"',
'col_header_info' => 'width="15%"',
);
$tableName = 'table_a';
$primaryCol = 'a_id';
$errorFun = array(&$this,'logError');
$permissions = 'EUFIM';
....
$this->Editor->setConfig('editInPlace',true);
$this->Editor->setConfig('extraOrderByInfo','name asc');
$this->Editor->setConfig('customJoin',"left join b as b on a.a_id = b.b_id");
$this->Editor->setConfig('sqlFilters',"role = '5' OR role = '6'");
The table column view is fine but when update the row. There is error : Unknown column 'phone' in 'field list'
Is there any way to edit the value of the columns of the joined table? I want the phone column to be editable.