How can I make that the list of values of the prompt is taken automatically from one table. For example, what I want that the query ask for the “Region” and there is a table of regions so I want that in the prompt, the list of values are the values that are on the regions table.
Is there any way that the user can select an option like “All of them” in the prompt? I mean, in the regions table there are R01, R02, R03, etc… is there any option where the user could select “All”?
By manual query do you mean free hand SQL? There are no LOV options for free hand SQL unless you hard code them, you cannot pull from a table. Which means:
… that this is not an option. If you are using a Universe to build your query, then that’s different. There are LOV (list of values) options that work exactly the way you are requesting.
Assuming that you are using a Universe, yes. Please see the Designer FAQ.
I’m doing a manual query and I want 2 things:
(BOB member since 2002-06-06)