We are using a data source query in Laserfiche Cloud to run an UPDATE statement against an on-premise SQL Server (using a remote agent).
The agent works great, we can lookup data and write data back to the tables really easily. One thing we have noticed however is that using an UPDATE query, there is no way (that I can see) to set a columns value to NULL.
Running an INSERT query is fine, because you can choose to just not map the column in the rule, but if there is currently data in the column and you want to set it back to NULL there doesn't appear to be a way to do this.
If there is a way could someone let me know how please, or if not could I raise this as a feature request?