Agile (MOSC)

MOSC Banner

Is it possible to update translated values, like Portuguese and Spanish, to a list of values via sq

edited Dec 14, 2017 5:24AM in Agile (MOSC) 2 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center