ComfyUI Node
Nova SQLite Data Table & Filter 🔎
A ComfyUI node in ▶️ Nova Audio/📦 Delivery & Metadata with 7 inputs and 7 outputs.
Nova SQLite Data Table & Filter 🔎
- row_data_json
- table
- row_data_json
- rows_json
- matched_rows
- total_rows
- where_clause
- table
- selected_rows
◄where_json[]►
◄selected_rows[]►
◄output_rowsmatching rows►
◄case_sensitivefalse►
◄max_display_rows200►
Category▶️ Nova Audio/📦 Delivery & Metadata
Inputs (7)
| Name | Type | Default | Description |
|---|---|---|---|
| where_json | STRING | [] | — |
| selected_rows | STRING | [] | — |
| output_rows | COMBO | matching rows | Which rows leave this node: everything the conditions match, or only the rows highlighted in the grid. |
| case_sensitive | BOOLEAN | false | Off: text is matched regardless of upper / lower case |
| max_display_rows | INT | 2001–10000 | How many rows the table shows. All matching rows are still passed on. |
| row_data_jsonopt | NOVA_SQLITE_ROWS | Rows from the Nova Dynamic SQLite Browser. | |
| tableopt | NOVA_TABLE | A NOVA_TABLE from any pack node, so its rows can be filtered too. |
Outputs (7)
| Name | Type | Description |
|---|---|---|
| row_data_json | NOVA_SQLITE_ROWS | The rows leaving this node, for the Row Iterator and Single Row nodes. |
| rows_json | STRING | The same rows as plain text. |
| matched_rows | INT | How many rows the conditions matched. |
| total_rows | INT | How many rows came in. |
| where_clause | STRING | The same conditions as SQL, safely escaped. |
| table | NOVA_TABLE | The same rows as a NOVA_TABLE, for Nova Tag Writer and the other pack nodes. |
| selected_rows | INT | How many rows are highlighted in the grid. |