SQL Queries to the Database

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.

.

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment