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