Hello, I am very pleased to share with you a subflow that enables CRUD operations using Dashboard 2 and SQLite. Getting Started: Add a Dashboard 2 group Add an SQLite database ( node-red-node-sqlite ) Add a table / Columns in the database with another tool Import the subflow Configure …

Personally, I would use msg.columns rather than msg.payload.columns. Reserving msg.payload for the actual data payload. This is on my backlog of work for the uib-element node which has a table output that needs the same enhancement.

[image] TotallyInformation: Reserving msg.payload for the actual data payload There is no payload applicable. The subflow reads all data from the sqlite database schema. The reason I suggested using topic and payload was that it's the most well known and accessible properties of the msg. And…

[image] Steve-Mcl: At a future time, you could even enhance this to accept multiple operations via a single message msg.payload = { "config": {...}, "table": "table2", "class": "finance-table", } I think that is the best solution... Perhaps keep the table name separately to keep th…

I've tried to share my node i've created from my subflow... I've created my npm package, but it doesn't appear in the palette. Do you have any ideas ? Links ( dashboard-2-sqlite-crud - npm )

Hi @Cyprien Ideally, this would have been published as a scoped package - see recommended naming convention in Introducing the Node Scorecard : Node-RED Once done, you need to manually add it to the flows library then it appears in the node-red palette manager with the next 30 mins. See Adding to f…

Hi Steve i published the problem in dashboard 2 crudsql [image] Dasboard-2-sqlserverDatabase-crud Dashboard Hi Guys im trying to replicate the crud of sqlite https://flows.nodered.org/flow/ca8b64f1465f7246781315fdff6234c4 but with sql server db, this is the payload that i …

As i said to you @rafasimple , i think that the problem come from the pragma query that is not existing in sqlserver...

[image] Cyprien: i think that the problem come from the pragma query that is no can you gave me a screenshot for your payload, after using the join node?

I've give it to you this screenshot this afternoon [image] Is there a problem with it ?

Thanks Steve, I will read it carefully... Do you think that it's better to scope it with @flowfuse (for easier search) or with @cyprien ?

Node-RED

Node-RED Forum

Dashboard 2 CRUD node

Dashboard

rafasimple 2 July 2024 19:04 18

Hi Steve i published the problem in dashboard 2 crudsql

Topic		Replies	Views
Dashboard-2-sqlserverDatabase-crud Dashboard dashboard-2	5	305	8 July 2024
Hello! I'm trying to extract the data from an sql server into a table from my dashboard but i dont get the table filled. My version of node-red is v3.0.2, Windows, and i'm running a Docker Dashboard database	16	431	17 November 2023
Table with edit / delete function Dashboard dashboard	14	541	11 September 2024
Get ui-table data in JSON format Dashboard	11	2961	7 January 2022
Ui-table row contextmenu doesn't work? Dashboard node-red-dashboard	9	1069	15 December 2021

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.

Dashboard 2 CRUD node

Related topics