Hi,

Good Day to All!

Ive been using the sfDatagrid Plugin, but i came across to use a
custom query not from doctrine classes. So using the parameter
$base_query is a way to go but upon using it i came across this
problem that the columns from the join table is not longer searchable.

Below is the sample db.

User
-------
id
city_id
name

City
--------
id
cityname


$base_query = Doctrine_Query::create()
                       -> select("id,name,v.cityname as cityname")
                          -> from('User u')
                          -> innerJoin('u.City v');

$d->setColumns(array(
                    'id'        => 'ID',
                    'name'      => 'Name',
                    'cityname'  => 'City',
            ));


Hope you can help to resolve the issue, why its not search on join
table column.

Thanks

-- 
If you want to report a vulnerability issue on symfony, please send it to 
security at symfony-project.com

You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en

Reply via email to