Industry Online Support
Technical Forum
1/28/2014 7:25 AM | |
Joined: 10/3/2010 Last visit: 6/14/2024 Posts: 1552 Rating: (188) |
You can manipulate the AlarmControl with its properties "DefaultMsgFilterSQL" and "MsgFilterSQL". DefaultMsgFilterSQL is an SQL statement for a fixed selection of alarms. With MsgFilterSQL you can add custom selections. Both properties are logically combined as "AND". You can change MsgFilterSQL dynamically with vbs script but the control doesn't really have a direct property for only manipulating starttime and endtime. You have to build a working SQL string and write this to MsgFilterSQL-property. Something your SQLFilter to write to MsgFilterSQL should look similar to: DATETIME >= startDNTpicker.value AND DATETIME <=endDNTpicker.value becomes DATETIME >= '2014-01-20 8:00:00.000' AND DATETIME <= '2014-01-21 20:00:00.000' but you probably have to manipulate startDNTpicker.value and endDNTpicker.value first in a variable to a working SQL-datetime-format. Don't forget the single quotes around the start and end time. Hope this is a litlle clear? |
B r g d s , |
|
Follow us on