What is the Queries function?
The Queries screen provides limited functionality for running SQL queries directly against the Handyman database. It is intended for system administrators who need to look up or verify data that is not exposed through the standard Handyman interface. Standard users should not need to use this function.
How do I run a query?
- In Handyman Office, go to Configuration → Queries (CTRL+F7)
- Check the SQL Server and Database fields at the top. If the database you need is not in the dropdown, verify you have the correct server selected in the Client tab.
- Type your SQL query in the query field
- Click Run to execute the query
- Results appear in the lower panel
What other options are available?
- Save — saves the current query to a file for later reuse
- Load from file — loads a previously saved query file
- Delete — clears the current query from the editor
Note: Only read queries (SELECT) should be run here. Modifying data directly in the database without guidance from GSG Handyman Support can cause data integrity issues and may not be supported. Contact GSG Handyman Support before running any write operations.