# SQLTags alerting - custom expression message **URL:** \ **Category:** Archived Topics\ **Created:** [July 11, 2009, 12:52am UTC](https://forum.inductiveautomation.com/t/sqltags-alerting-custom-expression-message/1215 "2009-07-11T00:52:21Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![nathan](https://avatars.discourse-cdn.com/v4/letter/n/c5a1d2/32.png) [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Post date:** [July 11, 2009, 12:52am UTC](https://forum.inductiveautomation.com/t/sqltags-alerting-custom-expression-message/1215/1 "2009-07-11T00:52:21Z")
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](http://www.inductiveautomation.com/forum/viewtopic.php?f=14&t=4429&p=8913#p8913). ---
**Author:** ![david\_mccutchen](https://avatars.discourse-cdn.com/v4/letter/d/919ad9/32.png) [@david\_mccutchen](https://forum.inductiveautomation.com/u/david_mccutchen)\ **Post date:** [July 11, 2009, 2:12am UTC](https://forum.inductiveautomation.com/t/sqltags-alerting-custom-expression-message/1215/2 "2009-07-11T02:12:25Z")
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. ---
**Author:** ![chris\_d\_sanders](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/chris_d_sanders/32/3359_2.png) [@chris\_d\_sanders](https://forum.inductiveautomation.com/u/chris_d_sanders)\ **Post date:** [November 9, 2009, 6:12pm UTC](https://forum.inductiveautomation.com/t/sqltags-alerting-custom-expression-message/1215/3 "2009-11-09T18:12:44Z")
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. ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [November 10, 2009, 4:06am UTC](https://forum.inductiveautomation.com/t/sqltags-alerting-custom-expression-message/1215/4 "2009-11-10T04:06:40Z")
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. ---
**Author:** ![chris\_d\_sanders](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/chris_d_sanders/32/3359_2.png) [@chris\_d\_sanders](https://forum.inductiveautomation.com/u/chris_d_sanders)\ **Post date:** [November 20, 2009, 6:08am UTC](https://forum.inductiveautomation.com/t/sqltags-alerting-custom-expression-message/1215/5 "2009-11-20T06:08:21Z")
Made any head way on this guys?? This would be a VERY powerful tool. ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [November 21, 2009, 11:00pm UTC](https://forum.inductiveautomation.com/t/sqltags-alerting-custom-expression-message/1215/6 "2009-11-21T23:00:51Z")
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. ---
**Author:** ![chris\_d\_sanders](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/chris_d_sanders/32/3359_2.png) [@chris\_d\_sanders](https://forum.inductiveautomation.com/u/chris_d_sanders)\ **Post date:** [July 12, 2010, 7:19pm UTC](https://forum.inductiveautomation.com/t/sqltags-alerting-custom-expression-message/1215/7 "2010-07-12T19:19:50Z")
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 ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [July 20, 2010, 5:09pm UTC](https://forum.inductiveautomation.com/t/sqltags-alerting-custom-expression-message/1215/8 "2010-07-20T17:09:38Z")
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! ---
**Author:** ![david\_mccutchen](https://avatars.discourse-cdn.com/v4/letter/d/919ad9/32.png) [@david\_mccutchen](https://forum.inductiveautomation.com/u/david_mccutchen)\ **Post date:** [July 20, 2010, 5:33pm UTC](https://forum.inductiveautomation.com/t/sqltags-alerting-custom-expression-message/1215/9 "2010-07-20T17:33:36Z")
Awesome, thanks for getting this in. ---
**Author:** ![chris\_d\_sanders](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/chris_d_sanders/32/3359_2.png) [@chris\_d\_sanders](https://forum.inductiveautomation.com/u/chris_d_sanders)\ **Post date:** [August 5, 2011, 7:27pm UTC](https://forum.inductiveautomation.com/t/sqltags-alerting-custom-expression-message/1215/10 "2011-08-05T19:27:16Z")
Carl, David and myself are wondering what the status of this feature is. ---
**Author:** ![chris\_d\_sanders](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/chris_d_sanders/32/3359_2.png) [@chris\_d\_sanders](https://forum.inductiveautomation.com/u/chris_d_sanders)\ **Post date:** [August 18, 2011, 6:20pm UTC](https://forum.inductiveautomation.com/t/sqltags-alerting-custom-expression-message/1215/11 "2011-08-18T18:20:11Z")
Anything? ![:scratch:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/76d1620bec252bfac07050c889ff5a91dc8a9c25.gif ":scratch:") ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [September 9, 2011, 5:55pm UTC](https://forum.inductiveautomation.com/t/sqltags-alerting-custom-expression-message/1215/12 "2011-09-09T17:55:23Z")
Sorry - the Alerting redux had to be postponed until after Ignition 7.3. We don’t have a hard timeframe on it yet. ---
**Author:** ![zxcslo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zxcslo/32/61610_2.png) [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Post date:** [January 20, 2013, 10:38am UTC](https://forum.inductiveautomation.com/t/sqltags-alerting-custom-expression-message/1215/13 "2013-01-20T10:38:54Z")
Is there any news about this? I’m trying Ignition 7.5.5 and I still doesn’t see that option… ☹ ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [January 21, 2013, 3:54pm UTC](https://forum.inductiveautomation.com/t/sqltags-alerting-custom-expression-message/1215/14 "2013-01-21T15:54:00Z")
It looks like we will have those features in February this year. ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [January 21, 2013, 5:14pm UTC](https://forum.inductiveautomation.com/t/sqltags-alerting-custom-expression-message/1215/15 "2013-01-21T17:14:02Z")
Ignition 7.6, which is currently entering private beta, is our “Alarming” release. It has the features mentioned above such as custom fields on an alarm that can “capture” the values of other tags at the time of the alarm. Release will most likely be in March. ---
**Author:** ![zxcslo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zxcslo/32/61610_2.png) [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Post date:** [January 21, 2013, 7:35pm UTC](https://forum.inductiveautomation.com/t/sqltags-alerting-custom-expression-message/1215/16 "2013-01-21T19:35:27Z")
Great. ![:thumb_left:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/e26afb081ddde6df016df6ee49159cf56aaca688.gif ":thumb\_left:") Can you perhaps give us a little info about what else will be in this 7.6 release? ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [January 21, 2013, 9:17pm UTC](https://forum.inductiveautomation.com/t/sqltags-alerting-custom-expression-message/1215/17 "2013-01-21T21:17:44Z")
I don’t want to spill the beans here. Stay tuned, we’ll have some communication coming.