what about the case where the id is in an array and you want to SET all the IDs in the array to {{table1.selectedRow.dat.id? Basically the opposite of your solution. I tried it but i got an error "Condition WHERE ... id IN (...) failed because the value is not an array.)
I tried it in sql mode with the following:
update admin.node
set bundle_id = {{tableBundles.selectedRow.data.id}}
WHERE admin.node.id in {{ multiselectNodesAvailable.value.map(x => `${x}`).join(",") }}
The output from this is "101005,101006"
I tried this:
update admin.node
set bundle_id = {{tableBundles.selectedRow.data.id}}
WHERE admin.node.id IN { {{ multiselectNodesAvailable.value.map(x => `${x}`).join(",") }} }
Error: syntax error at or near "$2"
I've been working on this all day so I'd really appreciate some help.