{}

Our Brands

Impact-Company-Logo-English Black-01-177x54

Welcome to the Schneider Electric Website

Welcome to our website.
Search FAQs
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:






Schneider Electric Canada

Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.