Hi all,

I have a form (I18N:Item) where I store localized objects. Each entry has "Locale" field, "Categorization_ID" field, "Category_Name" field, ... Extract :

"en_GB", "00001", "Hardware", ...
"fr_FR", "00001", "Matériel", ...
"en_GB", "00002", "Software", ...

Objects must be defined in the "reference" locale before to be defined in another locale.

I want to create a table field to show objects not yet localized. The user will select a locale and the table will display all objects in the "reference" locale which do not exist in the locale selected by the user.

In SQL :
select i1.Categorization_ID
from I18N_Item i1
left outer join I18N_Item i2 on (i1.Categorization_ID = i2.Categorization_ID and i2.Locale = 'de_DE')
where i1.Locale = 'fr_FR' and i1.Category_ID = '00002' and
i2.Categorization_ID is NULL

Here, 'fr_FR' is the "Reference" locale and the user has selected 'de_DE'.

I have not found if I could build this fonctionnality. I can't create a join form where a part of the join criteria is dynamically constructed (i2.Locale = 'de_DE' for example).

Have you an idea ?
Best reagards