# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=200 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 201 --- ## [Table column set to invisible is still visible](https://forum.inductiveautomation.com/t/table-column-set-to-invisible-is-still-visible/105916)
**Author:** [@Tyler\_Dolan](https://forum.inductiveautomation.com/u/Tyler_Dolan)\ **Replies:** 6\ **Last updated:** [May 7, 2025, 9:39pm UTC](https://forum.inductiveautomation.com/t/table-column-set-to-invisible-is-still-visible/105916 "2025-05-07T21:39:07Z")
I have a perspective table with a data binding that queries a database. The column field names correspond to column names in the database table. If I create a table column with that field name and set it to invisible, th… --- ## [Best way to publish non-SparkplugB MQTT data?](https://forum.inductiveautomation.com/t/best-way-to-publish-non-sparkplugb-mqtt-data/74208)
**Author:** [@Joe\_Bonhage](https://forum.inductiveautomation.com/u/Joe_Bonhage)\ **Replies:** 6\ **Last updated:** [May 5, 2025, 12:39pm UTC](https://forum.inductiveautomation.com/t/best-way-to-publish-non-sparkplugb-mqtt-data/74208 "2025-05-05T12:39:09Z")
Hi all, I'm looking for the best approach to put an entire tag provider (or a certain folders) to publish plain MQTT (non-SpB) on change. I currently have an on-change tag event working (script below) but I'd like to de… --- ## [Query Problem: A result set was generated for update](https://forum.inductiveautomation.com/t/query-problem-a-result-set-was-generated-for-update/106007)
**Author:** [@Burger\_King](https://forum.inductiveautomation.com/u/Burger_King)\ **Replies:** 1\ **Last updated:** [May 7, 2025, 9:23pm UTC](https://forum.inductiveautomation.com/t/query-problem-a-result-set-was-generated-for-update/106007 "2025-05-07T21:23:34Z")
I am having periodic issues running a query in my Ignition script. I have a select statement and I am inserting the rows returned. Example below INSERT INTO \*my\_table\* () SELECT columns FROM \*a\_different\_table\* Most of… --- ## [Do calculation on OPC Tags](https://forum.inductiveautomation.com/t/do-calculation-on-opc-tags/105982)
**Author:** [@Eugene49](https://forum.inductiveautomation.com/u/Eugene49)\ **Replies:** 7\ **Last updated:** [May 7, 2025, 5:25pm UTC](https://forum.inductiveautomation.com/t/do-calculation-on-opc-tags/105982 "2025-05-07T17:25:00Z")
Opc source path shows unit in Celsius. I need translate to Fahrenheit and import this to Tag Browser. I need this translation to be in tag level, so I can apply alarming in F units as well. What is the best/short way … --- ## [XY chart individual column color change](https://forum.inductiveautomation.com/t/xy-chart-individual-column-color-change/105992)
**Author:** [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\ **Replies:** 3\ **Last updated:** [May 7, 2025, 3:58pm UTC](https://forum.inductiveautomation.com/t/xy-chart-individual-column-color-change/105992 "2025-05-07T15:58:51Z")
Hello, Is it possible to change the color of the individual columns from same dataset on my XY chart control in Perspective ? Cheers! Alejandro --- ## [Ignition 7.9.21: ftplib not found](https://forum.inductiveautomation.com/t/ignition-7-9-21-ftplib-not-found/105940)
**Author:** [@gregory.sachs](https://forum.inductiveautomation.com/u/gregory.sachs)\ **Replies:** 6\ **Last updated:** [May 7, 2025, 3:46pm UTC](https://forum.inductiveautomation.com/t/ignition-7-9-21-ftplib-not-found/105940 "2025-05-07T15:46:35Z")
I know, I need to upgrade, but can't right now on this server. I'm trying to script ftping, and i suddenly started getting this message: ImportError: No module named ftplib This was working, and suddenly stopped worki… --- ## [Best option for connecting to SAP and Limble using API](https://forum.inductiveautomation.com/t/best-option-for-connecting-to-sap-and-limble-using-api/105976)
**Author:** [@Alex\_Ford-King](https://forum.inductiveautomation.com/u/Alex_Ford-King)\ **Replies:** 2\ **Last updated:** [May 7, 2025, 3:40pm UTC](https://forum.inductiveautomation.com/t/best-option-for-connecting-to-sap-and-limble-using-api/105976 "2025-05-07T15:40:03Z")
I am trying to implement a connection between SAP and our maintenance software, Limble. It would be used to collect data in Ignition and pass it to both apps. They both have API's so i assume this is how i could accompli… --- ## [Rest API Calls with Kerebros Encryption](https://forum.inductiveautomation.com/t/rest-api-calls-with-kerebros-encryption/104157)
**Author:** [@h.sumrain](https://forum.inductiveautomation.com/u/h.sumrain)\ **Replies:** 29\ **Last updated:** [May 7, 2025, 3:32pm UTC](https://forum.inductiveautomation.com/t/rest-api-calls-with-kerebros-encryption/104157 "2025-05-07T15:32:36Z")
Hi team, I need to send data using REST API POST requests to a system that has kerebros encryption while the Ignition side use Active Directory within a domain. What do I need to do to enable it in Ignition while contin… --- ## [How to store and trend tag history more efficiently](https://forum.inductiveautomation.com/t/how-to-store-and-trend-tag-history-more-efficiently/74625)
**Author:** [@Joern\_Selnes\_Hella](https://forum.inductiveautomation.com/u/Joern_Selnes_Hella)\ **Replies:** 4\ **Last updated:** [May 7, 2025, 3:31pm UTC](https://forum.inductiveautomation.com/t/how-to-store-and-trend-tag-history-more-efficiently/74625 "2025-05-07T15:31:31Z")
Hi, I'm fairly new to Ignition and am trying to use postgresql with TimescaleDB on top as a tag history provider. We have quite a few tags with a sampling rate of 1 second, and we're seeing high load times in Perspectiv… --- ## [How to realize the function that perspective button text line break？](https://forum.inductiveautomation.com/t/how-to-realize-the-function-that-perspective-button-text-line-break/105954)
**Author:** [@ywang142](https://forum.inductiveautomation.com/u/ywang142)\ **Replies:** 4\ **Last updated:** [May 7, 2025, 3:08pm UTC](https://forum.inductiveautomation.com/t/how-to-realize-the-function-that-perspective-button-text-line-break/105954 "2025-05-07T15:08:26Z")
I knew in ignition 7.9 it can work with , but I try this way in 8.1, seem the html render can't work, does someone know? --- ## [Reporting flow totals, issue with PLC data rollover](https://forum.inductiveautomation.com/t/reporting-flow-totals-issue-with-plc-data-rollover/105971)
**Author:** [@Christopher\_Drum](https://forum.inductiveautomation.com/u/Christopher_Drum)\ **Replies:** 7\ **Last updated:** [May 7, 2025, 2:25pm UTC](https://forum.inductiveautomation.com/t/reporting-flow-totals-issue-with-plc-data-rollover/105971 "2025-05-07T14:25:52Z")
I ran into an issue with a customers flow total report. My issue is that the variable used in the PLC is only a 16 bit unsigned integer so the value rolls over every 2-3 days. The report was setup to use Aggregation mode… --- ## [Perspective Multistate buttons border radius](https://forum.inductiveautomation.com/t/perspective-multistate-buttons-border-radius/105975)
**Author:** [@ppricket1224](https://forum.inductiveautomation.com/u/ppricket1224)\ **Replies:** 2\ **Last updated:** [May 7, 2025, 1:41pm UTC](https://forum.inductiveautomation.com/t/perspective-multistate-buttons-border-radius/105975 "2025-05-07T13:41:09Z")
I'm using a multistate button in perspective and i'm using the border radius to round the corners. The middle button is how i want it to look, but the top and bottom still have square corners, even when i set it to rad… --- ## [Creating a Mentions Function in within Comments Functionality (CMMS Project)](https://forum.inductiveautomation.com/t/creating-a-mentions-function-in-within-comments-functionality-cmms-project/96257)
**Author:** [@Nick\_Moore](https://forum.inductiveautomation.com/u/Nick_Moore)\ **Replies:** 7\ **Last updated:** [May 7, 2025, 1:32pm UTC](https://forum.inductiveautomation.com/t/creating-a-mentions-function-in-within-comments-functionality-cmms-project/96257 "2025-05-07T13:32:41Z")
I'm working on building out a CMMS with Vision Windows for my team and as you might be able to tell from the photo, the way to mention someone is a little......clunky. Clicking a username in the list adds the username to… --- ## [Question about the license for upgrading modules](https://forum.inductiveautomation.com/t/question-about-the-license-for-upgrading-modules/82466)
**Author:** [@Stef\_Velers](https://forum.inductiveautomation.com/u/Stef_Velers)\ **Replies:** 11\ **Last updated:** [May 7, 2025, 12:43pm UTC](https://forum.inductiveautomation.com/t/question-about-the-license-for-upgrading-modules/82466 "2025-05-07T12:43:57Z")
Hello, I have read the Support Policy and there is one thing that is unclear to me. In this example, there is an Ignition License price and then the Support Plan is a percentage of that License price. Does this mean… --- ## [Handling pump state in Perspective](https://forum.inductiveautomation.com/t/handling-pump-state-in-perspective/105937)
**Author:** [@Anirban-Debnath](https://forum.inductiveautomation.com/u/Anirban-Debnath)\ **Replies:** 4\ **Last updated:** [May 7, 2025, 11:21am UTC](https://forum.inductiveautomation.com/t/handling-pump-state-in-perspective/105937 "2025-05-07T11:21:38Z")
In a perspective design, I have a pump where I am writing a script in pump "onClick" event. I expect the script will change the state of the pump to "running" in both UI and the tag property. When I run the project in br… --- ## [Deleting individual historian partitions?](https://forum.inductiveautomation.com/t/deleting-individual-historian-partitions/105941)
**Author:** [@Eric\_G](https://forum.inductiveautomation.com/u/Eric_G)\ **Replies:** 2\ **Last updated:** [May 7, 2025, 10:55am UTC](https://forum.inductiveautomation.com/t/deleting-individual-historian-partitions/105941 "2025-05-07T10:55:59Z")
I'm preparing to move the historian database to another machine. I'd like to reduce downtime by copying over as much of the historian data as possible beforehand. My plan is to copy the database to the new system, then… --- ## [Problems with system.tag.queryTagHistory](https://forum.inductiveautomation.com/t/problems-with-system-tag-querytaghistory/105866)
**Author:** [@Filarm27](https://forum.inductiveautomation.com/u/Filarm27)\ **Replies:** 6\ **Last updated:** [May 7, 2025, 7:40am UTC](https://forum.inductiveautomation.com/t/problems-with-system-tag-querytaghistory/105866 "2025-05-07T07:40:44Z")
Hi everyone, I'm trying to implement a count of the number of times a valve has opened since midnight of the current day via script using system.tag.queryTagHistory. I have a tag boolean that indicates the valve's open… --- ## [Embedded View Parameter Timing](https://forum.inductiveautomation.com/t/embedded-view-parameter-timing/105922)
**Author:** [@CB123](https://forum.inductiveautomation.com/u/CB123)\ **Replies:** 5\ **Last updated:** [May 7, 2025, 5:32am UTC](https://forum.inductiveautomation.com/t/embedded-view-parameter-timing/105922 "2025-05-07T05:32:35Z")
Ignition 8.1.24 Perspective I am passing a parameter to an embedded view, I use the value of that parameter (0 or 1) to either display or not display a label. Works fine, except if I don't want the label to display on… --- ## [XY Chart - Tooltip width problem](https://forum.inductiveautomation.com/t/xy-chart-tooltip-width-problem/105909)
**Author:** [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\ **Replies:** 4\ **Last updated:** [May 7, 2025, 5:27am UTC](https://forum.inductiveautomation.com/t/xy-chart-tooltip-width-problem/105909 "2025-05-07T05:27:53Z")
Hello everybody, I'm wondering if it's possible to set a maximum width for XY Chart tooltips in Perspective. My problem is that the tooltip contains a Description string that can sometimes be quite long. When this happ… --- ## [Copy XML To Clipboard not available](https://forum.inductiveautomation.com/t/copy-xml-to-clipboard-not-available/105950)
**Author:** [@indra.biswas](https://forum.inductiveautomation.com/u/indra.biswas)\ **Replies:** 1\ **Last updated:** [May 7, 2025, 1:49am UTC](https://forum.inductiveautomation.com/t/copy-xml-to-clipboard-not-available/105950 "2025-05-07T01:49:42Z")
I thought this feature was available in earlier versions of Ignition Designer- Copy XML To Clipboard on right clicking a Vision window. Did it get removed at some point ? My version is 8.1.33 --- ## [Alarm test not going through, but email is](https://forum.inductiveautomation.com/t/alarm-test-not-going-through-but-email-is/105947)
**Author:** [@aaaa](https://forum.inductiveautomation.com/u/aaaa)\ **Replies:** 2\ **Last updated:** [May 7, 2025, 12:08am UTC](https://forum.inductiveautomation.com/t/alarm-test-not-going-through-but-email-is/105947 "2025-05-07T00:08:11Z")
Hello I'm testing a very simple pipeline, Start -\> in of notification block. I'm injecting fake alarm events into the pipeline from gateway/alarming/notification. But nothing is sent to the email. The log says nothing a… --- ## [Merging Multiple PDF Reports into a Single File and Downloading in Ignition Perspective](https://forum.inductiveautomation.com/t/merging-multiple-pdf-reports-into-a-single-file-and-downloading-in-ignition-perspective/102231)
**Author:** [@Goutham\_Rao\_Y](https://forum.inductiveautomation.com/u/Goutham_Rao_Y)\ **Replies:** 3\ **Last updated:** [May 6, 2025, 4:53pm UTC](https://forum.inductiveautomation.com/t/merging-multiple-pdf-reports-into-a-single-file-and-downloading-in-ignition-perspective/102231 "2025-05-06T16:53:34Z")
Hello team, How can I combine into a single PDF file in Ignition Perspective and download it using system.perspective.download? Here is the script generating the PDF byte arrays: def runAction(self, event): startTi… --- ## [Tab strip object - How to hide tabs through scripting](https://forum.inductiveautomation.com/t/tab-strip-object-how-to-hide-tabs-through-scripting/105946)
**Author:** [@rigoberto.reyes](https://forum.inductiveautomation.com/u/rigoberto.reyes)\ **Replies:** 1\ **Last updated:** [May 6, 2025, 10:16pm UTC](https://forum.inductiveautomation.com/t/tab-strip-object-how-to-hide-tabs-through-scripting/105946 "2025-05-06T22:16:02Z")
Hi. I need to hide/unhide some tabs using a script when a condition is triggered. Is there any way to do it? --- ## [Bound view.custom parameter persistence](https://forum.inductiveautomation.com/t/bound-view-custom-parameter-persistence/90470)
**Author:** [@hunterdg](https://forum.inductiveautomation.com/u/hunterdg)\ **Replies:** 0\ **Last updated:** [May 16, 2024, 3:50am UTC](https://forum.inductiveautomation.com/t/bound-view-custom-parameter-persistence/90470 "2024-05-16T03:50:28Z")
Why isn’t persistence automatically toggled for view.custom params when bound (like every other param)? (Besides the fact that this would probably break pre-existing behavior) worthy of noting, this doesn't happen when… --- ## [Issue connecting to CompactLogix dual IP](https://forum.inductiveautomation.com/t/issue-connecting-to-compactlogix-dual-ip/105881)
**Author:** [@jmb6259](https://forum.inductiveautomation.com/u/jmb6259)\ **Replies:** 7\ **Last updated:** [May 6, 2025, 8:45pm UTC](https://forum.inductiveautomation.com/t/issue-connecting-to-compactlogix-dual-ip/105881 "2025-05-06T20:45:41Z")
I'm having issues connecting to a CompactLogix processor. It is set up as a dual IP, and we've confirmed that it is configured as such. It is not on any kind of back-plane, so there shouldn't be any need for a 'path' i… --- ## [Code signing certificate SSL.com](https://forum.inductiveautomation.com/t/code-signing-certificate-ssl-com/105932)
**Author:** [@Rick\_de\_Man](https://forum.inductiveautomation.com/u/Rick_de_Man)\ **Replies:** 2\ **Last updated:** [May 6, 2025, 8:45pm UTC](https://forum.inductiveautomation.com/t/code-signing-certificate-ssl-com/105932 "2025-05-06T20:45:24Z")
I'm looking into getting starting with the Ignition SDK modules which requires a Code Signing Certificate in order to use the module in a production environment. The Module will be for internal use only at this moment. … --- ## [Ignition Cloud MQTT Broker Host URL](https://forum.inductiveautomation.com/t/ignition-cloud-mqtt-broker-host-url/105931)
**Author:** [@Marcos\_Verdugo](https://forum.inductiveautomation.com/u/Marcos_Verdugo)\ **Replies:** 2\ **Last updated:** [May 6, 2025, 7:52pm UTC](https://forum.inductiveautomation.com/t/ignition-cloud-mqtt-broker-host-url/105931 "2025-05-06T19:52:49Z")
Hi, I am currently working on a Ignition Cloud version, the PC that hosts the gateway is on my boss computer. So I have access to the gateway thorugh an IP address over the internet. I installed the MQTT modules (Distrib… --- ## [Tag address at OPC UA vs OPC Item Path at Ignition 8.1.47](https://forum.inductiveautomation.com/t/tag-address-at-opc-ua-vs-opc-item-path-at-ignition-8-1-47/105864)
**Author:** [@matt.taheri.ca](https://forum.inductiveautomation.com/u/matt.taheri.ca)\ **Replies:** 5\ **Last updated:** [May 6, 2025, 5:21pm UTC](https://forum.inductiveautomation.com/t/tag-address-at-opc-ua-vs-opc-item-path-at-ignition-8-1-47/105864 "2025-05-06T17:21:41Z")
I have a tag in OPC UA with the type 'word array' and the address R00006\[1\]\[6\]. I'm trying to read this tag from Ignition Designer. Here's what I did: Created a tag of type integer (since I can't create a word array t… --- ## [Alarm on Query Tag Not Working](https://forum.inductiveautomation.com/t/alarm-on-query-tag-not-working/94234)
**Author:** [@Pico\_Sankari](https://forum.inductiveautomation.com/u/Pico_Sankari)\ **Replies:** 3\ **Last updated:** [May 6, 2025, 4:26pm UTC](https://forum.inductiveautomation.com/t/alarm-on-query-tag-not-working/94234 "2025-05-06T16:26:20Z")
I have alarms set on query tags that are not going off when they should. The query tags run a basic query that returns the number of entries in a table in the last XX minutes. These queries work and will return different… --- ## [ValueChanged string format breaks](https://forum.inductiveautomation.com/t/valuechanged-string-format-breaks/105903)
**Author:** [@Rick\_de\_Man](https://forum.inductiveautomation.com/u/Rick_de_Man)\ **Replies:** 10\ **Last updated:** [May 6, 2025, 3:45pm UTC](https://forum.inductiveautomation.com/t/valuechanged-string-format-breaks/105903 "2025-05-06T15:45:06Z")
I Have a ValueChanged script on a tag and when string format function is within the code it completely breaks and fails to execute, not even the Gateway logs show any errors. The following line wil make the ValueChange … [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=199) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=201)