Filtering with translated content

[bobvandevijver]

Is it possible to filter on translated content?

I am using https://github.com/KnpLabs/DoctrineBehaviors for the translations, and https://github.com/a2lix/TranslationFormBundle to edit the translations fields.

If it is not possible (yet), than I would like to make this a feature request.

[ioleo]

There is no such feature now. Adding this to v1.1.0 ideas.

[cedriclombardot]

I think you can override methods to do that in your controller look the
good method name in the cache

Le lundi 15 juillet 2013, loostro [email protected] a écrit :

There is no such feature now. Adding this to v1.1.0 ideas.

—
Reply to this email directly or view it on GitHub.

[montabou]

I had the same problem and I solve it overwriting this in my ListController :

    protected function processQuery($query)
    {
       return $query
            ->where('translations.locale = :locale')
            ->setParameter('locale', $this->getRequest()->getLocale())
        ;
    }

[ioleo]

@bobvandevijver @montabou If this solution works, could you make a PR to update the Resources/doc/cookbook/a2lixTranslationFormBundle-integration.md docs?

[bobvandevijver]

@loostro @montabou I will try it this weekend!

[montabou]

@bobvandevijver After rereading your problem I'm not sure that it will resolve yours.

Using what I did just filter with current locale so that sort (for example) is performed on translated content and not all translations.

It will not let you filter after that on some fields using the generator.yml as I guess it's not possible until issue #434 is not resolved

[montabou]

After using my solution I've just figured out that it works only if there is a addJoinFor call before (with sorting on translations.something). So it's rubbish, sorry for that :-(

PS: Well it works if you test if you have to leftJoin with translations before...