Help Desk

Submit a ticket My Tickets
Welcome
Login

Can I use the UPDATE or INSERT statements with Advanced Query?

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:

If you need additional support, please contact support@onecloud.io.

Login to post a comment