# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=747 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 748 --- ## [Reduce area to the left of a time series chart?](https://forum.inductiveautomation.com/t/reduce-area-to-the-left-of-a-time-series-chart/66498)
**Author:** [@Sahil\_Nagpal](https://forum.inductiveautomation.com/u/Sahil_Nagpal)\ **Replies:** 3\ **Last updated:** [November 15, 2022, 9:13pm UTC](https://forum.inductiveautomation.com/t/reduce-area-to-the-left-of-a-time-series-chart/66498 "2022-11-15T21:13:13Z")
Hi, Just wondering if it is possible to reduce the length that the x-axis goes to the left hand side. I feel like for a time series chart, there will never be a negative time so that is valuable real-estate I would like… --- ## [Null Values from properties when deploying?](https://forum.inductiveautomation.com/t/null-values-from-properties-when-deploying/66544)
**Author:** [@Sahil\_Nagpal](https://forum.inductiveautomation.com/u/Sahil_Nagpal)\ **Replies:** 3\ **Last updated:** [November 15, 2022, 9:07pm UTC](https://forum.inductiveautomation.com/t/null-values-from-properties-when-deploying/66544 "2022-11-15T21:07:02Z")
Hi, I seem to be getting null values for some of my labels when I am deploying my application in perspective. But when I view it in Designer, there is no null value. Can anyone recommend what might be happening? I have… --- ## [Mssql-jdbc General Issues Resolved](https://forum.inductiveautomation.com/t/mssql-jdbc-general-issues-resolved/66547)
**Author:** [@davis.gray](https://forum.inductiveautomation.com/u/davis.gray)\ **Replies:** 4\ **Last updated:** [November 15, 2022, 9:06pm UTC](https://forum.inductiveautomation.com/t/mssql-jdbc-general-issues-resolved/66547 "2022-11-15T21:06:11Z")
Wanted to post my resolution to an intermittent issue we've been having for the past year to an onsite SQL Server instance, which would disconnect and time out at random times, with the only logs stating: com.microsoft.… --- ## [How to force the Gateway to map drives when there is a failed attempt at restart](https://forum.inductiveautomation.com/t/how-to-force-the-gateway-to-map-drives-when-there-is-a-failed-attempt-at-restart/65929)
**Author:** [@francois.morin](https://forum.inductiveautomation.com/u/francois.morin)\ **Replies:** 4\ **Last updated:** [November 15, 2022, 6:04pm UTC](https://forum.inductiveautomation.com/t/how-to-force-the-gateway-to-map-drives-when-there-is-a-failed-attempt-at-restart/65929 "2022-11-15T18:04:28Z")
This week-end the Ignition Gateway server rebooted after windows updates. At reboot, the gateway failed to map a drive to a remote server (maybe because it was rebooting too) Is there a way to force the gateway to try … --- ## [Referencing a custom property using variable](https://forum.inductiveautomation.com/t/referencing-a-custom-property-using-variable/66538)
**Author:** [@Salem\_Marshall](https://forum.inductiveautomation.com/u/Salem_Marshall)\ **Replies:** 2\ **Last updated:** [November 15, 2022, 5:56pm UTC](https://forum.inductiveautomation.com/t/referencing-a-custom-property-using-variable/66538 "2022-11-15T17:56:33Z")
I want to run the same python code for several custom properties in a vision window on a triggered action. All of the custom properties are a dataset, so I want to pull that data into a variable called "rawData" and then… --- ## [Ignition Reports grinding to a halt after a few day, restart ignition server and it fast again. 8.1.18](https://forum.inductiveautomation.com/t/ignition-reports-grinding-to-a-halt-after-a-few-day-restart-ignition-server-and-it-fast-again-8-1-18/66500)
**Author:** [@rhayes2](https://forum.inductiveautomation.com/u/rhayes2)\ **Replies:** 1\ **Last updated:** [November 15, 2022, 4:41pm UTC](https://forum.inductiveautomation.com/t/ignition-reports-grinding-to-a-halt-after-a-few-day-restart-ignition-server-and-it-fast-again-8-1-18/66500 "2022-11-15T16:41:49Z")
(Vision) Has anyone had a problem where reports work well for several day, but then the queries take too long, effectively becoming unusable? Ignition Server CPU 8-20% Memory 4gb/10gb usage. Database server 2% CPU , 2… --- ## [Read PDF Reports and Extract Data](https://forum.inductiveautomation.com/t/read-pdf-reports-and-extract-data/34286)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 6\ **Last updated:** [November 15, 2022, 4:39pm UTC](https://forum.inductiveautomation.com/t/read-pdf-reports-and-extract-data/34286 "2022-11-15T16:39:19Z")
Over the years we have created hundreds of PDF reports. We now want to extract the data from these reports and put into a database. I know there are external programs that can do this but if possible I would like to inte… --- ## [Script transform unexpectedly return array](https://forum.inductiveautomation.com/t/script-transform-unexpectedly-return-array/66444)
**Author:** [@ASF](https://forum.inductiveautomation.com/u/ASF)\ **Replies:** 3\ **Last updated:** [November 15, 2022, 4:30pm UTC](https://forum.inductiveautomation.com/t/script-transform-unexpectedly-return-array/66444 "2022-11-15T16:30:09Z")
Got an odd one. I was trying to set up a script transform to essentially check the data type of a parameter, and output one of two strings based on the result. It was behaving oddly, and I managed to isolate it down to … --- ## [Fixing database connections in a redudant gateway](https://forum.inductiveautomation.com/t/fixing-database-connections-in-a-redudant-gateway/66523)
**Author:** [@L\_F](https://forum.inductiveautomation.com/u/L_F)\ **Replies:** 5\ **Last updated:** [November 15, 2022, 1:19pm UTC](https://forum.inductiveautomation.com/t/fixing-database-connections-in-a-redudant-gateway/66523 "2022-11-15T13:19:41Z")
Ignition version: 8.1.22 Database: MySQL I need my redudant gateway on one server, opc1, to communicate a database on the server with my master gateway, opc0. I created a new user within MySQL specifically for Ignition… --- ## [Modify Incoming Data from Dataset Tag and Write Modified Values Back to Same Tag](https://forum.inductiveautomation.com/t/modify-incoming-data-from-dataset-tag-and-write-modified-values-back-to-same-tag/66519)
**Author:** [@Tyler\_Ellis](https://forum.inductiveautomation.com/u/Tyler_Ellis)\ **Replies:** 2\ **Last updated:** [November 15, 2022, 1:03pm UTC](https://forum.inductiveautomation.com/t/modify-incoming-data-from-dataset-tag-and-write-modified-values-back-to-same-tag/66519 "2022-11-15T13:03:24Z")
I'm working on a program that pings an IP device and modifies a boolean value based on the result within a gateway timer script. I am well aware that Datasets and Pydatasets cannot be modified without creating an entirel… --- ## [Calling getComponent('title') or insert a variable?](https://forum.inductiveautomation.com/t/calling-getcomponent-title-or-insert-a-variable/66512)
**Author:** [@christopher\_wray](https://forum.inductiveautomation.com/u/christopher_wray)\ **Replies:** 2\ **Last updated:** [November 15, 2022, 12:54pm UTC](https://forum.inductiveautomation.com/t/calling-getcomponent-title-or-insert-a-variable/66512 "2022-11-15T12:54:12Z")
Hi Is it possible when calling getComponent() to insert a variable instead of hard coded name ? for example if I wanted to go to a specific template instance within my root container ?. I know you can loop through a te… --- ## [PrepQuery with SQL Variable](https://forum.inductiveautomation.com/t/prepquery-with-sql-variable/66509)
**Author:** [@julien.rouillard](https://forum.inductiveautomation.com/u/julien.rouillard)\ **Replies:** 3\ **Last updated:** [November 15, 2022, 12:49pm UTC](https://forum.inductiveautomation.com/t/prepquery-with-sql-variable/66509 "2022-11-15T12:49:01Z")
Hello, I am trying to see if it is possible to use the sql variables with prep query. The idea is to have something like that: queryTest = "DECLARE @vWorkerID VARCHAR(30);SET @vWorkerID = ?; SELECT \* FROM TbWorker WH… --- ## [Failed to create DataTypeDictionary](https://forum.inductiveautomation.com/t/failed-to-create-datatypedictionary/66520)
**Author:** [@thierryv](https://forum.inductiveautomation.com/u/thierryv)\ **Replies:** 1\ **Last updated:** [November 15, 2022, 12:40pm UTC](https://forum.inductiveautomation.com/t/failed-to-create-datatypedictionary/66520 "2022-11-15T12:40:48Z")
Greetings, we have a problem when we restart some of our servers. It takes a long time before opc tags become valid. We are still looking into the issue but are wondering if the error below could have something to do wi… --- ## [In-Person Perspective Training](https://forum.inductiveautomation.com/t/in-person-perspective-training/66497)
**Author:** [@diat150](https://forum.inductiveautomation.com/u/diat150)\ **Replies:** 4\ **Last updated:** [November 15, 2022, 12:15am UTC](https://forum.inductiveautomation.com/t/in-person-perspective-training/66497 "2022-11-15T00:15:53Z")
my question is when are you gonna have on-site perspective training in Folsom? --- ## [Ignition OPC and MS Update KB5004442 / CVE-2021-26414](https://forum.inductiveautomation.com/t/ignition-opc-and-ms-update-kb5004442-cve-2021-26414/56383)
**Author:** [@econder](https://forum.inductiveautomation.com/u/econder)\ **Replies:** 5\ **Last updated:** [November 14, 2022, 10:09pm UTC](https://forum.inductiveautomation.com/t/ignition-opc-and-ms-update-kb5004442-cve-2021-26414/56383 "2022-11-14T22:09:38Z")
Can you tell me if Ignition OPC communication is affected by CVE-2021-26414 and Microsoft Update KB5004442? --- ## [Start Tag Browser Tree from list of Tag Providers in Perspective](https://forum.inductiveautomation.com/t/start-tag-browser-tree-from-list-of-tag-providers-in-perspective/66147)
**Author:** [@ARez](https://forum.inductiveautomation.com/u/ARez)\ **Replies:** 1\ **Last updated:** [November 14, 2022, 9:50pm UTC](https://forum.inductiveautomation.com/t/start-tag-browser-tree-from-list-of-tag-providers-in-perspective/66147 "2022-11-14T21:50:25Z")
Hi, I am looking to use Tag Browses Tree component in perspective to display tags. Is there a way to start my tree from list of providers? Thanks in advance --- ## [Popup not appearing using scripting](https://forum.inductiveautomation.com/t/popup-not-appearing-using-scripting/66316)
**Author:** [@Tyler\_Folsom](https://forum.inductiveautomation.com/u/Tyler_Folsom)\ **Replies:** 2\ **Last updated:** [November 14, 2022, 9:22pm UTC](https://forum.inductiveautomation.com/t/popup-not-appearing-using-scripting/66316 "2022-11-14T21:22:42Z")
Hello, I am having trouble with getting a popup to display. I have a created a page for users to enter data then press a button upon completion. Depending on the data entered, I require a popup window to appear. I cann… --- ## [\[Feature-5015\] Named Query Copy Parameters Button](https://forum.inductiveautomation.com/t/feature-5015-named-query-copy-parameters-button/66096)
**Author:** [@Matthew.gaitan](https://forum.inductiveautomation.com/u/Matthew.gaitan)\ **Replies:** 0\ **Last updated:** [November 3, 2022, 8:32pm UTC](https://forum.inductiveautomation.com/t/feature-5015-named-query-copy-parameters-button/66096 "2022-11-03T20:32:45Z")
It's currently a pain to write out all the parameters to a system.db.runNamedQuery() call. It would be great if there was a button in the Named Query designer that allowed for quickly copying all of the parameters to be … --- ## [Bacnet Device Creation Automated Scripting Solution](https://forum.inductiveautomation.com/t/bacnet-device-creation-automated-scripting-solution/66075)
**Author:** [@Steve\_Deer](https://forum.inductiveautomation.com/u/Steve_Deer)\ **Replies:** 1\ **Last updated:** [November 14, 2022, 8:59pm UTC](https://forum.inductiveautomation.com/t/bacnet-device-creation-automated-scripting-solution/66075 "2022-11-14T20:59:57Z")
Hey all, Looking to see if anyone has a resource for automating/scripting the device creation process for BacNET devices. Unfortunately, the ignition driver as i feel many are aware for BacNET is lacking and doesn't al… --- ## [Monitoring status from grandstream voip device](https://forum.inductiveautomation.com/t/monitoring-status-from-grandstream-voip-device/65954)
**Author:** [@Dseckel](https://forum.inductiveautomation.com/u/Dseckel)\ **Replies:** 1\ **Last updated:** [November 14, 2022, 8:37pm UTC](https://forum.inductiveautomation.com/t/monitoring-status-from-grandstream-voip-device/65954 "2022-11-14T20:37:27Z")
Has anyone found a way to alarm in ignition if the voip device lost connection? Or if the phone line went down? I am loking for a way to splash a message on a screen if the grandstream went down or that an alarm didnt ca… --- ## [Perspective DateTime Picker in other language](https://forum.inductiveautomation.com/t/perspective-datetime-picker-in-other-language/66494)
**Author:** [@jean.arnosti](https://forum.inductiveautomation.com/u/jean.arnosti)\ **Replies:** 2\ **Last updated:** [November 14, 2022, 8:34pm UTC](https://forum.inductiveautomation.com/t/perspective-datetime-picker-in-other-language/66494 "2022-11-14T20:34:36Z")
Hi All, I am developing a project using Perspective and need a DateTime Picker in French. The actual component available is in English. Is there a way to use translate manager fill my need? Does anyone was able to us… --- ## [Access properties of of component from another view?](https://forum.inductiveautomation.com/t/access-properties-of-of-component-from-another-view/66492)
**Author:** [@Sahil\_Nagpal](https://forum.inductiveautomation.com/u/Sahil_Nagpal)\ **Replies:** 7\ **Last updated:** [November 14, 2022, 8:29pm UTC](https://forum.inductiveautomation.com/t/access-properties-of-of-component-from-another-view/66492 "2022-11-14T20:29:34Z")
Hi, I am trying to link a property which is present in my header view, to one of my components in another view. Is this possible to do? When I try and browse the available properties, I am only seeing properties pertai… --- ## [Conditionally Extracting Rows from Table](https://forum.inductiveautomation.com/t/conditionally-extracting-rows-from-table/65993)
**Author:** [@CMuecke](https://forum.inductiveautomation.com/u/CMuecke)\ **Replies:** 44\ **Last updated:** [November 14, 2022, 7:37pm UTC](https://forum.inductiveautomation.com/t/conditionally-extracting-rows-from-table/65993 "2022-11-14T19:37:13Z")
def transform(self, value, quality, timestamp): RouteData = \[\] # This maps out the list. for row in value: RouteData.append({ "DeviceID": row\["DEVICE\_ID"\], "DeviceName": row\["DEVICE\_NAME"\], "DestinationSel… --- ## [Read Ignition tags from PLC](https://forum.inductiveautomation.com/t/read-ignition-tags-from-plc/66472)
**Author:** [@Nathan\_Higgins1](https://forum.inductiveautomation.com/u/Nathan_Higgins1)\ **Replies:** 7\ **Last updated:** [November 14, 2022, 7:19pm UTC](https://forum.inductiveautomation.com/t/read-ignition-tags-from-plc/66472 "2022-11-14T19:19:05Z")
How do I read Ignition tags from an external device? I have a HMI that needs to read tags out of my ignition project --- ## [Dataset Turning into Int Inside For Loop](https://forum.inductiveautomation.com/t/dataset-turning-into-int-inside-for-loop/66482)
**Author:** [@Isaac\_Hodgkins](https://forum.inductiveautomation.com/u/Isaac_Hodgkins)\ **Replies:** 1\ **Last updated:** [November 14, 2022, 5:28pm UTC](https://forum.inductiveautomation.com/t/dataset-turning-into-int-inside-for-loop/66482 "2022-11-14T17:28:40Z")
type or def runAction(self, event): """ This event is fired when the 'action' of the component occurs. Arguments: self: A reference to the component that is invoking this function. event: An empty event object… --- ## [Perspective Time Series Chart set time range](https://forum.inductiveautomation.com/t/perspective-time-series-chart-set-time-range/66473)
**Author:** [@bfreeman](https://forum.inductiveautomation.com/u/bfreeman)\ **Replies:** 2\ **Last updated:** [November 14, 2022, 4:51pm UTC](https://forum.inductiveautomation.com/t/perspective-time-series-chart-set-time-range/66473 "2022-11-14T16:51:34Z")
Hi, Is it possible to manually set the time range in a Perspective Time Series Chart? Thanks --- ## [OPC structure conversion to tag](https://forum.inductiveautomation.com/t/opc-structure-conversion-to-tag/66457)
**Author:** [@Michal\_Goralczyk](https://forum.inductiveautomation.com/u/Michal_Goralczyk)\ **Replies:** 9\ **Last updated:** [November 14, 2022, 4:38pm UTC](https://forum.inductiveautomation.com/t/opc-structure-conversion-to-tag/66457 "2022-11-14T16:38:19Z")
Hello, I am using the method described in this topic: OPC UA struct data type? My structure in the controller is highly developed. All devices connected to the PLC are represented as a structure. Of course, it is possi… --- ## [Multi-State Indicator mouse click read-write tag to toggle state](https://forum.inductiveautomation.com/t/multi-state-indicator-mouse-click-read-write-tag-to-toggle-state/66468)
**Author:** [@zachary\_larick](https://forum.inductiveautomation.com/u/zachary_larick)\ **Replies:** 4\ **Last updated:** [November 14, 2022, 4:35pm UTC](https://forum.inductiveautomation.com/t/multi-state-indicator-mouse-click-read-write-tag-to-toggle-state/66468 "2022-11-14T16:35:50Z")
I'm attempting to make it so when there is a mouse click on a multi-state indicator it toggles the state between 0-1 and writes this change to the tag. --- ## [Canary historian vs Ignition trends](https://forum.inductiveautomation.com/t/canary-historian-vs-ignition-trends/66465)
**Author:** [@hewking32](https://forum.inductiveautomation.com/u/hewking32)\ **Replies:** 2\ **Last updated:** [November 14, 2022, 1:27pm UTC](https://forum.inductiveautomation.com/t/canary-historian-vs-ignition-trends/66465 "2022-11-14T13:27:15Z")
Hi All Could somebody please advise me if canary ignition data connector be used with standard ignition based trend? thanks for any info in advance! --- ## [PLC leaves high tag values when probes disconnected, how to change this value to something more meaningful](https://forum.inductiveautomation.com/t/plc-leaves-high-tag-values-when-probes-disconnected-how-to-change-this-value-to-something-more-meaningful/66464)
**Author:** [@John\_Reilly](https://forum.inductiveautomation.com/u/John_Reilly)\ **Replies:** 3\ **Last updated:** [November 14, 2022, 1:20pm UTC](https://forum.inductiveautomation.com/t/plc-leaves-high-tag-values-when-probes-disconnected-how-to-change-this-value-to-something-more-meaningful/66464 "2022-11-14T13:20:39Z")
Hi, I am having issue displaying meaningful information on tags when the probes are disconnected and PLC fails these values to high As you can see probes with 1372 values are disconnected and looking to change this t… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=746) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=748)