# Latest

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

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

**Page:** 462

---

## [Ignition Report creating](https://forum.inductiveautomation.com/t/ignition-report-creating/91792)

<div class="topic-metadata">

**Author:** [@kugan.puspanathan](https://forum.inductiveautomation.com/u/kugan.puspanathan)\
**Replies:** 5\
**Last updated:** [June 13, 2024, 5:02pm UTC](https://forum.inductiveautomation.com/t/ignition-report-creating/91792 "2024-06-13T17:02:46Z")

</div>

Hey everyone, I currently have a report with 3 different sections. Sections Title page A table which shows status for pallets A table which shows alarms triggered for the current day As we know the tables for sectio…

---

## [Refresh a transform](https://forum.inductiveautomation.com/t/refresh-a-transform/91776)

<div class="topic-metadata">

**Author:** [@Tim\_Knezevich](https://forum.inductiveautomation.com/u/Tim_Knezevich)\
**Replies:** 24\
**Last updated:** [June 13, 2024, 3:48pm UTC](https://forum.inductiveautomation.com/t/refresh-a-transform/91776 "2024-06-13T15:48:16Z")

</div>

So I think I am trying to refresh a transform. I am making a messaging system that will allow operators to communicate between stations. I have a dataset tag for each station that stores all incoming and outgoing messag…

---

## [Appropriate approach for better performance. SQL vs transform?](https://forum.inductiveautomation.com/t/appropriate-approach-for-better-performance-sql-vs-transform/91801)

<div class="topic-metadata">

**Author:** [@raro](https://forum.inductiveautomation.com/u/raro)\
**Replies:** 3\
**Last updated:** [June 13, 2024, 2:30pm UTC](https://forum.inductiveautomation.com/t/appropriate-approach-for-better-performance-sql-vs-transform/91801 "2024-06-13T14:30:01Z")

</div>

Hello, I am interested in knowing which solution is more appropriate for better performance. In a Perspective table, I have data retrieved using a named query. I want to add a button to each row of the table that will …

---

## [Dropdown size to fit all the text](https://forum.inductiveautomation.com/t/dropdown-size-to-fit-all-the-text/91822)

<div class="topic-metadata">

**Author:** [@Martin\_Chauveliere](https://forum.inductiveautomation.com/u/Martin_Chauveliere)\
**Replies:** 2\
**Last updated:** [June 13, 2024, 2:24pm UTC](https://forum.inductiveautomation.com/t/dropdown-size-to-fit-all-the-text/91822 "2024-06-13T14:24:27Z")

</div>

Hi everyone I think its not that hard but I cant figure out how to make fit all the text in the dropdown without having to scrolling horizontaly. Thx guys

---

## [Easy way to check if tag use on Screen](https://forum.inductiveautomation.com/t/easy-way-to-check-if-tag-use-on-screen/91824)

<div class="topic-metadata">

**Author:** [@Eugene49](https://forum.inductiveautomation.com/u/Eugene49)\
**Replies:** 2\
**Last updated:** [June 13, 2024, 2:10pm UTC](https://forum.inductiveautomation.com/t/easy-way-to-check-if-tag-use-on-screen/91824 "2024-06-13T14:10:40Z")

</div>

Is there an easy way to check if a tag was use on any of the project's view. I wanted to be able to classify if tag's mode should be classified as direct or leased. Some tags are not on screen but are there for logging…

---

## [Best Practice: Script or Expression](https://forum.inductiveautomation.com/t/best-practice-script-or-expression/91764)

<div class="topic-metadata">

**Author:** [@Matthew\_Kuss](https://forum.inductiveautomation.com/u/Matthew_Kuss)\
**Replies:** 4\
**Last updated:** [June 13, 2024, 1:16pm UTC](https://forum.inductiveautomation.com/t/best-practice-script-or-expression/91764 "2024-06-13T13:16:18Z")

</div>

Generically, is it better to use a script or an expression when performing a transform in Perspective? In most cases I can use either one, but my personal preference is scripts. Is there a reason why I should be using an…

---

## [USB QR Code Reader communication with Vision Client](https://forum.inductiveautomation.com/t/usb-qr-code-reader-communication-with-vision-client/91818)

<div class="topic-metadata">

**Author:** [@Sanket](https://forum.inductiveautomation.com/u/Sanket)\
**Replies:** 0\
**Last updated:** [June 13, 2024, 1:06pm UTC](https://forum.inductiveautomation.com/t/usb-qr-code-reader-communication-with-vision-client/91818 "2024-06-13T13:06:00Z")

</div>

Ignition 8.1.19 vision module. USB type Zebra QR code Reader. I have seperate vision client running PC, to this PC QR reader is connected via USB port. How can I read data in vision client pop by the operator?

---

## [Vision Project is not enabled; Transaction groups not working](https://forum.inductiveautomation.com/t/vision-project-is-not-enabled-transaction-groups-not-working/91814)

<div class="topic-metadata">

**Author:** [@AnkThis](https://forum.inductiveautomation.com/u/AnkThis)\
**Replies:** 4\
**Last updated:** [June 13, 2024, 12:22pm UTC](https://forum.inductiveautomation.com/t/vision-project-is-not-enabled-transaction-groups-not-working/91814 "2024-06-13T12:22:18Z")

</div>

Tried everything mentioned on community forums but still cannot enable the vision project. It shows enabled on the gateway, but would not show up on the launcher and the transaction groups wouldn't work. Inheritance is t…

---

## [Getting Window Root Container Object from within a Template](https://forum.inductiveautomation.com/t/getting-window-root-container-object-from-within-a-template/91811)

<div class="topic-metadata">

**Author:** [@MG3](https://forum.inductiveautomation.com/u/MG3)\
**Replies:** 6\
**Last updated:** [June 13, 2024, 12:11pm UTC](https://forum.inductiveautomation.com/t/getting-window-root-container-object-from-within-a-template/91811 "2024-06-13T12:11:22Z")

</div>

Hi all, From a Template I am looking to have a Script that will need to access a component on the Root Container. Is there any simple way to get the Root Container of the Parent Window to the Template? I am unsure if e…

---

## [RunPrepUpdate errors during insert](https://forum.inductiveautomation.com/t/runprepupdate-errors-during-insert/91812)

<div class="topic-metadata">

**Author:** [@Klara\_Motlova](https://forum.inductiveautomation.com/u/Klara_Motlova)\
**Replies:** 2\
**Last updated:** [June 13, 2024, 12:09pm UTC](https://forum.inductiveautomation.com/t/runprepupdate-errors-during-insert/91812 "2024-06-13T12:09:46Z")

</div>

When executing system.db.runPrepUpdate in Designer Tools, the following errors appear and the traceback says: "Caused by: java.lang.Exception: Error executing system.db.runPrepUpdate( INSERT INTO \[abc\] (a\_id, \[Length\],…

---

## [Changes on Cell Commit Don't go Through](https://forum.inductiveautomation.com/t/changes-on-cell-commit-dont-go-through/91762)

<div class="topic-metadata">

**Author:** [@Miguel\_Villasenor\_Es](https://forum.inductiveautomation.com/u/Miguel_Villasenor_Es)\
**Replies:** 4\
**Last updated:** [June 13, 2024, 11:41am UTC](https://forum.inductiveautomation.com/t/changes-on-cell-commit-dont-go-through/91762 "2024-06-13T11:41:45Z")

</div>

Hello everyone. I am working on perspective and I have a table with a data binding and a transform script- it also has json as a return format. I made sure that the columns and rows are editable. I also have the onEditc…

---

## [Checkbox filter, selected box and non selected boxes](https://forum.inductiveautomation.com/t/checkbox-filter-selected-box-and-non-selected-boxes/91754)

<div class="topic-metadata">

**Author:** [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\
**Replies:** 8\
**Last updated:** [June 13, 2024, 11:33am UTC](https://forum.inductiveautomation.com/t/checkbox-filter-selected-box-and-non-selected-boxes/91754 "2024-06-13T11:33:13Z")

</div>

Hello! I´m applying a checkbox filter to a table binded to a named query. I using a Expression chk\_6: {.../Checkbox\_inv\_6.props.selected} chk\_7: {.../Checkbox\_inv\_7.props.selected} chk\_8: {.../Checkbox\_inv\_8.props.se…

---

## [Add Tag change scripts](https://forum.inductiveautomation.com/t/add-tag-change-scripts/56821)

<div class="topic-metadata">

**Author:** [@taohongyu88](https://forum.inductiveautomation.com/u/taohongyu88)\
**Replies:** 7\
**Last updated:** [June 13, 2024, 11:26am UTC](https://forum.inductiveautomation.com/t/add-tag-change-scripts/56821 "2024-06-13T11:26:10Z")

</div>

I want to monitor some tags change, then do some scripts. if i have many tags want to monitor, I have to add many tag change scripts. Is there another idea? Today i find we can write scripts in tag or UDT tag. Whe…

---

## [\[FEATURE\] Voice Notification Module: Automatic Public Bind Address](https://forum.inductiveautomation.com/t/feature-voice-notification-module-automatic-public-bind-address/91803)

<div class="topic-metadata">

**Author:** [@diamond](https://forum.inductiveautomation.com/u/diamond)\
**Replies:** 1\
**Last updated:** [June 13, 2024, 11:14am UTC](https://forum.inductiveautomation.com/t/feature-voice-notification-module-automatic-public-bind-address/91803 "2024-06-13T11:14:51Z")

</div>

Hello, I would like to propose a feature in Ignition's Voice Notification module, as a result of a problem we have had this week. In our company we have several public IP addresses with which we can expose to the publi…

---

## [Perspective XY Chart - Y axis Maximum Value not getting changed to visible series](https://forum.inductiveautomation.com/t/perspective-xy-chart-y-axis-maximum-value-not-getting-changed-to-visible-series/91810)

<div class="topic-metadata">

**Author:** [@Sudharsanan\_Mothilal](https://forum.inductiveautomation.com/u/Sudharsanan_Mothilal)\
**Replies:** 0\
**Last updated:** [June 13, 2024, 9:37am UTC](https://forum.inductiveautomation.com/t/perspective-xy-chart-y-axis-maximum-value-not-getting-changed-to-visible-series/91810 "2024-06-13T09:37:13Z")

</div>

In my project there is an XY Chart holding 4 series of values. XY Chart has the inbuilt option of hiding the series when it is live. During that time when i want to hide some series, the maximum value of y chart is not g…

---

## [Database connection to Oracle with SSL certificate](https://forum.inductiveautomation.com/t/database-connection-to-oracle-with-ssl-certificate/91612)

<div class="topic-metadata">

**Author:** [@Gauthier\_Dabas](https://forum.inductiveautomation.com/u/Gauthier_Dabas)\
**Replies:** 2\
**Last updated:** [June 13, 2024, 8:35am UTC](https://forum.inductiveautomation.com/t/database-connection-to-oracle-with-ssl-certificate/91612 "2024-06-13T08:35:40Z")

</div>

Hello, We need to configure a database connection from Ignition to Oracle with a SSL certificate. Do you know where to place the certificate and how to configure the connection accordingly in the gateway configuration …

---

## [Perspective DateTimeInput can select second?](https://forum.inductiveautomation.com/t/perspective-datetimeinput-can-select-second/91715)

<div class="topic-metadata">

**Author:** [@taohongyu88](https://forum.inductiveautomation.com/u/taohongyu88)\
**Replies:** 3\
**Last updated:** [June 13, 2024, 7:39am UTC](https://forum.inductiveautomation.com/t/perspective-datetimeinput-can-select-second/91715 "2024-06-13T07:39:10Z")

</div>

Perspective DateTimeInput can select second?

---

## [Connecting to OneLake using T-SQL?](https://forum.inductiveautomation.com/t/connecting-to-onelake-using-t-sql/87545)

<div class="topic-metadata">

**Author:** [@SBL](https://forum.inductiveautomation.com/u/SBL)\
**Replies:** 2\
**Last updated:** [June 13, 2024, 7:23am UTC](https://forum.inductiveautomation.com/t/connecting-to-onelake-using-t-sql/87545 "2024-06-13T07:23:54Z")

</div>

Hi everyone, Has anyone successfully connected to Microsoft OneLake (Fabric) using their T-SQL connection? Need some pointers on how. :slight\_smile:

---

## [XY Chart, bars occasionally render with thin lines](https://forum.inductiveautomation.com/t/xy-chart-bars-occasionally-render-with-thin-lines/91800)

<div class="topic-metadata">

**Author:** [@Jgoh](https://forum.inductiveautomation.com/u/Jgoh)\
**Replies:** 0\
**Last updated:** [June 13, 2024, 7:07am UTC](https://forum.inductiveautomation.com/t/xy-chart-bars-occasionally-render-with-thin-lines/91800 "2024-06-13T07:07:16Z")

</div>

Hey guys, Hoping you can assist with this issue that is bugging me. I have a mixed XY Chart with stacked columns and one line series displaying totals for every hour of the day. This is querying about 7 tags through th…

---

## [Component Scripting Window Default Size](https://forum.inductiveautomation.com/t/component-scripting-window-default-size/68548)

<div class="topic-metadata">

**Author:** [@Skylar\_Sabo](https://forum.inductiveautomation.com/u/Skylar_Sabo)\
**Replies:** 15\
**Last updated:** [June 13, 2024, 6:49am UTC](https://forum.inductiveautomation.com/t/component-scripting-window-default-size/68548 "2024-06-13T06:49:45Z")

</div>

Hello Ignition Forums, I was wondering if it's possible to change the default popup size of the component scripting window. When I do ctrl J to quickly open a scripting window on a component my window seems to always r…

---

## [\[BUG\] Json encode function break the runNamedQuery](https://forum.inductiveautomation.com/t/bug-json-encode-function-break-the-runnamedquery/91724)

<div class="topic-metadata">

**Author:** [@Paul\_Najberg1](https://forum.inductiveautomation.com/u/Paul_Najberg1)\
**Replies:** 5\
**Last updated:** [June 13, 2024, 6:47am UTC](https://forum.inductiveautomation.com/t/bug-json-encode-function-break-the-runnamedquery/91724 "2024-06-13T06:47:15Z")

</div>

Hello there, TLDR : I use the perspective JSON encode function to convert Object from custom data to JSON and it makes it impossible for the RunNamedQuery function to find the query. I tried another way to pass my para…

---

## [Power Chart - Showing transformed value in x-trace instead of integer value?](https://forum.inductiveautomation.com/t/power-chart-showing-transformed-value-in-x-trace-instead-of-integer-value/68527)

<div class="topic-metadata">

**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Replies:** 4\
**Last updated:** [June 13, 2024, 5:21am UTC](https://forum.inductiveautomation.com/t/power-chart-showing-transformed-value-in-x-trace-instead-of-integer-value/68527 "2024-06-13T05:21:52Z")

</div>

In Vision we can transform the x-trace values, for example, translate an enum integer value into its corresponding text value (0 -\> 'Stopped', 1 -\> 'Starting', etc.) Can we do this in Perspective? I'm guessing not at th…

---

## [Maker ignition designer doesn't launch](https://forum.inductiveautomation.com/t/maker-ignition-designer-doesnt-launch/91797)

<div class="topic-metadata">

**Author:** [@vaibhav\_chadha](https://forum.inductiveautomation.com/u/vaibhav_chadha)\
**Replies:** 0\
**Last updated:** [June 13, 2024, 4:56am UTC](https://forum.inductiveautomation.com/t/maker-ignition-designer-doesnt-launch/91797 "2024-06-13T04:56:36Z")

</div>

Greetings, I have installed Makers edition 8.1.41 with Designer and Zulu JDK, but I am unable to launch Designer, upon selecting the running gateway and trying to launch Designer, it opens and validates the signature the…

---

## [Remote roster in perspective](https://forum.inductiveautomation.com/t/remote-roster-in-perspective/89946)

<div class="topic-metadata">

**Author:** [@celo\_Tu](https://forum.inductiveautomation.com/u/celo_Tu)\
**Replies:** 7\
**Last updated:** [June 13, 2024, 4:40am UTC](https://forum.inductiveautomation.com/t/remote-roster-in-perspective/89946 "2024-06-13T04:40:34Z")

</div>

Is there any way to remote alarm roster in perspective ?

---

## [OPC tags subscription issue](https://forum.inductiveautomation.com/t/opc-tags-subscription-issue/91527)

<div class="topic-metadata">

**Author:** [@Ben\_Pang](https://forum.inductiveautomation.com/u/Ben_Pang)\
**Replies:** 8\
**Last updated:** [June 13, 2024, 2:58am UTC](https://forum.inductiveautomation.com/t/opc-tags-subscription-issue/91527 "2024-06-13T02:58:30Z")

</div>

Hello, We have approx. 250k OPC tags from our PLC to ignition, which are spread over 7 OPC servers connection on the gateway. To add, the 250k tags are reasonably/evenly spread over approx. 300 tag groups from the desig…

---

## [Chinese translation doesn't work](https://forum.inductiveautomation.com/t/chinese-translation-doesnt-work/91672)

<div class="topic-metadata">

**Author:** [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\
**Replies:** 15\
**Last updated:** [June 13, 2024, 2:53am UTC](https://forum.inductiveautomation.com/t/chinese-translation-doesnt-work/91672 "2024-06-13T02:53:55Z")

</div>

Good morning, I'm working with the translation, I can translate to English but not to Chinese. This is the dropdown for the language change This is the text that I'm trying to translate: The translation should …

---

## [Historizing Fault tags data](https://forum.inductiveautomation.com/t/historizing-fault-tags-data/91740)

<div class="topic-metadata">

**Author:** [@Babla\_Bogam](https://forum.inductiveautomation.com/u/Babla_Bogam)\
**Replies:** 5\
**Last updated:** [June 13, 2024, 2:27am UTC](https://forum.inductiveautomation.com/t/historizing-fault-tags-data/91740 "2024-06-13T02:27:38Z")

</div>

I am creating a fault tag history table in SQL database. We have about 70 machines. In each machine’s PLC program we have several (about 400 of them) tags that are fault tags. They have either 0 or 1 value. 1 meaning fau…

---

## [Additional X-axis in PowerChart](https://forum.inductiveautomation.com/t/additional-x-axis-in-powerchart/91747)

<div class="topic-metadata">

**Author:** [@Yash\_Patel](https://forum.inductiveautomation.com/u/Yash_Patel)\
**Replies:** 1\
**Last updated:** [June 13, 2024, 1:10am UTC](https://forum.inductiveautomation.com/t/additional-x-axis-in-powerchart/91747 "2024-06-13T01:10:54Z")

</div>

I'm in a bit of a pickle trying to integrate Digiforce real-time data into PowerChart. The snag? Customizing the X-axis. \[We're currently using PowerChart because it provides all the functionality we need, leveraging th…

---

## [Power Chart (I just want to show a database)](https://forum.inductiveautomation.com/t/power-chart-i-just-want-to-show-a-database/46434)

<div class="topic-metadata">

**Author:** [@patricio.rojas.bolom](https://forum.inductiveautomation.com/u/patricio.rojas.bolom)\
**Replies:** 3\
**Last updated:** [June 13, 2024, 12:47am UTC](https://forum.inductiveautomation.com/t/power-chart-i-just-want-to-show-a-database/46434 "2024-06-13T00:47:34Z")

</div>

When I want to add a tag to “POWER CHART”, 2 databases appear (I have two projects), but I want each area to show only its database in power chart Cuando queiero agregar un tag a “POWER CHART” me aparecen 2 bases de d…

---

## [runScript PathToTag Property](https://forum.inductiveautomation.com/t/runscript-pathtotag-property/91656)

<div class="topic-metadata">

**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\
**Replies:** 19\
**Last updated:** [June 12, 2024, 11:17pm UTC](https://forum.inductiveautomation.com/t/runscript-pathtotag-property/91656 "2024-06-12T23:17:41Z")

</div>

I am trying to run a script from an expression tag using runScript The script works, given the correct arguments. Common.Data.histArrayToDataset('Pumps\_Motors/2111-WP/Runtime\_Starts/History/1/0/Chart.Path') However, t…

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

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