Query Tool

The Query Tool menu is only visible to the Support Engineer role. By using this tool, you can run SQL queries against a database to manipulate and modify data.

The Restricted Queries property (Advanced > System Debugging) in the Configurator specifies a list of queries that should be supported by the query tool.

By default, INSERT, UPDATE, CREATE, DELETE, DROP, and TRUNCATE queries are not allowed. You can allow these operations by specifying values through the Configurator or specify NONE to allow all queries.