Pull the data from database.

[Former Member]

Hi EveryBody,

                 I have a requirement in universe if the end user will select the date from (1/8/14 to 10/8/14) then pull the data from the database. but when the end user select the data more than 10 days(e.g 1/8/14 to 15/8/14 etc...) then no need to pull the data from database.

how will write the filter in the universe?

how will achieve this? please help me.

Thank you.

[Former Member · Accepted solution]

Hi  ,

I am assuming you are giving prompt for start date and end date  respectively start_date and end_date.

please see the below work around. (below is pseudo code)

1. create one dummy objects as

case when @prompt(end_date) - @prompt(start_date) <= 10 then = 1 end

Remember text used in dummy object should be same as you use it for you date prompts

2. pull this objects in where clause along with your date prompts as

dummy_object = 1 

It will work as below :=

your report will be prompted for start_date and end_date .

Same values will be passed to dummy objects.

When dummy object will be executed , it will check for  end_date-start_date <=10 or not.

If it is less then 10 then query will executed else it will come out as where  clause is not satisfied.

Hope this answers your question :-).

Regards

Jeevan 

[Former Member · Accepted solution]

Hi jeevan,

              Thanks am going to implement the this logic surely.