# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=524 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 525 --- ## [Need help storing and manipulating data set](https://forum.inductiveautomation.com/t/need-help-storing-and-manipulating-data-set/82858)
**Author:** [@Jason\_Oberholtzer](https://forum.inductiveautomation.com/u/Jason_Oberholtzer)\ **Replies:** 5\ **Last updated:** [December 7, 2023, 6:38pm UTC](https://forum.inductiveautomation.com/t/need-help-storing-and-manipulating-data-set/82858 "2023-12-07T18:38:57Z")
Hello, Ignition beginner here, working on a machine control Edge HMI project for a building component saw. Here's what I am trying to accomplish: Import data to Ignition from a text file on the hard drive. This data… --- ## [Ignition.conf Java Additional Parameters recommendations](https://forum.inductiveautomation.com/t/ignition-conf-java-additional-parameters-recommendations/82856)
**Author:** [@cesrom](https://forum.inductiveautomation.com/u/cesrom)\ **Replies:** 4\ **Last updated:** [December 7, 2023, 5:25pm UTC](https://forum.inductiveautomation.com/t/ignition-conf-java-additional-parameters-recommendations/82856 "2023-12-07T17:25:12Z")
Hello community. Yesterday I tried to upgrade one of the Gateways I maintain from 8.1.28 to 8.1.35 but the Ignition Service failed to start. After looking at the logs it was clear that a Java Additional Parameter inheri… --- ## [Pass Wildcard to Report Query for one letter](https://forum.inductiveautomation.com/t/pass-wildcard-to-report-query-for-one-letter/82843)
**Author:** [@Schiavone8](https://forum.inductiveautomation.com/u/Schiavone8)\ **Replies:** 6\ **Last updated:** [December 7, 2023, 4:54pm UTC](https://forum.inductiveautomation.com/t/pass-wildcard-to-report-query-for-one-letter/82843 "2023-12-07T16:54:51Z")
I am trying to have a report where users can select from items with a single letter designation like A, B, C, etc. Is there a way to pass a wildcard to the report that can be used in the SQL query to get all of the lette… --- ## [Functionality on list 2 individual list component](https://forum.inductiveautomation.com/t/functionality-on-list-2-individual-list-component/82840)
**Author:** [@Mohd\_Waqas](https://forum.inductiveautomation.com/u/Mohd_Waqas)\ **Replies:** 1\ **Last updated:** [December 7, 2023, 3:42pm UTC](https://forum.inductiveautomation.com/t/functionality-on-list-2-individual-list-component/82840 "2023-12-07T15:42:05Z")
Above is the image like when select air in left list component and click on green arrow button the data is tranfer to right list component and vice-versa. How this functionality will be executable in ignition point of… --- ## [Select Elements/Components From ID instead of Hierarchical](https://forum.inductiveautomation.com/t/select-elements-components-from-id-instead-of-hierarchical/82851)
**Author:** [@Subin\_Adhikari](https://forum.inductiveautomation.com/u/Subin_Adhikari)\ **Replies:** 1\ **Last updated:** [December 7, 2023, 3:25pm UTC](https://forum.inductiveautomation.com/t/select-elements-components-from-id-instead-of-hierarchical/82851 "2023-12-07T15:25:33Z")
Dear Gurus, I see in perspective I can set a DOMID to any components, so I wonder if instead of self.parent.getChild("FlexContainer").getChild("tblList").props.data can I do something like document.getElementByID(… --- ## [Environment Variable for JDBC Connect URL](https://forum.inductiveautomation.com/t/environment-variable-for-jdbc-connect-url/82820)
**Author:** [@andrewdhunt7](https://forum.inductiveautomation.com/u/andrewdhunt7)\ **Replies:** 2\ **Last updated:** [December 7, 2023, 3:07pm UTC](https://forum.inductiveautomation.com/t/environment-variable-for-jdbc-connect-url/82820 "2023-12-07T15:07:16Z")
Not sure if what I'm looking to do is missing a small piece of syntax or is unsupported. Say I have a database connection where the connect string property is jdbc:mysql://localhost:3306/test If I have that stored to… --- ## [HTTP Parser error is launched constantly](https://forum.inductiveautomation.com/t/http-parser-error-is-launched-constantly/37551)
**Author:** [@Carlos\_Castillo](https://forum.inductiveautomation.com/u/Carlos_Castillo)\ **Replies:** 6\ **Last updated:** [December 7, 2023, 1:51pm UTC](https://forum.inductiveautomation.com/t/http-parser-error-is-launched-constantly/37551 "2023-12-07T13:51:08Z")
Hi all, Im getting this error in Ignition V7.9.11: Illegal character 0x16 in state=START for buffer HeapByteBuffer@4ec19b22\[p=1,l=517,c=8192,r=516\]={\\x16\<\<\<\\x03\\x01\\x02\\x00\\x01\\x00\\x01\\xFc\\x03\\x03N(\\xB5y?T\\xB0…\\x00\\x00… --- ## [\[Bug?\] Message handler Error](https://forum.inductiveautomation.com/t/bug-message-handler-error/82828)
**Author:** [@MSviga](https://forum.inductiveautomation.com/u/MSviga)\ **Replies:** 3\ **Last updated:** [December 7, 2023, 1:03pm UTC](https://forum.inductiveautomation.com/t/bug-message-handler-error/82828 "2023-12-07T13:03:35Z")
Preface: This is on Ignition 8.1.32 Perspective. I have been stumped by this for a while now, so im hoping someone might be able to give me a bit more insight into why this si happening. I have a group of 3 projects (na… --- ## [File upload component issue](https://forum.inductiveautomation.com/t/file-upload-component-issue/82265)
**Author:** [@Pappu\_Gupta](https://forum.inductiveautomation.com/u/Pappu_Gupta)\ **Replies:** 26\ **Last updated:** [December 7, 2023, 1:26pm UTC](https://forum.inductiveautomation.com/t/file-upload-component-issue/82265 "2023-12-07T13:26:32Z")
I am using a file upload component to upload a images.I have decrease the width of file upload component and provide a icon of camera for user understanding that what file upload component do. Sometimes it is working fin… --- ## [How to log multiple tag when one tag value change?](https://forum.inductiveautomation.com/t/how-to-log-multiple-tag-when-one-tag-value-change/82763)
**Author:** [@govind](https://forum.inductiveautomation.com/u/govind)\ **Replies:** 6\ **Last updated:** [December 7, 2023, 1:17pm UTC](https://forum.inductiveautomation.com/t/how-to-log-multiple-tag-when-one-tag-value-change/82763 "2023-12-07T13:17:19Z")
Hello Friends, I want to log multiple tags using of the one tag value change. For example : 100 tags log when the tag\_1 value change. Thanks & Regards, Govind Suthar --- ## [OPC tag bad\_connected](https://forum.inductiveautomation.com/t/opc-tag-bad-connected/82831)
**Author:** [@Denis\_Pahomov](https://forum.inductiveautomation.com/u/Denis_Pahomov)\ **Replies:** 4\ **Last updated:** [December 7, 2023, 11:28am UTC](https://forum.inductiveautomation.com/t/opc-tag-bad-connected/82831 "2023-12-07T11:28:30Z")
Hello, I am trying to make Ignition and Allen bradley connection, and I got this problem: Server status is connected, any ideas what I am missing? --- ## [Perspective: components on top block click events in below components despite no events configured on top](https://forum.inductiveautomation.com/t/perspective-components-on-top-block-click-events-in-below-components-despite-no-events-configured-on-top/42283)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 9\ **Last updated:** [December 7, 2023, 11:18am UTC](https://forum.inductiveautomation.com/t/perspective-components-on-top-block-click-events-in-below-components-despite-no-events-configured-on-top/42283 "2023-12-07T11:18:45Z")
v8.1.0 When two components are placed overlapping each other in a Coordinate container, the component on top will block any mouse click events on components below it where it overlaps. This is despite the top component … --- ## [Error on Box and Whisker chart](https://forum.inductiveautomation.com/t/error-on-box-and-whisker-chart/82827)
**Author:** [@nmunoli](https://forum.inductiveautomation.com/u/nmunoli)\ **Replies:** 1\ **Last updated:** [December 7, 2023, 9:53am UTC](https://forum.inductiveautomation.com/t/error-on-box-and-whisker-chart/82827 "2023-12-07T09:53:30Z")
I get this error when I insert a (date) property value in the SQL query, but works properly when i type in specific date. Any ideas why? caused by IllegalArgumentException: Range(double, double): require lower (Infinity… --- ## [Any possibilities of report table scroll option?](https://forum.inductiveautomation.com/t/any-possibilities-of-report-table-scroll-option/82832)
**Author:** [@YOSHUVA\_V1](https://forum.inductiveautomation.com/u/YOSHUVA_V1)\ **Replies:** 1\ **Last updated:** [December 7, 2023, 9:29am UTC](https://forum.inductiveautomation.com/t/any-possibilities-of-report-table-scroll-option/82832 "2023-12-07T09:29:00Z")
If multiple rows were inserted in a table, this will be moved to the next page. But I want If many rows are available in there that tabel will automatic scrolling option. like a vision power table component. --- ## [Change report bar chart x- axis and y-axis label colour](https://forum.inductiveautomation.com/t/change-report-bar-chart-x-axis-and-y-axis-label-colour/82570)
**Author:** [@YOSHUVA\_V1](https://forum.inductiveautomation.com/u/YOSHUVA_V1)\ **Replies:** 2\ **Last updated:** [December 7, 2023, 6:33am UTC](https://forum.inductiveautomation.com/t/change-report-bar-chart-x-axis-and-y-axis-label-colour/82570 "2023-12-07T06:33:17Z")
How to change report bar chart label color ? --- ## [Custom SVGs, where are they?](https://forum.inductiveautomation.com/t/custom-svgs-where-are-they/82817)
**Author:** [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\ **Replies:** 2\ **Last updated:** [December 7, 2023, 4:50am UTC](https://forum.inductiveautomation.com/t/custom-svgs-where-are-they/82817 "2023-12-07T04:50:55Z")
Hey all, somewhere, somehow, I came across a thread in which a dev posted a link to several animated custom SVGs. We had a visitor from another facility here today and I was attempting to show him said SVGs and where t… --- ## [Different return values from ignition DB](https://forum.inductiveautomation.com/t/different-return-values-from-ignition-db/82816)
**Author:** [@ignitionSL](https://forum.inductiveautomation.com/u/ignitionSL)\ **Replies:** 4\ **Last updated:** [December 7, 2023, 4:50am UTC](https://forum.inductiveautomation.com/t/different-return-values-from-ignition-db/82816 "2023-12-07T04:50:12Z")
I ran a query to retrieve data from the same table in MSSQL and in ignition "Named queries" but the results were not the same. Therefore, I did a manual calculation using Excel and it was matched with MSSQL output. I w… --- ## [Problem in attaching PDF's in Email through Gatewayscripts](https://forum.inductiveautomation.com/t/problem-in-attaching-pdfs-in-email-through-gatewayscripts/82616)
**Author:** [@Saranraj\_Chennappan](https://forum.inductiveautomation.com/u/Saranraj_Chennappan)\ **Replies:** 7\ **Last updated:** [December 7, 2023, 4:21am UTC](https://forum.inductiveautomation.com/t/problem-in-attaching-pdfs-in-email-through-gatewayscripts/82616 "2023-12-07T04:21:32Z")
Hi, we are facing some issue while attaching a PDF in Email. Seems no errors in the script. Script running well but i didn't receive mail with PDF attachments. here with find the code which we are using for your refere… --- ## [Dynamic UI Layout](https://forum.inductiveautomation.com/t/dynamic-ui-layout/82563)
**Author:** [@Devin\_Golberg](https://forum.inductiveautomation.com/u/Devin_Golberg)\ **Replies:** 15\ **Last updated:** [December 7, 2023, 3:04am UTC](https://forum.inductiveautomation.com/t/dynamic-ui-layout/82563 "2023-12-07T03:04:16Z")
I'm a bit new to Ignition, so bear with me. I've done a fair amount of programming in Java and some script automation through JavaScript which included interface windows (mostly Photoshop batching automation with input … --- ## [Ignition 8.1.35 is now available for download](https://forum.inductiveautomation.com/t/ignition-8-1-35-is-now-available-for-download/82814)
**Author:** [@sreis](https://forum.inductiveautomation.com/u/sreis)\ **Replies:** 0\ **Last updated:** [December 6, 2023, 11:37pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-35-is-now-available-for-download/82814 "2023-12-06T23:37:09Z")
Ignition 8.1.35 is now available for download. This release fixes the regression introduced in 8.1.34 with remote tags. Inductive Automation recommends that all customers prioritize their upgrade to 8.1.35 based on criti… --- ## [Clarification executing a stored procedure](https://forum.inductiveautomation.com/t/clarification-executing-a-stored-procedure/82807)
**Author:** [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\ **Replies:** 11\ **Last updated:** [December 6, 2023, 10:19pm UTC](https://forum.inductiveautomation.com/t/clarification-executing-a-stored-procedure/82807 "2023-12-06T22:19:12Z")
So, first time trying to execute an SP. Wondering if I think this is right: I create a project, in the Gateway Event Scripts, set a scheduled script - based on whatever occurrence I want it to execute at, then the scrip… --- ## [Report just show one row of table](https://forum.inductiveautomation.com/t/report-just-show-one-row-of-table/82737)
**Author:** [@marco\_alvarez](https://forum.inductiveautomation.com/u/marco_alvarez)\ **Replies:** 5\ **Last updated:** [December 6, 2023, 9:36pm UTC](https://forum.inductiveautomation.com/t/report-just-show-one-row-of-table/82737 "2023-12-06T21:36:48Z")
Hi, I have a report that use data from a nested query. The nested query work fine because checking the XML file, I have all the right data. In my case just two of the instances of the nested query should bring data, usua… --- ## [Reading String Tag From ControlLogix PLC using CMT-G01 - MQTT connection](https://forum.inductiveautomation.com/t/reading-string-tag-from-controllogix-plc-using-cmt-g01-mqtt-connection/82790)
**Author:** [@Eagel007](https://forum.inductiveautomation.com/u/Eagel007)\ **Replies:** 8\ **Last updated:** [December 6, 2023, 8:22pm UTC](https://forum.inductiveautomation.com/t/reading-string-tag-from-controllogix-plc-using-cmt-g01-mqtt-connection/82790 "2023-12-06T20:22:50Z")
Hi there, for ControlLogix PLC String tag, I am only able to capture LEN and DATA. where DATA is in SINT. In my case, I am trying to get String value scanned from barcode reader. However the only format I can get it is … --- ## [Issue writing value to tag in script](https://forum.inductiveautomation.com/t/issue-writing-value-to-tag-in-script/82745)
**Author:** [@Brad\_Kloehn](https://forum.inductiveautomation.com/u/Brad_Kloehn)\ **Replies:** 4\ **Last updated:** [December 6, 2023, 7:50pm UTC](https://forum.inductiveautomation.com/t/issue-writing-value-to-tag-in-script/82745 "2023-12-06T19:50:12Z")
I have provided a snip of the script I am attempting to write. Full disclosure, I made the move from Foxboro DCS to Ignition so there will be some syntax things I have yet to learn. In any event, the script below is tied… --- ## [Memory issues with hosted images](https://forum.inductiveautomation.com/t/memory-issues-with-hosted-images/82797)
**Author:** [@Tyler\_Dixon](https://forum.inductiveautomation.com/u/Tyler_Dixon)\ **Replies:** 8\ **Last updated:** [December 6, 2023, 6:39pm UTC](https://forum.inductiveautomation.com/t/memory-issues-with-hosted-images/82797 "2023-12-06T18:39:01Z")
I have the same issue, which I suspect is from several SVG graphic in my Image Management folder at a size of 56MB. I have them linked to a container through the CSS under backgroundImage url("/system/images/path/to/imag… --- ## [Bar chart changing the text color in the series](https://forum.inductiveautomation.com/t/bar-chart-changing-the-text-color-in-the-series/82803)
**Author:** [@dan\_mueller](https://forum.inductiveautomation.com/u/dan_mueller)\ **Replies:** 1\ **Last updated:** [December 6, 2023, 6:32pm UTC](https://forum.inductiveautomation.com/t/bar-chart-changing-the-text-color-in-the-series/82803 "2023-12-06T18:32:36Z")
Built a Perspective XY chart and wanted to display the text data in the column field. Someone helped me by adding a series with render value of step line. I want to know how to change the color of the text but cant figur… --- ## [Multiple databases in single history provider/store](https://forum.inductiveautomation.com/t/multiple-databases-in-single-history-provider-store/82732)
**Author:** [@Connor\_Sims](https://forum.inductiveautomation.com/u/Connor_Sims)\ **Replies:** 2\ **Last updated:** [December 6, 2023, 5:13pm UTC](https://forum.inductiveautomation.com/t/multiple-databases-in-single-history-provider-store/82732 "2023-12-06T17:13:21Z")
The Tag Properties document indicates "A particular Tag can only target one history store." Can this one history store be multiple mysql databases on the same server? Or, must we specify one particular mysql database? .… --- ## [Does ignition support writing math equations in equation format similar to microsoft word](https://forum.inductiveautomation.com/t/does-ignition-support-writing-math-equations-in-equation-format-similar-to-microsoft-word/82798)
**Author:** [@prashants](https://forum.inductiveautomation.com/u/prashants)\ **Replies:** 3\ **Last updated:** [December 6, 2023, 4:57pm UTC](https://forum.inductiveautomation.com/t/does-ignition-support-writing-math-equations-in-equation-format-similar-to-microsoft-word/82798 "2023-12-06T16:57:44Z")
please let me know if there is a way to do this rather than having to manually create it using text and lines? Thanks --- ## [Bar Chart in Report - Control Chart Title using Configure/Edit Script](https://forum.inductiveautomation.com/t/bar-chart-in-report-control-chart-title-using-configure-edit-script/82774)
**Author:** [@Richard\_Tryon](https://forum.inductiveautomation.com/u/Richard_Tryon)\ **Replies:** 3\ **Last updated:** [December 6, 2023, 4:40pm UTC](https://forum.inductiveautomation.com/t/bar-chart-in-report-control-chart-title-using-configure-edit-script/82774 "2023-12-06T16:40:59Z")
I have been able to create a chart title (as opposed to just creating a text object and dragging it over top of the chart). I can't seem to set the font information for the title I created. The attached picture shows t… --- ## [High memory usage on gateway that only has perspective?](https://forum.inductiveautomation.com/t/high-memory-usage-on-gateway-that-only-has-perspective/53995)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 7\ **Last updated:** [December 10, 2021, 10:02pm UTC](https://forum.inductiveautomation.com/t/high-memory-usage-on-gateway-that-only-has-perspective/53995 "2021-12-10T22:02:44Z")
Started helping a coworker on a pretty fresh perspective project - only 5 views, no clients currently connected, a few SQL tags. I see a high usage warning - I’m attaching a thread dump I took during the same time a… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=523) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=525)