WEBI - web page prompts for report refresh (WICOM API)

[adam2002]

Hi All,

Can anyone help me with a question about Business Objects WebI SDK. Calling the API function:

wiPrompt.GetListOfValues()

...returns the list of valid entries for a dropdown box prompt on refreshing a report. (ie the same values that you see if you choose 'Show Values' in the InfoView interface.

Unfortunately this only seems to return a list of 'code' values rather than the user-friendly values mapped to the codes in the Universe.

Does anyone know how to lookup these code values against the mapping held in the universe please? Is there another API call?

(Full ASP code example below)

Thank you,
Adam.

Set wiOutput = WiDocument.GetHTMLView(True)

'find out if the refresh requires prompts to be filled in from user
Dim blnMustFillPrompts, wiPrompts
blnMustFillPrompts = WiDocument.MustFillPrompts

If blnMustFillPrompts then
Set wiPrompts = WiDocument.GetPrompts
End If

For i = 1 to wiPrompts.Count
Set wiPrompt = wiPrompts.Item(i)

'see if there is a list of values associated with this prompt
Dim wipValue, wipListOfValues
wipListOfValues = wiPrompt.GetListOfValues(False)

'test whether list returned - if not then simple input
If Ubound(wipListOfValues) < 0 then
Response.Write &quot;Input String, not selection list&quot;
Else
For each wipValue in wipListOfValues
'THIS LINE WRITES OUT CODE VALUES
'NOT USER-FRIENDLY VALUES
Response.Write &quot;wipValue=&quot; & wipValue & &quot;<BR>&quot;
Next
End If
Next