ATTENTION: Any SQL queries for ‘custom’ Lists should be written by engineers who have the appropriate experience and knowledge of the SQL language. Running a badly designed SQL query can have an adverse affect on the system. All queries should include suitable restrictions to limit the number of records that are retrieved from the database. An SQL query that queries vast amounts of data will affect the performance of the server while that query executes.
In order to reference the relevant database tables and include the required data in any custom Lists:
- You need to be familiar with the ClearSCADA database structure and naming conventions. This information is covered in detail in the ClearSCADA Guide to the Database.
- You should have the appropriate experience and knowledge of the SQL language. Some basic information is included in this section. Also see the SQL Guide.
In order to embed Lists successfully in Mimics, in addition to the above, you also need to be familiar with the principles of Mimic configuration in ClearSCADA. This is covered in detail in the ClearSCADA Guide to Mimics. In particular:
- see Embed a Queries List on a Mimic
- see Embed an Alarms List on a Mimic
- see Editing an Embedded Query List
- see Editing an Embedded Alarms List.
(Each of the above are references to sections in the ClearSCADA Guide to Mimics.)
In order to add extra Table Queries successfully in ClearSCADA, in addition to the bullet points listed at the start of this section, you need to be familiar with the syntax that ClearSCADA supports for Table Queries (see Extra Table Queries in the ClearSCADA Guide to Server Administration).