# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=395 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 396 --- ## [Reporting change font to bold if value is null](https://forum.inductiveautomation.com/t/reporting-change-font-to-bold-if-value-is-null/91843)
**Author:** [@Ayanakoji](https://forum.inductiveautomation.com/u/Ayanakoji)\ **Replies:** 5\ **Last updated:** [June 13, 2024, 11:52pm UTC](https://forum.inductiveautomation.com/t/reporting-change-font-to-bold-if-value-is-null/91843 "2024-06-13T23:52:47Z")
is this possible in reporting? change the row table font size or font using key expression ? --- ## [Ignition MQTT Engine not decoding Sparkplug B topic](https://forum.inductiveautomation.com/t/ignition-mqtt-engine-not-decoding-sparkplug-b-topic/91842)
**Author:** [@mariusscutea](https://forum.inductiveautomation.com/u/mariusscutea)\ **Replies:** 0\ **Last updated:** [June 13, 2024, 10:41pm UTC](https://forum.inductiveautomation.com/t/ignition-mqtt-engine-not-decoding-sparkplug-b-topic/91842 "2024-06-13T22:41:33Z")
I successfully developed a project on a testing environment; upon migration to production, the system no longer functions as it did on the testing environment. I have included two MQTT brokers on different ports, with t… --- ## [Perspective Screenshot Capture](https://forum.inductiveautomation.com/t/perspective-screenshot-capture/24312)
**Author:** [@roger\_larson](https://forum.inductiveautomation.com/u/roger_larson)\ **Replies:** 32\ **Last updated:** [June 13, 2024, 10:17pm UTC](https://forum.inductiveautomation.com/t/perspective-screenshot-capture/24312 "2024-06-13T22:17:31Z")
Hi all, Is there a way to take screen shots / screen captures in Perspective as we did in Vision with system.print functions? I’m thinking of using the system.perspective.download function to print out a byte array of a… --- ## [\[Bug\] Perspective Dropdown Custom Option Int Not Showing](https://forum.inductiveautomation.com/t/bug-perspective-dropdown-custom-option-int-not-showing/91840)
**Author:** [@Brandon\_Peterson](https://forum.inductiveautomation.com/u/Brandon_Peterson)\ **Replies:** 0\ **Last updated:** [June 13, 2024, 8:50pm UTC](https://forum.inductiveautomation.com/t/bug-perspective-dropdown-custom-option-int-not-showing/91840 "2024-06-13T20:50:20Z")
I have a form (view) where a user can enter data for an object to be saved to a table. One of the inputs is a dropdown that allows custom options (allowCustomOptions: True). There is a similar form (view) used to allow… --- ## [Switching Tags on a Custom Parameter Based on a PARAMS Input](https://forum.inductiveautomation.com/t/switching-tags-on-a-custom-parameter-based-on-a-params-input/91837)
**Author:** [@Peter\_Frazier](https://forum.inductiveautomation.com/u/Peter_Frazier)\ **Replies:** 1\ **Last updated:** [June 13, 2024, 8:18pm UTC](https://forum.inductiveautomation.com/t/switching-tags-on-a-custom-parameter-based-on-a-params-input/91837 "2024-06-13T20:18:04Z")
I am trying to switch a tag bounded to a custom parameter based on changing the value of a PARAMS variable. Anyone know how this can be accomplished? --- ## [Button properties disappearing](https://forum.inductiveautomation.com/t/button-properties-disappearing/91829)
**Author:** [@Zachary\_Zlotnick](https://forum.inductiveautomation.com/u/Zachary_Zlotnick)\ **Replies:** 11\ **Last updated:** [June 13, 2024, 7:44pm UTC](https://forum.inductiveautomation.com/t/button-properties-disappearing/91829 "2024-06-13T19:44:35Z")
I am using Ignition v8.1.38, configuring a simple button. Some pre-existing ones have the "Enabled" or "Visible" properties, however when I right-click "remove binding," or select "no binding" the property disappears ent… --- ## [Script Invoke Later Advanced Option (Checkbox)](https://forum.inductiveautomation.com/t/script-invoke-later-advanced-option-checkbox/91742)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 6\ **Last updated:** [June 13, 2024, 5:50pm UTC](https://forum.inductiveautomation.com/t/script-invoke-later-advanced-option-checkbox/91742 "2024-06-13T17:50:31Z")
In an event script, there's the advanced option for Invoke Later. What does this mean, exactly? When is later? --- ## [Ignition 8.1.28 61850 able to grab values from Model but not Reports](https://forum.inductiveautomation.com/t/ignition-8-1-28-61850-able-to-grab-values-from-model-but-not-reports/78832)
**Author:** [@Mike\_Le](https://forum.inductiveautomation.com/u/Mike_Le)\ **Replies:** 2\ **Last updated:** [June 13, 2024, 5:44pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-28-61850-able-to-grab-values-from-model-but-not-reports/78832 "2024-06-13T17:44:20Z")
Getting these errors: Tags are addressed to look at reports brcbA02 and urcbA02. Both reports are open and are not being utilized by another device. All tags connected to the reports are displaying: "Uncertain\_Initi… --- ## [Are OPC writes atomic? Conclusion: No](https://forum.inductiveautomation.com/t/are-opc-writes-atomic-conclusion-no/91825)
**Author:** [@zacht](https://forum.inductiveautomation.com/u/zacht)\ **Replies:** 10\ **Last updated:** [June 13, 2024, 5:05pm UTC](https://forum.inductiveautomation.com/t/are-opc-writes-atomic-conclusion-no/91825 "2024-06-13T17:05:04Z")
When using system.opc.writeValues to write to a PLC through the 'Allen-Bradley Logix Driver,' are multiple writes synchronous atomic within the PLC? The two values in this case are sequential elements (but not every elem… --- ## [Ignition Report creating](https://forum.inductiveautomation.com/t/ignition-report-creating/91792)
**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")
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)
**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")
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)
**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")
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)
**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")
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)
**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")
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)
**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")
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)
**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")
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)
**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")
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)
**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")
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)
**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")
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)
**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")
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)
**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")
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)
**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")
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)
**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")
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)
**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")
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)
**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")
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)
**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")
Perspective DateTimeInput can select second? --- ## [Connecting to OneLake using T-SQL?](https://forum.inductiveautomation.com/t/connecting-to-onelake-using-t-sql/87545)
**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")
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)
**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")
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)
**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")
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)
**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")
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… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=394) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=396)