Discover our Clipsal Smart Home packages as seen on the Block

in location

OR

I'm looking for

  • Wholesalers
    • Uncheck All Check All
  • EXPERTISE
    • Expand
    • Expand
    • Expand
    • Uncheck All Check All
  • Switchboard Manufacturers
    • Uncheck All Check All
OR

The best way to see what Clipsal electric products can do for your home is seeing them in action at a Clipsal Display Centre.

Product stock may vary according to location. If you're after a specific product range, please check with your chosen location before visiting.

10 Results
    Load More Load Complete
    Change Location

    How to animate embedded lists SQL queries

    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 replaces 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.
     

    Didn’t find what you were looking for?

    Try Searching Again View Our Categories

    Need further assistance?

    Our Customer Care department provides total customer service solutions for our residential, industrial and commercial applications.

    Get Assistance