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 Powerhouse 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

    Setting an SQL Query on an Embedded List in a Template

    DISCLAIMER

    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.


    It is common to have embedded lists in Templates that will show data that is relevant to each particular Instance. A way to achieve this is by setting the proper animation in the "Sql" property of the embedded mimic. For example, lets show a list with all point names (FulName) and values (CurrentValueFormatted) that are in each Instance. We can create an embedded list on a mimic right below the Group Template and configure its "Sql" property:





    For clarity, the "Sql" expression is reproduced below:

    'SELECT Id, FullName, CurrentValueFormatted from CDBPoint where FullName LIKE '''+".FullName" + '.%'''

    This expression makes the embedded list to show all entries from the CDBPoint table that have a "FullName" value that starts with the "FullName" of the group that contains the mimic, which is, by design, the Group Instance name once the instance is created.
    Below an example of the results on an instance:






     

    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