search

zfdatagrid / grid

A DataGrid library for Zend Framework
BSD 3-Clause "New" or "Revised" License
10 stars 16 forks source link

problems with join tables #855

Closed imonteiro closed 11 years ago

imonteiro commented 11 years ago

Original author: elie...@gmail.com (October 29, 2008 11:31:40)

What steps will reproduce the problem? 1-. Using a join with 2 tables that have the same name of a column: [CODE] $grid->from('provincies prov INNER JOIN paisos pai ON prov.paisos_id_pais = pai.id_pais') ->table(array('prov' => 'provincies', 'pai' => 'paisos' ));

$grid->addColumn ( 'prov.nomes', array ('title' => $this->view->translate->('nom'), 'searchType'=>'like' ) );

$grid->addColumn ( 'pai.nomes', array ('title' => $this->view->translate->('pais'), 'searchType'=>'like' ) );

[/CODE]

What is the expected output? I like to show the name of the country (pai.nom_es) and the name of the province (prov.nom_es)

What do you see instead? I see the name of the country (pai.nom_es) 2 times

What version of the product are you using? The latest svn repository on 29-10-2008

On what operating system? Windows

Original issue: http://code.google.com/p/zfdatagrid/issues/detail?id=10

imonteiro commented 11 years ago

From elie...@gmail.com on October 29, 2008 12:02:37 OK! I solved the problem with:

$grid->addColumn ( 'prov.nomes AS nomprov', array ('title' => $this->view->translate->('nom'), 'searchType'=>'like' ) );

Sorry, i don't knew this issue.

Good work!

Elies

imonteiro commented 11 years ago

From pao.fre...@gmail.com on October 29, 2008 23:54:36 Tanks... :)