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

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

Petr 17 October 2019 21:30 9

No problem, thanks for taking care anyway...

Topic		Replies	Views
SQLite SELECT from node-red function return nothing but in DB browser works fine General database , function-node	10	1172	16 February 2022
Sqlite SELECT OK from terminal, empty result from NR General database	13	382	20 December 2022
Select data from SQlite not working General	1	380	26 January 2022
Inconsistent SQLite node query behaviour General database , sqlite	10	163	26 November 2024
Help with Sqlite Select clause General	5	608	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