I generate a pdf report from sql query,all the row is filled but Time stamp row is empty. "This is My sql query" var fromdate = msg.payload.From; var todate = msg.payload.To; msg.topic = "SELECT * FROM `node-red`.`final` where Date_Time between '" + fromdate + "' And '" + todate + "';"; return msg…

yes, somehow the date component is not appearing in pdf if you use as it is. i modified the query to remove * and actually put all the fields in the syntax with date field as below. i am not sure of your field names, i am guessing from your previous post, try this and see if it solves the issue. b…

smanjunath211 4 June 2023 03:00 22

glad i could help.

Topic		Replies	Views
SQLite data into PDF report General	35	1297	19 August 2022
Create a Report from MYSQL General database , pdf	8	541	20 January 2023
Visualization in dashboard TEMPLATE Dashboard	11	618	27 June 2022
Issues with formatting of data as input to pdf make General	2	296	18 December 2022
MSSQL Datetime issues General	37	3745	16 February 2020

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Time Stamp Not Captured in pdf which I generated

Related topics