Lookups: Country/Language Code and tcLookupOperationsIntf.getDecodedValu...
703604Jul 9 2009 — edited Feb 21 2011Hi,
In the lookup table (lkv) there is a field for language and country codes. I've read some OIM tutorials where these fiels are visible in the Lookup Definition Form, but I can't see them in the version 9.1.0.1. Do I have to configure something have these fields visible in the form? Through API (addLookupValue) you have to inform these values.
About the tcLookupOperationsIntf.getDecodedValueForColumnEncodedValue... I saw this method executes the query below:
select lkv_decoded from lkv
where lku_key in (select lku_lookup_key from lku where lku_type_string_key = ?) and lkv_encoded = ?
I've tried to use this method but it doesn't return any value. The query above is comparing the field lku_key with lku_lookup_key, but for my lookup this field is null. I executed a query to count all lookups where this field is not null and I got 54 records from more than 1900, so few... And in only 5 of them the lku_key is equal to lku_lookup_key.
Have you ever used this method?
Thanks,
Renato.