6 steps to complete.
The SQL Manager is used to improve the standard reporting that exists in Corporate Office. To ensure that the live database performance will not be impacted, all queries run through the SQL Manager will run off a replicated database (the same that’s used for fail-overs).
Read more: 6.4. Using the SQL Manager to View Data
This guide will show you the steps involved in saving a query for future use.
In Corporate Office, navigate to: Reports > SQL Manager.
In the Query Box, run a SQL Query.
Step-by-step guide: How to Use the SQL Manager to View a Query
Click the Save button to save the query.
The Save Query pop-up window opens.
In the pop-up, type a Query Name.
The pop-up closes and the query is saved.
Click the View Saved Queries link in the top right to view your saved queries.
The Saved Queries pop-up window opens.
In the Saved Queries pop-up window, you can search through all your queries with the search bar at the top, or scroll through the list. The list shows the query name and the user name by whom it was created.
To delete a saved queries, click the Trash icon.
You now know how to save a query in the SQL Manager.