Question
I want to update records using the Advanced Query Command. How do I do this?
Answer
While the Advanced Filter Command supports SQL query statements, it currently does not support the UPDATE or INSERT SQL Commands. Only the SELECT statement along with complimentary statements such as JOIN, LEFT JOIN, RIGHT JOIN, etc. are currently supported. As a workaround, you can do the following:
To Insert / Add Rows to a CSVUse the OneCloud Tabular Transformation BizApp and select the "Stack Files" Command.
To Update Rows in a CSVUse the OneCloud Tabular Transformation BizApp and select the "Find and Replace" Command.
If you need additional support, please contact support@onecloud.io.