We have created Query objects that are located under the tools tab:





Queries are useful for long running GS SQL (displaying cached results are fast), queries with large result sets, queries that need to be run at a certain time.

Queries can be defined, saved, secured, and scheduled. Results are cached on the server at the time of run.







Query cached results can be retrieved via an API. They can be used as a data source in Pivot Grid Dashboard widget and the new SQL grid widget. Charts can be linked to the new SQL grid (X-axis will be the first column):

Query API Overview









GS SQL Overview

For Business Pro and Enterprise customers - Project is still in beta and is invite only.