Modifying a Free SQL Query

To modify a free SQL query, proceed as follows:

1. Select Queries in the left window pane.
2. Select the desired free SQL query in the left window pane.
3. Select the SQL tab in the right window pane.
4. Enter the your SQL query in the SQL Query field.Information

   Be aware of the following specifications when creating your free SQL query:

   • The query must start with SELECT .
   • The FROM must include the base table linked to the query type: if the type is Device , the query need to include the Device table.
   • The query cannot include the following operators: COUNT , SUM , AVERAGE , MAX , MIN , and SQL commands such as UNION , INTERSECT , EXCEPT , MINUS , and so on.
5. Select Edit > Verify SQL
   The database will verify your syntax and display the result in the following SQL Result . It will provide information about any errors it found, the detail level of which is based on your database system.
6. Select Edit > Save Query

The modifications of selected free SQL query are now saved.