Node-red-dashboard-2-table-tabulator problems when loading data

Dashboard
1

Hello,
I'm facing problems when loading data (around 1150 records) in the table. The data are not loaded and I get this popup in the top right of my dashboard. When I reduce the number of records (135 ) I do'nt get problem. Is there a limitation ?

image
image177×142 1.9 KB

Could you suggest me the best way (code) to upload data from a Msql DB in the table ?

Regards

Jean-Rem

2

This is due to the fact that the dashboard msg size exceeds the default limit, which causes the socket to reset and disconnect.
The way to solve this is by increasing the size limit in settings.js. For example, in order to increase the msg size to 100 MB, add the following:

	dashboard: {
		maxHttpBufferSize: 1e8 // size in bytes, example: 100 MB
	},
2 Likes
3

Hello,

That was the problem. Thanks for your reply :+1:

Regards

Jean-Rem

4

Ah - that explains why I am seeing random reconnects! Will try adjusting the buffer.

5

Hello,

Is there a specific way to clear headerFilter when headerFilters is set to ‘persistence’?
I'm trying to find a solution, but without success so far.
Do you have any ideas?

Best regards,

Jean-Rem

6

There are specific Tabulator APIs for clearing the header filters and clearing the persistence, but they are currently not supported by the ui-tabulator node.
I need to think about it.

7

Thanks for the info.

8

Hello,

I would like to know if it’s possible to create a filter like that : (Min - Max)

image
image163×143 1.09 KB

with the current version of dashboard-2-table-tabulator ? I can reproduce the same result with the actual tbCmd currently available to interact with the node. However this solution is not part of the “persistence” option I use for the other filters, which makes management a little bit tricky (for me :wink: ). If it’s possible, would you have a exemple of how to implement this filter ?

Best regards

Jean-Rem

9

The custom filter itself can be easily implemented as a custom function in the node configuration.
A simple solution would then be an input field taking a string in a format such as <min>-<max> (like page range selection in a print dialog), and parse it in the custom filter.

How did you create the filter UI (in the screenshot you provided)?. Is there a built-in feature for this which I'm not aware of, or some dynamic HTML trickery?

As for persistence, it is handled internally by tabulator and the browser, the node has no involvement or control over it (besides whatever is exposed by the tabulator API).

10

Hello,

The picture I used to explain ma question came from the Tabulator website (in the exemple folder). I took the Min - Max exemple just because I had two parameters to enter for my filter (field : not needed because it’s for one column only, type and value. I creeate the function like you explain to me, with the option: <, <=, >, >=, like, x - y (range). And with this solution I keep filter “presistence”.

Here is the result.

image
image346×166 3.84 KB

image
image315×123 2.47 KB

Thanks

Best regards

Jean-Rem

1 Like