I have a relatively big SQL SELECT query (44 lines). On the locally deployed sqlite database query works. On the server query works as well (server is the machine, where node-red runs + database file is deployed). From the node-red the query returns empty [ empty ] This is the flow I use: [{"id…

[image] Petr: I have a relatively big SQL SELECT query (44 lines). Respect for being able to read that! Could you post the query to me as a PM?

have you put in a catch nde connected to a debug node (display complete msg) to see if anytheing is reported? What version of nr and node.Js? Can you provide your schema?

Both queries (working and not-working) are included in the "template node" in the flow posted above.

nr 0.19.5 node.js v10.16.3 catch node doesn't return any error/msg (I thing because query just return nothing) What schema do you mean?

The database schema - the create table's syntax to show what al the columns are

There is not a problem in the database schema, AFIK. The table is really simple CREATE TABLE IF NOT EXISTS "POWER" ( "ID" INTEGER PRIMARY KEY AUTOINCREMENT, "TIMESTAMP" DATETIME NOT NULL DEFAULT (datetime(CURRENT_TIMESTAMP,'localtime')), "TOTAL_KWH" NUMERIC); I can get the data with the same SQL s…

Sorry I haven’t been able to get back to this. (Family issues and a wind storm cleanup) I hope ll have time later today

No problem, thanks for taking care anyway...

Well you're going to kick yourself. Try removing the first line (the create index) and see what you get.

Hmmm. I see. Query is returning data when first row is removed. But why it is not working with the first row? When I run whole query (including the first row) from CLI and from DB browser for SQLite the query is working....

Node-RED

Node-RED Forum

Sqlite select query not returning data

General

ghayne 15 October 2019 18:57 2

Respect for being able to read that! Could you post the query to me as a PM?

Topic		Replies	Views
SQLite SELECT from node-red function return nothing but in DB browser works fine General database , function-node	11	1119	16 February 2022
Sqlite SELECT OK from terminal, empty result from NR General database	14	314	20 December 2022
Select data from SQlite not working General	2	364	27 March 2022
Inconsistent SQLite node query behaviour General database , sqlite	11	122	26 November 2024
Help with Sqlite Select clause General	5	580	5 January 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.

Sqlite select query not returning data

Related topics