Timebased production information to .qvw

[tka_ovako]

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)');

[PrashantSangle]

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,

[santiago_respane]

Hi Timo,

What is the issue you are having?

Please be kind and elaborate more in order to solve your issue.

Kind regards,

[tka_ovako]

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?