Skip to Content

SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

SiePortalDeutsch

Search

Home
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menu temporary not available
- Menue temporary not available
- {{item.title}}

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

V12 TIA MsgFilterSql options

Created by: Enia at: 7/24/2013 10:49 AM (5 Replies)

Rating (2)

Thanks 4

6 Entries

7/24/2013 10:49 AM	Rate (1)
Enia Experienced Member Joined: 9/12/2008 Last visit: 10/21/2023 Posts: 73 Rating: (2)	Hi, I found a example how to use MsgFilterSql but the information isn't enough to make a good filter. I want to view the records between 2 dates, so my question is, how can i do that with the MsgFiltersql command? Example: Sub Filter Dim objAlarmControl 'create reference to AlarmControl Set objAlarmControl = ScreenItems("Control2") 'set / reset the filter and create a trace If (objAlarmControl.MsgFilterSQL = "") Then objAlarmControl.MsgFilterSQL = "MSGNR = 2" Else objAlarmControl.MsgFilterSQL = "" End If End Sub Thank you.
	Last edited by: Enia at: 7/24/2013 10:52 AM
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users AutoGen_2519079

7/25/2013 2:24 PM	Rate (1)
Enia Experienced Member Joined: 9/12/2008 Last visit: 10/21/2023 Posts: 73 Rating: (2)	And i found it: 9.3.6.7 SQL Statements for Filtering the Alarm View In the WinCC professional V12 manual Permissible Arguments Name SQL name Type Data Example Date/time DATETIME Date 'YYYY-MM-DD hh:mm:ss.msmsms' DATETIME >= '2007-05-03 16:00:00.000' Outputs alarms as of 05/03/2007, 16:00 hours. Number MSGNR Integer Alarm number MSGNR >= 10 AND MSGNR <= 12 Outputs the alarms with alarm numbers 10 - 12. Class CLASS IN Integer Alarm class ID 1-256 and "System" alarm classes 17 + 18 CLASS IN ( 1 ) Outputs alarms of alarm class 1. Status STATE Integer Value "ALARM_STATE_xx" Only the operands "=" and "IN(...)" are permitted. ALARM_STATE_1 ALARM_STATE_2 ALARM_STATE_3 ALARM_STATE_4 ALARM_STATE_10 ALARM_STATE_11 ALARM_STATE_16 ALARM_STATE_17 STATE IN(1,2,3) Outputs all alarms that came in, went out and were acknowledged. Possible values: 1 = incoming alarms 2 = outgoing alarms 3 = acknowledged alarms 4 = blocked alarms 10 = hidden alarms 11 = displayed alarms 16 = alarms acknowledged by the system 17 = Emergency-acknowledged alarms

Suggestion To thank Quote Answer
This contribution was helpful to 3 thankful Users O_Moderator schnautz rsmoreno

12/3/2014 9:23 PM	Rate (0)
schnautz Posts: 3 Rating: (0)	I'm also interested in filtering messages using the 'Alarm filter SQL statement' In the Alarm Control properties, I can set a filter to only show alarms where 'user text block 2' contains specific text. This lets me search for alarms that start with '<area1>' and hide all others. Is there a way to do this through the SQL filter instead, so I can dynamically filter for varying text? For what it's worth, I want a single Alarm Control that will dynamically show only the messages that the Current User/Group is allowed to view. I'm open to using some other field, as long as it's configurable from the PLC's 'program alarm' function. Thanks! Ken
schnautz Posts: 3 Rating: (0)
Suggestion To thank Quote Answer

12/13/2015 9:37 PM	Rate (0)
Levanteam Posts: 2 Rating: (0)	I am trying to do that. Did you find out how?! Please let me know ASAP as my project has to be completed. Thanks, Jamal
Levanteam Posts: 2 Rating: (0)
Suggestion To thank Quote Answer

5/14/2025 8:10 AM	Rate (0)
rsmoreno Joined: 9/9/2024 Last visit: 6/25/2025 Posts: 2 Rating: (0)	Thanks! this solved it for me
	Last edited by: rsmoreno at: 05/14/2025 08:11:40
Suggestion To thank Quote Answer

5/15/2025 6:16 AM	Rate (0)
bit7 Experienced Member Joined: 7/26/2008 Last visit: 9/9/2025 Posts: 109 Rating: (20)	Hi Enia, I prepared a comprehensive example project to incorporate all the arguments available to generate a MSGFilterSQL, but used TIA V19. I found displaying the MSGFilterSQL in runtime with manual filter inputs greatly assists with the correct syntax. I attach the filter vb script for possible assistance but the script will be most useful in the context of the example project. I could not figure out the first argument, limiting the number of alarms. Attachment 0515_Script.txt (86 Downloads)
	Last edited by: Moderator_Lan at: 05/15/2025 07:18:39 Script attached
Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Related topics by keywords:

TIA WinCC Prof System functions/Scripting

Follow us on