Technical FAQs

Ask a Question

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:






 
Was this helpful?
What can we do to improve the information ?