Pass parameters when loading script for QVW

[#1]

Hi

Is it possible that parameters can be passed into a QVW when it is being reloaded.  What I am looking to do is have the ability to load data for a given period, say 1st April 2014 to 31st July 2014.  Come say mid September, i want to load up to Aug 14.  The idea behind this is that I may want to reload data in Aug, but I dont want the period to change. 

[tresesco]

See, if this helps: Re: Load data based on a selection

[#3]

DIMFinancialPeriod:

SELECT date as FinancialPeriod

--date as SLRFinancialPeriod

, [Year] as 'Year'

, [quarter] as 'Quarter'

, left([month],3) as 'Month'

,left([month],3) + ' ' +[Year] as 'MonthYear'

,[Year] + ' ' + left([month],3) as 'YearMonth'

FROM Dates

where date between '2012-04-01' and '2013-08-09';

So in the example above i want to pass param into the two dates on reload if that makes sense.

[tresesco]

You mean passing variable like:

where date between '$(vDate1)' and '$(vDate1)';  ?

vDate1,vDate2 are variables defined somewhere prior to this statement.

[#5]

so is it as simple as setting up the two variables and then the where statement?  the date that will be passed into the variable will be entered by the admin user so I will use an object for that.

[tresesco]

Yes. If you are thinking of allowing fron-end users control reload, that would not be an good idea and not an easy way to follow as well. For that you have to take the root of EDX. There are several discussions on the same here in community.

[#7]

well it would only be for the single admin person.

[#8]

can i send you the qvw if you could help at all please