Hyperlink over Instances produced by any Template

[abdullah123456789]

Hello, 

In Geo SCADA Expert 2021 i must create a hyperlink for a button. This button has to be redirected me to Alarm List. But this Alarm List should only list alarms on the page with the button. And also, this page is an instance created from any template. So i think i should use "Relative" options in Hyperlink.

In Geo SCADA Help Page, I've found some information and tried them. The format I should use according to the Help Page is: SCX:///<system>/AlarmList/<filter1>="<value1>"&<filter2>="<value2>". I've tried it but when i tried to use this format, i didn't activate the "Relative" options. Can you help me about find the correct format or can you explain what is what in the above format? I'm sharing the format i type.

Also i search about where is the Alarm List in the home page but didn't find anything. Where is the source of this list in Geo SCADA? I guess the source of this list can help me. I am sharing the part I mentioned below.

[AndrewScott · Accepted solution]

To filter the alarm list by source you need to use the "Source" filter, for example:

SCX:////AlarmList/Source="R_FE_PR_BKV_PE_R"

The alarm list doesn't support relative sources as the alarm list is global to the whole system so there is nothing to be relative to.

To create a hyperlink with a relative source path would require you to animate the "PickParam" property to build up the URL, something like:

'SCX:////AlarmList/Source="' + ".R_FE_PR_BKV_PE_R.FullName" + '.*"'

Note, the relative tag in the middle of the string which evaluates to the full name (absolute path) of the source.

[abdullah123456789]

Thanks for your help. So is it possible to filter the Event List in a similar way?

[AndrewScott]

The event journal is accessed using an SQL query. You can use the same technique to build the WHERE clause of the SQL query in the "PickParam" animation:

'SCX:////List/Title="Events"&InitialSQL="SELECT TOP( 1000000 ) ""RecordId"", ""SeverityDesc"" AS ""~SeverityDesc"", ""RecordTime"" AS ""~RecordTime"", ""Source"", ""Message"", ""User"", ""Category"", ""Foreground"", ""SeqNo"", ""CommentNo"" FROM CDBEVENTJOURNAL WHERE ( ""~RecordTime"" BETWEEN { OPC ''H-23H'' } AND { OPC ''H+1H'' } ) AND ( ""Source"" LIKE ''' + ".R_FE_PR_BKV_PE_R.FullName" + '.%'' ) ORDER BY ""~RecordTime"" DESC, ""SeqNo"" DESC, ""CommentNo"" ASC"'

Note, the escaping of single quotes in the query and the relative tag used for the "Source" column constraint.

The downside to this is the whole query is copied into the hyperlink, so it won't automatically pick up any changes to the event list settings.