WinCC V7: #2 VBScript | How to use SQL instruction to filter the messages to be displayed?
Вставка
- Опубліковано 28 сер 2024
- 💰 SCADA mini-course 💰 : myscadaworld.c...
💰 WinCC V7 Installation: myscadaworld.c...
💰 WinCC Level 1: myscadaworld.c...
👍 HMI SCADA FB Group: myscadaworld.c...
💰 Our products: myscadaworld.c...
WinCC V7: Tip#2 VBScript WinCC Alarm Control. How to use SQL instruction to filter the messages to be displayed?
MsgFilterSQL
------------------------------------------------------------------------------------------------------------------------------------------
👑UA-cam: www.youtube.co....
👩👨 Facebook: / myscadaworld
☑ Blog details: www.MyScadaWor...
📕 Amazon: www.amazon.com....
---------------------------------------------------------------------------------------------------------------------------------------------
#SCADA
#WinCC
#MyScadaWorld
#Industrial
#automation
#PLC
If you need more just give me a comment!
Great, please upload the script more and more :)
I'll try my best 💪
thank you for the video, how can i filter the alarm messages based on a variable "contains text" instead of a static text ?
I mean to write a code in VBA or C that filters based on variable motor_name , and the motor_name is a string
Hi, thank you for the tutorial. Worked perfectly for me. Allows me to filter alarm messages between different machines on site. One question, is there a way to do a similar thing for OnlineTableControls? I have lines and lines of data in one of my OnlineTables and I'd like to be able to filter by keywords like machine IDs, product codes etc.
Yes you can select data in tables too
@@SCADAWorld I have run the same script for OnlineTableControls but I cannot find the "Text1" equivalent in OnlineTableControls. Like you found "Text1" was the property name for the column in the alarm table. I need to know what the property name for each value column on the OnlineTableControl. Where can I find that?
Hello there. I’m trying to get this script to work on the short duration archive list, and not only on the alarm list. Do you know how could I do that?
Thanks a lot!
Nevermind, I found it.
Using % instead of * does the trick (although I have no idea why)
Cheerio!
i dont know too :) didint try with shorts
WinCC V7: #2 VBScript | How to use SQL instruction to filter the messages to be displayed?
.
.
.
.
.
.
.
.
.
opens c editor
edit:
in VBS it would be
ScreenItems("Control1").MsgFilterSql = "TEXT1 LIKE 'valve1*'"
Yep 🔥
It didn't work for me on v7.5, i had to use '%' instead of '*'
It depends of regional settings 👍
hi, so what if i want to filter by start and end time?
Yep its possible. You need to change filter for datetime 👍
How can I do something like this: Text1 LIKE 'valve1' AND Text2 LIKE 'PLC02'
Hi.
Exactly same as you did 🔥
You can make them and or etc.
@@SCADAWorld OR and AND not works with condition text contains a string. So a I have to create new message group where is only text PLC01, PLC02 and now it is working with Text1 IN ('PLC01','PLC02')
Hmm good to know. Anyway i'll check it for my own why its not working with and