# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=409 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 410 --- ## [Gateway page not loading via OpenVpn](https://forum.inductiveautomation.com/t/gateway-page-not-loading-via-openvpn/90960)
**Author:** [@Eugene49](https://forum.inductiveautomation.com/u/Eugene49)\ **Replies:** 1\ **Last updated:** [May 27, 2024, 2:50pm UTC](https://forum.inductiveautomation.com/t/gateway-page-not-loading-via-openvpn/90960 "2024-05-27T14:50:41Z")
So I setup OpenVpn Server: Home Network -\> pfSense OpenVpn (hosted in home network) -\> VPN Tunnel Network. Ignition Gateway is on Home Network. My phone/laptop on Tunnel Network via 5G data. From Tunnel Network, I ca… --- ## [Alarm Status Table Double click to open new window](https://forum.inductiveautomation.com/t/alarm-status-table-double-click-to-open-new-window/89555)
**Author:** [@pimemike](https://forum.inductiveautomation.com/u/pimemike)\ **Replies:** 9\ **Last updated:** [May 27, 2024, 1:57pm UTC](https://forum.inductiveautomation.com/t/alarm-status-table-double-click-to-open-new-window/89555 "2024-05-27T13:57:15Z")
I'm in the process of converting a vision project over to perspective and one of the items I'm having a tough time converting is the onDoubleClicked script I created. Vision contains the parameter 'alarmEvent' which all… --- ## [Where to find this script?](https://forum.inductiveautomation.com/t/where-to-find-this-script/90956)
**Author:** [@yahia\_alem](https://forum.inductiveautomation.com/u/yahia_alem)\ **Replies:** 1\ **Last updated:** [May 27, 2024, 1:21pm UTC](https://forum.inductiveautomation.com/t/where-to-find-this-script/90956 "2024-05-27T13:21:12Z")
Hello everyone, I have this event on my UDT who is writing 42 in another variable. What I want to know Is where the function ValueChaned is defined ? I looked in All the scripts that I have in my project but I didn't fi… --- ## [XYChart Xaxis time problem (-1 hour offset)](https://forum.inductiveautomation.com/t/xychart-xaxis-time-problem-1-hour-offset/90957)
**Author:** [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\ **Replies:** 0\ **Last updated:** [May 27, 2024, 1:11pm UTC](https://forum.inductiveautomation.com/t/xychart-xaxis-time-problem-1-hour-offset/90957 "2024-05-27T13:11:32Z")
Hi guys, I'm using a XY chart to show the production status of some machines. I have the data coming from a SQL query and then with a script transform I manage it so to graph this data. The problem is that the dataSour… --- ## [Making X-trace more flexible in power chart](https://forum.inductiveautomation.com/t/making-x-trace-more-flexible-in-power-chart/90954)
**Author:** [@Maryam\_Saeed](https://forum.inductiveautomation.com/u/Maryam_Saeed)\ **Replies:** 0\ **Last updated:** [May 27, 2024, 12:57pm UTC](https://forum.inductiveautomation.com/t/making-x-trace-more-flexible-in-power-chart/90954 "2024-05-27T12:57:50Z")
I want to make my power chart show more data while I hover over the x trace. For instance, include units as these are important for my operator. Power chart only fetches the value. How about utilising the EngUnit. Does … --- ## [Perspective 8.1.24 How to disable right Click showing copy in Table?](https://forum.inductiveautomation.com/t/perspective-8-1-24-how-to-disable-right-click-showing-copy-in-table/90933)
**Author:** [@taohongyu88](https://forum.inductiveautomation.com/u/taohongyu88)\ **Replies:** 4\ **Last updated:** [May 27, 2024, 8:34am UTC](https://forum.inductiveautomation.com/t/perspective-8-1-24-how-to-disable-right-click-showing-copy-in-table/90933 "2024-05-27T08:34:55Z")
In Table ,when I right click in Table's row, it show copy button? I already set Table-Meta-contextMenu -False. I don't want to show the copy, I want to right click add a def submenu such as in Vision? --- ## [Perspective Table Component Customization](https://forum.inductiveautomation.com/t/perspective-table-component-customization/90935)
**Author:** [@Sachin\_Kale2](https://forum.inductiveautomation.com/u/Sachin_Kale2)\ **Replies:** 1\ **Last updated:** [May 27, 2024, 8:16am UTC](https://forum.inductiveautomation.com/t/perspective-table-component-customization/90935 "2024-05-27T08:16:00Z")
Hi, I want to customize perspective table component structure as below, how can I achieve this? --- ## [Report Viewer in scrolling mode?](https://forum.inductiveautomation.com/t/report-viewer-in-scrolling-mode/90862)
**Author:** [@Martin\_Chauveliere](https://forum.inductiveautomation.com/u/Martin_Chauveliere)\ **Replies:** 0\ **Last updated:** [May 24, 2024, 12:21pm UTC](https://forum.inductiveautomation.com/t/report-viewer-in-scrolling-mode/90862 "2024-05-24T12:21:08Z")
Hi guys, I am new to Ignition so my question may be stupid but in Perspective, I've add the Report Viewer Component and Ive created a Report with several pages. I would like to read this report by simply scrolling inst… --- ## [system.db.runPrepUpdate not working for update query, but working for insert query](https://forum.inductiveautomation.com/t/system-db-runprepupdate-not-working-for-update-query-but-working-for-insert-query/90856)
**Author:** [@srinivasan\_s](https://forum.inductiveautomation.com/u/srinivasan_s)\ **Replies:** 8\ **Last updated:** [May 27, 2024, 5:06am UTC](https://forum.inductiveautomation.com/t/system-db-runprepupdate-not-working-for-update-query-but-working-for-insert-query/90856 "2024-05-27T05:06:26Z")
I am using below script which is bind to button component. If button clicked, update query is not working.Just for checking I tried insert, that was working fine! Below is my code. i=self.view.params.row\_id system.db.ru… --- ## [Huge data in sqlth\_sce, Stale Data Detection how to prune records after turn of Stale Data Detection](https://forum.inductiveautomation.com/t/huge-data-in-sqlth-sce-stale-data-detection-how-to-prune-records-after-turn-of-stale-data-detection/90721)
**Author:** [@Lina\_Su](https://forum.inductiveautomation.com/u/Lina_Su)\ **Replies:** 6\ **Last updated:** [May 27, 2024, 12:54am UTC](https://forum.inductiveautomation.com/t/huge-data-in-sqlth-sce-stale-data-detection-how-to-prune-records-after-turn-of-stale-data-detection/90721 "2024-05-27T00:54:54Z")
Does anyone know what is purpose for this table sqlth\_sce. There are over 90,000 records in my table. And for some scid, it's over 40,000 lines. When I check my database log, it keep updating this table and give perfo… --- ## [Z-index not populating to html](https://forum.inductiveautomation.com/t/z-index-not-populating-to-html/90915)
**Author:** [@PFollansbee](https://forum.inductiveautomation.com/u/PFollansbee)\ **Replies:** 9\ **Last updated:** [May 26, 2024, 11:02pm UTC](https://forum.inductiveautomation.com/t/z-index-not-populating-to-html/90915 "2024-05-26T23:02:11Z")
Trying to work with z-index to have different parts overlap. Not sure if I am doing something wrong, but if I set an object to have a non-zero z-index, it doesn't come through to the source. Setting to zero seems fine. … --- ## [Perspective table cell color](https://forum.inductiveautomation.com/t/perspective-table-cell-color/50047)
**Author:** [@eichler-eng](https://forum.inductiveautomation.com/u/eichler-eng)\ **Replies:** 13\ **Last updated:** [May 26, 2024, 12:14pm UTC](https://forum.inductiveautomation.com/t/perspective-table-cell-color/50047 "2024-05-26T12:14:37Z")
Hi All Using this link below I have been able to set the color of individual rows in a Perspective table based on the value of a cell. I would like to set the colors of individual cells. I can see that the script below … --- ## [OPC Item Path takes decimal point on its own](https://forum.inductiveautomation.com/t/opc-item-path-takes-decimal-point-on-its-own/90437)
**Author:** [@Anamay\_Belekar](https://forum.inductiveautomation.com/u/Anamay_Belekar)\ **Replies:** 7\ **Last updated:** [May 25, 2024, 11:29pm UTC](https://forum.inductiveautomation.com/t/opc-item-path-takes-decimal-point-on-its-own/90437 "2024-05-25T23:29:45Z")
Hi.. I have created one UDT and an OPC tag in it. I have used tag parameters for OPC Item Path where {Rack} and {IsSW} are the UDT parameters. But when I create an instance, it is adding decimal point on its own ( .0… --- ## [Ignition can't connect to ModBus RTU device](https://forum.inductiveautomation.com/t/ignition-cant-connect-to-modbus-rtu-device/90823)
**Author:** [@SMarcin](https://forum.inductiveautomation.com/u/SMarcin)\ **Replies:** 6\ **Last updated:** [May 25, 2024, 7:55pm UTC](https://forum.inductiveautomation.com/t/ignition-cant-connect-to-modbus-rtu-device/90823 "2024-05-25T19:55:18Z")
Hello, I have setup a ModbusRTU connection via RS232 which is valid since i am able to read the values from the device using qModMaster, but Ignition doesnt connect to it - status changes from Disconnected to Connecting… --- ## [Help Desk Style Vision Window](https://forum.inductiveautomation.com/t/help-desk-style-vision-window/90904)
**Author:** [@Varsha\_Gottipati1](https://forum.inductiveautomation.com/u/Varsha_Gottipati1)\ **Replies:** 4\ **Last updated:** [May 25, 2024, 5:22pm UTC](https://forum.inductiveautomation.com/t/help-desk-style-vision-window/90904 "2024-05-25T17:22:06Z")
Any idea how to create a "Help Desk" Style window in vision? I would like to create a window for operators in Production floor to be able to input any issues they encounter and address them to the appropriate department. … --- ## [Snowflake Query Issue](https://forum.inductiveautomation.com/t/snowflake-query-issue/90719)
**Author:** [@Collin\_Hodges](https://forum.inductiveautomation.com/u/Collin_Hodges)\ **Replies:** 2\ **Last updated:** [May 25, 2024, 12:57pm UTC](https://forum.inductiveautomation.com/t/snowflake-query-issue/90719 "2024-05-25T12:57:16Z")
I setup a JDBC Drive, a custom translator and a database connection to snowflake according to the insrtuctions. https://support.inductiveautomation.com/hc/en-us/articles/4408715117197-Creating-database-connections-with-c… --- ## [Implementing Auto Scroll for Flex Repeater](https://forum.inductiveautomation.com/t/implementing-auto-scroll-for-flex-repeater/73572)
**Author:** [@mdia](https://forum.inductiveautomation.com/u/mdia)\ **Replies:** 4\ **Last updated:** [May 25, 2024, 10:09am UTC](https://forum.inductiveautomation.com/t/implementing-auto-scroll-for-flex-repeater/73572 "2024-05-25T10:09:24Z")
I'm working on a project where I have a view with a flex repeater that could potentially create up to 20 instances or maybe more. All these instances won't fit on a single screen due to space constraints, which leads to … --- ## [Easy Chart Dates via Button](https://forum.inductiveautomation.com/t/easy-chart-dates-via-button/90907)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 1\ **Last updated:** [May 24, 2024, 9:50pm UTC](https://forum.inductiveautomation.com/t/easy-chart-dates-via-button/90907 "2024-05-24T21:50:40Z")
I don't know why this isn't working. I want a button to automatically set the historical chart to the last X hours (X) being a custom property on the button, bound to a dropdown's selected value. now = system.date.now()… --- ## [How to add data from a query to my report](https://forum.inductiveautomation.com/t/how-to-add-data-from-a-query-to-my-report/90882)
**Author:** [@Esme\_Lopez](https://forum.inductiveautomation.com/u/Esme_Lopez)\ **Replies:** 2\ **Last updated:** [May 24, 2024, 9:13pm UTC](https://forum.inductiveautomation.com/t/how-to-add-data-from-a-query-to-my-report/90882 "2024-05-24T21:13:33Z")
Hello everyone I have a query in the section data sources of a report Do you know how can I add every column of the query to a table in the page of the report? --- ## [Help with History binding to query tag](https://forum.inductiveautomation.com/t/help-with-history-binding-to-query-tag/90895)
**Author:** [@Michael\_Smith](https://forum.inductiveautomation.com/u/Michael_Smith)\ **Replies:** 13\ **Last updated:** [May 24, 2024, 8:48pm UTC](https://forum.inductiveautomation.com/t/help-with-history-binding-to-query-tag/90895 "2024-05-24T20:48:36Z")
Hi there I have a query tag setup with history enabled. I was then going to bind the data of a table to a tag history binding using the query tag history. Problem is I can only get it to return 4 rows, and the value r… --- ## [Serial port com open failed](https://forum.inductiveautomation.com/t/serial-port-com-open-failed/90903)
**Author:** [@Cedric\_BIGOT](https://forum.inductiveautomation.com/u/Cedric_BIGOT)\ **Replies:** 1\ **Last updated:** [May 24, 2024, 8:26pm UTC](https://forum.inductiveautomation.com/t/serial-port-com-open-failed/90903 "2024-05-24T20:26:36Z")
Hi, I try to make screen for read UID number of and mifare card. I put USB card-reader on my computer (the gateway is on a server) look for my port number (COM6) and try my code in the designer script console. port\_co… --- ## [\[BUG-9926\] Ignition Voice Notification Module: Address already in use](https://forum.inductiveautomation.com/t/bug-9926-ignition-voice-notification-module-address-already-in-use/90792)
**Author:** [@diamond](https://forum.inductiveautomation.com/u/diamond)\ **Replies:** 7\ **Last updated:** [May 24, 2024, 8:02pm UTC](https://forum.inductiveautomation.com/t/bug-9926-ignition-voice-notification-module-address-already-in-use/90792 "2024-05-24T20:02:16Z")
Hello, I have a clean Ignition 8.1.40 install in a brand new Windows Server virtual machine. In another server, I have an Ignition 8.1.31 instance under docker. In the docker instance, I can perform VOIP calls with AWS… --- ## [8.1.40 Pulled, 8.1.41 Emergency Release](https://forum.inductiveautomation.com/t/8-1-40-pulled-8-1-41-emergency-release/90901)
**Author:** [@sreis](https://forum.inductiveautomation.com/u/sreis)\ **Replies:** 0\ **Last updated:** [May 24, 2024, 7:06pm UTC](https://forum.inductiveautomation.com/t/8-1-40-pulled-8-1-41-emergency-release/90901 "2024-05-24T19:06:16Z")
Ignition 8.1.40 has been removed from our website and will be replaced with 8.1.41 as soon as possible. Upgrades or new installations are experiencing an error with their VOIP Voice Notification profiles upon gateway res… --- ## [Username Tag to Hold Current Session User](https://forum.inductiveautomation.com/t/username-tag-to-hold-current-session-user/90892)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 4\ **Last updated:** [May 24, 2024, 6:49pm UTC](https://forum.inductiveautomation.com/t/username-tag-to-hold-current-session-user/90892 "2024-05-24T18:49:05Z")
What is the best strategy to document the current user of a perspective session in a tag? I will use the tag in a transaction group. I've experimented with a runScript() expression inside the UDT with this \[ x\['userna… --- ## [Audit Events not logging when using system.tag.write?](https://forum.inductiveautomation.com/t/audit-events-not-logging-when-using-system-tag-write/90845)
**Author:** [@taohongyu88](https://forum.inductiveautomation.com/u/taohongyu88)\ **Replies:** 5\ **Last updated:** [May 24, 2024, 6:29pm UTC](https://forum.inductiveautomation.com/t/audit-events-not-logging-when-using-system-tag-write/90845 "2024-05-24T18:29:29Z")
I have two types of binding and control a valve. One : Direct bind Tag Audit Events can log the tag write . Two: Click Script write Tag Audit Events can't log the tag write . How to resolve the Two questi… --- ## [Tag value changed script "currentValue" always true when used in if statement?](https://forum.inductiveautomation.com/t/tag-value-changed-script-currentvalue-always-true-when-used-in-if-statement/90898)
**Author:** [@Joshua\_Graham](https://forum.inductiveautomation.com/u/Joshua_Graham)\ **Replies:** 3\ **Last updated:** [May 24, 2024, 6:26pm UTC](https://forum.inductiveautomation.com/t/tag-value-changed-script-currentvalue-always-true-when-used-in-if-statement/90898 "2024-05-24T18:26:02Z")
I've had to use the "System.tag.read" to get the value of the tag within the "Value Changed" script because "currentValue" is inconsistent. When I use it with an if statement it always thinks it's true, when I use it wit… --- ## [Cannot Convert String to Java INT](https://forum.inductiveautomation.com/t/cannot-convert-string-to-java-int/90880)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 9\ **Last updated:** [May 24, 2024, 6:04pm UTC](https://forum.inductiveautomation.com/t/cannot-convert-string-to-java-int/90880 "2024-05-24T18:04:27Z")
I have this script that creates a dataset. Runs fine in the script console with the same path provided, but I get an type conversion error when using runScript() on an expression dataset tag. def getDistributorDropdownD… --- ## [Styling table rows with embedded view columns](https://forum.inductiveautomation.com/t/styling-table-rows-with-embedded-view-columns/90819)
**Author:** [@Ty\_Mittleider](https://forum.inductiveautomation.com/u/Ty_Mittleider)\ **Replies:** 5\ **Last updated:** [May 24, 2024, 5:52pm UTC](https://forum.inductiveautomation.com/t/styling-table-rows-with-embedded-view-columns/90819 "2024-05-24T17:52:11Z")
I have been trying to style a table component to change the color of rows that have a certain column value. This I can do fairly easily, but it breaks the embedded view that I have set on one of the columns. I believe th… --- ## [Inserting PLC values into a table with a Gateway Event Tag Change Script](https://forum.inductiveautomation.com/t/inserting-plc-values-into-a-table-with-a-gateway-event-tag-change-script/90235)
**Author:** [@Luke\_Smith1](https://forum.inductiveautomation.com/u/Luke_Smith1)\ **Replies:** 12\ **Last updated:** [May 24, 2024, 5:44pm UTC](https://forum.inductiveautomation.com/t/inserting-plc-values-into-a-table-with-a-gateway-event-tag-change-script/90235 "2024-05-24T17:44:18Z")
Hi all, I have created a Named Query that inserts two parameters (values) into a table. I would like to have a Gateway Tag Change Script that runs the Named Query when a PLC tag changes and provides the PLC values to th… --- ## [Adding a transform to Table Data being written from a property change script](https://forum.inductiveautomation.com/t/adding-a-transform-to-table-data-being-written-from-a-property-change-script/90889)
**Author:** [@Luke\_Smith1](https://forum.inductiveautomation.com/u/Luke_Smith1)\ **Replies:** 8\ **Last updated:** [May 24, 2024, 5:32pm UTC](https://forum.inductiveautomation.com/t/adding-a-transform-to-table-data-being-written-from-a-property-change-script/90889 "2024-05-24T17:32:55Z")
Hello everyone! I am using a property change script to write data to a table. I then need to add a transform to modify the colors of the rows of the table depending on the value inside of them. When Trigger becomes True… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=408) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=410)