# Latest

**URL:** https://forum.inductiveautomation.com/latest.md?page=340

[Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md)

**Page:** 341

---

## [SQL tag stops execution rate](https://forum.inductiveautomation.com/t/sql-tag-stops-execution-rate/99428)

<div class="topic-metadata">

**Author:** [@rfolkes](https://forum.inductiveautomation.com/u/rfolkes)\
**Replies:** 1\
**Last updated:** [December 4, 2024, 3:57pm UTC](https://forum.inductiveautomation.com/t/sql-tag-stops-execution-rate/99428 "2024-12-04T15:57:51Z")

</div>

I have some SQL tags that appear to stop updating. execution rate is set to 1 min. There are times that I find it not updating at all. If I go into the tag and turn on the "green dot for UDT change" hit apply then tur…

---

## [Line Spacing](https://forum.inductiveautomation.com/t/line-spacing/9421)

<div class="topic-metadata">

**Author:** [@zacslade](https://forum.inductiveautomation.com/u/zacslade)\
**Replies:** 10\
**Last updated:** [December 4, 2024, 3:51pm UTC](https://forum.inductiveautomation.com/t/line-spacing/9421 "2024-12-04T15:51:17Z")

</div>

Hi there, I'm working on a project in Ignition Designer, and it would save me some time if I were able to adjust the line spacing for my text. I'm running Windows 7 with the latest Java. My ignition version informatio…

---

## [Docker - Offline Licence Activation on Standard Edition](https://forum.inductiveautomation.com/t/docker-offline-licence-activation-on-standard-edition/99412)

<div class="topic-metadata">

**Author:** [@Sulivann\_BROUTIN](https://forum.inductiveautomation.com/u/Sulivann_BROUTIN)\
**Replies:** 4\
**Last updated:** [December 4, 2024, 3:46pm UTC](https://forum.inductiveautomation.com/t/docker-offline-licence-activation-on-standard-edition/99412 "2024-12-04T15:46:08Z")

</div>

Hello, I would like to activate a license for a Strandard Edition after a command line installation. The server is offline. I've a 8 characters license to be used with the IGNITION\_LICENSE\_KEY keyword. As the server i…

---

## [MQTT via Network Gateway](https://forum.inductiveautomation.com/t/mqtt-via-network-gateway/99424)

<div class="topic-metadata">

**Author:** [@Zachary\_Sobie](https://forum.inductiveautomation.com/u/Zachary_Sobie)\
**Replies:** 1\
**Last updated:** [December 4, 2024, 3:30pm UTC](https://forum.inductiveautomation.com/t/mqtt-via-network-gateway/99424 "2024-12-04T15:30:21Z")

</div>

I have an IFM AL1326 IO-Link Master Module that I would like to connect directly to Ignition. We use an Allen-Bradley 1783-NATR as a Network Gateway. Can anyone tell me if this is possible? I would also like to keep t…

---

## [Using update, Insert and select query in a single named query on same database](https://forum.inductiveautomation.com/t/using-update-insert-and-select-query-in-a-single-named-query-on-same-database/99402)

<div class="topic-metadata">

**Author:** [@Amitkumar\_Ravat1](https://forum.inductiveautomation.com/u/Amitkumar_Ravat1)\
**Replies:** 7\
**Last updated:** [December 4, 2024, 2:46pm UTC](https://forum.inductiveautomation.com/t/using-update-insert-and-select-query-in-a-single-named-query-on-same-database/99402 "2024-12-04T14:46:32Z")

</div>

Can I use update, Insert and select query in a single named query on same database with query type as Query not Update type ? Insert into dbo.TableToUpdate(field1, field2) values (value1, value2) UPDATE dbo.TableToUpda…

---

## [Export only filtered data](https://forum.inductiveautomation.com/t/export-only-filtered-data/99419)

<div class="topic-metadata">

**Author:** [@JMarc](https://forum.inductiveautomation.com/u/JMarc)\
**Replies:** 2\
**Last updated:** [December 4, 2024, 1:42pm UTC](https://forum.inductiveautomation.com/t/export-only-filtered-data/99419 "2024-12-04T13:42:23Z")

</div>

I am working in perspective 8.1.13 and I would like to only export data filtered in my table component. Below is the script I am using on my button but it exports everything in my table.

---

## [java.lang.Exception](https://forum.inductiveautomation.com/t/java-lang-exception/99414)

<div class="topic-metadata">

**Author:** [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\
**Replies:** 3\
**Last updated:** [December 4, 2024, 12:29pm UTC](https://forum.inductiveautomation.com/t/java-lang-exception/99414 "2024-12-04T12:29:06Z")

</div>

I am getting this error while using perspective with my project. Aniway to fix it? Should I got back to previous version? Thanks

---

## [Send Historical Data from Ignition API Server to an API-Client upon Get Request](https://forum.inductiveautomation.com/t/send-historical-data-from-ignition-api-server-to-an-api-client-upon-get-request/99400)

<div class="topic-metadata">

**Author:** [@Filippos\_Onisiforou](https://forum.inductiveautomation.com/u/Filippos_Onisiforou)\
**Replies:** 3\
**Last updated:** [December 4, 2024, 11:17am UTC](https://forum.inductiveautomation.com/t/send-historical-data-from-ignition-api-server-to-an-api-client-upon-get-request/99400 "2024-12-04T11:17:34Z")

</div>

Dear All , We want to examine the below if this is possible to be done with Ignition as API Server So the main objective is to send Historical Data from our SQL database to a User . The User Will Request Data from Pl…

---

## [Connecting to QuestDB](https://forum.inductiveautomation.com/t/connecting-to-questdb/73199)

<div class="topic-metadata">

**Author:** [@coffeyr](https://forum.inductiveautomation.com/u/coffeyr)\
**Replies:** 7\
**Last updated:** [December 4, 2024, 10:12am UTC](https://forum.inductiveautomation.com/t/connecting-to-questdb/73199 "2024-12-04T10:12:39Z")

</div>

We are looking to connect to a QuestDB instance that is set up on the same server as our gateway. Has anyone done this before that could offer any pointers?

---

## [Changing tank color on the fly](https://forum.inductiveautomation.com/t/changing-tank-color-on-the-fly/99377)

<div class="topic-metadata">

**Author:** [@Alfie\_Inman](https://forum.inductiveautomation.com/u/Alfie_Inman)\
**Replies:** 8\
**Last updated:** [December 4, 2024, 9:11am UTC](https://forum.inductiveautomation.com/t/changing-tank-color-on-the-fly/99377 "2024-12-04T09:11:58Z")

</div>

Hello there, I'm very new to Ignition and have run into a problem. I'm trying to change the color of a cylindrical tank depending on an input (rgb values). I've bound the property to an expression that correctly updates …

---

## [Rectangle Component gradient Shadow](https://forum.inductiveautomation.com/t/rectangle-component-gradient-shadow/74108)

<div class="topic-metadata">

**Author:** [@Dan\_Kevin\_Dagapioso](https://forum.inductiveautomation.com/u/Dan_Kevin_Dagapioso)\
**Replies:** 12\
**Last updated:** [December 4, 2024, 9:08am UTC](https://forum.inductiveautomation.com/t/rectangle-component-gradient-shadow/74108 "2024-12-04T09:08:55Z")

</div>

Can I make the rectangle component like this?

---

## [MQTT Engine Conneciton](https://forum.inductiveautomation.com/t/mqtt-engine-conneciton/99404)

<div class="topic-metadata">

**Author:** [@Batuhan\_Parlakay](https://forum.inductiveautomation.com/u/Batuhan_Parlakay)\
**Replies:** 2\
**Last updated:** [December 4, 2024, 9:02am UTC](https://forum.inductiveautomation.com/t/mqtt-engine-conneciton/99404 "2024-12-04T09:02:57Z")

</div>

Hello, I am trying to use the MQTT Engine module in Ignition. My Ignition version is 8.1.41, and the Engine module version is 4.0.21. I am attempting this locally. I have a local Mosquitto broker, which is working witho…

---

## [Writing to Database from a Tag Value Change Script](https://forum.inductiveautomation.com/t/writing-to-database-from-a-tag-value-change-script/99389)

<div class="topic-metadata">

**Author:** [@Christopher\_Cooper1](https://forum.inductiveautomation.com/u/Christopher_Cooper1)\
**Replies:** 7\
**Last updated:** [December 4, 2024, 8:53am UTC](https://forum.inductiveautomation.com/t/writing-to-database-from-a-tag-value-change-script/99389 "2024-12-04T08:53:15Z")

</div>

I am trying to add rows to the database every time a tag changes state. Specifically, every time a Boolean tag becomes true, I want to take the name of that tag and add it into a new row in the database table. I have tr…

---

## [Hide Perspective Equipment Schedule Label](https://forum.inductiveautomation.com/t/hide-perspective-equipment-schedule-label/99356)

<div class="topic-metadata">

**Author:** [@richard\_hamilton](https://forum.inductiveautomation.com/u/richard_hamilton)\
**Replies:** 4\
**Last updated:** [December 4, 2024, 8:14am UTC](https://forum.inductiveautomation.com/t/hide-perspective-equipment-schedule-label/99356 "2024-12-04T08:14:28Z")

</div>

Hi folks, I was wondering if someone could help me with the perspective equipment schedule. When I click on a scheduled event, a label showing the start date appears on the left hand side. Is it possible to hide th…

---

## [\[IGN-6093\]Perspective Component, ScriptCallable Method Hints](https://forum.inductiveautomation.com/t/ign-6093-perspective-component-scriptcallable-method-hints/99399)

<div class="topic-metadata">

**Author:** [@bmusson](https://forum.inductiveautomation.com/u/bmusson)\
**Replies:** 1\
**Last updated:** [December 4, 2024, 7:02am UTC](https://forum.inductiveautomation.com/t/ign-6093-perspective-component-scriptcallable-method-hints/99399 "2024-12-04T07:02:21Z")

</div>

Hey, On my ComponentModelDelegate I have methods annotated with ScriptCallable. I can call these methods, no problem. But what do I need to do to get hints for those methods here?

---

## [Filters on Perspective table](https://forum.inductiveautomation.com/t/filters-on-perspective-table/99381)

<div class="topic-metadata">

**Author:** [@JMarc](https://forum.inductiveautomation.com/u/JMarc)\
**Replies:** 8\
**Last updated:** [December 3, 2024, 10:55pm UTC](https://forum.inductiveautomation.com/t/filters-on-perspective-table/99381 "2024-12-03T22:55:31Z")

</div>

Is there a way to add multiple filters to an ignition perspective table?

---

## [Issue Reading Modbus Registers with Float conversion](https://forum.inductiveautomation.com/t/issue-reading-modbus-registers-with-float-conversion/99350)

<div class="topic-metadata">

**Author:** [@Sameer\_Ambegaonkar](https://forum.inductiveautomation.com/u/Sameer_Ambegaonkar)\
**Replies:** 3\
**Last updated:** [December 3, 2024, 10:25pm UTC](https://forum.inductiveautomation.com/t/issue-reading-modbus-registers-with-float-conversion/99350 "2024-12-03T22:25:27Z")

</div>

Trying to read float energy values from power meter through modbus in Ignition OPC tags. Values on the meter don't match with values in Ignition. They are however close. Modbus registers: As in vendor manual Ignition…

---

## [How to find which Tags are using a certain DB connection/Historian?](https://forum.inductiveautomation.com/t/how-to-find-which-tags-are-using-a-certain-db-connection-historian/99385)

<div class="topic-metadata">

**Author:** [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\
**Replies:** 2\
**Last updated:** [December 3, 2024, 9:54pm UTC](https://forum.inductiveautomation.com/t/how-to-find-which-tags-are-using-a-certain-db-connection-historian/99385 "2024-12-03T21:54:35Z")

</div>

I am in the process of migrating from MySQL to MSSQL, and I used the Tag Report Tool to track down which MySQL schemas were active for the Historical data... Apparently, I missed at least one tag, so when I removed the …

---

## [Derived tags from remote tag provider not updating quality](https://forum.inductiveautomation.com/t/derived-tags-from-remote-tag-provider-not-updating-quality/97836)

<div class="topic-metadata">

**Author:** [@Kelltek](https://forum.inductiveautomation.com/u/Kelltek)\
**Replies:** 3\
**Last updated:** [December 3, 2024, 8:34pm UTC](https://forum.inductiveautomation.com/t/derived-tags-from-remote-tag-provider-not-updating-quality/97836 "2024-12-03T20:34:08Z")

</div>

I have a tag issue that is repeatable and manifests after a gateway restart. Our front end has some derived/ reference tags whos source is on a remote gateway tag provider. After a restart of the front end gateway - UDT…

---

## [Gateway Network Remnants](https://forum.inductiveautomation.com/t/gateway-network-remnants/99379)

<div class="topic-metadata">

**Author:** [@mcgheeiv](https://forum.inductiveautomation.com/u/mcgheeiv)\
**Replies:** 0\
**Last updated:** [December 3, 2024, 7:06pm UTC](https://forum.inductiveautomation.com/t/gateway-network-remnants/99379 "2024-12-03T19:06:26Z")

</div>

The six gateway networks in the image with errors do not exist. Is there anyway to remove the items from this status page? Some background follows below. There used to be a gateway network between NARS-TOW-IGN1 (8.1…

---

## [Ignition core certificate test](https://forum.inductiveautomation.com/t/ignition-core-certificate-test/99373)

<div class="topic-metadata">

**Author:** [@Ahmed\_badawi1](https://forum.inductiveautomation.com/u/Ahmed_badawi1)\
**Replies:** 3\
**Last updated:** [December 3, 2024, 6:35pm UTC](https://forum.inductiveautomation.com/t/ignition-core-certificate-test/99373 "2024-12-03T18:35:16Z")

</div>

About ignition core certificate test, i have read that the test consists of 9 sections about different topics of ignition with minimum required grade 75% for each section , my question is if i failed at any section, do i…

---

## [Dropdown menu that dictates next drop down](https://forum.inductiveautomation.com/t/dropdown-menu-that-dictates-next-drop-down/99340)

<div class="topic-metadata">

**Author:** [@karmspabs](https://forum.inductiveautomation.com/u/karmspabs)\
**Replies:** 6\
**Last updated:** [December 3, 2024, 6:06pm UTC](https://forum.inductiveautomation.com/t/dropdown-menu-that-dictates-next-drop-down/99340 "2024-12-03T18:06:34Z")

</div>

I'm trying to give my operators a better option to review reports, as currently they just have a single drop down and have to scroll through Serial Numbers to find exactly what they're looking for. I have 4 banks of mach…

---

## [Not seeing tag change in audit log](https://forum.inductiveautomation.com/t/not-seeing-tag-change-in-audit-log/47977)

<div class="topic-metadata">

**Author:** [@andrews](https://forum.inductiveautomation.com/u/andrews)\
**Replies:** 6\
**Last updated:** [December 3, 2024, 6:02pm UTC](https://forum.inductiveautomation.com/t/not-seeing-tag-change-in-audit-log/47977 "2024-12-03T18:02:27Z")

</div>

Hello, we are trying to use the audit system to see what users do, thus catch who did what. I thought the audit log was suppose to log all tag changes. But it seems when they use a HOA it does not record the tag being c…

---

## [SSL certificate expiration notification](https://forum.inductiveautomation.com/t/ssl-certificate-expiration-notification/99367)

<div class="topic-metadata">

**Author:** [@Ajay\_Gupta](https://forum.inductiveautomation.com/u/Ajay_Gupta)\
**Replies:** 5\
**Last updated:** [December 3, 2024, 5:55pm UTC](https://forum.inductiveautomation.com/t/ssl-certificate-expiration-notification/99367 "2024-12-03T17:55:10Z")

</div>

Hi, Does Ignition have in-built feature to send notification email when the gateway SSL certificate is about to expire? Thanks, Ajay

---

## [Right-click a table component and select the row first](https://forum.inductiveautomation.com/t/right-click-a-table-component-and-select-the-row-first/12322)

<div class="topic-metadata">

**Author:** [@DougSN](https://forum.inductiveautomation.com/u/DougSN)\
**Replies:** 6\
**Last updated:** [December 3, 2024, 5:54pm UTC](https://forum.inductiveautomation.com/t/right-click-a-table-component-and-select-the-row-first/12322 "2024-12-03T17:54:35Z")

</div>

I have a table component with a popup menu on right click (using the mouseReleased event). When I right click on the table, it does not select the row that I am clicking, it just shows the popup menu. So if I have a diff…

---

## [Error 'edt-watchdog-1 non responsive ui thread detected' when opening image](https://forum.inductiveautomation.com/t/error-edt-watchdog-1-non-responsive-ui-thread-detected-when-opening-image/99198)

<div class="topic-metadata">

**Author:** [@ictabak](https://forum.inductiveautomation.com/u/ictabak)\
**Replies:** 6\
**Last updated:** [December 3, 2024, 5:07pm UTC](https://forum.inductiveautomation.com/t/error-edt-watchdog-1-non-responsive-ui-thread-detected-when-opening-image/99198 "2024-12-03T17:07:33Z")

</div>

This error pops up when opening a specific image and the Designer becomes unresponsive. Opening the exact same image for another machine works fine. I have tried to check with Kindling, but am not very familiar with th…

---

## [Ignition Perspective user monitor](https://forum.inductiveautomation.com/t/ignition-perspective-user-monitor/99370)

<div class="topic-metadata">

**Author:** [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\
**Replies:** 3\
**Last updated:** [December 3, 2024, 5:02pm UTC](https://forum.inductiveautomation.com/t/ignition-perspective-user-monitor/99370 "2024-12-03T17:02:46Z")

</div>

Hello! Does perspective an starnadard way to monitor user behaviur through the aplication like: Username IP Address Timestamp Accessed Window Cheers!

---

## [Seeking Ideas for Uptime/Downtime Management Tool for Biogas Facilities](https://forum.inductiveautomation.com/t/seeking-ideas-for-uptime-downtime-management-tool-for-biogas-facilities/99360)

<div class="topic-metadata">

**Author:** [@Coleman\_Jones](https://forum.inductiveautomation.com/u/Coleman_Jones)\
**Replies:** 3\
**Last updated:** [December 3, 2024, 4:23pm UTC](https://forum.inductiveautomation.com/t/seeking-ideas-for-uptime-downtime-management-tool-for-biogas-facilities/99360 "2024-12-03T16:23:19Z")

</div>

Hi everyone, I'm currently developing an uptime and downtime monitoring tool for operators at our biogas facility using Ignition and Canary Labs. The goal is to provide an intuitive interface that empowers operators to …

---

## [Message handler behavior](https://forum.inductiveautomation.com/t/message-handler-behavior/99226)

<div class="topic-metadata">

**Author:** [@Leigh.shannan](https://forum.inductiveautomation.com/u/Leigh.shannan)\
**Replies:** 4\
**Last updated:** [December 3, 2024, 4:31pm UTC](https://forum.inductiveautomation.com/t/message-handler-behavior/99226 "2024-12-03T16:31:17Z")

</div>

Hi, I've been pulling my hair out with this one for a while. I'm probably missing something really simple. I have a view in perspective, which contains a table. The table is populated with data from several different s…

---

## [TimeSeries Bar chart color assigning to 3rd columns is not showing](https://forum.inductiveautomation.com/t/timeseries-bar-chart-color-assigning-to-3rd-columns-is-not-showing/99368)

<div class="topic-metadata">

**Author:** [@srinivasan\_s](https://forum.inductiveautomation.com/u/srinivasan_s)\
**Replies:** 0\
**Last updated:** [December 3, 2024, 4:22pm UTC](https://forum.inductiveautomation.com/t/timeseries-bar-chart-color-assigning-to-3rd-columns-is-not-showing/99368 "2024-12-03T16:22:28Z")

</div>

I am using timeseries Chart. I am not able to see the third column color in stack ony in bar but able to see in line and all other ones. Below are image. Kindly help on this.

[Previous page](https://forum.inductiveautomation.com/latest.md?page=339)

[Next page](https://forum.inductiveautomation.com/latest.md?page=341)
