BusinessObjects Board

@ Prompt Syntax

Hi there,

I have created prompts and would like to have all values selected as the default value.
How can I select “all values” as the default value?
does anyone know the syntax for it?

thx
Mile


Mile (BOB member since 2018-03-01)

Just make it an optional prompt. Not selecting any values is mostly equivalent to selecting all values.


joepeters :us: (BOB member since 2002-08-29)

the @Prompt is defined in Data Foundation Layer and can not deine “optional”


Mile (BOB member since 2018-03-01)

If you’re not able to change it to a BL-level prompt, then it gets much more complicated.

You would need to use the “all values” trick in the predefined condition. Here’s a post from 2002 that describes the method. Note that this works by including a static text value in the LOV, then applying logic when that value is selected.

There’s no way to do what you want to do – actually default the prompt to including all values.

Joe


joepeters :us: (BOB member since 2002-08-29)