# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=911 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 912 --- ## [SQL time convert error](https://forum.inductiveautomation.com/t/sql-time-convert-error/54467)
**Author:** [@Fernando\_Alonso\_Aram](https://forum.inductiveautomation.com/u/Fernando_Alonso_Aram)\ **Replies:** 4\ **Last updated:** [December 29, 2021, 2:14am UTC](https://forum.inductiveautomation.com/t/sql-time-convert-error/54467 "2021-12-29T02:14:03Z")
Hello. Im searching for help to run a script to sql database, i´m using 2 date time inputs as a range of time to search in sql but i get conversion error. some of you had an idea how to fix? --- ## [Debug Console not showing 'Live' Outputs](https://forum.inductiveautomation.com/t/debug-console-not-showing-live-outputs/54503)
**Author:** [@Chris\_Bingham](https://forum.inductiveautomation.com/u/Chris_Bingham)\ **Replies:** 5\ **Last updated:** [December 28, 2021, 11:37pm UTC](https://forum.inductiveautomation.com/t/debug-console-not-showing-live-outputs/54503 "2021-12-28T23:37:00Z")
Running Ignition Edge 8.1.11: I am running a button-triggered script with a for-loop which reads hundreds (at times, thousands) of values from a remote OPC server, and writes the values of tags to a memory array tag. I … --- ## [Designer Launcher No Longer Works](https://forum.inductiveautomation.com/t/designer-launcher-no-longer-works/54505)
**Author:** [@sbeauregard66](https://forum.inductiveautomation.com/u/sbeauregard66)\ **Replies:** 2\ **Last updated:** [December 28, 2021, 11:10pm UTC](https://forum.inductiveautomation.com/t/designer-launcher-no-longer-works/54505 "2021-12-28T23:10:25Z")
Hi there. Hoping for some help here. A little long winded but hopefully shed some detailed light on my situation. Problem: Designer launcher no longer opens. What happens is briefly a blank designer window pops up f… --- ## [\[Bug IGN-5309\] 8.1.12 - disabled dropdown are permanently disabled after a scripting event](https://forum.inductiveautomation.com/t/bug-ign-5309-8-1-12-disabled-dropdown-are-permanently-disabled-after-a-scripting-event/54500)
**Author:** [@mal](https://forum.inductiveautomation.com/u/mal)\ **Replies:** 3\ **Last updated:** [December 28, 2021, 4:14pm UTC](https://forum.inductiveautomation.com/t/bug-ign-5309-8-1-12-disabled-dropdown-are-permanently-disabled-after-a-scripting-event/54500 "2021-12-28T16:14:25Z")
This was an odd one. We lockout navigation after the user makes changes on some views until it is saved, this entails disabling several dropdown components on the page. After lockout, the user can click on the locked d… --- ## [Report - Query Historical Data stored with storeTagHistory function](https://forum.inductiveautomation.com/t/report-query-historical-data-stored-with-storetaghistory-function/54498)
**Author:** [@jeff1](https://forum.inductiveautomation.com/u/jeff1)\ **Replies:** 4\ **Last updated:** [December 28, 2021, 4:12pm UTC](https://forum.inductiveautomation.com/t/report-query-historical-data-stored-with-storetaghistory-function/54498 "2021-12-28T16:12:19Z")
I have two totalized flows. At midnight a Gateway Event script stores the now previous day’s total in the MySQL historical database. It is stored with: system.tag.storeTagHistory(histProv,tagProv,paths,values,quals,t\_st… --- ## [Change Perspective Table Row Color Programmatically](https://forum.inductiveautomation.com/t/change-perspective-table-row-color-programmatically/26453)
**Author:** [@nick.shea](https://forum.inductiveautomation.com/u/nick.shea)\ **Replies:** 11\ **Last updated:** [December 28, 2021, 3:48pm UTC](https://forum.inductiveautomation.com/t/change-perspective-table-row-color-programmatically/26453 "2021-12-28T15:48:28Z")
Hello, I’m trying to set the background color of rows in a perspective table. I’m stuck with the following: I am running a onClick script on my table that should change the self.props.rows.striped.color from odd to eve… --- ## [Perspective Tag History bindings not updating properly in client?](https://forum.inductiveautomation.com/t/perspective-tag-history-bindings-not-updating-properly-in-client/54462)
**Author:** [@cdunn.home](https://forum.inductiveautomation.com/u/cdunn.home)\ **Replies:** 0\ **Last updated:** [December 27, 2021, 6:55pm UTC](https://forum.inductiveautomation.com/t/perspective-tag-history-bindings-not-updating-properly-in-client/54462 "2021-12-27T18:55:55Z")
I’m using Tag History to get a motor’s bool “running” tag’s DURATION ON to obtain an “Equipment Runtime” for a PM schedule. A “Reset” simply writes to separate DB table (MaintResets) and associates a timestamp with the e… --- ## [Is it possible to make the reconnection to PLC devices manully](https://forum.inductiveautomation.com/t/is-it-possible-to-make-the-reconnection-to-plc-devices-manully/54483)
**Author:** [@jeff.li](https://forum.inductiveautomation.com/u/jeff.li)\ **Replies:** 1\ **Last updated:** [December 28, 2021, 12:43pm UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-make-the-reconnection-to-plc-devices-manully/54483 "2021-12-28T12:43:00Z")
I ask this question because in my Ignition gateway, totally I have around 100 devices connected by Omron Fins/TCP driver, and for example if there are couple of devices powered off, then it will make all another existing… --- ## [How to latch indicator with momentary input signal](https://forum.inductiveautomation.com/t/how-to-latch-indicator-with-momentary-input-signal/54454)
**Author:** [@indi](https://forum.inductiveautomation.com/u/indi)\ **Replies:** 6\ **Last updated:** [December 28, 2021, 9:23am UTC](https://forum.inductiveautomation.com/t/how-to-latch-indicator-with-momentary-input-signal/54454 "2021-12-28T09:23:09Z")
Hi all, I’m new with ignition scada. is it possible and how to make an latching/set indicator with momentary input signal? The indicator will be unlatch/reset until reset button is pressed and remain latching/set when m… --- ## [Filtering for individual column on table(prespective)](https://forum.inductiveautomation.com/t/filtering-for-individual-column-on-table-prespective/54478)
**Author:** [@user66](https://forum.inductiveautomation.com/u/user66)\ **Replies:** 0\ **Last updated:** [December 28, 2021, 6:17am UTC](https://forum.inductiveautomation.com/t/filtering-for-individual-column-on-table-prespective/54478 "2021-12-28T06:17:57Z")
can we filter a table data based only on a particular column? --- ## [Error Launching java.lang.NullPointerException](https://forum.inductiveautomation.com/t/error-launching-java-lang-nullpointerexception/41491)
**Author:** [@Apisit\_Chuencharoen](https://forum.inductiveautomation.com/u/Apisit_Chuencharoen)\ **Replies:** 5\ **Last updated:** [December 28, 2021, 12:08am UTC](https://forum.inductiveautomation.com/t/error-launching-java-lang-nullpointerexception/41491 "2021-12-28T00:08:33Z")
Hello, One of our user cannot launch Ignition Vision client but he can launch Ignition designer. Error is java.lang.NullPointerException (as pitctured below). We try to uninstall and re-install Ignition vision client bu… --- ## [Numeric Entry Overriding PLC value with default](https://forum.inductiveautomation.com/t/numeric-entry-overriding-plc-value-with-default/54411)
**Author:** [@david.gillbee](https://forum.inductiveautomation.com/u/david.gillbee)\ **Replies:** 6\ **Last updated:** [December 27, 2021, 5:45pm UTC](https://forum.inductiveautomation.com/t/numeric-entry-overriding-plc-value-with-default/54411 "2021-12-27T17:45:18Z")
I have embedded a numeric entry object into a perspective view which i use as a generic setpoint entry. I am seeing a bug where when i embed this setpoint view into a page it will somtimes override my PLC value with the … --- ## [Vision Table propertyChange](https://forum.inductiveautomation.com/t/vision-table-propertychange/54456)
**Author:** [@iscrac](https://forum.inductiveautomation.com/u/iscrac)\ **Replies:** 4\ **Last updated:** [December 27, 2021, 4:16pm UTC](https://forum.inductiveautomation.com/t/vision-table-propertychange/54456 "2021-12-27T16:16:38Z")
Hi, Ignition v.8.1.12 Is it possible somehow to catch propertyChange just once? when I print event.propertyName, so it gives me a lot of "data" and some other properties were changed many times: selectedColumn data … --- ## [Utilize only the columns portion of power chart in perspective](https://forum.inductiveautomation.com/t/utilize-only-the-columns-portion-of-power-chart-in-perspective/54457)
**Author:** [@hsw1217](https://forum.inductiveautomation.com/u/hsw1217)\ **Replies:** 1\ **Last updated:** [December 27, 2021, 3:52pm UTC](https://forum.inductiveautomation.com/t/utilize-only-the-columns-portion-of-power-chart-in-perspective/54457 "2021-12-27T15:52:59Z")
Is there a way to remove the chart portion of the power chart in perspective so that only the columns/data table is left. I’m sure this seems like a round-about way of creating a data table, but the design and format of … --- ## [Perspective Popup with Dynamic Height/Width](https://forum.inductiveautomation.com/t/perspective-popup-with-dynamic-height-width/39247)
**Author:** [@bradley.falzon](https://forum.inductiveautomation.com/u/bradley.falzon)\ **Replies:** 1\ **Last updated:** [October 1, 2020, 2:30pm UTC](https://forum.inductiveautomation.com/t/perspective-popup-with-dynamic-height-width/39247 "2020-10-01T14:30:47Z")
I have a generic view for setting set points, which also shows recent changes to those set points, shown in a popup. I have a popup when called with particular parameters, allows you to change set points and also shows … --- ## [HTML5 canvas - amChart5](https://forum.inductiveautomation.com/t/html5-canvas-amchart5/51069)
**Author:** [@eberly88](https://forum.inductiveautomation.com/u/eberly88)\ **Replies:** 1\ **Last updated:** [December 26, 2021, 9:29am UTC](https://forum.inductiveautomation.com/t/html5-canvas-amchart5/51069 "2021-12-26T09:29:51Z")
Are there plans to upgrade ignitions vector-based amChart4 components to amChart5 raster-based charts when it’s released? --- ## [Upgrade from 8.1.1 to 8.1.10 - Any issues?](https://forum.inductiveautomation.com/t/upgrade-from-8-1-1-to-8-1-10-any-issues/53662)
**Author:** [@sharmila.belvalkar](https://forum.inductiveautomation.com/u/sharmila.belvalkar)\ **Replies:** 5\ **Last updated:** [December 25, 2021, 4:04pm UTC](https://forum.inductiveautomation.com/t/upgrade-from-8-1-1-to-8-1-10-any-issues/53662 "2021-12-25T16:04:03Z")
Does anyone have any input for this upgrade with regards to issues, considerations to prevent issues etc? Thanks --- ## [OPC Tag overlay](https://forum.inductiveautomation.com/t/opc-tag-overlay/54449)
**Author:** [@PRAMANJ](https://forum.inductiveautomation.com/u/PRAMANJ)\ **Replies:** 1\ **Last updated:** [December 25, 2021, 2:55pm UTC](https://forum.inductiveautomation.com/t/opc-tag-overlay/54449 "2021-12-25T14:55:41Z")
Under what circumstances does the OPC tags in CoreSimulator stop updating? How to reset it? It was working fine till some hours ago! All components using these tags are overlaid ! --- ## [What is the answer to perspective templates?](https://forum.inductiveautomation.com/t/what-is-the-answer-to-perspective-templates/54259)
**Author:** [@franklepkowski](https://forum.inductiveautomation.com/u/franklepkowski)\ **Replies:** 15\ **Last updated:** [December 25, 2021, 11:07am UTC](https://forum.inductiveautomation.com/t/what-is-the-answer-to-perspective-templates/54259 "2021-12-25T11:07:40Z")
Hello All, What is the de facto for using templates in Perspective? Logical answer is embedded views, however these degrade HMI performance and create a lot of latency. We have been staying away from embedded views alto… --- ## [Focus on Text Box in Embedded view does not fire](https://forum.inductiveautomation.com/t/focus-on-text-box-in-embedded-view-does-not-fire/54286)
**Author:** [@stefan.marcin74](https://forum.inductiveautomation.com/u/stefan.marcin74)\ **Replies:** 7\ **Last updated:** [December 25, 2021, 6:19am UTC](https://forum.inductiveautomation.com/t/focus-on-text-box-in-embedded-view-does-not-fire/54286 "2021-12-25T06:19:37Z")
Coming from # Focus on Text Box Loses Cursor - is there any better solution then specifying Sleep function ? Its the worst way to solve problem like this. Or can anyone explain what the flow of execution of scripts in em… --- ## [Perspective map layers](https://forum.inductiveautomation.com/t/perspective-map-layers/53735)
**Author:** [@lachguerabdallah](https://forum.inductiveautomation.com/u/lachguerabdallah)\ **Replies:** 1\ **Last updated:** [December 25, 2021, 12:20am UTC](https://forum.inductiveautomation.com/t/perspective-map-layers/53735 "2021-12-25T00:20:50Z")
Hello, I would like to create a map of temperature, precipitation, wind direction like the maps I show below using the perspective map. Has someone done something similar? --- ## [Translation manager import quirk](https://forum.inductiveautomation.com/t/translation-manager-import-quirk/54430)
**Author:** [@ShaneH](https://forum.inductiveautomation.com/u/ShaneH)\ **Replies:** 3\ **Last updated:** [December 23, 2021, 4:16pm UTC](https://forum.inductiveautomation.com/t/translation-manager-import-quirk/54430 "2021-12-23T16:16:05Z")
Perspective 8.1.11 I exported my translation terms to ‘my\_terms\_es\_US.PROPERTIES’ I made a copy to ‘es\_US.PROPERTIES’ – note I removed the prefix! I made some hand edits, then tried to re-import it. It would only im… --- ## [Perspective Integer found String Expected](https://forum.inductiveautomation.com/t/perspective-integer-found-string-expected/36546)
**Author:** [@kyle.lawson](https://forum.inductiveautomation.com/u/kyle.lawson)\ **Replies:** 13\ **Last updated:** [December 23, 2021, 4:10pm UTC](https://forum.inductiveautomation.com/t/perspective-integer-found-string-expected/36546 "2021-12-23T16:10:11Z")
Hello, How can I not get an error when an integer is entered on a text field? Currently I am getting an “integer found, string expected” error. Sometimes the user will enter just an integer and other times it will be … --- ## [Tag gateway initialization](https://forum.inductiveautomation.com/t/tag-gateway-initialization/54398)
**Author:** [@betti.francesco](https://forum.inductiveautomation.com/u/betti.francesco)\ **Replies:** 4\ **Last updated:** [December 23, 2021, 11:03am UTC](https://forum.inductiveautomation.com/t/tag-gateway-initialization/54398 "2021-12-23T11:03:00Z")
In a Perspective project I have some global state variables leaning back on some memory tags. I need those tags to be initialized on they’re default state when the gateway restarts: I was thinking to implement the initia… --- ## [Tag Path dependent on System Name](https://forum.inductiveautomation.com/t/tag-path-dependent-on-system-name/54412)
**Author:** [@Bryan\_Mason](https://forum.inductiveautomation.com/u/Bryan_Mason)\ **Replies:** 1\ **Last updated:** [December 23, 2021, 5:09am UTC](https://forum.inductiveautomation.com/t/tag-path-dependent-on-system-name/54412 "2021-12-23T05:09:49Z")
I was trying to export views from one gateway to another and discovered that my power chart was broken because the Tag Path (under Edit Pens) depends on the name of the gateway to find the correct OPC path. For example, … --- ## [getSelectedRows](https://forum.inductiveautomation.com/t/getselectedrows/54420)
**Author:** [@Johnny\_Li1](https://forum.inductiveautomation.com/u/Johnny_Li1)\ **Replies:** 5\ **Last updated:** [December 23, 2021, 4:54am UTC](https://forum.inductiveautomation.com/t/getselectedrows/54420 "2021-12-23T04:54:21Z")
Hi guys I am just wondering how do you use getSelectedRows()? How to fix this issue ? many thanks Johnny --- ## [How to scroll to the highlighed row of the table](https://forum.inductiveautomation.com/t/how-to-scroll-to-the-highlighed-row-of-the-table/54039)
**Author:** [@manjuyadav95.m](https://forum.inductiveautomation.com/u/manjuyadav95.m)\ **Replies:** 40\ **Last updated:** [December 23, 2021, 4:46am UTC](https://forum.inductiveautomation.com/t/how-to-scroll-to-the-highlighed-row-of-the-table/54039 "2021-12-23T04:46:39Z")
@cmallonee @victordcq I referred to this below link and the given solution worked out but to see the highlighted row in the table sometimes I need to check by scrolling down ..how can I make it top of the list or auto-s… --- ## [No default tag folders](https://forum.inductiveautomation.com/t/no-default-tag-folders/54418)
**Author:** [@John\_Coleman](https://forum.inductiveautomation.com/u/John_Coleman)\ **Replies:** 1\ **Last updated:** [December 23, 2021, 12:26am UTC](https://forum.inductiveautomation.com/t/no-default-tag-folders/54418 "2021-12-23T00:26:29Z")
Hi, I’m new and working my way through the videos. I Installed 8.1 gateway, and made connections to 2 ControlLogix processors successfully, connected to a SQL server, installed the designer, started a project. So far s… --- ## [Popup window to db.refresh table on main window?](https://forum.inductiveautomation.com/t/popup-window-to-db-refresh-table-on-main-window/7231)
**Author:** [@matkent](https://forum.inductiveautomation.com/u/matkent)\ **Replies:** 4\ **Last updated:** [December 22, 2021, 11:21pm UTC](https://forum.inductiveautomation.com/t/popup-window-to-db-refresh-table-on-main-window/7231 "2021-12-22T23:21:58Z")
Hello, I have a table on the main window which reflects a db. I have a button which opens a popup window with input fields (just a form) etc for adding to the DB (table on the main window). Once all the fields are f… --- ## [Object has no attribute 'getComponent' in actionPerform script](https://forum.inductiveautomation.com/t/object-has-no-attribute-getcomponent-in-actionperform-script/54381)
**Author:** [@Johnny\_Li1](https://forum.inductiveautomation.com/u/Johnny_Li1)\ **Replies:** 2\ **Last updated:** [December 22, 2021, 11:15pm UTC](https://forum.inductiveautomation.com/t/object-has-no-attribute-getcomponent-in-actionperform-script/54381 "2021-12-22T23:15:27Z")
Hi guys I am current working on a button that has a script as shown below . I am just wondering is it possible to use getComponent from onActionPerformed event ? many thanks [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=910) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=912)