The ClearSCADA Guide to SQL, and the SQL technical reference online Help provide general information about SQL. This topic provides links out to other ClearSCADA guides that describe specific aspects of SQL implementation within ClearSCADA.
- Lists Guide
- Queries List— Queries Lists are Lists of database values. You can display many Queries Lists in ClearSCADA. You can use those Lists to monitor, control and compare various aspects of your system.
- Custom Lists— Use custom SQL query minimizes the loading of requests for data by only retrieving those records that are of interest, rather than all of the records in the database.
- Querying Third Party ODBC Databases— You can use ClearSCADA to query an ODBC database. This is useful as it allows ClearSCADA users to view data stored in other ODBC database systems. If you have an SQL Server database, you can use Queries Lists to view the SQL Server’s data in ClearSCADA.
- Use SQL to Create a Filter for a List other than an Alarms List— You can use SQL to customize filters by defining the filter criteria as an SQL query.
- Mimics Guide
- Embedded Query List Animations - SQL— This describes how to use the Sql property to represents an SQL query that defines what is shown in an embedded List on a Mimic.
- System Administration Guide
- SQL Query Configuration Settings— The Server Configuration Tool has SQL Query Configuration settings. You may need to adjust these settings if you have SQL Queries that need to be run on a regular basis.
- Extra Table Queries — You can use the Extra Table Queries feature to create custom pick actions that provide access to specific Queries Lists.
- Scripting Guide
- Query Functions— Describes the query functions available within scripts.
- Query Properties— Describes the properties of the Query Control Object.
- Server Status Guide
Query Processor Status Information— The Query Processor branch of the ClearSCADA Server Status Tool provides status information about the latest, largest and longest SQL query made on clients that are connected to the server on which you are working.
- Logic Guide
- Using an ST Program to Call an SQL Query— Describes how you can code an ST program to retrieve information from the database via an SQL Query.
- Raw Historic Values in SQL Queries— Describes how to use SQL Queries in your Logic programs to retrieve multiple raw historic values.
- Core Configuration Guide
- Queries Bar— Explains about the Explorer Bar that provides access to Queries Lists.
- Configuring Data Tables— You can use Data Tables to store the results of custom calculations that are running in Logic programs on your system, or to store the values that are returned by Mimic scripts. Data Tables are designed to be populated automatically using, Logic or SQL.
For further information about SQL, see the SQL technical reference online Help.