Creating and Running Advanced Queries
You must have previous experience writing SQL queries to use
this feature of the accounting and reporting console.
How to Create an Advanced Query
-
Click New Advanced Query on the Query List screen.
-
Type your SQL query in the field.
-
Save or run your query.
-
To save your query, click Save.
-
To run your query, click Run.
How to Run an Advanced Query
-
Run the query.
-
To run a query that you just created, click Run on the
Advanced Query screen.
-
To run a query that you previously saved, select the query
from the Query List screen and click Run.
How to Edit an Advanced Query
-
Select a query from the list on the Query List screen
-
Click Edit.
A completed version of the Advanced
Query screen displays.
-
Make changes to the SQL query.
-
Save or run your changed query.
-
To save your changed query, click Save.
-
To run your changed query, click Run.