# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1246 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1247 --- ## [Null values in namedQuery](https://forum.inductiveautomation.com/t/null-values-in-namedquery/16946)
**Author:** [@martinel3746](https://forum.inductiveautomation.com/u/martinel3746)\ **Replies:** 2\ **Last updated:** [December 31, 2020, 5:15pm UTC](https://forum.inductiveautomation.com/t/null-values-in-namedquery/16946 "2020-12-31T17:15:37Z")
I have a named UPDATE Query to do an SQL INSERT. It works great when all parameters have values but, I get errors when passing NULL values to columns that allow Nulls. Columns in the table include: ... DATA\_TYPE, CHAR,… --- ## [\[Bug-1473\] Radio Group flickers when entering page when there is binding in props.index](https://forum.inductiveautomation.com/t/bug-1473-radio-group-flickers-when-entering-page-when-there-is-binding-in-props-index/41876)
**Author:** [@janne.p](https://forum.inductiveautomation.com/u/janne.p)\ **Replies:** 0\ **Last updated:** [December 31, 2020, 12:52pm UTC](https://forum.inductiveautomation.com/t/bug-1473-radio-group-flickers-when-entering-page-when-there-is-binding-in-props-index/41876 "2020-12-31T12:52:54Z")
After updating to new version of ignition (Version: 8.1.1 (b2020120808) ) there seems to be an interesting bug in Radio Group -control. If there is binding in props.index which sets the default value something else tha… --- ## [Number of perspective sessions](https://forum.inductiveautomation.com/t/number-of-perspective-sessions/32946)
**Author:** [@ankitkarwa21](https://forum.inductiveautomation.com/u/ankitkarwa21)\ **Replies:** 4\ **Last updated:** [December 31, 2020, 4:42pm UTC](https://forum.inductiveautomation.com/t/number-of-perspective-sessions/32946 "2020-12-31T16:42:13Z")
Is it possible to get the number of open perspective sessions (that can be seen in the gateway) in a tag or through a script? --- ## [Modbus read two register into one opc tag](https://forum.inductiveautomation.com/t/modbus-read-two-register-into-one-opc-tag/41858)
**Author:** [@SamuelsenLarsen](https://forum.inductiveautomation.com/u/SamuelsenLarsen)\ **Replies:** 6\ **Last updated:** [December 31, 2020, 2:52pm UTC](https://forum.inductiveautomation.com/t/modbus-read-two-register-into-one-opc-tag/41858 "2020-12-31T14:52:42Z")
Hi, I’m trying to read some values from a modbus TCP device. Some of the values are described as 2 word Long Interger in manual. When I set up OPC Ithem Path for the register that hold these values I use prefix HRI, but… --- ## [Fonts change when launched on a different machine](https://forum.inductiveautomation.com/t/fonts-change-when-launched-on-a-different-machine/41871)
**Author:** [@mashwin7991](https://forum.inductiveautomation.com/u/mashwin7991)\ **Replies:** 0\ **Last updated:** [December 31, 2020, 4:14am UTC](https://forum.inductiveautomation.com/t/fonts-change-when-launched-on-a-different-machine/41871 "2020-12-31T04:14:59Z")
Hi, I have installed the font I required to the windows settings. When launched the project in base server browser everything seems to be fine. But if I launch the URL in different server machine the font is different … --- ## [Playing a sound when alarms go active](https://forum.inductiveautomation.com/t/playing-a-sound-when-alarms-go-active/23603)
**Author:** [@michael\_goodman](https://forum.inductiveautomation.com/u/michael_goodman)\ **Replies:** 5\ **Last updated:** [December 30, 2020, 9:58pm UTC](https://forum.inductiveautomation.com/t/playing-a-sound-when-alarms-go-active/23603 "2020-12-30T21:58:20Z")
As everything I have found is from old posts, I figured I would reach out for any new ideas. I need an alarm to play, until acknowledged, for an active high priority alarm (HiHi & LoLo). I can add a tag event scrip for… --- ## [Motor Amps from Device Net to Rockwell SLC500 to Ignition](https://forum.inductiveautomation.com/t/motor-amps-from-device-net-to-rockwell-slc500-to-ignition/41867)
**Author:** [@will.allen](https://forum.inductiveautomation.com/u/will.allen)\ **Replies:** 1\ **Last updated:** [December 30, 2020, 9:46pm UTC](https://forum.inductiveautomation.com/t/motor-amps-from-device-net-to-rockwell-slc500-to-ignition/41867 "2020-12-30T21:46:07Z")
I would like to pull the voltage and amps from Device Net to SLC500 outputs and be able to bring in the OPC tags to show historical trends and be able to develop thresholds to warn or see fault history. I am setting up … --- ## [\[bug-13870\]Perspective Drop Down Background Color](https://forum.inductiveautomation.com/t/bug-13870-perspective-drop-down-background-color/25085)
**Author:** [@craigb](https://forum.inductiveautomation.com/u/craigb)\ **Replies:** 16\ **Last updated:** [December 30, 2020, 9:18pm UTC](https://forum.inductiveautomation.com/t/bug-13870-perspective-drop-down-background-color/25085 "2020-12-30T21:18:28Z")
I cant seem to figure out how to change the background color of the drop down as it sits with the default place holder. I’ve tried the ‘backgroundColor’ under all the different style options but none work. Am i missing… --- ## [Display PDF from Table in the PDF Viewer in Perspective](https://forum.inductiveautomation.com/t/display-pdf-from-table-in-the-pdf-viewer-in-perspective/41866)
**Author:** [@awarunek187](https://forum.inductiveautomation.com/u/awarunek187)\ **Replies:** 0\ **Last updated:** [December 30, 2020, 9:08pm UTC](https://forum.inductiveautomation.com/t/display-pdf-from-table-in-the-pdf-viewer-in-perspective/41866 "2020-12-30T21:08:38Z")
Is there a way to display a PDF that exists in my DB, by clicking on the row of the table component in Perspective without using the WebDev module and transform mapping? I can currently accomplish this by adding the pdf… --- ## [Best way to handle an opc tag that writes as a bool and comes back as string?](https://forum.inductiveautomation.com/t/best-way-to-handle-an-opc-tag-that-writes-as-a-bool-and-comes-back-as-string/41705)
**Author:** [@tmahaffey](https://forum.inductiveautomation.com/u/tmahaffey)\ **Replies:** 8\ **Last updated:** [December 30, 2020, 7:58pm UTC](https://forum.inductiveautomation.com/t/best-way-to-handle-an-opc-tag-that-writes-as-a-bool-and-comes-back-as-string/41705 "2020-12-30T19:58:59Z")
I think the title says it all. Any advice? --- ## [Indirect tag formatString](https://forum.inductiveautomation.com/t/indirect-tag-formatstring/41859)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 1\ **Last updated:** [December 30, 2020, 7:51pm UTC](https://forum.inductiveautomation.com/t/indirect-tag-formatstring/41859 "2020-12-30T19:51:15Z")
I’m trying to use my tags’ FormatString in my view’s indirect tags. I found a similar thread, Perspective Indirect formatting on a label, but haven’t figured it out yet. The following works up to step 3 but when I add t… --- ## [Complaints/annoyances about the new ignition designer in 8.1](https://forum.inductiveautomation.com/t/complaints-annoyances-about-the-new-ignition-designer-in-8-1/41864)
**Author:** [@tmahaffey](https://forum.inductiveautomation.com/u/tmahaffey)\ **Replies:** 4\ **Last updated:** [December 30, 2020, 7:46pm UTC](https://forum.inductiveautomation.com/t/complaints-annoyances-about-the-new-ignition-designer-in-8-1/41864 "2020-12-30T19:46:53Z")
Main annoyance - going between the scripting module and perspective modules. The project browser and the tag browser swap spots inside the designer when clicking between them. To me, this offeres absolutely no benefit, a… --- ## [system.util.invokeLater()](https://forum.inductiveautomation.com/t/system-util-invokelater/41663)
**Author:** [@ken.maze](https://forum.inductiveautomation.com/u/ken.maze)\ **Replies:** 5\ **Last updated:** [December 30, 2020, 6:49pm UTC](https://forum.inductiveautomation.com/t/system-util-invokelater/41663 "2020-12-30T18:49:27Z")
Hi, I am wanting to hide w text field until I need it, then make it visible and put it into focus. I am attempting to follow the advice at https://docs.inductiveautomation.com/display/DOC80/Focus+Manipulation#FocusMan… --- ## [How to find highest 3 value tags and print tag name to another display](https://forum.inductiveautomation.com/t/how-to-find-highest-3-value-tags-and-print-tag-name-to-another-display/41720)
**Author:** [@berkay.cinar](https://forum.inductiveautomation.com/u/berkay.cinar)\ **Replies:** 11\ **Last updated:** [December 30, 2020, 6:18pm UTC](https://forum.inductiveautomation.com/t/how-to-find-highest-3-value-tags-and-print-tag-name-to-another-display/41720 "2020-12-30T18:18:42Z")
Hello I am very new to ignition. Trying to figure out how can I find 3 highest value inside the tags I list and write the tag name to a display with its value to another display. To be more clear; In my project there a… --- ## [\[FEATURE-14162\] Loading Animation](https://forum.inductiveautomation.com/t/feature-14162-loading-animation/27189)
**Author:** [@andrea.morando](https://forum.inductiveautomation.com/u/andrea.morando)\ **Replies:** 6\ **Last updated:** [December 30, 2020, 5:33pm UTC](https://forum.inductiveautomation.com/t/feature-14162-loading-animation/27189 "2020-12-30T17:33:07Z")
Dear all, I need to implement a loading animation in Perspective, used for historical data views, for example. I would expect something like the loading animation you implemented for the Flex Repeater component. What i… --- ## [Web Browser Module -- "Failed to read DnsConfig"](https://forum.inductiveautomation.com/t/web-browser-module-failed-to-read-dnsconfig/17560)
**Author:** [@brian.kehn](https://forum.inductiveautomation.com/u/brian.kehn)\ **Replies:** 3\ **Last updated:** [December 30, 2020, 8:19am UTC](https://forum.inductiveautomation.com/t/web-browser-module-failed-to-read-dnsconfig/17560 "2020-12-30T08:19:12Z")
Ignition 7.9.5 Windows 10 x64 jre 1.8.0\_161 We recently added a web browser module to our application, and we're using it to show an SVG in the C:\\ Drive by pointing to a URL. The component does show the SVG, but in th… --- ## [Architecture for setup ignition for 3 millions tags](https://forum.inductiveautomation.com/t/architecture-for-setup-ignition-for-3-millions-tags/41747)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 0\ **Last updated:** [December 23, 2020, 5:58am UTC](https://forum.inductiveautomation.com/t/architecture-for-setup-ignition-for-3-millions-tags/41747 "2020-12-23T05:58:28Z")
Hi I want to get some idea what is the best practice to setup a hardware and software architecture to handle 3 millions tags with ignition. For example is it ok to run ignition on single peace on powerfull hardware? Or… --- ## [Setting Up Modbus](https://forum.inductiveautomation.com/t/setting-up-modbus/41763)
**Author:** [@brandon222](https://forum.inductiveautomation.com/u/brandon222)\ **Replies:** 27\ **Last updated:** [December 30, 2020, 6:01am UTC](https://forum.inductiveautomation.com/t/setting-up-modbus/41763 "2020-12-30T06:01:51Z")
I am having trouble setting up a modbus connection to Ignition 7. I have managed to get connection to it but when I look for a tag they all fail. Anyone know what I am doing wrong. I added the tag which is at 10.16.16… --- ## [\[BUG\] Vision Label text cut off at bottom despite ample room](https://forum.inductiveautomation.com/t/bug-vision-label-text-cut-off-at-bottom-despite-ample-room/41855)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 0\ **Last updated:** [December 30, 2020, 2:28am UTC](https://forum.inductiveautomation.com/t/bug-vision-label-text-cut-off-at-bottom-despite-ample-room/41855 "2020-12-30T02:28:04Z")
Not sure what’s going on here, but the text appears ok when I increase the height by 1px. There appears to be a top and bottom margin now in v8 between the text and the bounding box that acts as a clipping mask which w… --- ## [Gateway backup (gwbk file) large due to Internal Historian](https://forum.inductiveautomation.com/t/gateway-backup-gwbk-file-large-due-to-internal-historian/41854)
**Author:** [@shane.m.alexander](https://forum.inductiveautomation.com/u/shane.m.alexander)\ **Replies:** 0\ **Last updated:** [December 29, 2020, 10:31pm UTC](https://forum.inductiveautomation.com/t/gateway-backup-gwbk-file-large-due-to-internal-historian/41854 "2020-12-29T22:31:38Z")
I found that the gwbk file was getting larger over time for a project. I changed the .gwbk file to a .zip file and opened to find most of the disk space (147 of 170 MB) was in a history file: \\modules\\com.inductiveautoma… --- ## [Screen Swap Won't Work For a Specific Button](https://forum.inductiveautomation.com/t/screen-swap-wont-work-for-a-specific-button/41853)
**Author:** [@rrebro](https://forum.inductiveautomation.com/u/rrebro)\ **Replies:** 0\ **Last updated:** [December 29, 2020, 9:23pm UTC](https://forum.inductiveautomation.com/t/screen-swap-wont-work-for-a-specific-button/41853 "2020-12-29T21:23:56Z")
I have a whole panel of Buttons that swap to different screens. Everything works fine except for one specific Button, no matter what I do, It will not swap to the screen it is setup to swap to. I understand swap Screen g… --- ## [Using setButtonBG()](https://forum.inductiveautomation.com/t/using-setbuttonbg/41849)
**Author:** [@kwatkins](https://forum.inductiveautomation.com/u/kwatkins)\ **Replies:** 0\ **Last updated:** [December 29, 2020, 7:57pm UTC](https://forum.inductiveautomation.com/t/using-setbuttonbg/41849 "2020-12-29T19:57:05Z")
Trying to use the setButtonBG() to change the background color on a button. Keep getting errors on the color. What format do you need in the () to set the color? --- ## [system.db.dateFormat returning incorrect year](https://forum.inductiveautomation.com/t/system-db-dateformat-returning-incorrect-year/41846)
**Author:** [@jmonter](https://forum.inductiveautomation.com/u/jmonter)\ **Replies:** 0\ **Last updated:** [December 29, 2020, 5:44pm UTC](https://forum.inductiveautomation.com/t/system-db-dateformat-returning-incorrect-year/41846 "2020-12-29T17:44:51Z")
Hi, I have a script on Ignition 7.7.1 that is formatting the current gateway date into YYYY-MM-DD and it has been working fine until today. Its currently returning the 2020 year as 2021. objDate = system.tag.getTagValu… --- ## [The MQTT server is receiving the Info, just not passing it into tags](https://forum.inductiveautomation.com/t/the-mqtt-server-is-receiving-the-info-just-not-passing-it-into-tags/41804)
**Author:** [@arjunrajas](https://forum.inductiveautomation.com/u/arjunrajas)\ **Replies:** 11\ **Last updated:** [December 29, 2020, 5:29pm UTC](https://forum.inductiveautomation.com/t/the-mqtt-server-is-receiving-the-info-just-not-passing-it-into-tags/41804 "2020-12-29T17:29:21Z")
hi, I have connected to the mosquitto broker successfully with MQTT Engine and have also created a new namespace custom but when i check the tag browser no tag in created. when i check the log in Provider Logs in TRACE … --- ## [Removing duplicate rows from dataset](https://forum.inductiveautomation.com/t/removing-duplicate-rows-from-dataset/41844)
**Author:** [@hachjessed](https://forum.inductiveautomation.com/u/hachjessed)\ **Replies:** 1\ **Last updated:** [December 29, 2020, 5:28pm UTC](https://forum.inductiveautomation.com/t/removing-duplicate-rows-from-dataset/41844 "2020-12-29T17:28:39Z")
Beginning with a basic dataset, what would be the simplest way to remove duplicate rows of data? Input ds: ID Value 01 val1 02 val2 03 val3 01 val1 02 val2 02 val2 Desired output ds: ID Value 01 v… --- ## [Web API Scripting Help](https://forum.inductiveautomation.com/t/web-api-scripting-help/41566)
**Author:** [@cegge](https://forum.inductiveautomation.com/u/cegge)\ **Replies:** 15\ **Last updated:** [December 29, 2020, 5:11pm UTC](https://forum.inductiveautomation.com/t/web-api-scripting-help/41566 "2020-12-29T17:11:59Z")
Hello, I am having trouble with the Web Dev module, I am using the Python resource. In the drop down I have selected the doPatch. I cant find any examples of what my code should look like. Where do I place the code? I d… --- ## [Perspective Launcher Icon](https://forum.inductiveautomation.com/t/perspective-launcher-icon/41845)
**Author:** [@brownd18](https://forum.inductiveautomation.com/u/brownd18)\ **Replies:** 0\ **Last updated:** [December 29, 2020, 4:54pm UTC](https://forum.inductiveautomation.com/t/perspective-launcher-icon/41845 "2020-12-29T16:54:09Z")
In the gateway properties, there is an option to specify to use a launcher icon and according to the manual, it will show up in certain places. However, whenever I tell to use a photo it doesn’t do what it is intended to… --- ## [Timer series chart y-axis label vertical positioning](https://forum.inductiveautomation.com/t/timer-series-chart-y-axis-label-vertical-positioning/41841)
**Author:** [@mleefers](https://forum.inductiveautomation.com/u/mleefers)\ **Replies:** 0\ **Last updated:** [December 29, 2020, 3:26pm UTC](https://forum.inductiveautomation.com/t/timer-series-chart-y-axis-label-vertical-positioning/41841 "2020-12-29T15:26:21Z")
Hello, I have a pretty simple time series chart and I am trying to set the y-axis label’s vertical position to be in the middle of the the axis. When it renders, it automatically puts it at the top of the axis and I can… --- ## [Modbus RTU over UDP/IP?](https://forum.inductiveautomation.com/t/modbus-rtu-over-udp-ip/41823)
**Author:** [@Tom.R](https://forum.inductiveautomation.com/u/Tom.R)\ **Replies:** 1\ **Last updated:** [December 29, 2020, 3:25pm UTC](https://forum.inductiveautomation.com/t/modbus-rtu-over-udp-ip/41823 "2020-12-29T15:25:47Z")
I am looking into acquiring some data on a couple of compressors in our shop. After looking through the controllers manual I have found that I need to purchase an optional comms module. They are stating that their commun… --- ## [Edit PDFs in Perspective](https://forum.inductiveautomation.com/t/edit-pdfs-in-perspective/41821)
**Author:** [@awarunek187](https://forum.inductiveautomation.com/u/awarunek187)\ **Replies:** 3\ **Last updated:** [December 29, 2020, 3:02pm UTC](https://forum.inductiveautomation.com/t/edit-pdfs-in-perspective/41821 "2020-12-29T15:02:57Z")
I am trying to figure out how to edit PDFs in Perspective. I am using the Upload Component to upload my PDFs into a table. I am then using the WebDev Module to grab the file path for the PDF, from selecting the filename … [Previous page](https://forum.inductiveautomation.com/latest.md?page=1245) [Next page](https://forum.inductiveautomation.com/latest.md?page=1247)