How to organize a complicated time filter?

[system]

Hello, i’m using Oracle and BO 6.5.1
Is it possible to make such a prompt?

The user should choose the start date and end date in the report, but:
1.If the user only input one date (start or end), the period is all-specific end date or start date-all
2.if the user isn’t input at all, BO query all time in db.

Is it possible to make such a filter?

Regards, Alex.

---

werstatyw (BOB member since 2006-12-13)

[system]

Hi,
This can be possible, but you have to impliment STORED PROCEDURE for the same. With FreeHand SQL or Universe not possible.

---

KP_Pani (BOB member since 2007-05-03)

[system]

Hi KP_Pani!
Recently i’ve found this solution, what do you think?

Getting all values using Prompt IN THE DATA PROVIDER

Hi, I am trying to get all the values selected when a user types ‘All’ in a prompt given in a DATA PROVIDER. Can anyone help me out here ? Please note that I am not talking about the ‘@Prompt function’ given in the universe. I know that if we are using the '@Prompt" we could write the function ‘All IN @Prompt(, , ,)’ Thanks for your help, Sudha SudhaP (BOB member since 2007-04-11)

---

werstatyw (BOB member since 2006-12-13)

[system]

Thanks Alex. You are Correct.

---

KP_Pani (BOB member since 2007-05-03)