PDA

View Full Version : Date Picker in Report Query



pentahouser1988
03-01-2018, 07:52 AM
Hi All.

I am using following query to fetch data from Postgres

SELECT * FROM Func1('archivevalueTable',ARRAY[${TagName}],'2017-09-06 10:00:00','2017-09-06 18:00:00')
where timetest1>=${StartTime} and timetest1<=${EndTime}

For Tags I am able to pass required info.

But For time i.e. providing StartTime and EndTime I am not getting any data

My parameter details for StartTime and EndTime as follows

Name: - StartTime(EndTime)
Value Type:- Timestamp
Data Format:- yyyy-MM-dd hh:mm:sss
DisplayTime :- Datapicker
Query:-datanew
value:-timetest1

Please find attached
image
19213

of time on report.
where my following hard coded query works fine for me.

SELECT * FROM Func1('archivevalueTable',ARRAY['Para1','Para2','Para3'],
'2017-09-06 04:00:00','2017-09-09 21:00:00' ) where timetest1>='2017-09-06 14:00:00' and timetest1<='2017-09-09 21:00:00'


Query Require time to be sent in format :- '2017-09-06 14:00:00'

and I get the data as..



Para1
5.99
06-09-2017 14:00:00


Para2
5.6
06-09-2017 14:00:00


Para3
7.6
06-09-2017 14:00:00


Para1
6.3
06-09-2017 14:15:15


Para2
6.2
06-09-2017 14:15:15


Paar3
8.22
06-09-2017 14:15:15






Please Support

Regards