Is it possible to update translated values, like Portuguese and Spanish, to a list of values via sq
Hi all,
I´m looking a way to mass update list of values with values in different languages like Portuguese and Spanish.
I figured out that the following query will bring the values for English, Spanish and Portuguese that I want to update.
select l.id as LIST_ID, l.name as LIST_NAME, E.ENTRYID, e.entryvalue as LIST_VALUE, e.description, e.langid
from agile.listentry e, agile.listname l
where parentid in (select id from agile.listname where name like 'Oxi_%')
and e.entryvalue IN ('Butanols', 'Butanoles', 'ACETATO(S) DE BUTILA')
and l.id=e.parentid