# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=713 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 714 --- ## [Named query column as a text field in Perspective](https://forum.inductiveautomation.com/t/named-query-column-as-a-text-field-in-perspective/69203)
**Author:** [@Matabufalez](https://forum.inductiveautomation.com/u/Matabufalez)\ **Replies:** 2\ **Last updated:** [January 31, 2023, 2:09pm UTC](https://forum.inductiveautomation.com/t/named-query-column-as-a-text-field-in-perspective/69203 "2023-01-31T14:09:25Z")
Good morning, I still crashing into walls while trying to learn about this enviroment. Perspective seems to be very powerfull but I am missing some options which in "Reports" enviroment are quite easy. I just want to u… --- ## [Convert Java.Byte.Array to "normal" Arrays to send Binary Data via Cirrus Link MQTT](https://forum.inductiveautomation.com/t/convert-java-byte-array-to-normal-arrays-to-send-binary-data-via-cirrus-link-mqtt/56200)
**Author:** [@jeffrey.boey](https://forum.inductiveautomation.com/u/jeffrey.boey)\ **Replies:** 6\ **Last updated:** [January 31, 2023, 1:44pm UTC](https://forum.inductiveautomation.com/t/convert-java-byte-array-to-normal-arrays-to-send-binary-data-via-cirrus-link-mqtt/56200 "2023-01-31T13:44:12Z")
Hi everyone, I'm hoping to get your opinions on an issue that I faced I have 2 gateways (A and B). Gateway A needs to send a file to B via Cirrus Link MQTT, so I create a Byte Array tag since Binary Data is not supporte… --- ## [Composite tag with scripting](https://forum.inductiveautomation.com/t/composite-tag-with-scripting/69206)
**Author:** [@Penn](https://forum.inductiveautomation.com/u/Penn)\ **Replies:** 1\ **Last updated:** [January 31, 2023, 1:40pm UTC](https://forum.inductiveautomation.com/t/composite-tag-with-scripting/69206 "2023-01-31T13:40:05Z")
Is there a way to create a 'composite tag' with scripting? I have several folders each containing boolean tags relating to the other tags in its respective folder. Can I make a script with a parameter of the path to one … --- ## [Sum multiple datasets](https://forum.inductiveautomation.com/t/sum-multiple-datasets/69146)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 13\ **Last updated:** [January 31, 2023, 6:51am UTC](https://forum.inductiveautomation.com/t/sum-multiple-datasets/69146 "2023-01-31T06:51:45Z")
Hi, i want to sum the datasets value and put in first dataset note: First column will be time stamp that i don't want to sum it example code endTime = system.date.now() startTime = system.date.addMinutes(endTime, … --- ## [Power table and Auto Row Height offset - VISION](https://forum.inductiveautomation.com/t/power-table-and-auto-row-height-offset-vision/69148)
**Author:** [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\ **Replies:** 3\ **Last updated:** [January 31, 2023, 6:47am UTC](https://forum.inductiveautomation.com/t/power-table-and-auto-row-height-offset-vision/69148 "2023-01-31T06:47:12Z")
Good morning, I have a power table where I query the default table "Notes". I set the wrap text for the note columns because sometimes the text is longer than the column. So I also enable the Auto Row Height to see the … --- ## [Message using WhatsApp](https://forum.inductiveautomation.com/t/message-using-whatsapp/41967)
**Author:** [@tom.wouters](https://forum.inductiveautomation.com/u/tom.wouters)\ **Replies:** 3\ **Last updated:** [January 31, 2023, 6:46am UTC](https://forum.inductiveautomation.com/t/message-using-whatsapp/41967 "2023-01-31T06:46:53Z")
Hello experts, I have a client that wishes to use whatsapp messages when certain alarms are active. Now I know there is an SMS module but i’m wondering if it’s possible to use whatsapp? If you guys have any other sugg… --- ## [Ignition 7.9 tag browse tree filter on tag/udt enabled](https://forum.inductiveautomation.com/t/ignition-7-9-tag-browse-tree-filter-on-tag-udt-enabled/69106)
**Author:** [@nbrown](https://forum.inductiveautomation.com/u/nbrown)\ **Replies:** 7\ **Last updated:** [January 31, 2023, 5:31am UTC](https://forum.inductiveautomation.com/t/ignition-7-9-tag-browse-tree-filter-on-tag-udt-enabled/69106 "2023-01-31T05:31:31Z")
I know I need to upgrade to 8.1, and I'm working on that... but I have a tag tree browser that I'd like to filter and only show if the tags are enabled, but its currently showing all tags. Anyone have any advice? I'm u… --- ## [Select variable number of columns with MYSQL](https://forum.inductiveautomation.com/t/select-variable-number-of-columns-with-mysql/68885)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 11\ **Last updated:** [January 31, 2023, 4:39am UTC](https://forum.inductiveautomation.com/t/select-variable-number-of-columns-with-mysql/68885 "2023-01-31T04:39:13Z")
I have a table of data recording new downtime reasons every hour for all machines with the following format: ID t\_stamp machine reason minutes 3 2023-01-22 08:00:00 Solder1 Running 60 4 2023-01-22 08:00:00 Sol… --- ## [Upload Ignition Gateway backup project](https://forum.inductiveautomation.com/t/upload-ignition-gateway-backup-project/69184)
**Author:** [@Michael\_Daigle](https://forum.inductiveautomation.com/u/Michael_Daigle)\ **Replies:** 3\ **Last updated:** [January 31, 2023, 1:04am UTC](https://forum.inductiveautomation.com/t/upload-ignition-gateway-backup-project/69184 "2023-01-31T01:04:21Z")
Hi, I am trying to take the core certificate test project via the trial mode. I am confused about where to upload the Ignition Gateway backup for the troubleshooting section. Do I download the Designer, Vision Client La… --- ## [Not able to write a string onto a memory tag using value changed function of an another tag](https://forum.inductiveautomation.com/t/not-able-to-write-a-string-onto-a-memory-tag-using-value-changed-function-of-an-another-tag/69185)
**Author:** [@Bharat\_Krishnan](https://forum.inductiveautomation.com/u/Bharat_Krishnan)\ **Replies:** 3\ **Last updated:** [January 31, 2023, 12:37am UTC](https://forum.inductiveautomation.com/t/not-able-to-write-a-string-onto-a-memory-tag-using-value-changed-function-of-an-another-tag/69185 "2023-01-31T00:37:35Z")
Hi all, I am not able to write string "TANK" or "SEALING PLATE" to a tag named "LoadType" using the another tag's value changed script. Basically wat I want is to enter the above mentioned strings to a tag after checki… --- ## [Connecting Ignition to B&R PLC](https://forum.inductiveautomation.com/t/connecting-ignition-to-b-r-plc/68884)
**Author:** [@michel\_feria](https://forum.inductiveautomation.com/u/michel_feria)\ **Replies:** 1\ **Last updated:** [January 30, 2023, 11:46pm UTC](https://forum.inductiveautomation.com/t/connecting-ignition-to-b-r-plc/68884 "2023-01-30T23:46:04Z")
Hello, I would like to communicate with some B&R PLC that use presently a PVI driver. I cannot enable another communication on the PLC so I need to use this specific driver on the PLC, someone knows if this communicati… --- ## [Restart Gateway fixed issue but is there a better way. Fun with API calls](https://forum.inductiveautomation.com/t/restart-gateway-fixed-issue-but-is-there-a-better-way-fun-with-api-calls/69171)
**Author:** [@Duggan639](https://forum.inductiveautomation.com/u/Duggan639)\ **Replies:** 7\ **Last updated:** [January 30, 2023, 11:16pm UTC](https://forum.inductiveautomation.com/t/restart-gateway-fixed-issue-but-is-there-a-better-way-fun-with-api-calls/69171 "2023-01-30T23:16:29Z")
So I am new to dealing with Ignition and inherited this Ignition install from a former Engineer who set this up for the project before I started at my current company and he is no longer apart of the company. So I am st… --- ## [Saving component to mounted folder](https://forum.inductiveautomation.com/t/saving-component-to-mounted-folder/69170)
**Author:** [@mjoseph](https://forum.inductiveautomation.com/u/mjoseph)\ **Replies:** 3\ **Last updated:** [January 30, 2023, 10:20pm UTC](https://forum.inductiveautomation.com/t/saving-component-to-mounted-folder/69170 "2023-01-30T22:20:40Z")
My program has the user enter in text which generates a barcode with the Barcode component. It's then supposed to print the barcode to a label printer on a button press but as far as I know, it's not possible to print a … --- ## [\[FEATURE\] Perspective Style Class Enhancements](https://forum.inductiveautomation.com/t/feature-perspective-style-class-enhancements/60810)
**Author:** [@kgamble](https://forum.inductiveautomation.com/u/kgamble)\ **Replies:** 14\ **Last updated:** [January 30, 2023, 7:56pm UTC](https://forum.inductiveautomation.com/t/feature-perspective-style-class-enhancements/60810 "2023-01-30T19:56:53Z")
I have noticed that more and more frequently, when you want to do any kind of intermediate-level css without using theming than you have to escape the style class with what feels like SQL injection with something like }.… --- ## [Report parameters unbinding](https://forum.inductiveautomation.com/t/report-parameters-unbinding/69166)
**Author:** [@jbb5310](https://forum.inductiveautomation.com/u/jbb5310)\ **Replies:** 4\ **Last updated:** [January 30, 2023, 7:18pm UTC](https://forum.inductiveautomation.com/t/report-parameters-unbinding/69166 "2023-01-30T19:18:07Z")
I'm using a dropdown component with names of reports that is linked to the report path on the report viewer. My issue is when changing reports that do not share the same parameters they tend to unbind which becomes an is… --- ## [Tags Historical logging Sampling rate Issue](https://forum.inductiveautomation.com/t/tags-historical-logging-sampling-rate-issue/64075)
**Author:** [@Shaheryar\_Ahmad](https://forum.inductiveautomation.com/u/Shaheryar_Ahmad)\ **Replies:** 9\ **Last updated:** [January 30, 2023, 5:55pm UTC](https://forum.inductiveautomation.com/t/tags-historical-logging-sampling-rate-issue/64075 "2023-01-30T17:55:57Z")
Dear All, Hope you all are doing well. I am facing a very weird issue when using the tag history feature in Ignition 8.1 perspective. When, I enable historical logging in a tag (float datatype) and do the configuration… --- ## [ODBC Database Connection - CMS AS400](https://forum.inductiveautomation.com/t/odbc-database-connection-cms-as400/69149)
**Author:** [@David\_Choi](https://forum.inductiveautomation.com/u/David_Choi)\ **Replies:** 1\ **Last updated:** [January 30, 2023, 5:00pm UTC](https://forum.inductiveautomation.com/t/odbc-database-connection-cms-as400/69149 "2023-01-30T17:00:46Z")
Hello All, We're trying to create a real-time display for production line where the data only resides within our CMS AS400 system, but no way to visualize. Attempt is to use Ignition to work as the visualization tool. … --- ## [Docked View Shadow](https://forum.inductiveautomation.com/t/docked-view-shadow/69156)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 2\ **Last updated:** [January 30, 2023, 3:24pm UTC](https://forum.inductiveautomation.com/t/docked-view-shadow/69156 "2023-01-30T15:24:42Z")
I have a docked view with a transparent background that I have set up to cover/show on all pages. It works as expected, but there's a shadow on the edge that's undesirable. Any way to remove this? (preferably only for th… --- ## [Writing Scaled OPC tag from Memory tag](https://forum.inductiveautomation.com/t/writing-scaled-opc-tag-from-memory-tag/69142)
**Author:** [@Thomas\_Mulcahy](https://forum.inductiveautomation.com/u/Thomas_Mulcahy)\ **Replies:** 5\ **Last updated:** [January 30, 2023, 3:19pm UTC](https://forum.inductiveautomation.com/t/writing-scaled-opc-tag-from-memory-tag/69142 "2023-01-30T15:19:00Z")
Hi, I have a quick question regarding tags, and scaling. We have a system where we have a SPEED tag and a SPEED\_SET tag coming from a PLC. The SPEED tag, which is read-only and comes in as 2000-5000, which I can scale… --- ## [Python tagprovider selection](https://forum.inductiveautomation.com/t/python-tagprovider-selection/69155)
**Author:** [@GeraldB](https://forum.inductiveautomation.com/u/GeraldB)\ **Replies:** 1\ **Last updated:** [January 30, 2023, 2:46pm UTC](https://forum.inductiveautomation.com/t/python-tagprovider-selection/69155 "2023-01-30T14:46:28Z")
Hello, in python scripting when i have the full path of a tag e.g. '\[default\]10003220/device1/Kav1', i also can replace the tag provider by \[~\] and \[.\]. What is the difference between using \[default\], \[~\] or \[.\]? Than… --- ## [Master is not available. Backup is available, node is inactive](https://forum.inductiveautomation.com/t/master-is-not-available-backup-is-available-node-is-inactive/31321)
**Author:** [@dstorm](https://forum.inductiveautomation.com/u/dstorm)\ **Replies:** 3\ **Last updated:** [January 30, 2023, 1:47pm UTC](https://forum.inductiveautomation.com/t/master-is-not-available-backup-is-available-node-is-inactive/31321 "2023-01-30T13:47:15Z")
I have an operator running client on their computer workstation while connected to the master. There is a master and backup for Ignition. They are having issues from time to time where the red overlay on components will … --- ## [Gateway scripts stop running FTP](https://forum.inductiveautomation.com/t/gateway-scripts-stop-running-ftp/18380)
**Author:** [@albetro.15](https://forum.inductiveautomation.com/u/albetro.15)\ **Replies:** 4\ **Last updated:** [January 30, 2023, 1:36pm UTC](https://forum.inductiveautomation.com/t/gateway-scripts-stop-running-ftp/18380 "2023-01-30T13:36:25Z")
I have a series of scripts in the gateway that at som point stop. As pointed in http://forum.inductiveautomation.com/t/gateway-timer-scripts-mysteriously-stopped/7453 it is very likely it is due to a ftp socket that d… --- ## [Get Difference value from dataset](https://forum.inductiveautomation.com/t/get-difference-value-from-dataset/68999)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 15\ **Last updated:** [January 30, 2023, 12:59pm UTC](https://forum.inductiveautomation.com/t/get-difference-value-from-dataset/68999 "2023-01-30T12:59:32Z")
Hi , I have a dataset with below mentioned columns |t\_stamp|running|starting|stop|stopping| |---|---|---|---|---| |12:00:00 AM|2026686.859|0|604281.2019|0| |12:04:48 AM|2027128.76|0|604414.1515|0| |12:09:36 AM|2027569.0… --- ## [Refreshing Report Viewer](https://forum.inductiveautomation.com/t/refreshing-report-viewer/14089)
**Author:** [@Tom\_Smits](https://forum.inductiveautomation.com/u/Tom_Smits)\ **Replies:** 9\ **Last updated:** [January 30, 2023, 12:50pm UTC](https://forum.inductiveautomation.com/t/refreshing-report-viewer/14089 "2023-01-30T12:50:52Z")
Hello there, I'm currently working on a project where I have to generate a report every time a new record is inserted in my database. So far, I have created a label which is filled with the highest "BalkID" in my da… --- ## [System.gui.confirm - Text Formatting](https://forum.inductiveautomation.com/t/system-gui-confirm-text-formatting/63750)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 17\ **Last updated:** [January 30, 2023, 10:20am UTC](https://forum.inductiveautomation.com/t/system-gui-confirm-text-formatting/63750 "2023-01-30T10:20:01Z")
Hi, I am using the below script in button. But alignment of the text is not good. Any way to adjust my script? i = 0 tag\_check\_neagtive = \["\[default\]Montreal/Weather/Description","\[default\]Montreal/Weather/Description",… --- ## [Display sum of a column at the end of the table](https://forum.inductiveautomation.com/t/display-sum-of-a-column-at-the-end-of-the-table/68717)
**Author:** [@Dharani\_T](https://forum.inductiveautomation.com/u/Dharani_T)\ **Replies:** 13\ **Last updated:** [January 30, 2023, 6:44am UTC](https://forum.inductiveautomation.com/t/display-sum-of-a-column-at-the-end-of-the-table/68717 "2023-01-30T06:44:03Z")
Hi, I would like to display status of machines in vision like below, Is there any option to display the sum of each column at the end of the table as shown in the pic. --- ## [Mouseover Text Visibility or Position](https://forum.inductiveautomation.com/t/mouseover-text-visibility-or-position/68788)
**Author:** [@robertm](https://forum.inductiveautomation.com/u/robertm)\ **Replies:** 4\ **Last updated:** [January 29, 2023, 7:16pm UTC](https://forum.inductiveautomation.com/t/mouseover-text-visibility-or-position/68788 "2023-01-29T19:16:16Z")
Is there a global means to disable all Mouseover Text's in a project? They're great for new implementations and training, but after awhile are annoying. Short of binding every mouseover to a client tag and wholesale ch… --- ## [Customizing the Report Bar Chart using scripting](https://forum.inductiveautomation.com/t/customizing-the-report-bar-chart-using-scripting/69089)
**Author:** [@naturesbeast](https://forum.inductiveautomation.com/u/naturesbeast)\ **Replies:** 4\ **Last updated:** [January 29, 2023, 4:12pm UTC](https://forum.inductiveautomation.com/t/customizing-the-report-bar-chart-using-scripting/69089 "2023-01-29T16:12:23Z")
I've created the following report using a Bar Chart: However, I'd like to customize it so that the color changes based upon whether or not the value exceeds a target value for each item. I added the following code: … --- ## [Scale out Architecture VS Increasing Hardware Resource](https://forum.inductiveautomation.com/t/scale-out-architecture-vs-increasing-hardware-resource/69076)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 6\ **Last updated:** [January 29, 2023, 2:14pm UTC](https://forum.inductiveautomation.com/t/scale-out-architecture-vs-increasing-hardware-resource/69076 "2023-01-29T14:14:54Z")
Hi, These days everyone talks about using scale-out architecture to separate the backend from frontend, and having multiple frontends adding load balancer for large projects. The questions is as this involve a lot of h… --- ## [View reports in browser](https://forum.inductiveautomation.com/t/view-reports-in-browser/69086)
**Author:** [@Matabufalez](https://forum.inductiveautomation.com/u/Matabufalez)\ **Replies:** 5\ **Last updated:** [January 29, 2023, 11:15am UTC](https://forum.inductiveautomation.com/t/view-reports-in-browser/69086 "2023-01-29T11:15:47Z")
Good morning, I have just created my first report, but now I would like to view it by a Browser, as we use the Microsoft Reporting Services currently. Is it possible to do it in Ignition? My report is in "Ignition Dei… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=712) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=714)