The example below is intended to demonstrate one or more features or methods and is presented as a configuration example only. Schneider Electric assumes no liability for the use or application of this example or any portion thereof.
SQL queries are used for embedded lists that can be placed onto mimics in ClearSCADA. If the content of the data needs to change based on some variables, then the SQL query should be contained within an animation.
When trying to enter SQL into animations, there are several things to be aware of:
- the entire expression must be enclosed within single quotes,
- any carriage returns must be removed and
- any single quotes within the expression must be replaced with two single quotes.
For example the query:
| SELECT FULLNAME, CURRENTVALUEFORMATTED FROM CDBPOINT WHERE FULLNAME LIKE 'Article.%' |
which shows FullName and value for all points under the folder "Article" would become the following Sql animation:
Note that the SQL is now enclosed within a single quote (') and that the single quotes around the time fields have been replaced with two single quotes.
The simplest way to convert an existing SQL query to a string for an Sql animation is to enter the SQL into an embedded list then, on the query tab, right click and select the "Generate Animation" option. This will auto generate the SQL query into the appropriate form for an animation and add the query to the Sql animation of the embedded list:
Once the animation is generated, we can edit it to add variables. The example below can be used to show the FullName and value for all points under the group that contains the mimic:
Because the animation is a string, we can concatenate other substrings to it so we get a dynamic animation. Note that ".FullName" will return the FullName of the group that contains the mimic.
