# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1141 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1142 --- ## [MySQL database query oddity](https://forum.inductiveautomation.com/t/mysql-database-query-oddity/37427)
**Author:** [@weertske](https://forum.inductiveautomation.com/u/weertske)\ **Replies:** 7\ **Last updated:** [August 7, 2020, 7:15pm UTC](https://forum.inductiveautomation.com/t/mysql-database-query-oddity/37427 "2020-08-07T19:15:19Z")
@PGriffith I am running this query against a MySQL database: select recipeData from Recipes where recipeId = “a2daf0ae-d35a-11ea-b3a8-069f50ec786e” If I run this query from a 7.9 machine, unusual characters (unicode) g… --- ## [system.net.openURL: keep browser open, replace tab on openURL script](https://forum.inductiveautomation.com/t/system-net-openurl-keep-browser-open-replace-tab-on-openurl-script/37514)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 0\ **Last updated:** [August 7, 2020, 6:48pm UTC](https://forum.inductiveautomation.com/t/system-net-openurl-keep-browser-open-replace-tab-on-openurl-script/37514 "2020-08-07T18:48:29Z")
I was going to use the web browser component but it does not work on a raspberry pi, so now I have a URL that I am opening to display information based on a scan with system.net.openURL(). It is much faster if I leave t… --- ## [Error Writing to "tag" value is not an array](https://forum.inductiveautomation.com/t/error-writing-to-tag-value-is-not-an-array/37510)
**Author:** [@Alejandro01r](https://forum.inductiveautomation.com/u/Alejandro01r)\ **Replies:** 1\ **Last updated:** [August 7, 2020, 5:34pm UTC](https://forum.inductiveautomation.com/t/error-writing-to-tag-value-is-not-an-array/37510 "2020-08-07T17:34:25Z")
Hello guys, Quite new to ignition. I ran into an issue where i cannot write to an Integer array. Could someone lend me a hand. Thx! --- ## [Report issues with JSON data](https://forum.inductiveautomation.com/t/report-issues-with-json-data/37500)
**Author:** [@philc](https://forum.inductiveautomation.com/u/philc)\ **Replies:** 3\ **Last updated:** [August 7, 2020, 5:33pm UTC](https://forum.inductiveautomation.com/t/report-issues-with-json-data/37500 "2020-08-07T17:33:18Z")
I am struggling in my attempt to create a report using some http json as a datasource. in my first attempt the data loads but I don’t get access to the individual fields to properly create a report. If I manually enter t… --- ## [Table group / nested query problem](https://forum.inductiveautomation.com/t/table-group-nested-query-problem/33287)
**Author:** [@wpmccormick](https://forum.inductiveautomation.com/u/wpmccormick)\ **Replies:** 3\ **Last updated:** [August 7, 2020, 4:59pm UTC](https://forum.inductiveautomation.com/t/table-group-nested-query-problem/33287 "2020-08-07T16:59:25Z")
I have a problem using table groups with a nested query back-end. It seems that trying to print each new row of the parent table on a new page (New page per row option) stops the first time the child table has no data. S… --- ## [Ignition OPC UA Server and OPC Foundation Local Discovery Server](https://forum.inductiveautomation.com/t/ignition-opc-ua-server-and-opc-foundation-local-discovery-server/37509)
**Author:** [@eoursel](https://forum.inductiveautomation.com/u/eoursel)\ **Replies:** 1\ **Last updated:** [August 7, 2020, 4:57pm UTC](https://forum.inductiveautomation.com/t/ignition-opc-ua-server-and-opc-foundation-local-discovery-server/37509 "2020-08-07T16:57:20Z")
Hi Kevin It looks like Ocean Data Dream Report tries to find OPC UA servers on the Local Discovery Server (LDS) running on port 4840 by default. It seems it does not support the custom discovery URL you are using opc.t… --- ## [Gateway Errors](https://forum.inductiveautomation.com/t/gateway-errors/2655)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 4\ **Last updated:** [August 7, 2020, 4:42pm UTC](https://forum.inductiveautomation.com/t/gateway-errors/2655 "2020-08-07T16:42:16Z")
I get this recurring error several times per day: "Connection to Gateway lost, due to exception" "Gateway Error 600: Address already in use: connect" Can you tell me what I should be looking at to figure out where the… --- ## [What do red resize handles mean in vision designer](https://forum.inductiveautomation.com/t/what-do-red-resize-handles-mean-in-vision-designer/37501)
**Author:** [@dirk1](https://forum.inductiveautomation.com/u/dirk1)\ **Replies:** 2\ **Last updated:** [August 7, 2020, 3:02pm UTC](https://forum.inductiveautomation.com/t/what-do-red-resize-handles-mean-in-vision-designer/37501 "2020-08-07T15:02:33Z")
I’m guessing these are trying to tell me something important since my navigate button does not work. Assumed it meant I was outside some sort of boundary, but shrinking component didn’t help. --- ## [Number of MQTT Clients](https://forum.inductiveautomation.com/t/number-of-mqtt-clients/37224)
**Author:** [@kumar.chellappan](https://forum.inductiveautomation.com/u/kumar.chellappan)\ **Replies:** 1\ **Last updated:** [August 7, 2020, 2:39pm UTC](https://forum.inductiveautomation.com/t/number-of-mqtt-clients/37224 "2020-08-07T14:39:58Z")
Hi, I do see Nodes Offline and Nodes Online, Node Unit Count but I don’t see them changing values. I believe it is Related to the no of servers. I am not using Ignition Edge Transmission. I am using RedLion DA30 to sen… --- ## [Scripting question with custom property](https://forum.inductiveautomation.com/t/scripting-question-with-custom-property/37484)
**Author:** [@trishadx](https://forum.inductiveautomation.com/u/trishadx)\ **Replies:** 3\ **Last updated:** [August 7, 2020, 2:07pm UTC](https://forum.inductiveautomation.com/t/scripting-question-with-custom-property/37484 "2020-08-07T14:07:22Z")
Hi guys, could someone please point out where I’m going wrong. my scripting skills are far from intermediate… I’m trying to make a component change its visibility depending on if an alarm is active for that tag or not,… --- ## [Calling custom methods from a different view without messages](https://forum.inductiveautomation.com/t/calling-custom-methods-from-a-different-view-without-messages/37499)
**Author:** [@aeryavec](https://forum.inductiveautomation.com/u/aeryavec)\ **Replies:** 1\ **Last updated:** [August 7, 2020, 1:26pm UTC](https://forum.inductiveautomation.com/t/calling-custom-methods-from-a-different-view-without-messages/37499 "2020-08-07T13:26:43Z")
I am trying to determine the most effective way to call a custom method on a main view from a popup opened by a button on the main view. Since the popup is a different view than the main view I am unable to directly refe… --- ## [AbstractDBCommand Read timedout in sql a query time out and HMI shows all RED boxes](https://forum.inductiveautomation.com/t/abstractdbcommand-read-timedout-in-sql-a-query-time-out-and-hmi-shows-all-red-boxes/37497)
**Author:** [@deancable](https://forum.inductiveautomation.com/u/deancable)\ **Replies:** 1\ **Last updated:** [August 7, 2020, 12:24pm UTC](https://forum.inductiveautomation.com/t/abstractdbcommand-read-timedout-in-sql-a-query-time-out-and-hmi-shows-all-red-boxes/37497 "2020-08-07T12:24:06Z")
Hello, I tried to search on AbstractDBCommand and found some threads about queries timing out and basically the answer was…fix the indexes on the tables so the query does not time out. However, what about when yo… --- ## [Update Gateway Failed](https://forum.inductiveautomation.com/t/update-gateway-failed/37401)
**Author:** [@twstevic](https://forum.inductiveautomation.com/u/twstevic)\ **Replies:** 2\ **Last updated:** [August 7, 2020, 12:18pm UTC](https://forum.inductiveautomation.com/t/update-gateway-failed/37401 "2020-08-07T12:18:11Z")
I am trying to update Ignition from 8.0.10 to 8.0.15. I downloaded the file and ran the installer. I am getting ‘Ignition Gateway Is Starting’, This may take a while’. It has been trying to start for well over 30 minute… --- ## [Perspective Table numberFormat Percentage multiply by 100](https://forum.inductiveautomation.com/t/perspective-table-numberformat-percentage-multiply-by-100/37492)
**Author:** [@Brett\_Yeomans](https://forum.inductiveautomation.com/u/Brett_Yeomans)\ **Replies:** 0\ **Last updated:** [August 7, 2020, 8:48am UTC](https://forum.inductiveautomation.com/t/perspective-table-numberformat-percentage-multiply-by-100/37492 "2020-08-07T08:48:52Z")
What was the outcome to having a percentage suffix? Like the forum entry below if I select % for my column it multiplies the value by 100. --- ## [Path of a Component In A Container](https://forum.inductiveautomation.com/t/path-of-a-component-in-a-container/26833)
**Author:** [@ammermanbrittanyf](https://forum.inductiveautomation.com/u/ammermanbrittanyf)\ **Replies:** 5\ **Last updated:** [August 7, 2020, 3:48am UTC](https://forum.inductiveautomation.com/t/path-of-a-component-in-a-container/26833 "2020-08-07T03:48:37Z")
Hello. I recently put about 20 check boxes into a container. I am hoping to then read those check boxes to update a power table. However, I can not figure out what the path of the check box is to obtain the value. I am d… --- ## [What kind of data is event.data?](https://forum.inductiveautomation.com/t/what-kind-of-data-is-event-data/37489)
**Author:** [@pdixon](https://forum.inductiveautomation.com/u/pdixon)\ **Replies:** 2\ **Last updated:** [August 7, 2020, 3:42am UTC](https://forum.inductiveautomation.com/t/what-kind-of-data-is-event-data/37489 "2020-08-07T03:42:42Z")
I have a table and when I click on a row I want to set a text label to the selected value in the table. The onSelectionChange script is: This returns event.data, which contains the data I want. What I get is a valu… --- ## [Clear textfields with Client Event Script](https://forum.inductiveautomation.com/t/clear-textfields-with-client-event-script/37380)
**Author:** [@jesusaltamirano600](https://forum.inductiveautomation.com/u/jesusaltamirano600)\ **Replies:** 14\ **Last updated:** [August 7, 2020, 3:18am UTC](https://forum.inductiveautomation.com/t/clear-textfields-with-client-event-script/37380 "2020-08-07T03:18:33Z")
Hello. I would like to ask for your help with this issue. I’m trying to create a SCRIPT to clear a group of textfields when a Client Tag changes its value. Basically I have the following code in the Client Tag change pr… --- ## [User Management Issues](https://forum.inductiveautomation.com/t/user-management-issues/35413)
**Author:** [@idioknna](https://forum.inductiveautomation.com/u/idioknna)\ **Replies:** 1\ **Last updated:** [June 10, 2020, 11:37am UTC](https://forum.inductiveautomation.com/t/user-management-issues/35413 "2020-06-10T11:37:47Z")
I need help trying to configure user management component to be able to edit every user information by having an administrative role (example: Admin Role) and restricting anyother user without admin roles from editing ot… --- ## [Designer's pop up calender](https://forum.inductiveautomation.com/t/designers-pop-up-calender/37455)
**Author:** [@trishadx](https://forum.inductiveautomation.com/u/trishadx)\ **Replies:** 2\ **Last updated:** [August 6, 2020, 10:12pm UTC](https://forum.inductiveautomation.com/t/designers-pop-up-calender/37455 "2020-08-06T22:12:06Z")
Hi all, can anyone point me to the right direction on using the pop up calendar components on designer? ATM I have it to show the current date and time. however i would like it to be manipulated e.g. to show certain al… --- ## [Gateway Tag Change Script not finishing](https://forum.inductiveautomation.com/t/gateway-tag-change-script-not-finishing/37467)
**Author:** [@wpmccormick](https://forum.inductiveautomation.com/u/wpmccormick)\ **Replies:** 12\ **Last updated:** [August 6, 2020, 9:41pm UTC](https://forum.inductiveautomation.com/t/gateway-tag-change-script-not-finishing/37467 "2020-08-06T21:41:23Z")
I have a Gateway Tag Change script that seems not to finish. I know it starts, but it seems to fail when calling a project script in a the Script Library that does some recursive browseTags. My intent is have this script… --- ## [Ignition Client blocked by Java Security](https://forum.inductiveautomation.com/t/ignition-client-blocked-by-java-security/37462)
**Author:** [@meredithj](https://forum.inductiveautomation.com/u/meredithj)\ **Replies:** 3\ **Last updated:** [August 6, 2020, 8:40pm UTC](https://forum.inductiveautomation.com/t/ignition-client-blocked-by-java-security/37462 "2020-08-06T20:40:42Z")
Hi there, I am running an ignition 7.9.3 server and every time I launch a project, I am getting an error saying that the Ignition Client is Blocked by Java Security. The latest fix I could find for this is here: https… --- ## [Modbus ASII Read to String value](https://forum.inductiveautomation.com/t/modbus-asii-read-to-string-value/37474)
**Author:** [@DSI600](https://forum.inductiveautomation.com/u/DSI600)\ **Replies:** 5\ **Last updated:** [August 6, 2020, 7:11pm UTC](https://forum.inductiveautomation.com/t/modbus-asii-read-to-string-value/37474 "2020-08-06T19:11:32Z")
I have looked around the forum but can’t find my exact problem. I need to read a ASCII string from a device (It is not a PLC) It is a standalone machine with control boards on it that does have Modbus TCP. I can read i… --- ## [How to use httpGet & httpPost for SOAP Endpoint](https://forum.inductiveautomation.com/t/how-to-use-httpget-httppost-for-soap-endpoint/37421)
**Author:** [@harigobu.gb](https://forum.inductiveautomation.com/u/harigobu.gb)\ **Replies:** 4\ **Last updated:** [August 6, 2020, 6:02pm UTC](https://forum.inductiveautomation.com/t/how-to-use-httpget-httppost-for-soap-endpoint/37421 "2020-08-06T18:02:02Z")
Hi, I have created SOAP endpoint using Sepasoft Web services module. How to invoke the soap endpoint url using system.net.httpGet or system.net.httpPost . I tried the soap endpoint url using httpGet in script console … --- ## [Multiple docker instances on the same host share the same connection](https://forum.inductiveautomation.com/t/multiple-docker-instances-on-the-same-host-share-the-same-connection/37452)
**Author:** [@abiesbiogas](https://forum.inductiveautomation.com/u/abiesbiogas)\ **Replies:** 2\ **Last updated:** [August 6, 2020, 5:57pm UTC](https://forum.inductiveautomation.com/t/multiple-docker-instances-on-the-same-host-share-the-same-connection/37452 "2020-08-06T17:57:32Z")
I run more than one ignition container on the same host, binding the ports 8088 and 8043 to different couples for each instance and it’s really cool, because in a while I can set up the gateway and work with several desi… --- ## [Remove scrollbar from template instance and scrollbar customization](https://forum.inductiveautomation.com/t/remove-scrollbar-from-template-instance-and-scrollbar-customization/37469)
**Author:** [@Neo](https://forum.inductiveautomation.com/u/Neo)\ **Replies:** 0\ **Last updated:** [August 6, 2020, 5:11pm UTC](https://forum.inductiveautomation.com/t/remove-scrollbar-from-template-instance-and-scrollbar-customization/37469 "2020-08-06T17:11:14Z")
I have a template (with template canvas inside it). This template is used inside a template repeater. Every template instance in template repeater shows individual vertical scrollbar whenever there is more data in it. Bu… --- ## [Binding Transforms Best Practices](https://forum.inductiveautomation.com/t/binding-transforms-best-practices/24899)
**Author:** [@justin.brzozoski](https://forum.inductiveautomation.com/u/justin.brzozoski)\ **Replies:** 2\ **Last updated:** [August 6, 2020, 3:34pm UTC](https://forum.inductiveautomation.com/t/binding-transforms-best-practices/24899 "2020-08-06T15:34:53Z")
Here’s a question I haven’t found an answer for in either the manual or the forums: what are the best practice guidelines on when to choose between expressions, scripting, or the simpler binding transformations like mapp… --- ## [Clicking on Embedded View - no actionPerformed](https://forum.inductiveautomation.com/t/clicking-on-embedded-view-no-actionperformed/37392)
**Author:** [@john.glynn](https://forum.inductiveautomation.com/u/john.glynn)\ **Replies:** 1\ **Last updated:** [August 6, 2020, 3:48pm UTC](https://forum.inductiveautomation.com/t/clicking-on-embedded-view-no-actionperformed/37392 "2020-08-06T15:48:18Z")
I have a screen that shows a summary of various process cells in embedded views. These embedded views do not have any buttons, just some gauges and spark lines. I want a user to be able to click anywhere on the embedded … --- ## [Info box text in time series component in perspective](https://forum.inductiveautomation.com/t/info-box-text-in-time-series-component-in-perspective/37423)
**Author:** [@mbai1](https://forum.inductiveautomation.com/u/mbai1)\ **Replies:** 2\ **Last updated:** [August 6, 2020, 2:54pm UTC](https://forum.inductiveautomation.com/t/info-box-text-in-time-series-component-in-perspective/37423 "2020-08-06T14:54:25Z")
Hello, I am working with time series component and trying to change the text for the info box. Right now it is automatically referring to the column name of dateset, which is unchangeable. I am wondering if I can custom… --- ## [Binding Multi-State Button](https://forum.inductiveautomation.com/t/binding-multi-state-button/37453)
**Author:** [@Alejandro01r](https://forum.inductiveautomation.com/u/Alejandro01r)\ **Replies:** 2\ **Last updated:** [August 6, 2020, 1:54pm UTC](https://forum.inductiveautomation.com/t/binding-multi-state-button/37453 "2020-08-06T13:54:31Z")
How do I bind different tags to a Multi State Button in Perspective view?. I have 3 modes. Auto, Manual, Disable. I have a specific tag value indicator each state is on. A specific tag value to write the command. How … --- ## [Power Table configureCell intermittently returns the wrong result for up to the entire table](https://forum.inductiveautomation.com/t/power-table-configurecell-intermittently-returns-the-wrong-result-for-up-to-the-entire-table/37338)
**Author:** [@liam.mcglaughlin](https://forum.inductiveautomation.com/u/liam.mcglaughlin)\ **Replies:** 6\ **Last updated:** [August 6, 2020, 1:03pm UTC](https://forum.inductiveautomation.com/t/power-table-configurecell-intermittently-returns-the-wrong-result-for-up-to-the-entire-table/37338 "2020-08-06T13:03:11Z")
I have a power table that has an issue with the formatting. The table has a column with timestamps, 10 value columns, then 2 limit columns. The configure cell code (below) should reference the limit columns for the value… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1140) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1142)