I want to display 3 prompts when the query is run.with condition that any one or all of the 3 prompts data should be entered by the user. According to the data entered by the user ,v should get the result.
for example:
result pane : person id, person city
Prompt 1: Last name
or Prompt 2: first name
or Prompt 3: middle name
if only first name entered and other 2 prompts are left blank …the ok button is disabled .
is there any way i can select either of the prompts and get data?
You want what I’d call “optional prompts” – and unfortunately, there’s no standard built-in functionality for that.
However, if you take a look at this topic from our FAQ: Designer (“Frequently Asked Questions” in Designer), you may find an alternative that will get you close.
you could place wild cards in each of the prompts and advise the user to enter data before the wildcard in the field(s) that they want to search on. I use this approach for prompts across multiple universes and it works quite well.
Blueallover – you must then restrict your user to using the “matches pattern” – which translates to the SQL LIKE operator – which may not always be desirable.
(BOB member since 2002-06-17)