How to use a button to change an embedded list query in GeoSCADA 2021

[DShah912]

I created an embedded list with a query that allows me to display the point updates of all the historic data within a 12 hour time frame. I want to create a button that allows me to change the time frame to 1 hour whenever I press it. My goal is when I click the button the list updates to the data from the last hour. I tried using a mimic parameter and putting that parameter name within the query where the timeaddstamp is, but nothing is working. The finished product will have multiple buttons with different times so that the user can decide what time frame they want.

Any help would be much appreciated!

[CraigEl]

@DShah912 it might help if you specify what product you are working with.

[sbeadle]

This is Geo SCADA - see the title.

Use a script triggered by your button to change the SQL.

Use a line like this to set your SQL to a string variable:

Mimic.Layers(LayerName ).Item(ListName ).SQL = SQL

LayerName could be "New Layer" and ListName could be "Lst_1" depending on your mimic items.

[Hardin4019 · Accepted solution]

To expand on what Steve said. This is one suggested way of accomplishing a List Box with an adjustable Start Time:

• Create a String Variable in the same Group as the points you are working with (I called mine Start Time).
• Put buttons on the Mimic with
  • Pick Action = Method,
  • select Start Time or whatever you name your variable
  • then Set Value.
    • Set the expression to whatever starting time interval you want (one interval per button).
    • Example 'H-1H', 'H-6H', 'H-12H', etc.
• Pass the Start Time Variable into the SQL Query animation for the list box (see picture with the SQL Animation).
• My example below I passed both ".Start Time.Value" and ".FullName"+'.%' into the SQL Animation so that this can be copied into any group, or included in a template and it SHOULD automatically work. There might be a little goofiness the first time you open the mimic if the Start Time variable has no value.