Skip to Content
0
Apr 28, 2014 at 05:46 PM

Need to pass the URL parameters dynamically not hard-coded

124 Views

I am passing the values through a query template:

SET NOCOUNT ON

DECLARE @StartDate DateTime

DECLARE @EndDate DateTime

SET @StartDate = DATEADD(minute,60,'[Param.2]')

SET @EndDate = DATEADD(minute,60,'[Param.3]')

SET NOCOUNT OFF

SELECT TagName, DateTime, Value

FROM History

WHERE TagName IN ('[Param.1]')

AND wwRetrievalMode = 'Cyclic'

AND wwCycleCount = 500

AND wwVersion = 'Latest'

AND DateTime >= @StartDate

AND DateTime <= @EndDate

And declaring in the Transaction Details:

tagString FEN_01_AMIX_ASIDE.FLOw

StartDate 2014-04-21 10:00:00

EndDate 2014-04-22 12:00:00

But every time I change the dates in the url it does not show the new dates it keep on showing the above dates.

For instance if I do the following:

http://<server>:50000/XMII/Illuminator?IsTesting=T&QueryTemplate=HistQuery/WebServices/WebServicesFENHist&SD='4/20/2014 10:00:00'&ED'4/20/2014 12:00:00'=&OutputParameter=OutputDocument&Content-Type=text/html

It still shows the content for

StartDate 2014-04-21 10:00:00

EndDate 2014-04-22 12:00:00

instead of

StartDate 2014-04-20 10:00:00

EndDate 2014-04-20 12:00:00