+3Hi,
When creating custom attributes, for inbuilt enumerations, I can use:
enumeration_name_Api.decode(‘db_value’);
But when I create a custom enumeration and try to use the same expression, it gives me errors.
Any idea on how to access a custom enumeration using a statement?
Error:
CUSTOM_ENUMERATION_API"."DECODE": invalid identifier
Please help
+18shared with
+3Hello,
Nevermind, I figured it out. It should be:
enumeration_name_CFP.decode(‘db_value’);
Thank you!
+18Hello Mayura!!!!! :)
Really nice to hear from you!
Thank you!
🙂🙂
+3I’ve used something like:
select db_value from CUSTOM_FIELD_ENUM_VALUES
where lu = 'CUSTOM_ENUM_NAME'
Replacing “CUSTOM_ENUM_NAME” with the actual name of the enumeration. Nice and simple. There’s probably a more elegant way using an API, but..
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
