LOV's a DECODE

building semantic layer
1

I hope someone can help…

I am trying to DECODE the values that I am using in my LOV. I am not using a personal data file.

Where would I the function? There will only be to values returned for the LOV. Instead of having the abbreviation F for Financial and P for Physical, I want the user to see Financial and Physical. For some reason I have gone blank on where to add this.

Susie

susie (BOB member since 2005-05-02)

2

You’ll do this where you customize the LOV in designer. The problem is that you’ll likely have to manually edit the SQL to make it happen. Also, be very careful as you likely want a 2 column LOV. You really don’t want to pass a decoded value back to the database as a condition or it will not perform well.

Steve Krandel :us: (BOB member since 2002-06-25)