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
353808posts

[Imported] Creation of a SQL filter button

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.

Solved
sbeadle
Janeway Janeway
Janeway
0 Likes
1
368

[Imported] Creation of a SQL filter button

>>Message imported from previous forum - Category:ClearSCADA Software<<
User: KylePaynter123, originally posted: 2019-09-18 16:29:58 Id:518
Good Day guys,

I'm trying to create a button to filter a SQL query for example

I have a query that shows all alarms for Loss of power, but I want to add a filter button to search description of the location.


thanks guys


Accepted Solutions
sbeadle
Janeway Janeway
Janeway
0 Likes
0
366

Re: [Imported] Creation of a SQL filter button

>>Responses imported from previous forum


Reply From User: BevanWeiss, posted: 2019-09-18 21:45:32
There are two main ways to do this:
1) Have the SQL query as an animation
2) Use scripting to change the SQL query

My recommendation is option 1.
You would likely want to look into the REGISTRY() animation method, and then you can use Pick Actions on the buttons to set appropriate entries in the Registry which then influence the SQL query... simples... 😉


Reply From User: du5tin, posted: 2019-09-27 14:00:45
+1 for Bevan's note. We use option 1 all the time. It is robust and fast. Option 2 is prone to breakage on object renames, depending on how you put your script together.

See Answer In Context

1 Reply 1
sbeadle
Janeway Janeway
Janeway
0 Likes
0
367

Re: [Imported] Creation of a SQL filter button

>>Responses imported from previous forum


Reply From User: BevanWeiss, posted: 2019-09-18 21:45:32
There are two main ways to do this:
1) Have the SQL query as an animation
2) Use scripting to change the SQL query

My recommendation is option 1.
You would likely want to look into the REGISTRY() animation method, and then you can use Pick Actions on the buttons to set appropriate entries in the Registry which then influence the SQL query... simples... 😉


Reply From User: du5tin, posted: 2019-09-27 14:00:45
+1 for Bevan's note. We use option 1 all the time. It is robust and fast. Option 2 is prone to breakage on object renames, depending on how you put your script together.