BusinessObjects Board

@prompts

Is there any way to create a prompt but add in an additional value to select from. Something like
@prompt(‘please enter a value’,‘A’, {‘lov/lov’,‘other value’}, MULTI)
where lov/lov is an actual list of values?


lula123 (BOB member since 2004-04-13)

Nope. It’s either/or, but not both. You can build a small table in the database to house your list of values, and query that for your prompt.


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

I suspect that this technique would work. :slight_smile:


Dave Rathbun :us: (BOB member since 2002-06-06)

Ok, I am getting closer but is there any way to make this work:
@Select(field1\Name) IN @Prompt(‘Please enter a Name:’,‘A’,‘LOV\Name’,MULTI,) or
(@Prompt(‘Please enter a name:’,‘A’,'LOV\name,MULTI,) IN (‘All’) and @Select(field1\Name) like ‘%’)


lula123 (BOB member since 2004-04-13)