SQLTags alerting - custom expression message
| Author |
Message |
|
nathan
Moderator
Joined: Thu Mar 30, 2006 10:08 pm
Posts: 909
|
 SQLTags alerting - custom expression message The custom message supports expressions that can contain other tag values. For example. Fan_temp > { temp_sp} Send "The east section fan temperature is {fan_temp}" Requested here.
_________________
Nathan Boeger
Not Another Industrial Blog - My SCADA software blog
Inductive Automation - Specializing in SQL data loggers and web based/Java HMI systems
"Design Simplicity Cures Engineered Complexity"
Send me feedback on FactorySQL and FactoryPMI online training videos.
|
| Fri Jul 10, 2009 4:52 pm |
  |
 |
|
david_mccutchen
Colonel
Joined: Wed Jan 28, 2009 4:15 pm
Posts: 131
|
Re: SQLTags alerting - custom expression message This would be the "state_name" that needs dynamic properties. For example some alarm description with a captured sql tag value when the alarm went active like temp, speed, etc.
|
| Fri Jul 10, 2009 6:12 pm |
|
|
|
chris_d_sanders
Major
Joined: Tue Sep 23, 2008 5:07 am
Posts: 108
Location: Ardmore, Oklahoma
|
Re: SQLTags alerting - custom expression message David and I have discussed that at GREAT length. What would be VERY useful would be having the option to DYNAMICALY add "Columns" to an SQL tag. Meaning, in alarmlog, you have a FIXED array of columns, but wouldn't it be handy to be able to add additional columns to your table and have the option in an SQL tag to save VALUES to that column along with what is already logged.
|
| Mon Nov 09, 2009 10:12 am |
 |
|
|
Carl.Gould
Moderator
Joined: Sun Apr 02, 2006 2:46 pm
Posts: 2517
Location: Sacramento, CA
|
Re: SQLTags alerting - custom expression message Yeah, we've been discussing this internally a lot in the last few weeks too. We're mulling over the best way to implement this.
_________________
Carl Gould
Software Development
Inductive Automation
|
| Mon Nov 09, 2009 8:06 pm |
|
|
|
chris_d_sanders
Major
Joined: Tue Sep 23, 2008 5:07 am
Posts: 108
Location: Ardmore, Oklahoma
|
Re: SQLTags alerting - custom expression message Made any head way on this guys?? This would be a VERY powerful tool.
|
| Thu Nov 19, 2009 10:08 pm |
|
|
|
Carl.Gould
Moderator
Joined: Sun Apr 02, 2006 2:46 pm
Posts: 2517
Location: Sacramento, CA
|
Re: SQLTags alerting - custom expression message Yeah, we figured out how it would work, but we're a bit snowed under with all of our existing obligations for the next release. Expect it shortly after.
_________________
Carl Gould
Software Development
Inductive Automation
|
| Sat Nov 21, 2009 3:00 pm |
|
|
|
chris_d_sanders
Major
Joined: Tue Sep 23, 2008 5:07 am
Posts: 108
Location: Ardmore, Oklahoma
|
Re: SQLTags alerting - custom expression message Just looking for an update on creating custom columns in the ALERT_LOG table and writing OPC or SQLTags to that column.
If need be, we could move this discussion to the Ignition! board
|
| Mon Jul 12, 2010 11:19 am |
|
|
|
Carl.Gould
Moderator
Joined: Sun Apr 02, 2006 2:46 pm
Posts: 2517
Location: Sacramento, CA
|
Re: SQLTags alerting - custom expression message Alerting will be receiving some major upgrades sometime in the next 6 months (in Ignition, that is). Storing extra data points along with the alert will certainly be part of this upgrade. Stay tuned!
_________________
Carl Gould
Software Development
Inductive Automation
|
| Tue Jul 20, 2010 9:09 am |
|
|
|
david_mccutchen
Colonel
Joined: Wed Jan 28, 2009 4:15 pm
Posts: 131
|
Re: SQLTags alerting - custom expression message Awesome, thanks for getting this in.
|
| Tue Jul 20, 2010 9:33 am |
|
|
|
