# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=577 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 578 --- ## [How to properly set Message Handler Scope](https://forum.inductiveautomation.com/t/how-to-properly-set-message-handler-scope/77733)
**Author:** [@Eugene49](https://forum.inductiveautomation.com/u/Eugene49)\ **Replies:** 4\ **Last updated:** [September 10, 2023, 3:36pm UTC](https://forum.inductiveautomation.com/t/how-to-properly-set-message-handler-scope/77733 "2023-09-10T15:36:35Z")
Hi, In this case, the sender is on a small view. On small view -\> root -\> onClicked event -\> sendMessage This small view, is instantiated on a large view. On large view -\> root -\> script -\> message handler listening. … --- ## [Writing to two databases at the same time](https://forum.inductiveautomation.com/t/writing-to-two-databases-at-the-same-time/78945)
**Author:** [@brandon222](https://forum.inductiveautomation.com/u/brandon222)\ **Replies:** 4\ **Last updated:** [September 10, 2023, 5:24am UTC](https://forum.inductiveautomation.com/t/writing-to-two-databases-at-the-same-time/78945 "2023-09-10T05:24:28Z")
Does Ignition have a way to write the same data to two different databases at the same time. Like two different MySQL servers at the same time? --- ## [Button scripting](https://forum.inductiveautomation.com/t/button-scripting/78897)
**Author:** [@Roy](https://forum.inductiveautomation.com/u/Roy)\ **Replies:** 6\ **Last updated:** [September 10, 2023, 4:32am UTC](https://forum.inductiveautomation.com/t/button-scripting/78897 "2023-09-10T04:32:19Z")
New to Ignition and still struggling with my first project. I have three states (tags) that I need to control. Manual, Off, and Auto states (A rocker switch operation). Only one state should be active at a time; when ne… --- ## [Client over VPN](https://forum.inductiveautomation.com/t/client-over-vpn/78886)
**Author:** [@lyhkch](https://forum.inductiveautomation.com/u/lyhkch)\ **Replies:** 8\ **Last updated:** [September 10, 2023, 1:47am UTC](https://forum.inductiveautomation.com/t/client-over-vpn/78886 "2023-09-10T01:47:54Z")
Hi, V7.9.9, the client over vpn connect to the Server, I can open the web of gateway on client ,but can't download the currect client application, so i should check what? Thanks. --- ## [Unable to set port 80 on Ubuntu 20.04](https://forum.inductiveautomation.com/t/unable-to-set-port-80-on-ubuntu-20-04/53307)
**Author:** [@kgamble](https://forum.inductiveautomation.com/u/kgamble)\ **Replies:** 16\ **Last updated:** [September 10, 2023, 1:20am UTC](https://forum.inductiveautomation.com/t/unable-to-set-port-80-on-ubuntu-20-04/53307 "2023-09-10T01:20:02Z")
Trying to set the default port to 80 on a gateway but getting the following error message: The Entered http port 1-1023 is not allowed by the system. Please enter a different one I am fairly certain its just a linux is… --- ## [How to justify Ignition to decision makers who are not familiar with the SCADA space](https://forum.inductiveautomation.com/t/how-to-justify-ignition-to-decision-makers-who-are-not-familiar-with-the-scada-space/72845)
**Author:** [@cbanzet](https://forum.inductiveautomation.com/u/cbanzet)\ **Replies:** 64\ **Last updated:** [September 9, 2023, 2:20pm UTC](https://forum.inductiveautomation.com/t/how-to-justify-ignition-to-decision-makers-who-are-not-familiar-with-the-scada-space/72845 "2023-09-09T14:20:47Z")
There's a tl;dr further down the page. There was a similar question asked back in 2012 here, Make the case for Ignition, and I feel that Ignition has changed enough since then that it warrants being updated for the time… --- ## [MySQL connection failed](https://forum.inductiveautomation.com/t/mysql-connection-failed/78891)
**Author:** [@John\_Morgan1](https://forum.inductiveautomation.com/u/John_Morgan1)\ **Replies:** 3\ **Last updated:** [September 9, 2023, 1:37pm UTC](https://forum.inductiveautomation.com/t/mysql-connection-failed/78891 "2023-09-09T13:37:57Z")
Hi, I am trying to connect to a MySQL DB but I get this error message Cannot create PoolableConnectionFactory (Unknown database 'test') I have tried uninstalling both ignition and MySQL and installing them again and u… --- ## [Combining Report Data Sources](https://forum.inductiveautomation.com/t/combining-report-data-sources/78829)
**Author:** [@cole.young34](https://forum.inductiveautomation.com/u/cole.young34)\ **Replies:** 7\ **Last updated:** [September 9, 2023, 10:39am UTC](https://forum.inductiveautomation.com/t/combining-report-data-sources/78829 "2023-09-09T10:39:42Z")
Hi Everyone I am trying to combine two Report Data Sources into one. I found this post and have it working for the most part. Here is my code: def updateData(data, sample): #data\['myKey'\]='Example' levelDataset =… --- ## [Dynamic Bar Graph Segment Colors and using SQL query to populate the graph](https://forum.inductiveautomation.com/t/dynamic-bar-graph-segment-colors-and-using-sql-query-to-populate-the-graph/20128)
**Author:** [@Faisal.Shibli](https://forum.inductiveautomation.com/u/Faisal.Shibli)\ **Replies:** 6\ **Last updated:** [September 9, 2023, 3:26am UTC](https://forum.inductiveautomation.com/t/dynamic-bar-graph-segment-colors-and-using-sql-query-to-populate-the-graph/20128 "2023-09-09T03:26:52Z")
I am populating the bar graph using the sql query in the report viewer. I am successfully able to populate the bar graph however I would like the bars colour based on condition such as (Please see Bar Chart 1). Now look… --- ## [Power Table has active filter](https://forum.inductiveautomation.com/t/power-table-has-active-filter/78929)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 1\ **Last updated:** [September 8, 2023, 9:37pm UTC](https://forum.inductiveautomation.com/t/power-table-has-active-filter/78929 "2023-09-08T21:37:20Z")
Version 8.1.25 and Vision The question is if I have a power table, can I bind the visibility of something like a label that says 'Filters Active' whenever a power table in my window has a filter on. The only way I could… --- ## [Time Series Chart - forcing the X-axis range and grid offset](https://forum.inductiveautomation.com/t/time-series-chart-forcing-the-x-axis-range-and-grid-offset/78903)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 1\ **Last updated:** [September 8, 2023, 8:46pm UTC](https://forum.inductiveautomation.com/t/time-series-chart-forcing-the-x-axis-range-and-grid-offset/78903 "2023-09-08T20:46:30Z")
I've a couple of problems: By default the Time Series Chart uses the first and last values of the first column of data as the range for the x-axis. I want to display a full 24 hours starting on a particular hour (typ… --- ## [Named query in Expression, with Params](https://forum.inductiveautomation.com/t/named-query-in-expression-with-params/78885)
**Author:** [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\ **Replies:** 5\ **Last updated:** [September 8, 2023, 8:29pm UTC](https://forum.inductiveautomation.com/t/named-query-in-expression-with-params/78885 "2023-09-08T20:29:56Z")
Hi all, I have a view with many text fields that will indicate which users put their fingers in the pie. The underlying data stores the users as numbers, as a reference to a "User ID". The view pulls the data via a na… --- ## [GAN Incoming Connection Issue](https://forum.inductiveautomation.com/t/gan-incoming-connection-issue/78883)
**Author:** [@rsnaik](https://forum.inductiveautomation.com/u/rsnaik)\ **Replies:** 4\ **Last updated:** [September 8, 2023, 7:52pm UTC](https://forum.inductiveautomation.com/t/gan-incoming-connection-issue/78883 "2023-09-08T19:52:41Z")
Hello Team, We are trying to establish GAN connection between two server, But not able to get the certificate for approval under incoming connection. we tried both ways S1 to S2 and vice versa. Both are able to pin… --- ## [Perspective Carousel: Handheld Using Android App is Super Slow](https://forum.inductiveautomation.com/t/perspective-carousel-handheld-using-android-app-is-super-slow/78930)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 0\ **Last updated:** [September 8, 2023, 7:01pm UTC](https://forum.inductiveautomation.com/t/perspective-carousel-handheld-using-android-app-is-super-slow/78930 "2023-09-08T19:01:14Z")
I'm using a handheld barcode scanner in a mobile phone formfactor, and the carousel component is agonizingly slow. I've tried playing with lazyLoad prop, but it doesn't help. The views are small with a couple of labels… --- ## [Editing Cell Update Bindings](https://forum.inductiveautomation.com/t/editing-cell-update-bindings/78926)
**Author:** [@rfolkes](https://forum.inductiveautomation.com/u/rfolkes)\ **Replies:** 2\ **Last updated:** [September 8, 2023, 6:30pm UTC](https://forum.inductiveautomation.com/t/editing-cell-update-bindings/78926 "2023-09-08T18:30:43Z")
is there a way to bulk edit Cell Update Bindings? I need to repeat this same pattern for each row and right now I have been only able to do one cell at a time. copy paste function on the bottom left doesn't seem to do… --- ## [Frontend/Backend server issues](https://forum.inductiveautomation.com/t/frontend-backend-server-issues/78888)
**Author:** [@Brennan\_A](https://forum.inductiveautomation.com/u/Brennan_A)\ **Replies:** 5\ **Last updated:** [September 8, 2023, 6:15pm UTC](https://forum.inductiveautomation.com/t/frontend-backend-server-issues/78888 "2023-09-08T18:15:38Z")
Dual server setup 'Front End Server' Vision 8.1.11 Ignition Gateway, hosts Vision clients, contains the Vision Client tags, connected to Back End Server for remote tag provider via Gateway Network incoming connection. '… --- ## [Perspective Wi-Fi Access](https://forum.inductiveautomation.com/t/perspective-wi-fi-access/78916)
**Author:** [@Kfoldesi](https://forum.inductiveautomation.com/u/Kfoldesi)\ **Replies:** 2\ **Last updated:** [September 8, 2023, 6:02pm UTC](https://forum.inductiveautomation.com/t/perspective-wi-fi-access/78916 "2023-09-08T18:02:51Z")
I got a new project going last week. I thought if they got on the WiFi with their phones they would be able to get to the server. But neither with the server name or the IP the perspective project would load on IPhone wi… --- ## [Perspective failover not working using Master\\Backup](https://forum.inductiveautomation.com/t/perspective-failover-not-working-using-master-backup/72939)
**Author:** [@ericmoulton](https://forum.inductiveautomation.com/u/ericmoulton)\ **Replies:** 6\ **Last updated:** [September 8, 2023, 6:01pm UTC](https://forum.inductiveautomation.com/t/perspective-failover-not-working-using-master-backup/72939 "2023-09-08T18:01:16Z")
I'm new to redundancy, but I set up the Master and Backup per the documentation and it appears to be correct. I'm using cold start because I have 9k tags on one PLC (most rarely updating or disabled, but still...). I hav… --- ## [Import project in Ignition 8.1 for multiple gateway](https://forum.inductiveautomation.com/t/import-project-in-ignition-8-1-for-multiple-gateway/78915)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 1\ **Last updated:** [September 8, 2023, 3:05pm UTC](https://forum.inductiveautomation.com/t/import-project-in-ignition-8-1-for-multiple-gateway/78915 "2023-09-08T15:05:46Z")
I try to manage project import in Ignition 8.1 for multiple gateway. Is there a way to automate this process ? Seems to be doable with: https://files.inductiveautomation.com/sdk/javadoc/ignition81/8.1.29/com/inductive… --- ## [UDT Suppress Alarms on Edit](https://forum.inductiveautomation.com/t/udt-suppress-alarms-on-edit/19564)
**Author:** [@WillMT10](https://forum.inductiveautomation.com/u/WillMT10)\ **Replies:** 4\ **Last updated:** [September 8, 2023, 2:52pm UTC](https://forum.inductiveautomation.com/t/udt-suppress-alarms-on-edit/19564 "2023-09-08T14:52:20Z")
Forgive me if this has already been answered, but I couldn't find anything in the forums or manual on this. We're running into a little bit of a headache with the UDT's that we have configured. Whenever we make edits … --- ## [Perspective - Log in / Log out event](https://forum.inductiveautomation.com/t/perspective-log-in-log-out-event/38168)
**Author:** [@luc.martin](https://forum.inductiveautomation.com/u/luc.martin)\ **Replies:** 12\ **Last updated:** [September 8, 2023, 1:38pm UTC](https://forum.inductiveautomation.com/t/perspective-log-in-log-out-event/38168 "2023-09-08T13:38:18Z")
Is there a way to get events on log in and log out ? I want to load / save session custom value when user log and log out --- ## [Centering Data of a dataset on a table](https://forum.inductiveautomation.com/t/centering-data-of-a-dataset-on-a-table/78821)
**Author:** [@Alex\_Wakefield](https://forum.inductiveautomation.com/u/Alex_Wakefield)\ **Replies:** 18\ **Last updated:** [September 8, 2023, 12:44pm UTC](https://forum.inductiveautomation.com/t/centering-data-of-a-dataset-on-a-table/78821 "2023-09-08T12:44:23Z")
Hello, I'm just trying to figure out how to justify values in a table cell once it is populated with dataset values. Since it's the "data" property that gets written to and displayed, the row/col properties are empty, a… --- ## [Can I pass back parameters from a popup window to the parent window after popup is opened](https://forum.inductiveautomation.com/t/can-i-pass-back-parameters-from-a-popup-window-to-the-parent-window-after-popup-is-opened/76735)
**Author:** [@sathianandan.dharmas](https://forum.inductiveautomation.com/u/sathianandan.dharmas)\ **Replies:** 6\ **Last updated:** [September 8, 2023, 12:20pm UTC](https://forum.inductiveautomation.com/t/can-i-pass-back-parameters-from-a-popup-window-to-the-parent-window-after-popup-is-opened/76735 "2023-09-08T12:20:55Z")
I'm trying to send data back to parent window after a popup window is opened from the parent. There are options to pass parameters to the popup window instance while opening but not the other way. I can use an external … --- ## [Switching default database in named queries](https://forum.inductiveautomation.com/t/switching-default-database-in-named-queries/78904)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 2\ **Last updated:** [September 8, 2023, 11:35am UTC](https://forum.inductiveautomation.com/t/switching-default-database-in-named-queries/78904 "2023-09-08T11:35:01Z")
I'm developing an application to retrieve data from an SQL Express server running on the machine's HMI. I have some of the named queries operational at this stage.1 I have a second identical machine running its own inst… --- ## [Historise data with context](https://forum.inductiveautomation.com/t/historise-data-with-context/78900)
**Author:** [@Matthew\_Farmer](https://forum.inductiveautomation.com/u/Matthew_Farmer)\ **Replies:** 1\ **Last updated:** [September 8, 2023, 9:35am UTC](https://forum.inductiveautomation.com/t/historise-data-with-context/78900 "2023-09-08T09:35:54Z")
I have tags that record if a department is meeting their production target. (% of orders complete within 7 days of the due date) I want to save a snapshot of this tag on the midnight of the 7th day of the month as the s… --- ## [Security permissions requiring logical combinations or roles and zones](https://forum.inductiveautomation.com/t/security-permissions-requiring-logical-combinations-or-roles-and-zones/78877)
**Author:** [@justin.brzozoski](https://forum.inductiveautomation.com/u/justin.brzozoski)\ **Replies:** 1\ **Last updated:** [September 8, 2023, 6:09am UTC](https://forum.inductiveautomation.com/t/security-permissions-requiring-logical-combinations-or-roles-and-zones/78877 "2023-09-08T06:09:53Z")
I'm trying to lock down access to the designer and gateway pages based on a combination of roles and security zones. For simplicity, let's just say the role is Administrator and the two security zones are trusted\_ips and… --- ## [OIDC Logout on Perspective Mobile](https://forum.inductiveautomation.com/t/oidc-logout-on-perspective-mobile/78884)
**Author:** [@Ethan\_Brown](https://forum.inductiveautomation.com/u/Ethan_Brown)\ **Replies:** 0\ **Last updated:** [September 8, 2023, 1:17am UTC](https://forum.inductiveautomation.com/t/oidc-logout-on-perspective-mobile/78884 "2023-09-08T01:17:06Z")
I'm getting this error when logging out using Perspective Mobile and authenticating using OIDC. Everything works fine on desktop. Is there a different logout callback url other than http://:/data/federate/callback/oidc?… --- ## [Help with changing component value on tag change](https://forum.inductiveautomation.com/t/help-with-changing-component-value-on-tag-change/78773)
**Author:** [@Nicholas\_Ferris](https://forum.inductiveautomation.com/u/Nicholas_Ferris)\ **Replies:** 4\ **Last updated:** [September 7, 2023, 7:17pm UTC](https://forum.inductiveautomation.com/t/help-with-changing-component-value-on-tag-change/78773 "2023-09-07T19:17:37Z")
Afternoon Everyone, I'm having some difficulty understanding how to turn a two button toggle off whenever a tag value is greater than or equal to a set point value. I have the button working normally and I have the tag … --- ## [Sending Reports By Email Issue](https://forum.inductiveautomation.com/t/sending-reports-by-email-issue/70542)
**Author:** [@Mosh](https://forum.inductiveautomation.com/u/Mosh)\ **Replies:** 15\ **Last updated:** [September 7, 2023, 6:07pm UTC](https://forum.inductiveautomation.com/t/sending-reports-by-email-issue/70542 "2023-09-07T18:07:54Z")
Hi everyone. I am trying to send Reports Via emails but when i setup the SMTP profile i am not able to send emails and i get the error attached every time. Thank you in advance for your help, --- ## [How do you Export to Google Sheets?](https://forum.inductiveautomation.com/t/how-do-you-export-to-google-sheets/78831)
**Author:** [@Steve\_Laubach](https://forum.inductiveautomation.com/u/Steve_Laubach)\ **Replies:** 3\ **Last updated:** [September 7, 2023, 4:28pm UTC](https://forum.inductiveautomation.com/t/how-do-you-export-to-google-sheets/78831 "2023-09-07T16:28:23Z")
I'm not sure how doable this is but I figured this is probably a good place to ask. I know how to create an Excel file in Ignition. Is there a way to send that to Google sheets programatically? I did a quick look and … [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=576) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=578)