Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel

[Imported] Relative References in Embedded Lists Query Tab

EcoStruxure Geo SCADA Expert Forum

Find out how SCADA systems and networks, like EcoStruxure Geo SCADA Expert, help industrial organizations maintaining efficiency, processing data for smarter decision making with IoT, RTU and PLC devices.

Janeway Janeway

[Imported] Relative References in Embedded Lists Query Tab

>>Message imported from previous forum - Category:Scripts and Tips<<
User: mchartrand, originally posted: 2018-10-25 18:56:39 Id:272
This is a re-posting from the obsoleted (October 2018) "Schneider Electric Telemetry & SCADA" forum.


Hi Guys,
Do embedded lists support relative references? I will like to search for Points in the Current Folder with the text "Run" in the Fullname.
My WHERE syntax doesn't appear correct._**

"FullName" AS "~FullName", "Id", "Foreground", "Blink", "Background", "CurrentStateDesc", "CurrentQualityDesc"
"FullName" LIKE '..Fullname.%Run%'
"~FullName" ASC_



Hi Chadam,

Relative references can done through animations of List.

Double click the list and click animations. Now in the sql property enter the following:

'SELECT "FullName" AS "~FullName", "Id", "Foreground", "Blink", "Background", "CurrentStateDesc", "CurrentQualityDesc" FROM CDBPOINT WHERE Fullname Like ''' + ".FullName" +'.%Run%'' ORDER BY "~FullName" ASC'

You can view the populated query with actual value of the relatively refered fullname in the Query tab.

Not sure if there's any other workaround, ideally this should work


Cheers ! 🙂


A little trick that I find useful when doing this, is to break up the lines in the animation expression by putting the + at the end of each line. It makes it much more readable when you have to make long queries in an animation.


aneeskp's query could become:

_'SELECT "FullName" AS "~FullName", "Id", "Foreground", "Blink", "Background", "CurrentStateDesc", "CurrentQualityDesc" ' +
'WHERE Fullname Like ''' + ".FullName" +'.%Run%'' ' +
'ORDER BY "~FullName" ASC'_


You guys are legends. Works like a charm. Thanks for the quick responses._**