# R/W Access to Internal SQLTag DB AlertExecEnabled Property **URL:** \ **Category:** Ignition\ **Created:** [September 8, 2011, 12:41am UTC](https://forum.inductiveautomation.com/t/r-w-access-to-internal-sqltag-db-alertexecenabled-property/3265 "2011-09-08T00:41:45Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![MadMax](https://avatars.discourse-cdn.com/v4/letter/m/8baadc/32.png) [@MadMax](https://forum.inductiveautomation.com/u/MadMax)\ **Post date:** [September 8, 2011, 12:41am UTC](https://forum.inductiveautomation.com/t/r-w-access-to-internal-sqltag-db-alertexecenabled-property/3265/1 "2011-09-08T00:41:45Z")
A project I’m working on needs the ability to query and disable/enable alert properties for given SQLTags. Ultimately I think comprehensive internal DB access should be provided with a group of script and expression functions, but lacking that I will just ask for bits and pieces. See related request [http://inductiveautomation.com/forum/viewtopic.php?f=71&t=6833](http://inductiveautomation.com/forum/viewtopic.php?f=71&t=6833). BTW - I cannot replicate the former SCADA’s “Disable Alarm” feature, among others, without this level of access. This is more than important, it is imperative. ---
**Author:** ![nathan](https://avatars.discourse-cdn.com/v4/letter/n/c5a1d2/32.png) [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Post date:** [September 8, 2011, 3:36am UTC](https://forum.inductiveautomation.com/t/r-w-access-to-internal-sqltag-db-alertexecenabled-property/3265/2 "2011-09-08T03:36:11Z")
Are you trying to disable all alarms at once or individually? I suspect that you could change your alert configurations to support this requirement either way. It may be tedious, but should be possible. How many such alerts are set up? I won’t discredit your feature request, though. ---
**Author:** ![MadMax](https://avatars.discourse-cdn.com/v4/letter/m/8baadc/32.png) [@MadMax](https://forum.inductiveautomation.com/u/MadMax)\ **Post date:** [September 8, 2011, 3:29pm UTC](https://forum.inductiveautomation.com/t/r-w-access-to-internal-sqltag-db-alertexecenabled-property/3265/3 "2011-09-08T15:29:08Z")
With their old SCADA, they can select an alarm (alert) on their alarm screen, then enter a Ctrl-key to disable or re-enable that alarm. It’s à la carte, one at a time. They also have a window that keeps track of all disabled alarms. In my roll-your-own alert table, the tag path is part of the table, making it trivial (with maybe a right click) to access the AlertExecEnabled property, if a function existed that could get/put internal DB SQLTag properties. So close but yet so far… ---
**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Post date:** [September 8, 2011, 5:42pm UTC](https://forum.inductiveautomation.com/t/r-w-access-to-internal-sqltag-db-alertexecenabled-property/3265/4 "2011-09-08T17:42:08Z")
You can write to the AlertExecProperty: ```auto system.tag.writeToTag('Path/To/Tag.AlertExecEnabled',0) ``` You can bi-directionally bind the property to a component… try dragging it on the screen and make a two-state toggle. Am I missing something? Regards, ---
**Author:** ![MadMax](https://avatars.discourse-cdn.com/v4/letter/m/8baadc/32.png) [@MadMax](https://forum.inductiveautomation.com/u/MadMax)\ **Post date:** [September 8, 2011, 6:43pm UTC](https://forum.inductiveautomation.com/t/r-w-access-to-internal-sqltag-db-alertexecenabled-property/3265/5 "2011-09-08T18:43:33Z")
No, I was missing something. The manual does not mention tag properties in the function call syntax or example. So I can now globally assume whenever tagPath is a function parameter that ALL properties are available to that function? If so, I can work with that. Looking forward to returned datasets for these functions. Still need the ability to query SQLTag properties based on other SQLTag properties, such as: Return a dataset (based on a partial or full tagPath), with a list of returned properties I need, where AlertExecEnabled = 0. I appreciate all you do to make Ignition robust and SI friendly! 🙂 ---
**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Post date:** [September 8, 2011, 8:39pm UTC](https://forum.inductiveautomation.com/t/r-w-access-to-internal-sqltag-db-alertexecenabled-property/3265/6 "2011-09-08T20:39:31Z")
Good, so we’re halfway there. You’re right, you can’t currently search for tags that match a condition, though I’m sure that could be accomodated one way or another. Yes, a “tag path” is defined as “[Source]Path/Tag.Property”, where source is optional (when in a project- will be set to project default), and property is optional (will be assumed to be Value). So, anywhere you can use tag paths, you can specify properties. Most properties are writable. Some aren’t, like the current alert state, quality, last change, etc. If you write to a config property, it should change the value and reload the tag if necessary. Regards, ---
**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Post date:** [September 8, 2011, 8:40pm UTC](https://forum.inductiveautomation.com/t/r-w-access-to-internal-sqltag-db-alertexecenabled-property/3265/7 "2011-09-08T20:40:53Z")
Ah, according to [this thread](http://inductiveautomation.com/forum/viewtopic.php?f=70&t=6794), the multi-path compatible function will actually be in 7.2.9. Regards,