Query Tool

We partially expose the database to users who may want to extract data in their own format. The tool is accessible at Setup > Query Tool (under the title System Maintenance) The tool is extremely powerful. Do not use UPDATE, DELETE, DROP, or CREATE commands. If you have a mistake in your syntax, the application will simply crash without any explanation. It was not designed for end-user use.

Enter the query in the editor provided and click Export as Xlsx. This will export the query's results as an Excel file.

As always, be careful. We currently charge $45/hour for support. There is no limit to the headache a bad query can cause.