Issue on filtering search on es_xx

After updating from 3.8 to 4.2, and installing es_PE as language, filters stop working on values set from xml install like Currencies.

Example

Searching for USD on

- es => 'Dólar' => works
- es_PE => 'Dólar' => no results

Looks like an issue on parent translations

added trytond type::behavior + 1 deleted label

Since changeset049635454a98 because the translatable fields query [1] does not take in account the parent languages.

[1] http://hg.tryton.org/trytond/file/0c1fbcaaf301/trytond/model/fields/field.py#l367

added 1 deleted label and removed 1 deleted label

The issue is that rev 049635454a98 did not update the _get_translation_join [1]. It should create a join for all parent languages and take the one with value and having the longer language code.


[1] http://hg.tryton.org/trytond/file/default/trytond/model/fields/field.py#l367

assigned to @csotelo

assigned to @ced and unassigned @csotelo

added 1 deleted label and removed 1 deleted label

Here is review39971002

added 1 deleted label and removed 1 deleted label

I think the patch should be back-ported even if it changes the API of the method _get_translation_join. It is a private method and without this change it is not possible to really use the derivative feature of languages.

review39971002 updated at https://codereview.tryton.org/39971002/#ps1

New changeset 71f03e973642 by Cédric Krier in branch 'default':
Allow to search and order translated fields using the derivative translations
http://hg.tryton.org/trytond/rev/71f03e973642

added 1 deleted label and removed 1 deleted label

closed

New changeset 881ad200af26 by Cédric Krier in branch '4.6':
Allow to search and order translated fields using the derivative translations
http://hg.tryton.org/trytond/rev/881ad200af26

New changeset a7de704b19f2 by Cédric Krier in branch '4.4':
Allow to search and order translated fields using the derivative translations
http://hg.tryton.org/trytond/rev/a7de704b19f2

New changeset 84699a782320 by Cédric Krier in branch '4.2':
Allow to search and order translated fields using the derivative translations
http://hg.tryton.org/trytond/rev/84699a782320

New changeset bc6af20a1863 by Cédric Krier in branch '4.6':
Fix import of #6934 (closed) backport
http://hg.tryton.org/trytond/rev/bc6af20a1863

New changeset 7c8a735180b9 by Cédric Krier in branch '4.4':
Fix import of #6934 (closed) backport
http://hg.tryton.org/trytond/rev/7c8a735180b9

New changeset ff8cf599c78f by Cédric Krier in branch '4.2':
Fix import of #6934 (closed) backport
http://hg.tryton.org/trytond/rev/ff8cf599c78f