[V6.5] prompt with optionnal filters

[system]

Hello,

Sorry if this is not very clear, i will try the best to express my self in english.

Well here is my problem, I would like to create a prompt with a list of filters in BO V6.5 but il would like that some of the filters to be facultatives/optionnal, meaning that the user has to fill some of the prompt (let’s say for example that 5 prompts must be filled) and can fill 2 other prompt if he wants to.

When he’d fill the 5 prompts, he would have the possibility to push the 'OK" button to generate the report (even if he didn’t fill the 2 other prompts).

How can i make this?
For now i created the prompts but i have to fill in all of them to generate the report.

I hope it’s clear enough for you to understand because i’m looking for help.

Thanks!

---

Sokhar (BOB member since 2009-07-24)

[system]

Welcome to B:bob:B!

As far as I know, there is no concept of Optional prompts you can make in universe level. But Web-I 3.x has optional prompt concept at query level.

---

Jansi (BOB member since 2008-05-12)

[system]

Hi Jansi,

Thanks for your answer!
Well i guess i’ll have to find something else to deal with my problem…

One solution would be to fill in the “optionnal” prompts automatically at every refresh of the report (with a * ).
But again i don’t know exactly how to proceed…is it even possible this time haha?

Thanks!

---

Sokhar (BOB member since 2009-07-24)

[system]

Hi Sokhar,

In your BO version, you can simulate the optionality of a prompt by so called “ALL in LOV” concept. Basically, using one technique you add one additional value into the LOV. The value will be something like “-- All --”. Then if users selects this value from the LOV of a dimension then the condition will select all possible values of the dimension, it means it will work as there is no condition for the dimension.

Check these 2 entries in the Designer’s FAQ:

FAQ: Designer

Is there any way to set up a prompt that will allow a user to select one value, many values, or type ‘ALL’ for all values in a list? Yes. Below is a sample of the syntax required to allow a user to select one, many, or all values from a prompt. (@Select(Sales Geography\Country Group) IN @Prompt('Select Country Group or enter * for all groups','a','Sales Geography\Country Group',multi,free) ) OR ('*' in @Prompt('Select Country Group or enter * for all groups','a','Sales Geography\Co…

FAQ: Designer

Now that my LOV lets me use ALL for all values, how do I get the ALL in the list? Author: Dwayne Hoffpauir There are two approaches - overriding the LOV SQL, and creating a universe object. Overriding the LOV SQL Press the SQL button in the query panel of the LOV Add the phrase UNION SELECT ‘ALL’ FROM DUAL or similar dummy table for your particular database. For SQL Server (if you don’t care if the object parses or not) add SELECT xx From xx UNION SELECT ‘ALL’ (You don’t need a FRO…

---

Marek Chladny (BOB member since 2003-11-27)