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.

Close
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
84549members
353812posts

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

sbeadle
Janeway Janeway
Janeway
0 Likes
0
274

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

_______

**_Chadam:
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._**

_SELECT
"FullName" AS "~FullName", "Id", "Foreground", "Blink", "Background", "CurrentStateDesc", "CurrentQualityDesc"
FROM
CDBPOINT
WHERE
"FullName" LIKE '..Fullname.%Run%'
ORDER BY
"~FullName" ASC_

___________________________

aneeskp:

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 ! 🙂

________________________

dmercer:
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" ' +
'FROM CDBPOINT ' +
'WHERE Fullname Like ''' + ".FullName" +'.%Run%'' ' +
'ORDER BY "~FullName" ASC'_

___________________________

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