[Solved] Static Choices

[Sudha]

Hi All,

Can any help me out what are the steps to follow to make the Static Choices work the way I want.

The way I want is I have Four Prompts out of which two Prompts has values like Abbreviations or Codes (which come form DB like that) and I have a req. of Displaying the Detailed expansion of those Codes.
Well I did some research and am able to do ...but when I'm using these Static Choices Property for those Prompts, I see both the Codes as well as the Detailed Expansion of those Codes.

Can any 1 help how to hide the values comming from Database and just display what I want.

Eg., Prompt1: Country Code
IN - Value from DB
Display - India
USA - Value from DB
Display - America
EUR - Value from DB
Display - Europe

Values Before using Static Choices    IN
         Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  USA
         Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  EUR
         Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  ....

(In my case)
Values After Using Static Choices   India
         Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  America
         Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Europe
         Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  ....
         Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  INÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, (I don't need this)
         Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  USAÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  ''
         Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  EURÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  ''
         Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  ....

This is just for 1 Prompt

[CoginAustin]

Edit the field to something like:

CASE WHEN
(CountryCode='USA') THEN 'America'
(CountryCode='EUR') THEN 'Europe'
...more here
END

[Sudha]

where, I need to write this code (for the Prompt Value or...somewhere else)

...first of all after writing this code do I still need to use static choices or not

Well I tried various options am trying to figure out the steps
I'm sorry if I'm being pushy

Thanks
S

[Sudha]

I think I figured out what is the problem
Well in the Value Prompt Properties under Data I had to clear Use Value property that was the reason for the values (I mean the codes/Abbreviations) to display again in the Prompt (DropDown)

Well we can close this Issue.

Thanks a lot to you all
S