Prompt options and select ALL of them.

[system]

@reverke

Hi, I’m doing a manual query and I want 2 things:

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:

1. 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.

… 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.

2. 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”?

Assuming that you are using a Universe, yes. Please see the Designer FAQ.

---

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