# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1230 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1231 --- ## [Alarm Cleared at the same time it is set active](https://forum.inductiveautomation.com/t/alarm-cleared-at-the-same-time-it-is-set-active/42849)
**Author:** [@calimero100582](https://forum.inductiveautomation.com/u/calimero100582)\ **Replies:** 9\ **Last updated:** [February 2, 2021, 3:45pm UTC](https://forum.inductiveautomation.com/t/alarm-cleared-at-the-same-time-it-is-set-active/42849 "2021-02-02T15:45:21Z")
I’m in version 8.1.1. I have an alarm that is set at “Below SetPoint” with a value of 10. I was not able to get my Active Pipeline to trigger, and I think I found out why. My alarm, for no reason get cleared as soon as i… --- ## [MS Access database connection with Ignition 7.8](https://forum.inductiveautomation.com/t/ms-access-database-connection-with-ignition-7-8/11256)
**Author:** [@ted\_s](https://forum.inductiveautomation.com/u/ted_s)\ **Replies:** 20\ **Last updated:** [February 2, 2021, 3:20pm UTC](https://forum.inductiveautomation.com/t/ms-access-database-connection-with-ignition-7-8/11256 "2021-02-02T15:20:30Z")
I'm trying to connect to a MS Access database with Ignition 7.8 and have been unsuccessful. All the examples I've found have been pre-Java 8 and the elimination of the ODBC-JDBC bridge. I've been trying to use the UCa… --- ## [Perspective Table View Won't Fill the Entire Cell](https://forum.inductiveautomation.com/t/perspective-table-view-wont-fill-the-entire-cell/42847)
**Author:** [@m.boog](https://forum.inductiveautomation.com/u/m.boog)\ **Replies:** 3\ **Last updated:** [February 2, 2021, 2:48pm UTC](https://forum.inductiveautomation.com/t/perspective-table-view-wont-fill-the-entire-cell/42847 "2021-02-02T14:48:39Z")
Hi All, I’m working in Perspective, 8.0.16. I have a Perspective table that is displaying a view in each cell. I’m unable to get the view to completely fill the cell, however. As you can see, the views are not reaching… --- ## [ArrayIndexOutOfBoundsException: 7 \>= 7 - Error when binding SQL query to Table data property](https://forum.inductiveautomation.com/t/arrayindexoutofboundsexception-7-7-error-when-binding-sql-query-to-table-data-property/42885)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 1\ **Last updated:** [February 2, 2021, 2:42pm UTC](https://forum.inductiveautomation.com/t/arrayindexoutofboundsexception-7-7-error-when-binding-sql-query-to-table-data-property/42885 "2021-02-02T14:42:51Z")
Using Ignition 8.0.12. I have a table with the following query in the data property - SELECT \* FROM pathreconciliation WHERE depth=2 and it is throwing me this error in designer - java.lang.Exception: Error setting … --- ## [system.db.runPrepUpdate for updating multiple rows](https://forum.inductiveautomation.com/t/system-db-runprepupdate-for-updating-multiple-rows/42856)
**Author:** [@rwalters1](https://forum.inductiveautomation.com/u/rwalters1)\ **Replies:** 6\ **Last updated:** [February 2, 2021, 2:14pm UTC](https://forum.inductiveautomation.com/t/system-db-runprepupdate-for-updating-multiple-rows/42856 "2021-02-02T14:14:11Z")
I’m looking for some insight on the syntax for updating multiple rows within one query- Here is my current code, but this returns the error-“ERROR: operator does not exist:” system.db.runPrepUpdate(“UPDATE rw\_spt\_conver… --- ## [Sqlth\_te: Update the "id" manually](https://forum.inductiveautomation.com/t/sqlth-te-update-the-id-manually/42835)
**Author:** [@SaravanaKumar.S2](https://forum.inductiveautomation.com/u/SaravanaKumar.S2)\ **Replies:** 6\ **Last updated:** [February 2, 2021, 1:53pm UTC](https://forum.inductiveautomation.com/t/sqlth-te-update-the-id-manually/42835 "2021-02-02T13:53:11Z")
Dear @Kevin.Herron / @Kevin.McClusky, We have already a tag historian developed (Using Delphi) and used it for a long time. Due to this, we have a reference ID for each DCS signal. All our internal applications are usi… --- ## [Printer API, possible to connect?](https://forum.inductiveautomation.com/t/printer-api-possible-to-connect/31728)
**Author:** [@SBL\_MC](https://forum.inductiveautomation.com/u/SBL_MC)\ **Replies:** 5\ **Last updated:** [February 2, 2021, 1:44pm UTC](https://forum.inductiveautomation.com/t/printer-api-possible-to-connect/31728 "2021-02-02T13:44:32Z")
Hi all, I’m trying to get printer status from a label printer with C# API. Need some advice on how to connect and read data directly from Ignition - if possible? Thanks in advance. http://www.satoworldwide.com/softwar… --- ## [Database configuration](https://forum.inductiveautomation.com/t/database-configuration/42810)
**Author:** [@indenkleefj](https://forum.inductiveautomation.com/u/indenkleefj)\ **Replies:** 9\ **Last updated:** [February 2, 2021, 1:40pm UTC](https://forum.inductiveautomation.com/t/database-configuration/42810 "2021-02-02T13:40:16Z")
Hi, I’m curious as to which database you guys use and the reason for this choice. Also, how do you guys handle the database redundancy/backups? --- ## [Enunciate discrete alarm](https://forum.inductiveautomation.com/t/enunciate-discrete-alarm/42876)
**Author:** [@eddie\_johnson](https://forum.inductiveautomation.com/u/eddie_johnson)\ **Replies:** 0\ **Last updated:** [February 2, 2021, 12:01pm UTC](https://forum.inductiveautomation.com/t/enunciate-discrete-alarm/42876 "2021-02-02T12:01:43Z")
I have created 4 alarms associated with an analog tag. The usual suspects - HH,HI,LO,LL. The alarms show up properly in the Alarm Status table when triggered. Is there a way to know which alarm for a tag has been trigger… --- ## [Alarm journal table update data every 20 seconds](https://forum.inductiveautomation.com/t/alarm-journal-table-update-data-every-20-seconds/35529)
**Author:** [@marcg](https://forum.inductiveautomation.com/u/marcg)\ **Replies:** 3\ **Last updated:** [February 2, 2021, 11:16am UTC](https://forum.inductiveautomation.com/t/alarm-journal-table-update-data-every-20-seconds/35529 "2021-02-02T11:16:16Z")
hi guys please help me, i want to update my alarm journal table every 20 seconds. the now() commands is not working. Is there other way to solve this? thanks! --- ## [propertyChange in a template](https://forum.inductiveautomation.com/t/propertychange-in-a-template/42708)
**Author:** [@lachguerabdallah](https://forum.inductiveautomation.com/u/lachguerabdallah)\ **Replies:** 10\ **Last updated:** [February 2, 2021, 11:13am UTC](https://forum.inductiveautomation.com/t/propertychange-in-a-template/42708 "2021-02-02T11:13:20Z")
I’m using a propertyChange in a template, the problem that I’m that this script executes when opening the window where the template is located. ‘value’ is the value of a ‘numeric label component’ if event.propertyName=… --- ## [Get tag( value and timestamp) of selected tag in text field](https://forum.inductiveautomation.com/t/get-tag-value-and-timestamp-of-selected-tag-in-text-field/42870)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 1\ **Last updated:** [February 2, 2021, 8:31am UTC](https://forum.inductiveautomation.com/t/get-tag-value-and-timestamp-of-selected-tag-in-text-field/42870 "2021-02-02T08:31:06Z")
Please let me know how to get the value of a tag and timestamp from a text field that had tag path in it. I want to fetch the tag path from text field and want to show the tag value and timestamp in another text field co… --- ## [Tag export to Excel](https://forum.inductiveautomation.com/t/tag-export-to-excel/42802)
**Author:** [@matthew.roberts](https://forum.inductiveautomation.com/u/matthew.roberts)\ **Replies:** 3\ **Last updated:** [February 2, 2021, 6:55am UTC](https://forum.inductiveautomation.com/t/tag-export-to-excel/42802 "2021-02-02T06:55:24Z")
Hi Can someone please help with the script to export my tags to excel? I’m very new to this but I think i am missing a step before the toExcel command. Tags to Excel.pdf (16.3 KB) --- ## [\[BUG\] Tag browser - Changing UDT parent type deletes tags from other UDT types using them](https://forum.inductiveautomation.com/t/bug-tag-browser-changing-udt-parent-type-deletes-tags-from-other-udt-types-using-them/42865)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 0\ **Last updated:** [February 2, 2021, 5:11am UTC](https://forum.inductiveautomation.com/t/bug-tag-browser-changing-udt-parent-type-deletes-tags-from-other-udt-types-using-them/42865 "2021-02-02T05:11:33Z")
I have an old project that I’m gradually making changes to with enhancements that we’ve made over the years to our projects. One of these is using a standard UDT definition as the parent for all of our device UDTs which … --- ## [How to convert code from Java code to Python format T.T](https://forum.inductiveautomation.com/t/how-to-convert-code-from-java-code-to-python-format-t-t/42858)
**Author:** [@kjy0124kr](https://forum.inductiveautomation.com/u/kjy0124kr)\ **Replies:** 1\ **Last updated:** [February 2, 2021, 1:45am UTC](https://forum.inductiveautomation.com/t/how-to-convert-code-from-java-code-to-python-format-t-t/42858 "2021-02-02T01:45:51Z")
The code below is the Java source code. I would like to see the code that converted this source code to Python format. (Due to lack of Python knowledge…) Example) Data structure, instance creation Please help B… --- ## [\[BUG-1106\] Web Server SSL Config Issue](https://forum.inductiveautomation.com/t/bug-1106-web-server-ssl-config-issue/42822)
**Author:** [@douglas1](https://forum.inductiveautomation.com/u/douglas1)\ **Replies:** 0\ **Last updated:** [February 1, 2021, 4:17pm UTC](https://forum.inductiveautomation.com/t/bug-1106-web-server-ssl-config-issue/42822 "2021-02-01T16:17:14Z")
This is something like a bug report but maybe also like a small request to help users not put themselves into silly situations as I did. Steps to reproduce: Install SSL certificate under the configuration of the webser… --- ## [Potential flex repeater bug with parameters passed to instances](https://forum.inductiveautomation.com/t/potential-flex-repeater-bug-with-parameters-passed-to-instances/42840)
**Author:** [@chandler](https://forum.inductiveautomation.com/u/chandler)\ **Replies:** 1\ **Last updated:** [February 1, 2021, 10:27pm UTC](https://forum.inductiveautomation.com/t/potential-flex-repeater-bug-with-parameters-passed-to-instances/42840 "2021-02-01T22:27:53Z")
Hi, In a script I am dynamically creating a list of instances based on the results of a query: Here is the getInstance method that I am calling to get the dictionary with the instance’s parameters in it: As you ca… --- ## [When editing Named Queries, when do changes get written?](https://forum.inductiveautomation.com/t/when-editing-named-queries-when-do-changes-get-written/42850)
**Author:** [@peter](https://forum.inductiveautomation.com/u/peter)\ **Replies:** 3\ **Last updated:** [February 1, 2021, 9:40pm UTC](https://forum.inductiveautomation.com/t/when-editing-named-queries-when-do-changes-get-written/42850 "2021-02-01T21:40:42Z")
With (for example) Transaction Groups, and with Tag changes you have to do something in order for your changes to be written back to the system. But I can’t see any obvious mechanism for Named Queries to do the equivale… --- ## [Get status of printer from Java?](https://forum.inductiveautomation.com/t/get-status-of-printer-from-java/42836)
**Author:** [@wking](https://forum.inductiveautomation.com/u/wking)\ **Replies:** 5\ **Last updated:** [February 1, 2021, 9:12pm UTC](https://forum.inductiveautomation.com/t/get-status-of-printer-from-java/42836 "2021-02-01T21:12:51Z")
Does anyone have a good methodology for getting the status of a network printer and making it available to ignition. Through scripting. is it available through system properties? Or maybe making an HTTP call? Basically,… --- ## [How best to run a DB query on a timed basis?](https://forum.inductiveautomation.com/t/how-best-to-run-a-db-query-on-a-timed-basis/42834)
**Author:** [@peter](https://forum.inductiveautomation.com/u/peter)\ **Replies:** 4\ **Last updated:** [February 1, 2021, 8:51pm UTC](https://forum.inductiveautomation.com/t/how-best-to-run-a-db-query-on-a-timed-basis/42834 "2021-02-01T20:51:35Z")
So I have a complex UDT that represents a machine and aggregates data from different locations at different times. I have OPC data being collected whenever OPC collects data, and I have some DB data that can be collecte… --- ## [Best DB connection architecture for supporting a future change?](https://forum.inductiveautomation.com/t/best-db-connection-architecture-for-supporting-a-future-change/42815)
**Author:** [@peter](https://forum.inductiveautomation.com/u/peter)\ **Replies:** 8\ **Last updated:** [February 1, 2021, 7:17pm UTC](https://forum.inductiveautomation.com/t/best-db-connection-architecture-for-supporting-a-future-change/42815 "2021-02-01T19:17:03Z")
I am developing a system for a client which will read data from one set of tables (“In Tables”) and will write data to another set of tables (“Out Tables”). (And due to some requirements I think it the best way of imple… --- ## [How to convert Java class to Python T.T](https://forum.inductiveautomation.com/t/how-to-convert-java-class-to-python-t-t/42800)
**Author:** [@kjy0124kr](https://forum.inductiveautomation.com/u/kjy0124kr)\ **Replies:** 2\ **Last updated:** [February 1, 2021, 6:54pm UTC](https://forum.inductiveautomation.com/t/how-to-convert-java-class-to-python-t-t/42800 "2021-02-01T18:54:20Z")
Can someone tell me how to convert this java classes to python: Java: Help T.T File file = new File("/Users/gim-yuwan/Documents/project/RealResearch-API-BackEnd-Beta/src/main/resources/static/test.json"); … --- ## [Tag Historian configuration or Easy Chart configuration?](https://forum.inductiveautomation.com/t/tag-historian-configuration-or-easy-chart-configuration/42719)
**Author:** [@robb](https://forum.inductiveautomation.com/u/robb)\ **Replies:** 2\ **Last updated:** [February 1, 2021, 6:25pm UTC](https://forum.inductiveautomation.com/t/tag-historian-configuration-or-easy-chart-configuration/42719 "2021-02-01T18:25:39Z")
Hello, Setting up an Easy Chart in Historical mode, to work with Historical Tags. I need to show the same data as the hardwired chart recorder. My Easy chart does not show the data the same as the hardwired chart record… --- ## [Does the store and forward system work with db update queries?](https://forum.inductiveautomation.com/t/does-the-store-and-forward-system-work-with-db-update-queries/42723)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 3\ **Last updated:** [February 1, 2021, 5:56pm UTC](https://forum.inductiveautomation.com/t/does-the-store-and-forward-system-work-with-db-update-queries/42723 "2021-02-01T17:56:34Z")
As in title, do db update calls from script get added into the store and forward system? --- ## [PA Power Scripting Module](https://forum.inductiveautomation.com/t/pa-power-scripting-module/42828)
**Author:** [@vasilevdim](https://forum.inductiveautomation.com/u/vasilevdim)\ **Replies:** 1\ **Last updated:** [February 1, 2021, 5:50pm UTC](https://forum.inductiveautomation.com/t/pa-power-scripting-module/42828 "2021-02-01T17:50:45Z")
A quick one: can PA Power Scripting Module be used in Ignition 8.0 and 8.1? --- ## [Use Gradient for Simple Gauge Component?](https://forum.inductiveautomation.com/t/use-gradient-for-simple-gauge-component/41674)
**Author:** [@sungkhum](https://forum.inductiveautomation.com/u/sungkhum)\ **Replies:** 6\ **Last updated:** [February 1, 2021, 5:49pm UTC](https://forum.inductiveautomation.com/t/use-gradient-for-simple-gauge-component/41674 "2021-02-01T17:49:20Z")
Is there a way to use a gradient on the arc of a simple gauge? I’d like it to go from blue to red (cold to hot). I tried setting the background but that caused an error. linear-gradient(to right, #1d66ff, #ff5858) --- ## [Historical "LastValue" Script Incorrect Timestamps and Slow](https://forum.inductiveautomation.com/t/historical-lastvalue-script-incorrect-timestamps-and-slow/42830)
**Author:** [@benjamin.sperl](https://forum.inductiveautomation.com/u/benjamin.sperl)\ **Replies:** 0\ **Last updated:** [February 1, 2021, 5:32pm UTC](https://forum.inductiveautomation.com/t/historical-lastvalue-script-incorrect-timestamps-and-slow/42830 "2021-02-01T17:32:51Z")
Hello all, I’m having issues with the function “system.tag.queryTagHistory”. The intention of the script is to see the values of a group a tags at any given moment. So I am using the “Last Value” aggregation with a retu… --- ## [Perspective Properties - View all Component options](https://forum.inductiveautomation.com/t/perspective-properties-view-all-component-options/42795)
**Author:** [@andrewbrown](https://forum.inductiveautomation.com/u/andrewbrown)\ **Replies:** 1\ **Last updated:** [February 1, 2021, 5:05pm UTC](https://forum.inductiveautomation.com/t/perspective-properties-view-all-component-options/42795 "2021-02-01T17:05:57Z")
Hi All, Just wondering if there was any function, script or list available to access all the available props for perspective components? Would be great to fully understand where certain colours and the like come from. … --- ## [Template Canvas Help](https://forum.inductiveautomation.com/t/template-canvas-help/30671)
**Author:** [@ryanastiefes](https://forum.inductiveautomation.com/u/ryanastiefes)\ **Replies:** 1\ **Last updated:** [February 1, 2021, 5:02pm UTC](https://forum.inductiveautomation.com/t/template-canvas-help/30671 "2021-02-01T17:02:34Z")
7.8.5 Reaching out to anyone that might shed some light on my project. I currently have a custom SVG of a map that is set on a Template Canvas in which I am changing the map dimensions by way of a mouse scroll using the… --- ## [How to script when a docked window loses focus?](https://forum.inductiveautomation.com/t/how-to-script-when-a-docked-window-loses-focus/27491)
**Author:** [@sbrannen](https://forum.inductiveautomation.com/u/sbrannen)\ **Replies:** 6\ **Last updated:** [February 1, 2021, 4:45pm UTC](https://forum.inductiveautomation.com/t/how-to-script-when-a-docked-window-loses-focus/27491 "2021-02-01T16:45:03Z")
Hi, I have a West docked window that expands/collapses based on mouse movement. Works great except for one small issue… it doesn’t always close. I have a script on the root container event ‘mouseExited’ which slides t… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1229) [Next page](https://forum.inductiveautomation.com/latest.md?page=1231)