# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1607 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1608 --- ## [Alarm acknowledgment for multiple alarms from the same tag](https://forum.inductiveautomation.com/t/alarm-acknowledgment-for-multiple-alarms-from-the-same-tag/19834)
**Author:** [@mcarritt1](https://forum.inductiveautomation.com/u/mcarritt1)\ **Replies:** 0\ **Last updated:** [September 26, 2018, 12:52pm UTC](https://forum.inductiveautomation.com/t/alarm-acknowledgment-for-multiple-alarms-from-the-same-tag/19834 "2018-09-26T12:52:45Z")
I scripted out some things to use a 3rd party service to notify operators about alarms. The only problem I'm having is in the following scenario: Tag A goes in to alarm, then clears. (We'll call this alarm 1). Tag A… --- ## [Unexpected writing to memory array tags](https://forum.inductiveautomation.com/t/unexpected-writing-to-memory-array-tags/19799)
**Author:** [@derek.neilson](https://forum.inductiveautomation.com/u/derek.neilson)\ **Replies:** 3\ **Last updated:** [September 26, 2018, 11:35am UTC](https://forum.inductiveautomation.com/t/unexpected-writing-to-memory-array-tags/19799 "2018-09-26T11:35:56Z")
I have a script where I read the value of a memory array tag. I then manipulate the data in my script. I am finding that the value of the tag is being modified by the script even without using system.tag.write() I'm us… --- ## [Alarm Acknowledgement Handshake to PLC](https://forum.inductiveautomation.com/t/alarm-acknowledgement-handshake-to-plc/3917)
**Author:** [@jon\_wootton](https://forum.inductiveautomation.com/u/jon_wootton)\ **Replies:** 13\ **Last updated:** [September 26, 2018, 5:19am UTC](https://forum.inductiveautomation.com/t/alarm-acknowledgement-handshake-to-plc/3917 "2018-09-26T05:19:22Z")
I have my PLC code setup to receive an alarm acknowledgement from the SCADA. Without it the alarm that is latched in the PLC will not clear. Is there a way to bind a tag to an alarm so that the ACK will be turned on on… --- ## [Change power table column background color based on whether Editable enabled](https://forum.inductiveautomation.com/t/change-power-table-column-background-color-based-on-whether-editable-enabled/19817)
**Author:** [@bebel](https://forum.inductiveautomation.com/u/bebel)\ **Replies:** 0\ **Last updated:** [September 25, 2018, 5:35pm UTC](https://forum.inductiveautomation.com/t/change-power-table-column-background-color-based-on-whether-editable-enabled/19817 "2018-09-25T17:35:10Z")
I ma trying to find a way to gray out columns that can not be edited. This seems to be a standard practice for all windows programs so I am surprised that I cannot find any information on how to do this. --- ## [Fill colour look up table issue](https://forum.inductiveautomation.com/t/fill-colour-look-up-table-issue/19646)
**Author:** [@john.eichler](https://forum.inductiveautomation.com/u/john.eichler)\ **Replies:** 1\ **Last updated:** [September 26, 2018, 1:17am UTC](https://forum.inductiveautomation.com/t/fill-colour-look-up-table-issue/19646 "2018-09-26T01:17:56Z")
Ignition version : 7.9.7 PLC: Siemens S7-1200 Hi. I use a state variable from our PLCs to animate the icon for the device in question. Today I noticed some strange behavior. State variable and intended colour assignm… --- ## [Failing to catch exceptions from smart card reader](https://forum.inductiveautomation.com/t/failing-to-catch-exceptions-from-smart-card-reader/19819)
**Author:** [@Claus\_Nielsen](https://forum.inductiveautomation.com/u/Claus_Nielsen)\ **Replies:** 5\ **Last updated:** [September 25, 2018, 7:56pm UTC](https://forum.inductiveautomation.com/t/failing-to-catch-exceptions-from-smart-card-reader/19819 "2018-09-25T19:56:56Z")
Hi all, Working on a script for using smart card readers with my application using the javax.smartcardio package. However the huge amount of exceptions thrown here when reading from the smart card is 50% of the time no… --- ## [Change Text Field FOCUS Inner Border Color](https://forum.inductiveautomation.com/t/change-text-field-focus-inner-border-color/19822)
**Author:** [@raymond1982](https://forum.inductiveautomation.com/u/raymond1982)\ **Replies:** 0\ **Last updated:** [September 25, 2018, 7:34pm UTC](https://forum.inductiveautomation.com/t/change-text-field-focus-inner-border-color/19822 "2018-09-25T19:34:06Z")
Any way to change the default focus inner border color? its \[Orange\]. It seems that when the focus is gained a compound border is created and then replaced when the focus is lost. I need a way to hook in and change the c… --- ## [2 Radio buttons to control 1 boolean tag](https://forum.inductiveautomation.com/t/2-radio-buttons-to-control-1-boolean-tag/19821)
**Author:** [@dion.botha](https://forum.inductiveautomation.com/u/dion.botha)\ **Replies:** 1\ **Last updated:** [September 25, 2018, 7:23pm UTC](https://forum.inductiveautomation.com/t/2-radio-buttons-to-control-1-boolean-tag/19821 "2018-09-25T19:23:45Z")
Hi guys, Is it possible to control a boolean tag with 2 radio buttons? Regards, D.Botha --- ## [Button color on client](https://forum.inductiveautomation.com/t/button-color-on-client/19762)
**Author:** [@lyhkch](https://forum.inductiveautomation.com/u/lyhkch)\ **Replies:** 2\ **Last updated:** [September 25, 2018, 12:38pm UTC](https://forum.inductiveautomation.com/t/button-color-on-client/19762 "2018-09-25T12:38:01Z")
Hi , when I click button ,change it's color on one client , but when I use another client to check , this button color don't change. Why ? event.source.buttonBG = (71,255,71,255) event.source.parent.getComponent('bt\_un… --- ## [Reporting: combine data sources via scripting for chart dataset](https://forum.inductiveautomation.com/t/reporting-combine-data-sources-via-scripting-for-chart-dataset/19803)
**Author:** [@vanko25](https://forum.inductiveautomation.com/u/vanko25)\ **Replies:** 1\ **Last updated:** [September 25, 2018, 10:38am UTC](https://forum.inductiveautomation.com/t/reporting-combine-data-sources-via-scripting-for-chart-dataset/19803 "2018-09-25T10:38:04Z")
Hi all, I am having a report that I need to do for a client. I have various SQL queries that return single values to populate text boxes on the report. A pareto bar chart is also required to visually represent these v… --- ## [SQL query WHERE column = property value (string)](https://forum.inductiveautomation.com/t/sql-query-where-column-property-value-string/19794)
**Author:** [@dion.botha](https://forum.inductiveautomation.com/u/dion.botha)\ **Replies:** 1\ **Last updated:** [September 24, 2018, 10:37pm UTC](https://forum.inductiveautomation.com/t/sql-query-where-column-property-value-string/19794 "2018-09-24T22:37:41Z")
Hi guys, Can someone tell me why I can execute this SQL query: SELECT vsf\_grades.designator FROM vsf\_products INNER JOIN (vsf\_grades INNER JOIN vsf\_grade\_products ON vsf\_grades.db\_id = vsf\_grade\_products.vsf\_grades\_d… --- ## [Amy's Kitchen is looking for Ignition talent](https://forum.inductiveautomation.com/t/amys-kitchen-is-looking-for-ignition-talent/19793)
**Author:** [@brad.bowser](https://forum.inductiveautomation.com/u/brad.bowser)\ **Replies:** 0\ **Last updated:** [September 24, 2018, 8:57pm UTC](https://forum.inductiveautomation.com/t/amys-kitchen-is-looking-for-ignition-talent/19793 "2018-09-24T20:57:42Z")
Amy's Kitchen - the world leader in organic, vegetarian foods is looking for a full-time Applications Architect for Manufacturing Systems at our corporate headquarters, located in beautiful Petaluma, California. All Ign… --- ## [Pulling date range out of report table](https://forum.inductiveautomation.com/t/pulling-date-range-out-of-report-table/19791)
**Author:** [@christopher.raphael](https://forum.inductiveautomation.com/u/christopher.raphael)\ **Replies:** 2\ **Last updated:** [September 24, 2018, 8:36pm UTC](https://forum.inductiveautomation.com/t/pulling-date-range-out-of-report-table/19791 "2018-09-24T20:36:04Z")
Here is my code. Parameter TimeHolder is set to now(). I get an error: WARN: Simple Query could not be completed. Incorrect syntax near 'Sep' which is the current month but I don't know how to correct it. I can tell that… --- ## [Nested Historical Query in Report works, issues with Graphically Presenting Data](https://forum.inductiveautomation.com/t/nested-historical-query-in-report-works-issues-with-graphically-presenting-data/19769)
**Author:** [@dano38291](https://forum.inductiveautomation.com/u/dano38291)\ **Replies:** 1\ **Last updated:** [September 24, 2018, 7:15pm UTC](https://forum.inductiveautomation.com/t/nested-historical-query-in-report-works-issues-with-graphically-presenting-data/19769 "2018-09-24T19:15:09Z")
Hello, So I worked from the following post to get my Nested Child queries working. http://forum.inductiveautomation.com/t/report-with-scripted-nested-data/11801 Doing a few named queries using above idea. I am also … --- ## [Copy a record via a push button](https://forum.inductiveautomation.com/t/copy-a-record-via-a-push-button/19689)
**Author:** [@ssilk76](https://forum.inductiveautomation.com/u/ssilk76)\ **Replies:** 12\ **Last updated:** [September 24, 2018, 3:22pm UTC](https://forum.inductiveautomation.com/t/copy-a-record-via-a-push-button/19689 "2018-09-24T15:22:41Z")
I have a recipe table set up which services several machines. I have a transaction that is triggered by the PLC and uses a where clause for the part number to do a DB-\>OPC transfer. Everything works there, no problem. … --- ## [Find running process OR see if specific computer user logged in?](https://forum.inductiveautomation.com/t/find-running-process-or-see-if-specific-computer-user-logged-in/19786)
**Author:** [@StefanGronberg](https://forum.inductiveautomation.com/u/StefanGronberg)\ **Replies:** 2\ **Last updated:** [September 24, 2018, 1:39pm UTC](https://forum.inductiveautomation.com/t/find-running-process-or-see-if-specific-computer-user-logged-in/19786 "2018-09-24T13:39:26Z")
Hi. Which would be the best way to see if a specific .EXE is running or if a specific computer user where the gateway runs at, is logged in? Customer wish to see in the hmi weather the server is logged in (so a speci… --- ## [Database failover not working](https://forum.inductiveautomation.com/t/database-failover-not-working/19710)
**Author:** [@Andrew\_P](https://forum.inductiveautomation.com/u/Andrew_P)\ **Replies:** 2\ **Last updated:** [September 24, 2018, 8:56am UTC](https://forum.inductiveautomation.com/t/database-failover-not-working/19710 "2018-09-24T08:56:30Z")
Hi, I am having trouble with database failover. I have set up 3 connections: "a" (primary db) which is ok, "b" (secondary db) which is ok (and connecting to a different machine) and c which connects to the same db as "a… --- ## [Tag Browser Filtering](https://forum.inductiveautomation.com/t/tag-browser-filtering/19760)
**Author:** [@Andrew\_P](https://forum.inductiveautomation.com/u/Andrew_P)\ **Replies:** 6\ **Last updated:** [September 23, 2018, 1:41am UTC](https://forum.inductiveautomation.com/t/tag-browser-filtering/19760 "2018-09-23T01:41:33Z")
Does anyone know how to get filtering to work for UDTs on the Tag Browse Tree component? I want to filter on tags that contain a specific string. using the components builtin filter function, I can filter on tag name, … --- ## [Property Editor](https://forum.inductiveautomation.com/t/property-editor/19772)
**Author:** [@lupitatorres632](https://forum.inductiveautomation.com/u/lupitatorres632)\ **Replies:** 1\ **Last updated:** [September 21, 2018, 9:21pm UTC](https://forum.inductiveautomation.com/t/property-editor/19772 "2018-09-21T21:21:19Z")
Can I get an explanation as to why Background Color is in red? Thank you. --- ## [Real time Data storage duration](https://forum.inductiveautomation.com/t/real-time-data-storage-duration/19610)
**Author:** [@Mahesh\_Madapathi](https://forum.inductiveautomation.com/u/Mahesh_Madapathi)\ **Replies:** 1\ **Last updated:** [September 10, 2018, 8:59pm UTC](https://forum.inductiveautomation.com/t/real-time-data-storage-duration/19610 "2018-09-10T20:59:06Z")
What is the duration that the real-time data is stored in the Standard Tag provider (Real time tag provider) Tag database? --- ## [Issues loading demo Perspective project](https://forum.inductiveautomation.com/t/issues-loading-demo-perspective-project/19748)
**Author:** [@WillMT10](https://forum.inductiveautomation.com/u/WillMT10)\ **Replies:** 9\ **Last updated:** [September 21, 2018, 9:04pm UTC](https://forum.inductiveautomation.com/t/issues-loading-demo-perspective-project/19748 "2018-09-21T21:04:54Z")
--- ## [Precision on y-axis on easy chart](https://forum.inductiveautomation.com/t/precision-on-y-axis-on-easy-chart/19742)
**Author:** [@mluedecke](https://forum.inductiveautomation.com/u/mluedecke)\ **Replies:** 2\ **Last updated:** [September 21, 2018, 8:49pm UTC](https://forum.inductiveautomation.com/t/precision-on-y-axis-on-easy-chart/19742 "2018-09-21T20:49:05Z")
Is there any way to change the precision on the y-axis? Currently, what we are seeing is that the values being displayed are in the range 0.00037 and the y-axis is showing 0.004 for all ticks. We are currently using Ign… --- ## [Highlight interval on easy chart](https://forum.inductiveautomation.com/t/highlight-interval-on-easy-chart/19764)
**Author:** [@nicholas](https://forum.inductiveautomation.com/u/nicholas)\ **Replies:** 7\ **Last updated:** [September 21, 2018, 7:31pm UTC](https://forum.inductiveautomation.com/t/highlight-interval-on-easy-chart/19764 "2018-09-21T19:31:00Z")
Hello everyone, Does anyone know the best way to go about adding a highlight overlay for a specific time interval to an easy chart? It should look something along the lines of this image below. A bar or something at the… --- ## [Operator feedback](https://forum.inductiveautomation.com/t/operator-feedback/19768)
**Author:** [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Replies:** 5\ **Last updated:** [September 21, 2018, 6:31pm UTC](https://forum.inductiveautomation.com/t/operator-feedback/19768 "2018-09-21T18:31:52Z")
Has anybody created some sort of "messaging" system, so that operator can report when they see something unusually? For example, when the night shift operator sees some unusual behavior on the plant, they will write a me… --- ## [Set cell background by script](https://forum.inductiveautomation.com/t/set-cell-background-by-script/12811)
**Author:** [@StepanenkoPaul](https://forum.inductiveautomation.com/u/StepanenkoPaul)\ **Replies:** 6\ **Last updated:** [September 21, 2018, 12:01pm UTC](https://forum.inductiveautomation.com/t/set-cell-background-by-script/12811 "2018-09-21T12:01:14Z")
Can I set the color for a row in a specific column by script? --- ## [Power Table Column Drop Down Query Using configureEditor Extension Function](https://forum.inductiveautomation.com/t/power-table-column-drop-down-query-using-configureeditor-extension-function/19594)
**Author:** [@jshaffer09](https://forum.inductiveautomation.com/u/jshaffer09)\ **Replies:** 7\ **Last updated:** [September 21, 2018, 11:27am UTC](https://forum.inductiveautomation.com/t/power-table-column-drop-down-query-using-configureeditor-extension-function/19594 "2018-09-21T11:27:30Z")
How do you setup a drop down in a column and get the data for the drop down in a database table. I see the example in configureEditor but I am not for sure on the query side of it to make it work. --- ## [Set entire column to value with button](https://forum.inductiveautomation.com/t/set-entire-column-to-value-with-button/19530)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 20\ **Last updated:** [September 21, 2018, 11:15am UTC](https://forum.inductiveautomation.com/t/set-entire-column-to-value-with-button/19530 "2018-09-21T11:15:51Z")
I'm trying to set an entire column of values equal to 0. I've tried about 50 different ways, and keep failing miserably. I've found several snippets that are close to what I want, but I can't get any to work. tabl… --- ## [Store and Forward a prep-statement?](https://forum.inductiveautomation.com/t/store-and-forward-a-prep-statement/19732)
**Author:** [@Julio.Bautista](https://forum.inductiveautomation.com/u/Julio.Bautista)\ **Replies:** 3\ **Last updated:** [September 21, 2018, 2:43am UTC](https://forum.inductiveautomation.com/t/store-and-forward-a-prep-statement/19732 "2018-09-21T02:43:29Z")
If my database connection faulted would a prep-statement query be stored in cache till my connection is reestablished? I', running this code on a global shared script if that makes any difference. --- ## [Power table - Help coloring specific cells based on boolean tags value](https://forum.inductiveautomation.com/t/power-table-help-coloring-specific-cells-based-on-boolean-tags-value/18642)
**Author:** [@n.meluccio](https://forum.inductiveautomation.com/u/n.meluccio)\ **Replies:** 11\ **Last updated:** [September 21, 2018, 12:28am UTC](https://forum.inductiveautomation.com/t/power-table-help-coloring-specific-cells-based-on-boolean-tags-value/18642 "2018-09-21T00:28:19Z")
Hello sirs, i want to color just one cell of a power table, based on a boolean tag value. Below you can find the code: Numeri = \[1,2,3,4,5\] for x in Numeri: TAG = "\[Client\]NOK\_Pressione\_%s" % (x) Valore = syste… --- ## [Alarm Event Data - Get Custom Property](https://forum.inductiveautomation.com/t/alarm-event-data-get-custom-property/19756)
**Author:** [@WillMT10](https://forum.inductiveautomation.com/u/WillMT10)\ **Replies:** 0\ **Last updated:** [September 20, 2018, 9:48pm UTC](https://forum.inductiveautomation.com/t/alarm-event-data-get-custom-property/19756 "2018-09-20T21:48:43Z")
I've read various posts regarding fetching alarm event properties and discussions on grabbing custom properties, but the only solution I've seen is either sticking with the built in Extension Functions on the alarm statu… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1606) [Next page](https://forum.inductiveautomation.com/latest.md?page=1608)