Batch Processing in SQL mode

[Shegs]

• Goal: I have a table that is referencing a view in my SQL database. I have a calculated column that is a boolean field in this table. I have the field setup as editable in the table. so someone can check and uncheck people using that one checkbox.

I would like, when the user clicks save, for each of those keys selected to run a stored procedure on the server.

• Steps: I've tried clicking Enable batch Processing, but I don't know how to word the query to make it run for each changed item.
  I've tried this doing a JSON query, but that doesn't seem to work, even the bit at the bottom of this site that refers to referencing arrays with an in statement:
  Query JSON data with SQL statements | Retool Docs
  and converting my JSON to text etc.

• Screenshots:
  

  
  
  
  

[Tess]

Hi @Shegs,

The where IN logic varies depending on your specific SQL type. We have a cheatsheet here hope it helps!

[Tess]

I also see that you chatted with my teammate internally & he submitted a feature request on your behalf

[kent]

@Shegs have you considered using a Javascript loop to trigger your stored procedure for each selected item?

[Shegs]

this is what I ended up doing.