SQL Statements

Users with access to the Custom SQL feature of the query tools are able to create queries that will run select SQL statements.

Caution should be excercised when allowing users access to run a query based on an SQL statement. Data restrictions are not honoured in the same way as they are when running a query that was built using the query tool.

To give users access to this feature. You need to use the Administrator Function from the software login screen:-

Create Custom SQL queries

Method

Select New

Description

A name that identifies the query

Accessible by All Users?

Should all users of the software be able to run this query, or just the person who wrote it?

Note that data access restrictions are not honoured when running a custom SQL statement.

Next

SQL

Enter the SQL statement to be executed.

Finish.