Tabulator row click (DB2)

[Felix]

Hi all.

I have a question about Tabulator node, row dblclick.
Custom functions are set to :

var table = new Tabulator("#example-table", {
  //setup your table
});
table.on("rowDblClick", function (e, row) {
    //e - the click event object
    //row - row component
});

Debug wrote after double click following :

So I do not need repeated Select from SQLITE at output. After dblclick I need only rowIndex statement. Is there a possibility to filter it ?

Function node, after SQLITE placed before tabulator has this code :

msg.tbCmd = "setData";
msg.tbArgs = [
msg.payload
]
return msg;

Thanks a lot.

[marcus-j-davies]

Hi @Felix

I dont do DB Much.

But, what is your browser console output when you do this

table.on("rowDblClick", function (e, row) {
    console.log(`e: ${e}`)
    console.log(`row: ${row}`)
});

Just trying to understand what you are dealing with currently.

Marcus

[Felix]

nothing special …. same as I described in first post.

DB data from SQLITE goes as payload to function node and next to tabulator node.

And I don’t need it go thru tabulator to output, but …. still are here. In older dashboard 1 was at most components check box with message : Pass through messages from input. Here I have’n it.

But I think, exists a possibility, how it atenuate at output.

[marcus-j-davies]

OK - I see in your screen shot - that there is what you need.

rowIndex, rowData

Does the number of array collections (that appears as an addition) match what is in your table row count?

[Buckskin]

Use a Switch node with property: msg.payload, has key: rowData after the Tabulator node

[omrid]

I'm not sure I understand what you are trying to do.
ui-tabulator custom functions do not have access to the table object. They are only called (as callbacks) by the table. You cannot set table.on() events in a custom function. If you need event notifications, the node will do this for you: just specify the required event types in the node configuration

and you will get a notification of the dbl-clicked row with its full data:

[Felix]

Guys, thanks a lot for every contribution. @Buckskin and @omrid guided me on the right way.

Here is node flow :

And then visualise in table dashboard 2: