# Latest

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

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

**Page:** 477

---

## [Huge data in sqlth\_sce, Stale Data Detection how to prune records after turn of Stale Data Detection](https://forum.inductiveautomation.com/t/huge-data-in-sqlth-sce-stale-data-detection-how-to-prune-records-after-turn-of-stale-data-detection/90721)

<div class="topic-metadata">

**Author:** [@Lina\_Su](https://forum.inductiveautomation.com/u/Lina_Su)\
**Replies:** 6\
**Last updated:** [May 27, 2024, 12:54am UTC](https://forum.inductiveautomation.com/t/huge-data-in-sqlth-sce-stale-data-detection-how-to-prune-records-after-turn-of-stale-data-detection/90721 "2024-05-27T00:54:54Z")

</div>

Does anyone know what is purpose for this table sqlth\_sce. There are over 90,000 records in my table. And for some scid, it's over 40,000 lines. When I check my database log, it keep updating this table and give perfo…

---

## [Adding default onClick script to perspective component](https://forum.inductiveautomation.com/t/adding-default-onclick-script-to-perspective-component/90925)

<div class="topic-metadata">

**Author:** [@Phillip\_Wu](https://forum.inductiveautomation.com/u/Phillip_Wu)\
**Replies:** 1\
**Last updated:** [May 26, 2024, 11:51pm UTC](https://forum.inductiveautomation.com/t/adding-default-onclick-script-to-perspective-component/90925 "2024-05-26T23:51:45Z")

</div>

Hi! I am making some buttons as perspective components and need them to by default call a project library function when clicked. I want to do this by adding a default onClick() script to it's Mouse onClick event, such t…

---

## [Z-index not populating to html](https://forum.inductiveautomation.com/t/z-index-not-populating-to-html/90915)

<div class="topic-metadata">

**Author:** [@PFollansbee](https://forum.inductiveautomation.com/u/PFollansbee)\
**Replies:** 9\
**Last updated:** [May 26, 2024, 11:02pm UTC](https://forum.inductiveautomation.com/t/z-index-not-populating-to-html/90915 "2024-05-26T23:02:11Z")

</div>

Trying to work with z-index to have different parts overlap. Not sure if I am doing something wrong, but if I set an object to have a non-zero z-index, it doesn't come through to the source. Setting to zero seems fine. …

---

## [Perspective table cell color](https://forum.inductiveautomation.com/t/perspective-table-cell-color/50047)

<div class="topic-metadata">

**Author:** [@eichler-eng](https://forum.inductiveautomation.com/u/eichler-eng)\
**Replies:** 13\
**Last updated:** [May 26, 2024, 12:14pm UTC](https://forum.inductiveautomation.com/t/perspective-table-cell-color/50047 "2024-05-26T12:14:37Z")

</div>

Hi All Using this link below I have been able to set the color of individual rows in a Perspective table based on the value of a cell. I would like to set the colors of individual cells. I can see that the script below …

---

## [OPC Item Path takes decimal point on its own](https://forum.inductiveautomation.com/t/opc-item-path-takes-decimal-point-on-its-own/90437)

<div class="topic-metadata">

**Author:** [@Anamay\_Belekar](https://forum.inductiveautomation.com/u/Anamay_Belekar)\
**Replies:** 7\
**Last updated:** [May 25, 2024, 11:29pm UTC](https://forum.inductiveautomation.com/t/opc-item-path-takes-decimal-point-on-its-own/90437 "2024-05-25T23:29:45Z")

</div>

Hi.. I have created one UDT and an OPC tag in it. I have used tag parameters for OPC Item Path where {Rack} and {IsSW} are the UDT parameters. But when I create an instance, it is adding decimal point on its own ( .0…

---

## [Ignition can't connect to ModBus RTU device](https://forum.inductiveautomation.com/t/ignition-cant-connect-to-modbus-rtu-device/90823)

<div class="topic-metadata">

**Author:** [@SMarcin](https://forum.inductiveautomation.com/u/SMarcin)\
**Replies:** 6\
**Last updated:** [May 25, 2024, 7:55pm UTC](https://forum.inductiveautomation.com/t/ignition-cant-connect-to-modbus-rtu-device/90823 "2024-05-25T19:55:18Z")

</div>

Hello, I have setup a ModbusRTU connection via RS232 which is valid since i am able to read the values from the device using qModMaster, but Ignition doesnt connect to it - status changes from Disconnected to Connecting…

---

## [Help Desk Style Vision Window](https://forum.inductiveautomation.com/t/help-desk-style-vision-window/90904)

<div class="topic-metadata">

**Author:** [@Varsha\_Gottipati1](https://forum.inductiveautomation.com/u/Varsha_Gottipati1)\
**Replies:** 4\
**Last updated:** [May 25, 2024, 5:22pm UTC](https://forum.inductiveautomation.com/t/help-desk-style-vision-window/90904 "2024-05-25T17:22:06Z")

</div>

Any idea how to create a "Help Desk" Style window in vision? I would like to create a window for operators in Production floor to be able to input any issues they encounter and address them to the appropriate department. …

---

## [Snowflake Query Issue](https://forum.inductiveautomation.com/t/snowflake-query-issue/90719)

<div class="topic-metadata">

**Author:** [@Collin\_Hodges](https://forum.inductiveautomation.com/u/Collin_Hodges)\
**Replies:** 2\
**Last updated:** [May 25, 2024, 12:57pm UTC](https://forum.inductiveautomation.com/t/snowflake-query-issue/90719 "2024-05-25T12:57:16Z")

</div>

I setup a JDBC Drive, a custom translator and a database connection to snowflake according to the insrtuctions. https://support.inductiveautomation.com/hc/en-us/articles/4408715117197-Creating-database-connections-with-c…

---

## [Implementing Auto Scroll for Flex Repeater](https://forum.inductiveautomation.com/t/implementing-auto-scroll-for-flex-repeater/73572)

<div class="topic-metadata">

**Author:** [@mdia](https://forum.inductiveautomation.com/u/mdia)\
**Replies:** 4\
**Last updated:** [May 25, 2024, 10:09am UTC](https://forum.inductiveautomation.com/t/implementing-auto-scroll-for-flex-repeater/73572 "2024-05-25T10:09:24Z")

</div>

I'm working on a project where I have a view with a flex repeater that could potentially create up to 20 instances or maybe more. All these instances won't fit on a single screen due to space constraints, which leads to …

---

## [Easy Chart Dates via Button](https://forum.inductiveautomation.com/t/easy-chart-dates-via-button/90907)

<div class="topic-metadata">

**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\
**Replies:** 1\
**Last updated:** [May 24, 2024, 9:50pm UTC](https://forum.inductiveautomation.com/t/easy-chart-dates-via-button/90907 "2024-05-24T21:50:40Z")

</div>

I don't know why this isn't working. I want a button to automatically set the historical chart to the last X hours (X) being a custom property on the button, bound to a dropdown's selected value. now = system.date.now()…

---

## [How to add data from a query to my report](https://forum.inductiveautomation.com/t/how-to-add-data-from-a-query-to-my-report/90882)

<div class="topic-metadata">

**Author:** [@Esme\_Lopez](https://forum.inductiveautomation.com/u/Esme_Lopez)\
**Replies:** 2\
**Last updated:** [May 24, 2024, 9:13pm UTC](https://forum.inductiveautomation.com/t/how-to-add-data-from-a-query-to-my-report/90882 "2024-05-24T21:13:33Z")

</div>

Hello everyone I have a query in the section data sources of a report Do you know how can I add every column of the query to a table in the page of the report?

---

## [Help with History binding to query tag](https://forum.inductiveautomation.com/t/help-with-history-binding-to-query-tag/90895)

<div class="topic-metadata">

**Author:** [@Michael\_Smith](https://forum.inductiveautomation.com/u/Michael_Smith)\
**Replies:** 13\
**Last updated:** [May 24, 2024, 8:48pm UTC](https://forum.inductiveautomation.com/t/help-with-history-binding-to-query-tag/90895 "2024-05-24T20:48:36Z")

</div>

Hi there I have a query tag setup with history enabled. I was then going to bind the data of a table to a tag history binding using the query tag history. Problem is I can only get it to return 4 rows, and the value r…

---

## [Serial port com open failed](https://forum.inductiveautomation.com/t/serial-port-com-open-failed/90903)

<div class="topic-metadata">

**Author:** [@Cedric\_BIGOT](https://forum.inductiveautomation.com/u/Cedric_BIGOT)\
**Replies:** 1\
**Last updated:** [May 24, 2024, 8:26pm UTC](https://forum.inductiveautomation.com/t/serial-port-com-open-failed/90903 "2024-05-24T20:26:36Z")

</div>

Hi, I try to make screen for read UID number of and mifare card. I put USB card-reader on my computer (the gateway is on a server) look for my port number (COM6) and try my code in the designer script console. port\_co…

---

## [\[BUG-9926\] Ignition Voice Notification Module: Address already in use](https://forum.inductiveautomation.com/t/bug-9926-ignition-voice-notification-module-address-already-in-use/90792)

<div class="topic-metadata">

**Author:** [@diamond](https://forum.inductiveautomation.com/u/diamond)\
**Replies:** 7\
**Last updated:** [May 24, 2024, 8:02pm UTC](https://forum.inductiveautomation.com/t/bug-9926-ignition-voice-notification-module-address-already-in-use/90792 "2024-05-24T20:02:16Z")

</div>

Hello, I have a clean Ignition 8.1.40 install in a brand new Windows Server virtual machine. In another server, I have an Ignition 8.1.31 instance under docker. In the docker instance, I can perform VOIP calls with AWS…

---

## [Downloading Ignition](https://forum.inductiveautomation.com/t/downloading-ignition/33298)

<div class="topic-metadata">

**Author:** [@bebel](https://forum.inductiveautomation.com/u/bebel)\
**Replies:** 9\
**Last updated:** [May 24, 2024, 7:10pm UTC](https://forum.inductiveautomation.com/t/downloading-ignition/33298 "2024-05-24T19:10:33Z")

</div>

I understand that you want to collect data for people that are downloading Ignition to test it out but if I am signed into my account when I click the download button, why do I still need to fill out all the information …

---

## [8.1.40 Pulled, 8.1.41 Emergency Release](https://forum.inductiveautomation.com/t/8-1-40-pulled-8-1-41-emergency-release/90901)

<div class="topic-metadata">

**Author:** [@sreis](https://forum.inductiveautomation.com/u/sreis)\
**Replies:** 0\
**Last updated:** [May 24, 2024, 7:06pm UTC](https://forum.inductiveautomation.com/t/8-1-40-pulled-8-1-41-emergency-release/90901 "2024-05-24T19:06:16Z")

</div>

Ignition 8.1.40 has been removed from our website and will be replaced with 8.1.41 as soon as possible. Upgrades or new installations are experiencing an error with their VOIP Voice Notification profiles upon gateway res…

---

## [Username Tag to Hold Current Session User](https://forum.inductiveautomation.com/t/username-tag-to-hold-current-session-user/90892)

<div class="topic-metadata">

**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Replies:** 4\
**Last updated:** [May 24, 2024, 6:49pm UTC](https://forum.inductiveautomation.com/t/username-tag-to-hold-current-session-user/90892 "2024-05-24T18:49:05Z")

</div>

What is the best strategy to document the current user of a perspective session in a tag? I will use the tag in a transaction group. I've experimented with a runScript() expression inside the UDT with this \[ x\['userna…

---

## [Audit Events not logging when using system.tag.write?](https://forum.inductiveautomation.com/t/audit-events-not-logging-when-using-system-tag-write/90845)

<div class="topic-metadata">

**Author:** [@taohongyu88](https://forum.inductiveautomation.com/u/taohongyu88)\
**Replies:** 5\
**Last updated:** [May 24, 2024, 6:29pm UTC](https://forum.inductiveautomation.com/t/audit-events-not-logging-when-using-system-tag-write/90845 "2024-05-24T18:29:29Z")

</div>

I have two types of binding and control a valve. One : Direct bind Tag Audit Events can log the tag write . Two: Click Script write Tag Audit Events can't log the tag write . How to resolve the Two questi…

---

## [Tag value changed script "currentValue" always true when used in if statement?](https://forum.inductiveautomation.com/t/tag-value-changed-script-currentvalue-always-true-when-used-in-if-statement/90898)

<div class="topic-metadata">

**Author:** [@Joshua\_Graham](https://forum.inductiveautomation.com/u/Joshua_Graham)\
**Replies:** 3\
**Last updated:** [May 24, 2024, 6:26pm UTC](https://forum.inductiveautomation.com/t/tag-value-changed-script-currentvalue-always-true-when-used-in-if-statement/90898 "2024-05-24T18:26:02Z")

</div>

I've had to use the "System.tag.read" to get the value of the tag within the "Value Changed" script because "currentValue" is inconsistent. When I use it with an if statement it always thinks it's true, when I use it wit…

---

## [Cannot Convert String to Java INT](https://forum.inductiveautomation.com/t/cannot-convert-string-to-java-int/90880)

<div class="topic-metadata">

**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\
**Replies:** 9\
**Last updated:** [May 24, 2024, 6:04pm UTC](https://forum.inductiveautomation.com/t/cannot-convert-string-to-java-int/90880 "2024-05-24T18:04:27Z")

</div>

I have this script that creates a dataset. Runs fine in the script console with the same path provided, but I get an type conversion error when using runScript() on an expression dataset tag. def getDistributorDropdownD…

---

## [Styling table rows with embedded view columns](https://forum.inductiveautomation.com/t/styling-table-rows-with-embedded-view-columns/90819)

<div class="topic-metadata">

**Author:** [@Ty\_Mittleider](https://forum.inductiveautomation.com/u/Ty_Mittleider)\
**Replies:** 5\
**Last updated:** [May 24, 2024, 5:52pm UTC](https://forum.inductiveautomation.com/t/styling-table-rows-with-embedded-view-columns/90819 "2024-05-24T17:52:11Z")

</div>

I have been trying to style a table component to change the color of rows that have a certain column value. This I can do fairly easily, but it breaks the embedded view that I have set on one of the columns. I believe th…

---

## [Inserting PLC values into a table with a Gateway Event Tag Change Script](https://forum.inductiveautomation.com/t/inserting-plc-values-into-a-table-with-a-gateway-event-tag-change-script/90235)

<div class="topic-metadata">

**Author:** [@Luke\_Smith1](https://forum.inductiveautomation.com/u/Luke_Smith1)\
**Replies:** 12\
**Last updated:** [May 24, 2024, 5:44pm UTC](https://forum.inductiveautomation.com/t/inserting-plc-values-into-a-table-with-a-gateway-event-tag-change-script/90235 "2024-05-24T17:44:18Z")

</div>

Hi all, I have created a Named Query that inserts two parameters (values) into a table. I would like to have a Gateway Tag Change Script that runs the Named Query when a PLC tag changes and provides the PLC values to th…

---

## [Adding a transform to Table Data being written from a property change script](https://forum.inductiveautomation.com/t/adding-a-transform-to-table-data-being-written-from-a-property-change-script/90889)

<div class="topic-metadata">

**Author:** [@Luke\_Smith1](https://forum.inductiveautomation.com/u/Luke_Smith1)\
**Replies:** 8\
**Last updated:** [May 24, 2024, 5:32pm UTC](https://forum.inductiveautomation.com/t/adding-a-transform-to-table-data-being-written-from-a-property-change-script/90889 "2024-05-24T17:32:55Z")

</div>

Hello everyone! I am using a property change script to write data to a table. I then need to add a transform to modify the colors of the rows of the table depending on the value inside of them. When Trigger becomes True…

---

## [Convert Object Reference in Perspective Parameter to Actual Object](https://forum.inductiveautomation.com/t/convert-object-reference-in-perspective-parameter-to-actual-object/90766)

<div class="topic-metadata">

**Author:** [@rbachman](https://forum.inductiveautomation.com/u/rbachman)\
**Replies:** 12\
**Last updated:** [May 24, 2024, 5:21pm UTC](https://forum.inductiveautomation.com/t/convert-object-reference-in-perspective-parameter-to-actual-object/90766 "2024-05-24T17:21:19Z")

</div>

We're trying to upload a picture using the File Upload component and store it on a parameter in the view for later use to store to a database. The problem we're running into is that it appears that the Perspective parame…

---

## [Time Series Chart X Trace not lining up with gridline time label](https://forum.inductiveautomation.com/t/time-series-chart-x-trace-not-lining-up-with-gridline-time-label/90887)

<div class="topic-metadata">

**Author:** [@mbak](https://forum.inductiveautomation.com/u/mbak)\
**Replies:** 1\
**Last updated:** [May 24, 2024, 4:57pm UTC](https://forum.inductiveautomation.com/t/time-series-chart-x-trace-not-lining-up-with-gridline-time-label/90887 "2024-05-24T16:57:47Z")

</div>

We've got a time series chart where the X trace time is not lining up with the X trace's hovered data timestamp. The amount that it is off varies as the span of the dataset changes. Sometimes it is right on. This part…

---

## [Number of array items](https://forum.inductiveautomation.com/t/number-of-array-items/90881)

<div class="topic-metadata">

**Author:** [@ColeS](https://forum.inductiveautomation.com/u/ColeS)\
**Replies:** 8\
**Last updated:** [May 24, 2024, 4:34pm UTC](https://forum.inductiveautomation.com/t/number-of-array-items/90881 "2024-05-24T16:34:16Z")

</div>

What is the function/script to get the number of array items from an array?

---

## [Tag Browse Tree - filterTag - stop to a certain list condition](https://forum.inductiveautomation.com/t/tag-browse-tree-filtertag-stop-to-a-certain-list-condition/80477)

<div class="topic-metadata">

**Author:** [@gpellicelli](https://forum.inductiveautomation.com/u/gpellicelli)\
**Replies:** 4\
**Last updated:** [May 24, 2024, 4:01pm UTC](https://forum.inductiveautomation.com/t/tag-browse-tree-filtertag-stop-to-a-certain-list-condition/80477 "2024-05-24T16:01:34Z")

</div>

Hello am looking a way to filter my tagBrowse tree to remove certain folder and stop to a certain level when it find the typeId that I want. I would like to remove some FOlder with a list of it and same for the typeId. I…

---

## [Perspective Power Chart Busy indicator](https://forum.inductiveautomation.com/t/perspective-power-chart-busy-indicator/90879)

<div class="topic-metadata">

**Author:** [@pengelman](https://forum.inductiveautomation.com/u/pengelman)\
**Replies:** 0\
**Last updated:** [May 24, 2024, 3:15pm UTC](https://forum.inductiveautomation.com/t/perspective-power-chart-busy-indicator/90879 "2024-05-24T15:15:13Z")

</div>

On the Power chart in Vision there is a busy indicator when it is loading historical data. Is there a way to indicate this in Perspective? The reason I am asking is that users are adding tags and then getting impatient a…

---

## [Vision chart - Data quality color](https://forum.inductiveautomation.com/t/vision-chart-data-quality-color/90791)

<div class="topic-metadata">

**Author:** [@Overcraft31](https://forum.inductiveautomation.com/u/Overcraft31)\
**Replies:** 8\
**Last updated:** [May 24, 2024, 2:17pm UTC](https://forum.inductiveautomation.com/t/vision-chart-data-quality-color/90791 "2024-05-24T14:17:08Z")

</div>

Hello, I'm using chart/easy chart in Vision and I'm trying to display OPC UA data value on this graphic. I would like to display the quality of the trending value by changing the color of the trend. For exemple the tre…

---

## [Sparkline Hover Value](https://forum.inductiveautomation.com/t/sparkline-hover-value/90831)

<div class="topic-metadata">

**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\
**Replies:** 7\
**Last updated:** [May 24, 2024, 2:00pm UTC](https://forum.inductiveautomation.com/t/sparkline-hover-value/90831 "2024-05-24T14:00:01Z")

</div>

Is there any way to show the value when hovering over a sparkline chart? This would be especially useful for at least the min and max values, which can have special markers.

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

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