Undefined property: stdClass::$role.id_role (select -> table.column)

[renmura]

Hi, I read the documentation here about join query. I have two simple table to join with. But there is an error says that Undefined property: stdClass::$role.id_role Somehow the library recognize the table name as the column name, including the period symbol. In the documentation says that the offices.officeCode is fine.

Here is my code :

User table structure : id_user* id_role** name

Role table structure : id_role* role_name

Controller : $builder = $db->table('user') ->select('name, role.id_role, role.role_name') ->join('role', 'role.id_role = user.id_role');

return DataTable::of($builder) ->addNumbering() ->toJson(true);

Error : ErrorException Undefined property: stdClass::$role.id_role VENDORPATH/hermawan/codeigniter4-datatables/src/DataTableQuery.php at line 101

[hermawanramadhan]

can you show your javascript code?

what php and codeigniter version do you use?

[renmura]

can you show your javascript code?

what php and codeigniter version do you use?

I'm using php 8.0 and codeigniter 4.1.3 here is my javascript :

$('#table').DataTable({ processing: true, serverSide: true, ajax:{ url: 'user/datatable', method: 'POST' }, columnDefs: [ { targets: 0, orderable: false}, //first column is not orderable. ], sDom: "<'row'<'col-md-4'l><'col-md-4'B><'col-md-4'f>r>t<'row'<'col-md-6'i><'col-md-6'p>>", buttons: [ 'copy', { extend: 'excel', orientation: 'landscape', pageSize: 'A4', }, { extend: 'pdf', orientation: 'landscape', pageSize: 'A4', }, { extend: 'print', orientation: 'landscape', pageSize: 'A4', } ] });

[hermawanramadhan]

try define your datatable option with columns like example. also if using numbering also set parameter addNumbering('number');

in your case maybe like this

columns: [
    {data: 'number'},
    {data: 'id_role'},
    {data: 'role_name'},
]

[renmura]

try define your datatable option with columns like example. also if using numbering also set parameter addNumbering('number');

in your case maybe like this

columns: [
    {data: 'number'},
    {data: 'id_role'},
    {data: 'role_name'},
]

Great, it works.. I think the error from before is come from the backend side not in the frontend side.. Thank you very much