# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=275 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 276 --- ## [Named query insert to table, column always null](https://forum.inductiveautomation.com/t/named-query-insert-to-table-column-always-null/100478)
**Author:** [@Douglas\_Rudd](https://forum.inductiveautomation.com/u/Douglas_Rudd)\ **Replies:** 10\ **Last updated:** [January 6, 2025, 6:03pm UTC](https://forum.inductiveautomation.com/t/named-query-insert-to-table-column-always-null/100478 "2025-01-06T18:03:51Z")
I have a named query that updates a table with the results of a QC test. when I run the test in the named query screen all columns update correctly. but when I run the query from a value-changed script. using system.db.r… --- ## [Client tag expression with hasRole NPE](https://forum.inductiveautomation.com/t/client-tag-expression-with-hasrole-npe/100483)
**Author:** [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\ **Replies:** 5\ **Last updated:** [January 6, 2025, 5:54pm UTC](https://forum.inductiveautomation.com/t/client-tag-expression-with-hasrole-npe/100483 "2025-01-06T17:54:38Z")
I've got a weird issue, and I'm not sure if this is because of my usage or if there is an actual problem going on here. I want to use a Vision Client tag to generate some bit based on the current user roles. IE if the u… --- ## [Connected: browse pending](https://forum.inductiveautomation.com/t/connected-browse-pending/45631)
**Author:** [@Seth.williamson](https://forum.inductiveautomation.com/u/Seth.williamson)\ **Replies:** 10\ **Last updated:** [January 6, 2025, 5:33pm UTC](https://forum.inductiveautomation.com/t/connected-browse-pending/45631 "2025-01-06T17:33:04Z")
Having issues with one of my device connections it will say connected browse pending or downloading i disabled automatic browsing and i still have the same issue. My connection is a Allen-Bradley ControlLogix (Legacy) c… --- ## [Using Visual Studio Code for Writing SQL Queries in Ignition](https://forum.inductiveautomation.com/t/using-visual-studio-code-for-writing-sql-queries-in-ignition/100473)
**Author:** [@Gaurav.Shitole](https://forum.inductiveautomation.com/u/Gaurav.Shitole)\ **Replies:** 2\ **Last updated:** [January 6, 2025, 4:21pm UTC](https://forum.inductiveautomation.com/t/using-visual-studio-code-for-writing-sql-queries-in-ignition/100473 "2025-01-06T16:21:10Z")
Hello everyone, I wanted to know if anyone is using Visual Studio Code to write SQL queries for Ignition projects. Specifically, I am looking for a way to: Write SQL queries directly in Visual Studio Code. Automatical… --- ## [HTML Custom Message in Alarm Tag](https://forum.inductiveautomation.com/t/html-custom-message-in-alarm-tag/100485)
**Author:** [@Ramiro\_Ramirez](https://forum.inductiveautomation.com/u/Ramiro_Ramirez)\ **Replies:** 0\ **Last updated:** [January 6, 2025, 4:11pm UTC](https://forum.inductiveautomation.com/t/html-custom-message-in-alarm-tag/100485 "2025-01-06T16:11:44Z")
Hi, I would like to use HTML format on a Alarm Tag Custom Message, I read that is possible but can you help me with a quick example please?, Thank you. --- ## [Workaround for a Multi Demensional Array?](https://forum.inductiveautomation.com/t/workaround-for-a-multi-demensional-array/100405)
**Author:** [@Dillon\_Lippman](https://forum.inductiveautomation.com/u/Dillon_Lippman)\ **Replies:** 8\ **Last updated:** [January 6, 2025, 1:54pm UTC](https://forum.inductiveautomation.com/t/workaround-for-a-multi-demensional-array/100405 "2025-01-06T13:54:05Z")
So, like the title says is there any type of work around for PLC tags whose data types are multi-dimensional arrays? I'm working with a Control Logix L33ER PLC. I have a tag named "LS" with its Datatype as an INT\[40,100… --- ## [Alarm Notification Pipeline Scrip Block setting a Parameter Value](https://forum.inductiveautomation.com/t/alarm-notification-pipeline-scrip-block-setting-a-parameter-value/15900)
**Author:** [@MikeAllgood](https://forum.inductiveautomation.com/u/MikeAllgood)\ **Replies:** 4\ **Last updated:** [January 6, 2025, 1:25pm UTC](https://forum.inductiveautomation.com/t/alarm-notification-pipeline-scrip-block-setting-a-parameter-value/15900 "2025-01-06T13:25:48Z")
I'm trying to set up a notification pipeline that allows me to check for the existence of items in a database and based on values returned from the query, make some decisions on routing the notifications. Is it possible … --- ## [WebDev- How can I respond HTTP code 204](https://forum.inductiveautomation.com/t/webdev-how-can-i-respond-http-code-204/30338)
**Author:** [@gnguyen](https://forum.inductiveautomation.com/u/gnguyen)\ **Replies:** 3\ **Last updated:** [January 6, 2025, 1:01pm UTC](https://forum.inductiveautomation.com/t/webdev-how-can-i-respond-http-code-204/30338 "2025-01-06T13:01:28Z")
Hello everyone, Using WebDev, I’ve to respond to a callback and the server accept only a code 204 No Content as a response. It seems that webdev answer 200 by default if there is nothing return. How can I do that? Man… --- ## [Firebird Database Connection](https://forum.inductiveautomation.com/t/firebird-database-connection/59241)
**Author:** [@Jayden](https://forum.inductiveautomation.com/u/Jayden)\ **Replies:** 8\ **Last updated:** [January 6, 2025, 12:44pm UTC](https://forum.inductiveautomation.com/t/firebird-database-connection/59241 "2025-01-06T12:44:54Z")
Hi All, I have a need to connect to a Firebird database. I’m wondering if anyone out there would be able to assist with some guidance on how to get this connection working. TIA --- ## [Best Approach for High-Volume Flow Meter Calculations and Alarming in Ignition](https://forum.inductiveautomation.com/t/best-approach-for-high-volume-flow-meter-calculations-and-alarming-in-ignition/100092)
**Author:** [@louagejasper](https://forum.inductiveautomation.com/u/louagejasper)\ **Replies:** 16\ **Last updated:** [January 6, 2025, 8:08am UTC](https://forum.inductiveautomation.com/t/best-approach-for-high-volume-flow-meter-calculations-and-alarming-in-ignition/100092 "2025-01-06T08:08:21Z")
Hi all, We’re working on a quite large-scale project and need some guidance on the best approach to handle a computationally intensive task in Ignition. Here are the details of our setup and requirements: Setup: Over 2… --- ## [Perspective - images from gateway's file system](https://forum.inductiveautomation.com/t/perspective-images-from-gateways-file-system/70830)
**Author:** [@Lukasz\_Wieckowski](https://forum.inductiveautomation.com/u/Lukasz_Wieckowski)\ **Replies:** 1\ **Last updated:** [January 6, 2025, 6:34am UTC](https://forum.inductiveautomation.com/t/perspective-images-from-gateways-file-system/70830 "2025-01-06T06:34:18Z")
Hello everyone. We have a View in Perspective that needs to display an image from the gateway’s local file system. I try the method described in another topic. I save image in directory on gateway: C:\\Program Files\\Indu… --- ## [Unable to connect to secured gateway over VPN](https://forum.inductiveautomation.com/t/unable-to-connect-to-secured-gateway-over-vpn/100469)
**Author:** [@ccsmp](https://forum.inductiveautomation.com/u/ccsmp)\ **Replies:** 1\ **Last updated:** [January 6, 2025, 4:16am UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-secured-gateway-over-vpn/100469 "2025-01-06T04:16:01Z")
Hi I am trying to access the designer from a vpn at home and am having trouble connecting to the gateway. When I try and access our dev server I can just fine but not our prod. I haven’t had any issues before with the v… --- ## [Memory Tag not updating in Perspective web browser session](https://forum.inductiveautomation.com/t/memory-tag-not-updating-in-perspective-web-browser-session/100457)
**Author:** [@Jennifer\_Forde-Watli](https://forum.inductiveautomation.com/u/Jennifer_Forde-Watli)\ **Replies:** 7\ **Last updated:** [January 5, 2025, 11:59pm UTC](https://forum.inductiveautomation.com/t/memory-tag-not-updating-in-perspective-web-browser-session/100457 "2025-01-05T23:59:50Z")
I am using Perspective to build my views. I have one view (Overview) that has several buttons to select a station i.e. 1, 2, ...20. I have written a script to write an integer value to a memory tag that writes the specif… --- ## [How to Close a Perspective Popup Asynchronously After a Delay in Ignition?](https://forum.inductiveautomation.com/t/how-to-close-a-perspective-popup-asynchronously-after-a-delay-in-ignition/99869)
**Author:** [@sibabrat\_swain](https://forum.inductiveautomation.com/u/sibabrat_swain)\ **Replies:** 10\ **Last updated:** [January 5, 2025, 6:46pm UTC](https://forum.inductiveautomation.com/t/how-to-close-a-perspective-popup-asynchronously-after-a-delay-in-ignition/99869 "2025-01-05T18:46:05Z")
Hello everyone, I am working on an Ignition project using Perspective, and I want to create a toast notification using a popup. The popup should automatically close after a certain delay (e.g., 5 seconds) without blocki… --- ## [I want to dynamically reset and fillout options of a dropdown using scripting](https://forum.inductiveautomation.com/t/i-want-to-dynamically-reset-and-fillout-options-of-a-dropdown-using-scripting/100447)
**Author:** [@Ali\_Paridari](https://forum.inductiveautomation.com/u/Ali_Paridari)\ **Replies:** 4\ **Last updated:** [January 4, 2025, 3:24pm UTC](https://forum.inductiveautomation.com/t/i-want-to-dynamically-reset-and-fillout-options-of-a-dropdown-using-scripting/100447 "2025-01-04T15:24:20Z")
I have a script in which I need to reset the options of a dropdown element. When I try to del or remove an options index I run into errors. How do i do this? --- ## [Edge Historian Scripting not working?](https://forum.inductiveautomation.com/t/edge-historian-scripting-not-working/100445)
**Author:** [@Koen](https://forum.inductiveautomation.com/u/Koen)\ **Replies:** 1\ **Last updated:** [January 4, 2025, 7:35am UTC](https://forum.inductiveautomation.com/t/edge-historian-scripting-not-working/100445 "2025-01-04T07:35:32Z")
Hi, I can pull a tag history from the edge historian using script (system.tag.queryTagHistory()). This works fine in the Script Console but I can't seem to get a value (other than zero) when I run the same script in eit… --- ## [Selecting table row, single click on numeric embedded field does not work](https://forum.inductiveautomation.com/t/selecting-table-row-single-click-on-numeric-embedded-field-does-not-work/100440)
**Author:** [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\ **Replies:** 8\ **Last updated:** [January 4, 2025, 2:35am UTC](https://forum.inductiveautomation.com/t/selecting-table-row-single-click-on-numeric-embedded-field-does-not-work/100440 "2025-01-04T02:35:46Z")
Hey all, Have you noticed that if you use an embedded view, such as a text field or drop down, to select a table row it takes one click? But, if you use a numeric field you have to double-click? Is there a way t… --- ## [Table Row Background color, from scripting event. It's broken](https://forum.inductiveautomation.com/t/table-row-background-color-from-scripting-event-its-broken/100268)
**Author:** [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\ **Replies:** 7\ **Last updated:** [January 4, 2025, 1:45am UTC](https://forum.inductiveautomation.com/t/table-row-background-color-from-scripting-event-its-broken/100268 "2025-01-04T01:45:29Z")
I am following this guy's video on YT: Artek Solutions I have most of it working except for the background color styling on the Add and Delete button events. The data comes in from an NQ, then a script transform like t… --- ## [Using multiple tags in Time Series Chart](https://forum.inductiveautomation.com/t/using-multiple-tags-in-time-series-chart/100444)
**Author:** [@Christopher\_Torres](https://forum.inductiveautomation.com/u/Christopher_Torres)\ **Replies:** 1\ **Last updated:** [January 4, 2025, 1:10am UTC](https://forum.inductiveautomation.com/t/using-multiple-tags-in-time-series-chart/100444 "2025-01-04T01:10:13Z")
Hello everyone! I am having an issue when trying to use multiple tags in one time series chart. I want to be able to have two data lines on this chart and I am unable to get it to work unfortunately. When I add another … --- ## [Make a component or text flash](https://forum.inductiveautomation.com/t/make-a-component-or-text-flash/100437)
**Author:** [@Jeff\_Muldoon](https://forum.inductiveautomation.com/u/Jeff_Muldoon)\ **Replies:** 3\ **Last updated:** [January 3, 2025, 9:53pm UTC](https://forum.inductiveautomation.com/t/make-a-component-or-text-flash/100437 "2025-01-03T21:53:17Z")
I've got a request from our COO to make certain values change when over a certain level. For example, I'm using a 14 segment display to show a temperature and I'd like it to flash red when over... lets say 400. Currently… --- ## [Input text field, using vision, will not write to the linked tag](https://forum.inductiveautomation.com/t/input-text-field-using-vision-will-not-write-to-the-linked-tag/100441)
**Author:** [@Robert\_Reed](https://forum.inductiveautomation.com/u/Robert_Reed)\ **Replies:** 4\ **Last updated:** [January 3, 2025, 8:21pm UTC](https://forum.inductiveautomation.com/t/input-text-field-using-vision-will-not-write-to-the-linked-tag/100441 "2025-01-03T20:21:25Z")
I have a input text field liked to a memory tag. The linkage is to the text property. If I type in a new value thru the screen, I can see it in the input text property in the vision property editor. but it does not cha… --- ## [SQL Connection with Users Profile](https://forum.inductiveautomation.com/t/sql-connection-with-users-profile/100438)
**Author:** [@Anthony\_oneal](https://forum.inductiveautomation.com/u/Anthony_oneal)\ **Replies:** 2\ **Last updated:** [January 3, 2025, 7:55pm UTC](https://forum.inductiveautomation.com/t/sql-connection-with-users-profile/100438 "2025-01-03T19:55:05Z")
Background: Our ignition DB connection is using windows auth and we currently have the dll in place. Some of our in-place procs and triggers use DB level user gets. ISSUE: when the simple ORIGINAL\_LOGIN() is ran from… --- ## [Searching for tags based on Tag ID](https://forum.inductiveautomation.com/t/searching-for-tags-based-on-tag-id/98959)
**Author:** [@Kyle\_Young](https://forum.inductiveautomation.com/u/Kyle_Young)\ **Replies:** 2\ **Last updated:** [January 3, 2025, 7:54pm UTC](https://forum.inductiveautomation.com/t/searching-for-tags-based-on-tag-id/98959 "2025-01-03T19:54:27Z")
Is there a way to search for tags based on tag ID? I am having DB error and am getting a Tag ID instead of the actual tag name. My error is below. Thanks default (id=a49ea8d1) Error occurred while loading tag informat… --- ## [EasyChart Historical mode does not update with new data](https://forum.inductiveautomation.com/t/easychart-historical-mode-does-not-update-with-new-data/23677)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 12\ **Last updated:** [January 3, 2025, 7:39pm UTC](https://forum.inductiveautomation.com/t/easychart-historical-mode-does-not-update-with-new-data/23677 "2025-01-03T19:39:19Z")
I've noticed that the EasyChart using the Historical mode does not automatically pull in new trend data once the daterange has been set. If this range is set to a range that includes 'now' and beyond, new data is not pul… --- ## [ModbusTCP OPC/UA Driver - ADAM-4572 ModbusRTU Gateway Connection Issues](https://forum.inductiveautomation.com/t/modbustcp-opc-ua-driver-adam-4572-modbusrtu-gateway-connection-issues/99137)
**Author:** [@jpai](https://forum.inductiveautomation.com/u/jpai)\ **Replies:** 7\ **Last updated:** [January 3, 2025, 6:48pm UTC](https://forum.inductiveautomation.com/t/modbustcp-opc-ua-driver-adam-4572-modbusrtu-gateway-connection-issues/99137 "2025-01-03T18:48:12Z")
Hello, I am attempting to read holding registers from an Advantech ADAM-4572 using the OPC/UA ModbusTCP driver to no avail. I am trying to establish a test setup before attempting field work, and I am not sure if my ADA… --- ## [Issue with calling custom method](https://forum.inductiveautomation.com/t/issue-with-calling-custom-method/100432)
**Author:** [@Aisha\_Shiddat](https://forum.inductiveautomation.com/u/Aisha_Shiddat)\ **Replies:** 4\ **Last updated:** [January 3, 2025, 5:31pm UTC](https://forum.inductiveautomation.com/t/issue-with-calling-custom-method/100432 "2025-01-03T17:31:43Z")
I am having issues accessing my custom method from a child component in my view. There is a button event I created in a popup that im using to call my method, but I keep getting an error saying that object has no attribu… --- ## [Displaying Custom Property Object Structure in Perspective View](https://forum.inductiveautomation.com/t/displaying-custom-property-object-structure-in-perspective-view/100427)
**Author:** [@Randy\_Fulling](https://forum.inductiveautomation.com/u/Randy_Fulling)\ **Replies:** 5\ **Last updated:** [January 3, 2025, 4:36pm UTC](https://forum.inductiveautomation.com/t/displaying-custom-property-object-structure-in-perspective-view/100427 "2025-01-03T16:36:40Z")
Hello, I am doing a call to an API in a custom property in perspective and the pulling information from there for other custom properties. My question, is there a way to display/utilize a Custom Property Object in a Pe… --- ## [MQTT and Dev/Test Environment Tag Providers](https://forum.inductiveautomation.com/t/mqtt-and-dev-test-environment-tag-providers/95494)
**Author:** [@Mitchell\_Maziarz](https://forum.inductiveautomation.com/u/Mitchell_Maziarz)\ **Replies:** 13\ **Last updated:** [January 3, 2025, 4:22pm UTC](https://forum.inductiveautomation.com/t/mqtt-and-dev-test-environment-tag-providers/95494 "2025-01-03T16:22:57Z")
I am currently looking at setting up an MQTT network through the Cirrus Link modules and am trying to determine the best method for configuring tags and tag providers to allow for consistency between dev/test/prod enviro… --- ## [Time Not showing in Transaction Group](https://forum.inductiveautomation.com/t/time-not-showing-in-transaction-group/100422)
**Author:** [@Arun\_Mohan2](https://forum.inductiveautomation.com/u/Arun_Mohan2)\ **Replies:** 1\ **Last updated:** [January 3, 2025, 3:10pm UTC](https://forum.inductiveautomation.com/t/time-not-showing-in-transaction-group/100422 "2025-01-03T15:10:16Z")
Hi Everyone, I created a Tag, and it get time from gateway. In the numeric section of tag editor, I put the format string as h:mm:ss a and I am getting the correct time as tag value (picture attached). when I use this … --- ## [Security Certificate Issues : Cannot run API script without bypassing certificate validation](https://forum.inductiveautomation.com/t/security-certificate-issues-cannot-run-api-script-without-bypassing-certificate-validation/100420)
**Author:** [@Robert\_Long](https://forum.inductiveautomation.com/u/Robert_Long)\ **Replies:** 16\ **Last updated:** [January 3, 2025, 3:00pm UTC](https://forum.inductiveautomation.com/t/security-certificate-issues-cannot-run-api-script-without-bypassing-certificate-validation/100420 "2025-01-03T15:00:04Z")
Certificate Issues - Calling API without bypassingCertification always results in the following error message: IOError: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to fin… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=274) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=276)