# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=597 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 598 --- ## [Cannot create PoolableConnectionFactory (IO Error: The Network Adapter could not establish the connection)](https://forum.inductiveautomation.com/t/cannot-create-poolableconnectionfactory-io-error-the-network-adapter-could-not-establish-the-connection/77574)
**Author:** [@Arun\_Mohan2](https://forum.inductiveautomation.com/u/Arun_Mohan2)\ **Replies:** 1\ **Last updated:** [August 8, 2023, 3:20pm UTC](https://forum.inductiveautomation.com/t/cannot-create-poolableconnectionfactory-io-error-the-network-adapter-could-not-establish-the-connection/77574 "2023-08-08T15:20:12Z")
Hi Everyone, I am facing issues with Oracle database. I am getting an error "Cannot create PoolableConnectionFactory (IO Error: The Network Adapter could not establish the connection)" . This was running earlier. I am… --- ## [Connecting buttons to objects](https://forum.inductiveautomation.com/t/connecting-buttons-to-objects/77443)
**Author:** [@harleen\_chatrath](https://forum.inductiveautomation.com/u/harleen_chatrath)\ **Replies:** 7\ **Last updated:** [August 8, 2023, 2:03pm UTC](https://forum.inductiveautomation.com/t/connecting-buttons-to-objects/77443 "2023-08-08T14:03:24Z")
Im trying to connect the start buttons to the red square so it can change the starts in read/write mode. I have included the tagpath of the udt instance that has the start tag, however when I project it on launch screen … --- ## [getId with Named Queries](https://forum.inductiveautomation.com/t/getid-with-named-queries/18444)
**Author:** [@Amarth](https://forum.inductiveautomation.com/u/Amarth)\ **Replies:** 4\ **Last updated:** [August 8, 2023, 1:59pm UTC](https://forum.inductiveautomation.com/t/getid-with-named-queries/18444 "2023-08-08T13:59:22Z")
Hello all, Is it possible to retrieve the last insterted id (INSERT Query) by using the Named Queries ? It was possible to do this with the "Old Style" queries by setting the parameter getKey to 1 but I can't find an… --- ## [Issues Combining Datasets/Using Dataset Tags](https://forum.inductiveautomation.com/t/issues-combining-datasets-using-dataset-tags/77539)
**Author:** [@Joseph\_Alcide](https://forum.inductiveautomation.com/u/Joseph_Alcide)\ **Replies:** 7\ **Last updated:** [August 8, 2023, 1:58pm UTC](https://forum.inductiveautomation.com/t/issues-combining-datasets-using-dataset-tags/77539 "2023-08-08T13:58:34Z")
Hello All, Thank you very much to everyone who has helped me so far today. I am now trying to combine the datasets that I had previously stored as dataset tags. However, when I try to append their together, I get a real… --- ## [Adding an HTML resource file into my ignition perspective iFrame](https://forum.inductiveautomation.com/t/adding-an-html-resource-file-into-my-ignition-perspective-iframe/77541)
**Author:** [@Jaden\_Steinbacher](https://forum.inductiveautomation.com/u/Jaden_Steinbacher)\ **Replies:** 13\ **Last updated:** [August 8, 2023, 1:50pm UTC](https://forum.inductiveautomation.com/t/adding-an-html-resource-file-into-my-ignition-perspective-iframe/77541 "2023-08-08T13:50:42Z")
Hi, I am fairly new to the web development area and just learning the basics of html and JavaScript programming. My application is trying to display an image and dynamically draw over it in real time by the operator cli… --- ## [Trying to extract tag data to make a dataset](https://forum.inductiveautomation.com/t/trying-to-extract-tag-data-to-make-a-dataset/77526)
**Author:** [@Joseph\_Alcide](https://forum.inductiveautomation.com/u/Joseph_Alcide)\ **Replies:** 31\ **Last updated:** [August 8, 2023, 1:28pm UTC](https://forum.inductiveautomation.com/t/trying-to-extract-tag-data-to-make-a-dataset/77526 "2023-08-08T13:28:56Z")
'''data = system.tag.browse("\[default\]DataMemory") headers = data.getResults() keys\_to\_keep = \["name","value"\] filtered\_list = \[ {key: dct\[key\] for key in keys\_to\_keep} for dct in headers \] for dictionary in filte… --- ## [Get JIRA issues in Ignition](https://forum.inductiveautomation.com/t/get-jira-issues-in-ignition/77559)
**Author:** [@Rohit\_Das](https://forum.inductiveautomation.com/u/Rohit_Das)\ **Replies:** 1\ **Last updated:** [August 8, 2023, 12:44pm UTC](https://forum.inductiveautomation.com/t/get-jira-issues-in-ignition/77559 "2023-08-08T12:44:40Z")
How can I pull a list of JIRA issues to my Ignition UI? --- ## [Adding an Annotation to a Category Chart](https://forum.inductiveautomation.com/t/adding-an-annotation-to-a-category-chart/6175)
**Author:** [@mikehill100](https://forum.inductiveautomation.com/u/mikehill100)\ **Replies:** 8\ **Last updated:** [August 8, 2023, 12:37pm UTC](https://forum.inductiveautomation.com/t/adding-an-annotation-to-a-category-chart/6175 "2023-08-08T12:37:15Z")
I found a way to do it here : viewtopic.php?f=70&t=6402&p=18059&hilit=xytextAnnotation#p18059 Unfortunately I am not very familiar with java and am having a tough time navigating the jfreechart API to do the same thing… --- ## [Popup can't be moved over nav bar or header?](https://forum.inductiveautomation.com/t/popup-cant-be-moved-over-nav-bar-or-header/77534)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 4\ **Last updated:** [August 8, 2023, 12:06pm UTC](https://forum.inductiveautomation.com/t/popup-cant-be-moved-over-nav-bar-or-header/77534 "2023-08-08T12:06:22Z")
Using 7.9.21. Probably simple because it's either impossible or a simple setting I am missing but can't find a forum post on it currently. Have a vision project with a west docked nav bar and a north docked header. Po… --- ## [Alarm 'mode' values string or integer](https://forum.inductiveautomation.com/t/alarm-mode-values-string-or-integer/77553)
**Author:** [@gino.miucci](https://forum.inductiveautomation.com/u/gino.miucci)\ **Replies:** 2\ **Last updated:** [August 8, 2023, 10:39am UTC](https://forum.inductiveautomation.com/t/alarm-mode-values-string-or-integer/77553 "2023-08-08T10:39:30Z")
I have a alarm tag with an Associated Data property 'Setpoint B' attached to an expression based on the alarm {mode} property. This should return the alarm SetpointB value if the alarm is in a mode that makes use of the… --- ## [How to remove lines in XY chart and only show bubble chart](https://forum.inductiveautomation.com/t/how-to-remove-lines-in-xy-chart-and-only-show-bubble-chart/77552)
**Author:** [@Adarsh\_K](https://forum.inductiveautomation.com/u/Adarsh_K)\ **Replies:** 1\ **Last updated:** [August 8, 2023, 10:18am UTC](https://forum.inductiveautomation.com/t/how-to-remove-lines-in-xy-chart-and-only-show-bubble-chart/77552 "2023-08-08T10:18:29Z")
Hi All, I am trying to find a way to delete lines and only have bubbles in below XY graph . Can anyone guide on this. Thanks in advance! --- ## [Prepending the Flex Repeater Instances](https://forum.inductiveautomation.com/t/prepending-the-flex-repeater-instances/77549)
**Author:** [@KAVINAYA\_L](https://forum.inductiveautomation.com/u/KAVINAYA_L)\ **Replies:** 12\ **Last updated:** [August 8, 2023, 7:40am UTC](https://forum.inductiveautomation.com/t/prepending-the-flex-repeater-instances/77549 "2023-08-08T07:40:32Z")
Hi, When adding instances in Flex Repeater, I need to add those instances in descending order. In other words, when new Flex instances are added, they should be placed above the previously added instances. Are there any… --- ## [Making an alarm label visibility loop](https://forum.inductiveautomation.com/t/making-an-alarm-label-visibility-loop/77130)
**Author:** [@Leigh.shannan](https://forum.inductiveautomation.com/u/Leigh.shannan)\ **Replies:** 7\ **Last updated:** [August 8, 2023, 7:39am UTC](https://forum.inductiveautomation.com/t/making-an-alarm-label-visibility-loop/77130 "2023-08-08T07:39:54Z")
Hi, I have a project which monitors the status of some conveyors. The Step7 PLC has a double word which handles the alarms for each conveyor. Each bit of the double word relates to a specific alarm. I realise this is pr… --- ## [Ignition alarm pipeline publish to AWS SNS topic for sending SMS messages](https://forum.inductiveautomation.com/t/ignition-alarm-pipeline-publish-to-aws-sns-topic-for-sending-sms-messages/77524)
**Author:** [@gino.miucci](https://forum.inductiveautomation.com/u/gino.miucci)\ **Replies:** 2\ **Last updated:** [August 8, 2023, 7:09am UTC](https://forum.inductiveautomation.com/t/ignition-alarm-pipeline-publish-to-aws-sns-topic-for-sending-sms-messages/77524 "2023-08-08T07:09:12Z")
I'm looking at an application where a customer wishes to send SMS messages to users on Ignition events using AWS SNS (rather than Twilio) as they have a lot of their services on AWS already. At some point they would als… --- ## [\[IGN-8167\]Expression structure binding woes](https://forum.inductiveautomation.com/t/ign-8167-expression-structure-binding-woes/77533)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 17\ **Last updated:** [August 8, 2023, 6:20am UTC](https://forum.inductiveautomation.com/t/ign-8167-expression-structure-binding-woes/77533 "2023-08-08T06:20:46Z")
It's simpler to add them into an object property and just bind to the object. I don't particularly like expression structures for simply monitoring a number of properties (which is the only way you really should be using… --- ## [Tag-Alarms-Active Delay，How to set history as same as alarms?](https://forum.inductiveautomation.com/t/tag-alarms-active-delay-how-to-set-history-as-same-as-alarms/77116)
**Author:** [@taohongyu88](https://forum.inductiveautomation.com/u/taohongyu88)\ **Replies:** 2\ **Last updated:** [August 8, 2023, 5:48am UTC](https://forum.inductiveautomation.com/t/tag-alarms-active-delay-how-to-set-history-as-same-as-alarms/77116 "2023-08-08T05:48:46Z")
In tag settings,I set Alarms -Active Delay 3 seconds. How to set History as same as alarms and let hisotry charts as smooth as alarms? --- ## [Perspective Flex Repeater auto-fit contents - how?](https://forum.inductiveautomation.com/t/perspective-flex-repeater-auto-fit-contents-how/43106)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 3\ **Last updated:** [August 8, 2023, 12:06am UTC](https://forum.inductiveautomation.com/t/perspective-flex-repeater-auto-fit-contents-how/43106 "2023-08-08T00:06:21Z")
Ignition 8.1.1. I’m using the Flex Repeater to generate multiple instances of my dropdown view (a caption and a dropdown). How do I get it to autosize to “just” fit the contents. In my case I want the height to adjust a… --- ## [Table component error after deleting dataset row](https://forum.inductiveautomation.com/t/table-component-error-after-deleting-dataset-row/77543)
**Author:** [@josborn](https://forum.inductiveautomation.com/u/josborn)\ **Replies:** 3\ **Last updated:** [August 7, 2023, 11:23pm UTC](https://forum.inductiveautomation.com/t/table-component-error-after-deleting-dataset-row/77543 "2023-08-07T23:23:23Z")
I have a perspective table component that shows this message when i try to remove the last row from the dataset: This is the code from my delete row button. data = self.getSibling("Table").props.data row = self.get… --- ## [Script Syntax for disabling a text field after the text has been updated](https://forum.inductiveautomation.com/t/script-syntax-for-disabling-a-text-field-after-the-text-has-been-updated/77542)
**Author:** [@Roger\_Denison](https://forum.inductiveautomation.com/u/Roger_Denison)\ **Replies:** 5\ **Last updated:** [August 7, 2023, 10:22pm UTC](https://forum.inductiveautomation.com/t/script-syntax-for-disabling-a-text-field-after-the-text-has-been-updated/77542 "2023-08-07T22:22:13Z")
I would like to have a method where I can enter a string into a text field and then disable the text field so that the string is "locked". I can reenable the field later by clicking another button. TIA. --- ## [system.db.runNamedQuery in a report](https://forum.inductiveautomation.com/t/system-db-runnamedquery-in-a-report/77537)
**Author:** [@jay](https://forum.inductiveautomation.com/u/jay)\ **Replies:** 1\ **Last updated:** [August 7, 2023, 8:12pm UTC](https://forum.inductiveautomation.com/t/system-db-runnamedquery-in-a-report/77537 "2023-08-07T20:12:05Z")
I am trying to create a script data source for a report. The script is calling system.db.runNamedQuery to get some of the data. The problem I seem to be having that there are two version of this function, one for proje… --- ## [Writing to Tags](https://forum.inductiveautomation.com/t/writing-to-tags/77535)
**Author:** [@cole.young34](https://forum.inductiveautomation.com/u/cole.young34)\ **Replies:** 13\ **Last updated:** [August 7, 2023, 8:00pm UTC](https://forum.inductiveautomation.com/t/writing-to-tags/77535 "2023-08-07T20:00:09Z")
Hi. I am trying to write from a list of tags and write to another list. Here is the code I am using: paths = \[ "\[ABC\]Building 4/PCP/Remote Sites Bridge/Location1/Bridge\_Location1\_0\_", "\[ABC\]Building 4/PCP/Remote Site… --- ## [How to use a OPC value to](https://forum.inductiveautomation.com/t/how-to-use-a-opc-value-to/77529)
**Author:** [@Joshua\_Hoekstra](https://forum.inductiveautomation.com/u/Joshua_Hoekstra)\ **Replies:** 8\ **Last updated:** [August 7, 2023, 5:26pm UTC](https://forum.inductiveautomation.com/t/how-to-use-a-opc-value-to/77529 "2023-08-07T17:26:47Z")
I am trying to refence a tag in my queries but I keep getting weird errors. Any help would be appericated SELECT Built FROM View\_ActiveOrders Where Targetlineid = 50 And Orderid ='\[DT Right Hand\]New Tag' One of the e… --- ## [Issue converting imported json list of dicts from unicode to a list](https://forum.inductiveautomation.com/t/issue-converting-imported-json-list-of-dicts-from-unicode-to-a-list/77492)
**Author:** [@Joseph\_Alcide](https://forum.inductiveautomation.com/u/Joseph_Alcide)\ **Replies:** 24\ **Last updated:** [August 7, 2023, 5:08pm UTC](https://forum.inductiveautomation.com/t/issue-converting-imported-json-list-of-dicts-from-unicode-to-a-list/77492 "2023-08-07T17:08:22Z")
Hello all, I am trying to import json data into my window when within actionPerformed script editor. The json data data I am importing is UTF-8 with BOM. When I print the type, it will say unicode, but I need a list or … --- ## [String \<=\> Unicode Comparison?](https://forum.inductiveautomation.com/t/string-unicode-comparison/77076)
**Author:** [@Mark\_Rzewnicki](https://forum.inductiveautomation.com/u/Mark_Rzewnicki)\ **Replies:** 11\ **Last updated:** [August 7, 2023, 5:03pm UTC](https://forum.inductiveautomation.com/t/string-unicode-comparison/77076 "2023-08-07T17:03:42Z")
I have an array of ASCII codes coming from a PLC into Ignition - this corresponds to a string in the PLC. I am doing the following: VALUES = \[list of ASCII codes\] S = ''.join(chr(v) for v in VALUES) test\_string = \[str… --- ## [Unknown Error in Logs](https://forum.inductiveautomation.com/t/unknown-error-in-logs/77522)
**Author:** [@Ryan\_Craig](https://forum.inductiveautomation.com/u/Ryan_Craig)\ **Replies:** 7\ **Last updated:** [August 7, 2023, 4:10pm UTC](https://forum.inductiveautomation.com/t/unknown-error-in-logs/77522 "2023-08-07T16:10:56Z")
We are having a few problems with our equipment that is being run with Ignition. We can't seem to recreate the error but I found this error in the logs around when the problem was happening. Does anyone know what this e… --- ## [How many instances of an alarm are present in a vision alarm status table?](https://forum.inductiveautomation.com/t/how-many-instances-of-an-alarm-are-present-in-a-vision-alarm-status-table/77525)
**Author:** [@L\_F](https://forum.inductiveautomation.com/u/L_F)\ **Replies:** 1\ **Last updated:** [August 7, 2023, 3:08pm UTC](https://forum.inductiveautomation.com/t/how-many-instances-of-an-alarm-are-present-in-a-vision-alarm-status-table/77525 "2023-08-07T15:08:34Z")
I've been using an alarm status table as a blanket historian for while now, thinking that it would keep a running record of all the alarms generated. An operator recently pointed out that the status table only has 1 inst… --- ## [How create a recipe used igintion](https://forum.inductiveautomation.com/t/how-create-a-recipe-used-igintion/77517)
**Author:** [@nabil\_hocini](https://forum.inductiveautomation.com/u/nabil_hocini)\ **Replies:** 10\ **Last updated:** [August 7, 2023, 2:55pm UTC](https://forum.inductiveautomation.com/t/how-create-a-recipe-used-igintion/77517 "2023-08-07T14:55:41Z")
Hello everyone, I am beginning in ignition let me ask you about the way that I could create the recipe in ignition, please --- ## [Text highlighting on button hold](https://forum.inductiveautomation.com/t/text-highlighting-on-button-hold/77388)
**Author:** [@Colin\_Quinn](https://forum.inductiveautomation.com/u/Colin_Quinn)\ **Replies:** 8\ **Last updated:** [August 7, 2023, 2:49pm UTC](https://forum.inductiveautomation.com/t/text-highlighting-on-button-hold/77388 "2023-08-07T14:49:22Z")
Hi, I have a few buttons that are designed to be held down for a period of time, and then released. However when the user holds on the text of the button, the button gets released and the text gets highlighted. I can't … --- ## [PowerTable Item Listener](https://forum.inductiveautomation.com/t/powertable-item-listener/77490)
**Author:** [@ademovicemir](https://forum.inductiveautomation.com/u/ademovicemir)\ **Replies:** 5\ **Last updated:** [August 7, 2023, 2:13pm UTC](https://forum.inductiveautomation.com/t/powertable-item-listener/77490 "2023-08-07T14:13:52Z")
I'm running Ignition 8.1.26 and am having some trouble with an Item Listener on the configureEditor extension function on the Power Table. I'm looking to get a drop down component in the cells of the specified column whi… --- ## [Increase part count in Sql table](https://forum.inductiveautomation.com/t/increase-part-count-in-sql-table/77513)
**Author:** [@Joshua\_Hoekstra](https://forum.inductiveautomation.com/u/Joshua_Hoekstra)\ **Replies:** 12\ **Last updated:** [August 7, 2023, 2:04pm UTC](https://forum.inductiveautomation.com/t/increase-part-count-in-sql-table/77513 "2023-08-07T14:04:31Z")
I am looking to do an increase in to a part-built table in one my active orders. I can each order have a specific ID which will help me determine what order I am on but I'm curious the most efficient way of increasing th… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=596) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=598)