Cant get same columns nae from 2 tables

[mflash123]

$crud->set_table('ci_company');
$crud->columns('name');
$crud->set_relation('tarif_id','ci_tarif','name');

I have same name column "Name" in 2 tables: ci_company and ci_tarif. Example show me only name from ci_company. How can I get name from ci_tarif?

[bvrignaud]

Can you try this :

$crud->columns('ci_company.name');

I don't remember if this works.

You may find more help here : https://www.grocerycrud.com/forums/

[mflash123]

No, it doesnt work.

$crud->set_table('ci_company');
$crud->columns('ci_company.name','ci_tarif.name');
$crud->set_relation('tarif_id','ci_tarif','name');

There is sql query:

SELECT `ci_company`.*, j632c92be.name AS s632c92be, `ci_company`.name AS 'ci_company.name'
FROM `ci_company`
LEFT JOIN `ci_tarif` as `j632c92be` ON `j632c92be`.`id` = `ci_company`.`tarif_id`
 LIMIT 10 

As you can see, he doesnt take NAME column from select from ci_tarif table.

Can you try this :

$crud->columns('ci_company.name');

I don't remember if this works.

You may find more help here : https://www.grocerycrud.com/forums/

[portapipe]

Mmmm... I’ve added the join() function in my branch (It has more stuff but not as beautiful as Scombourdis ;) )
Try it and it will add you the power of the join functionality.

[bvrignaud]

I think tat the easiest way is to prefix your fields names in your database.
That's watt I did in each of my project where I use GroceryCRUD.
ex:

TABLE ci_company
 cin_name,
...
TABLE ci_tarif
 cit_name,

[mflash123]

Mmmm... I’ve added the join() function in my branch (It has more stuff but not as beautiful as Scombourdis ;) )
Try it and it will add you the power of the join functionality.

I cloned your branch but same problem still exist

[portapipe]

Did you use the join() function? If have to use the complete name: table.fieldname

Ex.
$crud->join(“client”,”client.id = event.client.id”);
$crud->select(“client.name as ‘client.name’, client.surname as ‘client.surname’, event_name”);

$crud->where(“client.name”,”portapipe”);

Then you’ll have the complete table.fieldname name for each join except for the main table that you have to use with regular name without table name.
I’m using this trick in a working project, and I’ve made a page with this code today.
Enjoy :)

[mflash123]

God damn such unfriendly CRUD..Now it works. But add_fields doesnt show same name fields with exist value.
Thats funny because I decided use CRUD to make smart tickets. And It becames long tickets.

Did you use the join() function? If have to use the complete name: table.fieldname

Ex.
$crud->join(“client”,”client.id = event.client.id”);
$crud->select(“client.name as ‘client.name’, client.surname as ‘client.surname’, event_name”);

Then you’ll have the complete table.fieldname name for each join except for the main table that you have to use with regular name without table name.
I’m using this trick in a working project, and I’ve made a page with this code today.
Enjoy :)

[bvrignaud]

Try this:

$this->crud->display_as('client.name', 'Client');

[mflash123]

Doesnt help, so everyone thanks for solutions. I decided make custom solutions. вт, 16 окт. 2018 г. в 14:50, Benoit VRIGNAUD <[email protected]>:

…

Try this: $this->crud->display_as('client.name', 'Client'); — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#461 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABHydY9osihlPGerLFCWvdCmsiEpViuTks5ulcgRgaJpZM4XbNfn> .