How does error handling work in Smart Query, and what happens if there are errors in the query?
Hi @sindhuja.murugesan, Regarding error handling in smart query for create and update flows, any errors in the query will be displayed during validation. If there is an error, you won’t be able to save the query. If an error occurs while saving, a pop-up message will notify you of the issue. For update flows, the same process applies. Errors will be displayed during validation, and if an error occurs while updating, the old data will be restored if new data can’t be created since both have the same table name. The save response will also include a notification of this. I have attached some screenshots for your reference.
If the query contains an incorrect table name or column name.
In case of any errors during the creation or updating of the view.