SQL Queries to the Database

You are here:
Estimated reading time: < 1 min

Strictly speaking, this is not an integration item as the following SQL calls can only be made from within the application. However, they can provide useful information for other activities.

There are two ways SQL calls can be made:

1. Go to Charts & Reports, click on + New Report and then select SQL Console
2. Go to Settings (small cog, lower left of the screen), click on SQL Console

Allowable SQL Calls

It is imperative that any calls made to a database contain the correct syntax. This being the case, the allowable SQL calls are included in the attached TXT file. Please copy the calls directly from your browser or download as a TXT file.

Was this article helpful?
Dislike 0
Views: 77