script.processUpdateQuery
This function is commonly used to update the SQL provided to the datasource based on user input from a prompt.
js
script.processUpdateQuery(sqlQuery)
Parameters
sqlQuery
- a string value which is the updated sql.
Example
js
let sqlQuery = "SELECT * FROM products";
script.processUpdateQuery(sqlQuery);