Notifications History

[_iJunior]

Hello people! I would like to know if it is possible to create some widget on the dashboard to show the history of received notifications, for example the last 5, do you know how I can do this? Or if it's possible at least?

[Steve-Mcl]

@_iJunior

history of received notifications

what notifications? from where?

@_iJunior

Or if it's possible at least?

If you have an array of 5 things, you can certainly show them on a dashboard yes.

[Christian-Me]

Perhaps something like a log?

Problem with data displayed in UI-Table when switching Tabs

So something like a logfile .... This is using a little bit more complex (but universal) subflow I use for all my tables. But you can do it more simple too: A) a function node which gets an array (of lines) from the flow context and pushes the new line at the end B) a second function node triggered by ui-control gets the same context array and send it to ui-table I splittend it up to different nodes to make it easier to understand / debug - The tricky part is to scroll the table if you in…

Here you find a basic example. One post later you find the code to limit the amount of rows to keep.

[_iJunior]

For example, I'm notifying the dashboard when there is a threshold such as temperature exceeded (example), in that I'd like to create a history with these notifications and the time to see when the last failure occurred, understand?

[_iJunior]

I thought of sending these notifications to a database with a timestamp and then pulling them to a table

[zenofmud]

So why not do that? Send the msg to a database node to record it. Else where you can have a flow that triggers however you want and select the rows descending with a ‘Limit’ clause

[_iJunior]

I'm trying this right now, but I don't know if I'm going the right way. The data arrives in the database correctly like in the print. But no bottom node is coming out of the database to send to the table.

[zenofmud]

1. What database are you using?
2. How are you triggering the select?
3. What are the sql statements you are using for the insert and select?
4. What is the schema for the table?
5. What database node are you using - the full name please node-red-contrib-?????

[_iJunior]

1 - Cloudant
2 - I didn't understand very well, I'm a bit new in this area, I'm managing to put the data in the database calmly, but I need something to activate the output, is that it?
3 -

4 - There will be two columns, one with the text of the last notification and the other is the time, showing when it was displayed in the dashboard
5 - node-red-contrib-cloudantplus

[zenofmud]

Cloudant… I was wondering about that. I have no experience with it so I will have to bow out here unless you want to use a sql database.

Is there a particular reason you are using cloutant?