Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
Is there any chance to get value from all timebased tags as shown below? Now I get only lastest value.
SET v.nrp_starttime = '22.05.2016 7:00:00';
SET v.nrp_endtime = '23.05.2016 10:00:00';
SET v.nrp_interval = 5;
SET v.nrp_taglist = HISTORIAN01/SCADA2.JJ.JP.MATX.TIL3/INTERPOLATED, |HISTORIAN01/SCADA2.JJ.JP.MAT.SUL3/INTERPOLATED, |HISTORIAN01/SCADA2.JJ.JP.MAT.ERA3/INTERPOLATED, |HISTORIAN01/SCADA2.JJ.JP.MIT2011/INTERPOLATED;
TABLE1:
SQL SELECT StartTime,
EndTime,
Value1,
Value2,
Value3,
Value4,
from NOVOPlusConfiguration.dbo.nrp_HistorianTableFunctionIntervalString('$(v.nrp_starttime)','$(v.nrp_endtime)','$(v.nrp_interval)','$(v.nrp_taglist)');
Hi,
did not get your question
check below time and date function in help menu might help you.
timestamp()
timestamp#()
date()
date#()
time()
time#()
monthName()
Year()
Day()
Month()
Regards,
Hi Timo,
What is the issue you are having?
Please be kind and elaborate more in order to solve your issue.
Kind regards,
Hello.
I mean that now I get values only from last tag: HISTORIAN01/SCADA2.JJ.JP.MIT2011/INTERPOLATED. Other 3 values are plank.
I managed to make own *.qvd from each tags and joined those to my qvw but is there chance to make it all in one qvw?