# Tabulator row click (DB2)

**URL:** <https://discourse.nodered.org/t/tabulator-row-click-db2/98686>\
**Category:** Dashboard\
**Tags:** dashboard-2\
**Created:** [15 August 2025 19:21 UTC](https://discourse.nodered.org/t/tabulator-row-click-db2/98686 "2025-08-15T19:21:39Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Felix](https://avatars.discourse-cdn.com/v4/letter/f/aeb1de/32.png) [@Felix](https://discourse.nodered.org/u/Felix)\
**Post date:** [15 August 2025 19:21 UTC](https://discourse.nodered.org/t/tabulator-row-click-db2/98686/1 "2025-08-15T19:21:39Z")

</div>

Hi all.

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

```auto
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 :

 ![obrázok](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/6/063687d8a6520fb72794ab50d1262b4190e1634b.png)

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 :

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

```

Thanks a lot.

---

<div class="post-metadata">

**Author:** ![marcus-j-davies](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/marcus-j-davies/32/103435_2.png) [@marcus-j-davies](https://discourse.nodered.org/u/marcus-j-davies)\
**Post date:** [15 August 2025 19:44 UTC](https://discourse.nodered.org/t/tabulator-row-click-db2/98686/2 "2025-08-15T19:44:17Z")

</div>

Hi @Felix

I dont do DB Much.

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

```auto
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

---

<div class="post-metadata">

**Author:** ![Felix](https://avatars.discourse-cdn.com/v4/letter/f/aeb1de/32.png) [@Felix](https://discourse.nodered.org/u/Felix)\
**Post date:** [15 August 2025 19:56 UTC](https://discourse.nodered.org/t/tabulator-row-click-db2/98686/3 "2025-08-15T19:56:28Z")

</div>

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

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

 ![obrázok](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/f/bf062afef367c22ecf6ff1c3daca8e8dc4df2b37.png)

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.

---

<div class="post-metadata">

**Author:** ![marcus-j-davies](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/marcus-j-davies/32/103435_2.png) [@marcus-j-davies](https://discourse.nodered.org/u/marcus-j-davies)\
**Post date:** [15 August 2025 20:14 UTC](https://discourse.nodered.org/t/tabulator-row-click-db2/98686/4 "2025-08-15T20:14:23Z")

</div>

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

```auto
rowIndex, rowData

```

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

---

<div class="post-metadata">

**Author:** ![Buckskin](https://avatars.discourse-cdn.com/v4/letter/b/b9e5f3/32.png) [@Buckskin](https://discourse.nodered.org/u/Buckskin)\
**Post date:** [15 August 2025 20:23 UTC](https://discourse.nodered.org/t/tabulator-row-click-db2/98686/5 "2025-08-15T20:23:50Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![omrid](https://avatars.discourse-cdn.com/v4/letter/o/77aa72/32.png) [@omrid](https://discourse.nodered.org/u/omrid)\
**Post date:** [15 August 2025 20:32 UTC](https://discourse.nodered.org/t/tabulator-row-click-db2/98686/6 "2025-08-15T20:32:04Z")

</div>

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

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/5/5/551e60d76a49e5fc0e48602b650ff18bce5e8f44.png)

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

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/9/f9109f00f24c5927c9062e75d0c0a334428df4af.png)

---

<div class="post-metadata">

**Author:** ![Felix](https://avatars.discourse-cdn.com/v4/letter/f/aeb1de/32.png) [@Felix](https://discourse.nodered.org/u/Felix)\
**Post date:** [15 August 2025 21:24 UTC](https://discourse.nodered.org/t/tabulator-row-click-db2/98686/7 "2025-08-15T21:24:51Z")

</div>

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

Here is node flow :

 ![obrázok](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/d/dde0eaf45dd7c6bd65672d276e108436bc807eac.png)

And then visualise in table dashboard 2:

 ![obrázok](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/0/c074833a08058e7d5159e67d5b956726c1abddcb.png)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [29 August 2025 21:24 UTC](https://discourse.nodered.org/t/tabulator-row-click-db2/98686/8 "2025-08-29T21:24:53Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.