# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=301 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 302 --- ## [Dynamic Insert Query not working](https://forum.inductiveautomation.com/t/dynamic-insert-query-not-working/98514)
**Author:** [@Alex\_Ford-King](https://forum.inductiveautomation.com/u/Alex_Ford-King)\ **Replies:** 8\ **Last updated:** [November 12, 2024, 3:49pm UTC](https://forum.inductiveautomation.com/t/dynamic-insert-query-not-working/98514 "2024-11-12T15:49:03Z")
I am working on taking data from an excel document and importing it into our database. I have this Script so far # Import necessary Java classes from org.apache.poi.ss.usermodel import WorkbookFactory, CellType from jav… --- ## [Tag configuration error expression binding](https://forum.inductiveautomation.com/t/tag-configuration-error-expression-binding/98481)
**Author:** [@Matthew\_Breeding](https://forum.inductiveautomation.com/u/Matthew_Breeding)\ **Replies:** 14\ **Last updated:** [November 12, 2024, 3:30pm UTC](https://forum.inductiveautomation.com/t/tag-configuration-error-expression-binding/98481 "2024-11-12T15:30:33Z")
Hey all I am having an issue when dynamically creating tags based off a UDT structure. I believe I have verified all the helpers but I would greatly appreciate any points of concerns. So I am generating a tag, this speci… --- ## [Perspective IIS Reverse Proxy](https://forum.inductiveautomation.com/t/perspective-iis-reverse-proxy/31196)
**Author:** [@matthew](https://forum.inductiveautomation.com/u/matthew)\ **Replies:** 23\ **Last updated:** [November 12, 2024, 2:13pm UTC](https://forum.inductiveautomation.com/t/perspective-iis-reverse-proxy/31196 "2024-11-12T14:13:36Z")
Has anyone successfully set up a reverse proxy using IIS and URL rewrite and can launch a project from the gateway that could help with some configuration issues I’m having. I’m using IIS and Certify the Web/Letsencrypt… --- ## [Cannot access OPCUA server from an external device on the same network](https://forum.inductiveautomation.com/t/cannot-access-opcua-server-from-an-external-device-on-the-same-network/98489)
**Author:** [@face\_plant](https://forum.inductiveautomation.com/u/face_plant)\ **Replies:** 2\ **Last updated:** [November 12, 2024, 1:59pm UTC](https://forum.inductiveautomation.com/t/cannot-access-opcua-server-from-an-external-device-on-the-same-network/98489 "2024-11-12T13:59:01Z")
Hello! I am trying to connect to the ignition edge OPCUA server running on my PLC from a process running in a docker container on a different computer within the same network. However, the process within the docker cont… --- ## [Alarm Pipeline need Alarm to send every 5 minutes rather than every value change when outside its setpoint](https://forum.inductiveautomation.com/t/alarm-pipeline-need-alarm-to-send-every-5-minutes-rather-than-every-value-change-when-outside-its-setpoint/98510)
**Author:** [@Austin\_Box](https://forum.inductiveautomation.com/u/Austin_Box)\ **Replies:** 2\ **Last updated:** [November 12, 2024, 1:58pm UTC](https://forum.inductiveautomation.com/t/alarm-pipeline-need-alarm-to-send-every-5-minutes-rather-than-every-value-change-when-outside-its-setpoint/98510 "2024-11-12T13:58:11Z")
I created an Alarm Pipeline and when the tag goes outside its set point it sends an email no problem, the issue I’m having is it sends a ton of alarm emails at every value change when alarm is active, is there a delay I … --- ## [Vision Image Management - Blurry when used in image](https://forum.inductiveautomation.com/t/vision-image-management-blurry-when-used-in-image/98508)
**Author:** [@Hec\_O](https://forum.inductiveautomation.com/u/Hec_O)\ **Replies:** 1\ **Last updated:** [November 12, 2024, 1:26pm UTC](https://forum.inductiveautomation.com/t/vision-image-management-blurry-when-used-in-image/98508 "2024-11-12T13:26:44Z")
Hi, I have a high definition image that I am using in a vision project. The original image looks great in terms of quality. However, when I add the image to my image management folder and then use it in an 'image' compo… --- ## [Ignition Tag Browser Timeout/Issues](https://forum.inductiveautomation.com/t/ignition-tag-browser-timeout-issues/98476)
**Author:** [@Diogo\_Campos](https://forum.inductiveautomation.com/u/Diogo_Campos)\ **Replies:** 7\ **Last updated:** [November 12, 2024, 9:33am UTC](https://forum.inductiveautomation.com/t/ignition-tag-browser-timeout-issues/98476 "2024-11-12T09:33:49Z")
Hello, I am using the Ignition maker edition to connect to an OPC DA server tunnelled through Matrikon OPC Tunneller. The connection is established just fine, and things generally work aside from two small issues: If I… --- ## [\[BUG-13830\] CompactLogix 1769-L36ERM/A Fails to browse](https://forum.inductiveautomation.com/t/bug-13830-compactlogix-1769-l36erm-a-fails-to-browse/24699)
**Author:** [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\ **Replies:** 14\ **Last updated:** [November 12, 2024, 12:42pm UTC](https://forum.inductiveautomation.com/t/bug-13830-compactlogix-1769-l36erm-a-fails-to-browse/24699 "2024-11-12T12:42:05Z")
Ignition 7.9.10 Logix 30.11 We cannot get the PLC to be browsed by the OPC Server. Have checked and verified and rechecked all access permissions on the tags, verified all connection settings and proper driver selecti… --- ## [Issue with Localization in Perspective Alarm Status Table: English Overrides Other Languages](https://forum.inductiveautomation.com/t/issue-with-localization-in-perspective-alarm-status-table-english-overrides-other-languages/98509)
**Author:** [@RodrigoR](https://forum.inductiveautomation.com/u/RodrigoR)\ **Replies:** 0\ **Last updated:** [November 12, 2024, 11:23am UTC](https://forum.inductiveautomation.com/t/issue-with-localization-in-perspective-alarm-status-table-english-overrides-other-languages/98509 "2024-11-12T11:23:59Z")
Hello everyone, I've encountered an issue with the Alarm Status Table in Ignition Perspective when using multiple languages for localization. In our project, we have both English and Spanish translations set up for alar… --- ## [Perspective behind nginx proxy generates "undefined" url when try to login](https://forum.inductiveautomation.com/t/perspective-behind-nginx-proxy-generates-undefined-url-when-try-to-login/84253)
**Author:** [@strinidad](https://forum.inductiveautomation.com/u/strinidad)\ **Replies:** 9\ **Last updated:** [November 12, 2024, 11:13am UTC](https://forum.inductiveautomation.com/t/perspective-behind-nginx-proxy-generates-undefined-url-when-try-to-login/84253 "2024-11-12T11:13:52Z")
Hello, I have many Perspective projects running on a local server. I'm triying to use a Nginx reverse proxy to use different domains. For example I want to use: https://myproject1.com and it must be proxied to http:/… --- ## [Is it possible to hide pois in google map component?](https://forum.inductiveautomation.com/t/is-it-possible-to-hide-pois-in-google-map-component/98505)
**Author:** [@Eva\_Solernou](https://forum.inductiveautomation.com/u/Eva_Solernou)\ **Replies:** 0\ **Last updated:** [November 12, 2024, 10:37am UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-hide-pois-in-google-map-component/98505 "2024-11-12T10:37:16Z")
Hello, I have the googleMap component working fine in Perspective but I need to to hide POIs. I have tried to customize a bit the map following a structure like this in properties but with no success. https://developers… --- ## [Perspective Table Highlight Index](https://forum.inductiveautomation.com/t/perspective-table-highlight-index/98196)
**Author:** [@bruno.nunes](https://forum.inductiveautomation.com/u/bruno.nunes)\ **Replies:** 4\ **Last updated:** [November 12, 2024, 7:32am UTC](https://forum.inductiveautomation.com/t/perspective-table-highlight-index/98196 "2024-11-12T07:32:10Z")
Hello, This might be a no brainer, but I'm struggling with it. With a perspective table, is it possible to get the index of the mouse over highlighted row? For example in this scenario, I wanted to fetch the right tab… --- ## [Is it possible to write Custom Table Properties to a tag?](https://forum.inductiveautomation.com/t/is-it-possible-to-write-custom-table-properties-to-a-tag/98485)
**Author:** [@R\_Connor\_Hopkins](https://forum.inductiveautomation.com/u/R_Connor_Hopkins)\ **Replies:** 2\ **Last updated:** [November 12, 2024, 5:28am UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-write-custom-table-properties-to-a-tag/98485 "2024-11-12T05:28:07Z")
Hi all, I have a table with several custom properties set up. The table is creating a read out for yields between blending system and filling system. The tags were in several different providers and the paths are dynami… --- ## [Change the column length when automatically create table And Insert](https://forum.inductiveautomation.com/t/change-the-column-length-when-automatically-create-table-and-insert/98453)
**Author:** [@Sam\_Tsai](https://forum.inductiveautomation.com/u/Sam_Tsai)\ **Replies:** 2\ **Last updated:** [November 12, 2024, 1:45am UTC](https://forum.inductiveautomation.com/t/change-the-column-length-when-automatically-create-table-and-insert/98453 "2024-11-12T01:45:02Z")
Is there any way to change the column length when a transaction group creates a new column or table? I want to set the default column type to nvarchar(MAX) without manually executing the ALTER script in the database. An… --- ## [Subplots are not generating, Colors are hidden but generating randomly - V8.1.32](https://forum.inductiveautomation.com/t/subplots-are-not-generating-colors-are-hidden-but-generating-randomly-v8-1-32/98488)
**Author:** [@Noah\_St\_Mark](https://forum.inductiveautomation.com/u/Noah_St_Mark)\ **Replies:** 13\ **Last updated:** [November 11, 2024, 10:53pm UTC](https://forum.inductiveautomation.com/t/subplots-are-not-generating-colors-are-hidden-but-generating-randomly-v8-1-32/98488 "2024-11-11T22:53:18Z")
Hi Everyone, I’ve written a script to load some tag pens onto an Easy Chart. I want subplots to be generated based on the available unit of measures. While the axes are being generated correctly from the unit of measure… --- ## [Possible to disable the trial popup in the Designer?](https://forum.inductiveautomation.com/t/possible-to-disable-the-trial-popup-in-the-designer/98413)
**Author:** [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\ **Replies:** 7\ **Last updated:** [November 11, 2024, 9:49pm UTC](https://forum.inductiveautomation.com/t/possible-to-disable-the-trial-popup-in-the-designer/98413 "2024-11-11T21:49:16Z")
Is it possible to disable the trial reminder popup in the Designer? It gets in the way while working on some projects. --- ## [OPC UA Server and Prosys Clinet](https://forum.inductiveautomation.com/t/opc-ua-server-and-prosys-clinet/81809)
**Author:** [@pshashipreetham](https://forum.inductiveautomation.com/u/pshashipreetham)\ **Replies:** 12\ **Last updated:** [November 11, 2024, 9:10pm UTC](https://forum.inductiveautomation.com/t/opc-ua-server-and-prosys-clinet/81809 "2024-11-11T21:10:05Z")
Hi, I have configured the OPC UA Server Setting in the Ignition, but when I try to connect with the server from the Prosys UA Client, it doesn't connect. When I press the select, it returns to the same window. I am … --- ## [MacOS Sequoia JXBrowser Designer Crash Issue](https://forum.inductiveautomation.com/t/macos-sequoia-jxbrowser-designer-crash-issue/95585)
**Author:** [@kgamble](https://forum.inductiveautomation.com/u/kgamble)\ **Replies:** 52\ **Last updated:** [November 11, 2024, 7:57pm UTC](https://forum.inductiveautomation.com/t/macos-sequoia-jxbrowser-designer-crash-issue/95585 "2024-11-11T19:57:51Z")
I am fairly certain this is related to this, so going to call it out first, this is on MacOS Seqouia's public beta. Need to use it for testing something else, and am hoping if thats the case I can sort a work-around for … --- ## [Changing the color of progress bar based on a value](https://forum.inductiveautomation.com/t/changing-the-color-of-progress-bar-based-on-a-value/98484)
**Author:** [@Mitchell\_Gerber](https://forum.inductiveautomation.com/u/Mitchell_Gerber)\ **Replies:** 4\ **Last updated:** [November 11, 2024, 8:47pm UTC](https://forum.inductiveautomation.com/t/changing-the-color-of-progress-bar-based-on-a-value/98484 "2024-11-11T20:47:41Z")
I am trying to change color of the progress bar based on a value. Should be green when its greater than 0 and when greater than the low set point, yellow when it's over the alarm setpoint, and red when it's over the shut… --- ## [Tag missing or removed since alarm active](https://forum.inductiveautomation.com/t/tag-missing-or-removed-since-alarm-active/98443)
**Author:** [@PLCTech89](https://forum.inductiveautomation.com/u/PLCTech89)\ **Replies:** 3\ **Last updated:** [November 11, 2024, 8:33pm UTC](https://forum.inductiveautomation.com/t/tag-missing-or-removed-since-alarm-active/98443 "2024-11-11T20:33:38Z")
I made a tag and set an alarm, but ended up deleting the tag while the alarm was active. Now my alarms table still shows it as active even though it's deleted. It gives this text "Tag missing or removed since alarm activ… --- ## [Convert historical status (string) data to integers](https://forum.inductiveautomation.com/t/convert-historical-status-string-data-to-integers/98473)
**Author:** [@Seth\_Johnson](https://forum.inductiveautomation.com/u/Seth_Johnson)\ **Replies:** 7\ **Last updated:** [November 11, 2024, 8:27pm UTC](https://forum.inductiveautomation.com/t/convert-historical-status-string-data-to-integers/98473 "2024-11-11T20:27:10Z")
Can I take a table of historical string values denoting run status (eg R, Q, S, etc) and convert them to integers? I figured it would be as easy as mapping a transform in the tag history binding eg R = 1, fallback = 0, … --- ## [Implementing User-Based Permissions in Query Parameters for Area Filtering](https://forum.inductiveautomation.com/t/implementing-user-based-permissions-in-query-parameters-for-area-filtering/98472)
**Author:** [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\ **Replies:** 3\ **Last updated:** [November 11, 2024, 6:59pm UTC](https://forum.inductiveautomation.com/t/implementing-user-based-permissions-in-query-parameters-for-area-filtering/98472 "2024-11-11T18:59:08Z")
In Ignition Perspective, I have a query that includes the following line: sql AND Asset.companyLevel IN ({nivelFilter}) The variable nivelFilter represents an area code, which can have values of 1, 2, 3, 4, 5, or 6. n… --- ## [Mixed Architecture Redundancy](https://forum.inductiveautomation.com/t/mixed-architecture-redundancy/98475)
**Author:** [@Asjal\_Ahmad](https://forum.inductiveautomation.com/u/Asjal_Ahmad)\ **Replies:** 2\ **Last updated:** [November 11, 2024, 6:10pm UTC](https://forum.inductiveautomation.com/t/mixed-architecture-redundancy/98475 "2024-11-11T18:10:43Z")
Will Ignition redundancy work properly if the gateway is hosted on different CPU architectures: ARM64 master \<-\> x86\_64 backup? --- ## [Azure Injector Settings](https://forum.inductiveautomation.com/t/azure-injector-settings/35146)
**Author:** [@amrutha.devaraju](https://forum.inductiveautomation.com/u/amrutha.devaraju)\ **Replies:** 2\ **Last updated:** [November 11, 2024, 3:55pm UTC](https://forum.inductiveautomation.com/t/azure-injector-settings/35146 "2024-11-11T15:55:55Z")
Hi, I’ve been trying to connect Ignition to Azure IoT Hub. I’ve followed the documentation described in \[Cirius Link\](Getting Started: Azure Injector Quick Start - MQTT Modules for Ignition 7.x - Confluence) and still … --- ## [Perspective apps failing at "Connecting" using External IP](https://forum.inductiveautomation.com/t/perspective-apps-failing-at-connecting-using-external-ip/86603)
**Author:** [@gloweware](https://forum.inductiveautomation.com/u/gloweware)\ **Replies:** 5\ **Last updated:** [November 11, 2024, 3:50pm UTC](https://forum.inductiveautomation.com/t/perspective-apps-failing-at-connecting-using-external-ip/86603 "2024-11-11T15:50:55Z")
About two weeks ago, my apps that have been accessible externally (for several years) started failing to load. They just stop at "Connecting..." If I access them internally, using either of the internal addresses, th… --- ## [Error with LIKE operator in tag report tool](https://forum.inductiveautomation.com/t/error-with-like-operator-in-tag-report-tool/98470)
**Author:** [@BVTV](https://forum.inductiveautomation.com/u/BVTV)\ **Replies:** 1\ **Last updated:** [November 11, 2024, 3:49pm UTC](https://forum.inductiveautomation.com/t/error-with-like-operator-in-tag-report-tool/98470 "2024-11-11T15:49:51Z")
I found a possible bug. I am using the tag report tool (and system.tag.query function). I use it to match tags that have a tooltip that contains the text "test". This works in most cases, but not if the tooltip contai… --- ## [MQTT Online Status](https://forum.inductiveautomation.com/t/mqtt-online-status/97779)
**Author:** [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\ **Replies:** 4\ **Last updated:** [November 11, 2024, 3:38pm UTC](https://forum.inductiveautomation.com/t/mqtt-online-status/97779 "2024-11-11T15:38:52Z")
I have had a search on the CL forum but posts go back to '21 with MQTT TX V4.0.8, suggesting reliability issues with the Online status boolean within the Node Info folder. I thought I would start here on the IA forum, t… --- ## [Where to find gateway users permision logic?](https://forum.inductiveautomation.com/t/where-to-find-gateway-users-permision-logic/98463)
**Author:** [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\ **Replies:** 5\ **Last updated:** [November 11, 2024, 3:12pm UTC](https://forum.inductiveautomation.com/t/where-to-find-gateway-users-permision-logic/98463 "2024-11-11T15:12:05Z")
Hello! I have to redo the logic from a vision project onto perspective. Now I´m looking for the users permission logic. Where should I try to find it? on the gateway or inside the project? Also how to open the gatew… --- ## [SMS Notification Module](https://forum.inductiveautomation.com/t/sms-notification-module/98467)
**Author:** [@Mohammed\_Sihamdi](https://forum.inductiveautomation.com/u/Mohammed_Sihamdi)\ **Replies:** 1\ **Last updated:** [November 11, 2024, 2:35pm UTC](https://forum.inductiveautomation.com/t/sms-notification-module/98467 "2024-11-11T14:35:42Z")
Hi everyone,We want to impliment sms notifications to the maintenance team and my question is : can we install only the SMS notification module without having to purchase the Alarm Notification Module. and what are the … --- ## [Violation set timeout error](https://forum.inductiveautomation.com/t/violation-set-timeout-error/98455)
**Author:** [@Dharani\_T](https://forum.inductiveautomation.com/u/Dharani_T)\ **Replies:** 1\ **Last updated:** [November 11, 2024, 12:58pm UTC](https://forum.inductiveautomation.com/t/violation-set-timeout-error/98455 "2024-11-11T12:58:29Z")
In Ignition, I use the following: query = procedure to fetch data table.data = query result params.Data = query result When the query result has more than 5000 rows, there's no issue binding it to the table (even when… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=300) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=302)