# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1318 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1319 --- ## [Power Table configureCell intermittently returns the wrong result for up to the entire table](https://forum.inductiveautomation.com/t/power-table-configurecell-intermittently-returns-the-wrong-result-for-up-to-the-entire-table/37338)
**Author:** [@liam.mcglaughlin](https://forum.inductiveautomation.com/u/liam.mcglaughlin)\ **Replies:** 6\ **Last updated:** [August 6, 2020, 1:03pm UTC](https://forum.inductiveautomation.com/t/power-table-configurecell-intermittently-returns-the-wrong-result-for-up-to-the-entire-table/37338 "2020-08-06T13:03:11Z")
I have a power table that has an issue with the formatting. The table has a column with timestamps, 10 value columns, then 2 limit columns. The configure cell code (below) should reference the limit columns for the value… --- ## [onClick Barcode scan in Ipad](https://forum.inductiveautomation.com/t/onclick-barcode-scan-in-ipad/37449)
**Author:** [@dtr019](https://forum.inductiveautomation.com/u/dtr019)\ **Replies:** 0\ **Last updated:** [August 6, 2020, 12:10pm UTC](https://forum.inductiveautomation.com/t/onclick-barcode-scan-in-ipad/37449 "2020-08-06T12:10:48Z")
Hi, We are on Ignition 8.0.15 and trying to set up barcode scanning in Perspective on an Ipad mini 4. We followed the example under Perspective session event scripts on the ignition website but the button is not doing a… --- ## [After hitting Enter Key have focus on button in perspective view](https://forum.inductiveautomation.com/t/after-hitting-enter-key-have-focus-on-button-in-perspective-view/37370)
**Author:** [@dholt](https://forum.inductiveautomation.com/u/dholt)\ **Replies:** 1\ **Last updated:** [August 6, 2020, 11:46am UTC](https://forum.inductiveautomation.com/t/after-hitting-enter-key-have-focus-on-button-in-perspective-view/37370 "2020-08-06T11:46:46Z")
Greetings; It’s me again lol. Quick question is it possible to have it set so that when the “Enter” key is pressed in a text field it automatically targets a corresponding button? Case in point I have users on the floor … --- ## [Which brand PLC's play best with Ignition?](https://forum.inductiveautomation.com/t/which-brand-plcs-play-best-with-ignition/36181)
**Author:** [@brett.muller](https://forum.inductiveautomation.com/u/brett.muller)\ **Replies:** 26\ **Last updated:** [August 6, 2020, 11:32am UTC](https://forum.inductiveautomation.com/t/which-brand-plcs-play-best-with-ignition/36181 "2020-08-06T11:32:41Z")
Hi, I run Ignition with a GE RX3i PLC and 15 remote I/O racks plus one Siemens PLC (in an OEM package) in a pilot plant/laboratory environment that I own. I am looking to specify Ignition as the SCADA system for a full … --- ## [EasyChart DB Pen Diagnostic Time column is not indexed](https://forum.inductiveautomation.com/t/easychart-db-pen-diagnostic-time-column-is-not-indexed/37444)
**Author:** [@Yfactor](https://forum.inductiveautomation.com/u/Yfactor)\ **Replies:** 2\ **Last updated:** [August 6, 2020, 10:55am UTC](https://forum.inductiveautomation.com/t/easychart-db-pen-diagnostic-time-column-is-not-indexed/37444 "2020-08-06T10:55:53Z")
Hi there, Can anyone help me understand what is wrong with the t\_stamp column I am trying to use for my DB Pen please? I ran the diagnostic and I got this not indexed message. and basically an error on the chart. the t… --- ## [Perspective dropdown text alignment](https://forum.inductiveautomation.com/t/perspective-dropdown-text-alignment/37447)
**Author:** [@djones](https://forum.inductiveautomation.com/u/djones)\ **Replies:** 1\ **Last updated:** [August 6, 2020, 10:40am UTC](https://forum.inductiveautomation.com/t/perspective-dropdown-text-alignment/37447 "2020-08-06T10:40:41Z")
I cannot seem to figure out how to center text on a dropdown component in perspective. The props.syle and props.dropdownOptionStyle don’t seem to do anything. v8.0.15 --- ## [\[BUG-16628\] DateTimes within UDT's are reset on Gateway Restart](https://forum.inductiveautomation.com/t/bug-16628-datetimes-within-udts-are-reset-on-gateway-restart/35508)
**Author:** [@md.szyman](https://forum.inductiveautomation.com/u/md.szyman)\ **Replies:** 4\ **Last updated:** [August 6, 2020, 4:49am UTC](https://forum.inductiveautomation.com/t/bug-16628-datetimes-within-udts-are-reset-on-gateway-restart/35508 "2020-08-06T04:49:18Z")
I’ve sent this as a support request but figured I’d post it here too just in case that helps. I am running Ignition Gateway version 8.0.12 (b2020042115). The gateway is running on Xubuntu Linux 20.04. The bug I’m exper… --- ## [Ignition Transmission module issue](https://forum.inductiveautomation.com/t/ignition-transmission-module-issue/31551)
**Author:** [@dushyant.gurumukhi](https://forum.inductiveautomation.com/u/dushyant.gurumukhi)\ **Replies:** 2\ **Last updated:** [August 6, 2020, 4:33am UTC](https://forum.inductiveautomation.com/t/ignition-transmission-module-issue/31551 "2020-08-06T04:33:36Z")
Hi All, In our Ignition (version 7.9.13) we are facing the below issue if anyone has any solution or suggestion please let us know. MQTT Transmission is not getting connected to the external MQTT server (custom creat… --- ## [Scripting library for MQTT modules](https://forum.inductiveautomation.com/t/scripting-library-for-mqtt-modules/36681)
**Author:** [@smcfarlane](https://forum.inductiveautomation.com/u/smcfarlane)\ **Replies:** 2\ **Last updated:** [August 6, 2020, 3:55am UTC](https://forum.inductiveautomation.com/t/scripting-library-for-mqtt-modules/36681 "2020-08-06T03:55:17Z")
Is there a scripting library for the MQTT modules from Cirrus? Their documentation has a couple of how-tos but I can’t find a list of all the functions available like in the Ignition manual. https://docs.chariot.io/disp… --- ## [Error box popup in designer - Takes focus!](https://forum.inductiveautomation.com/t/error-box-popup-in-designer-takes-focus/37439)
**Author:** [@joshdunstan](https://forum.inductiveautomation.com/u/joshdunstan)\ **Replies:** 3\ **Last updated:** [August 6, 2020, 2:34am UTC](https://forum.inductiveautomation.com/t/error-box-popup-in-designer-takes-focus/37439 "2020-08-06T02:34:15Z")
Hi, I’ve noticed over the last few updates that the error box in the designer pops up and takes focus for every active error… it can’t be ignored and fall away and be left in the background. Absolutely maddening! Any e… --- ## [Prepared Statements](https://forum.inductiveautomation.com/t/prepared-statements/1093)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 6\ **Last updated:** [August 6, 2020, 1:55am UTC](https://forum.inductiveautomation.com/t/prepared-statements/1093 "2020-08-06T01:55:42Z")
I have been reading in the manual about prepared statements and still do not quite understand when they should be used. Which of the following queries are better and why? userText = event.source.parent.getComponent("T… --- ## [Show a boolean tag history on sparkline](https://forum.inductiveautomation.com/t/show-a-boolean-tag-history-on-sparkline/27111)
**Author:** [@mcarritt1](https://forum.inductiveautomation.com/u/mcarritt1)\ **Replies:** 1\ **Last updated:** [August 5, 2020, 11:19pm UTC](https://forum.inductiveautomation.com/t/show-a-boolean-tag-history-on-sparkline/27111 "2020-08-05T23:19:41Z")
Is there anyway to get a sparkline to show boolean tag history like the easy chart does in this picture? I’ve tried messing around with the system.tag.queryTagHistory() bound to the sparkline data, but can’t get it. --- ## [Visible Binding - Using Expression type binding to search for key word in string](https://forum.inductiveautomation.com/t/visible-binding-using-expression-type-binding-to-search-for-key-word-in-string/37428)
**Author:** [@paulm1](https://forum.inductiveautomation.com/u/paulm1)\ **Replies:** 4\ **Last updated:** [August 5, 2020, 9:59pm UTC](https://forum.inductiveautomation.com/t/visible-binding-using-expression-type-binding-to-search-for-key-word-in-string/37428 "2020-08-05T21:59:12Z")
I have a drop down that is populated the following query. SELECT '%' AS Value,"Select Container" UNION Select CONCAT\_WS(' ', style, type) AS Value, CONCAT\_WS(' ', style, type) AS Label FROM container ORDER BY Value ASC … --- ## [On Call "Case Study"](https://forum.inductiveautomation.com/t/on-call-case-study/7373)
**Author:** [@tomt](https://forum.inductiveautomation.com/u/tomt)\ **Replies:** 8\ **Last updated:** [August 5, 2020, 9:20pm UTC](https://forum.inductiveautomation.com/t/on-call-case-study/7373 "2020-08-05T21:20:15Z")
I'll call this a case study because that's kind of what it looks like. There is no code (sorry - there isn't much to see anyway), but rather a dialog of how we made it work. I hope this helps others build something, an… --- ## [Dynamic 2D profile](https://forum.inductiveautomation.com/t/dynamic-2d-profile/37180)
**Author:** [@john.eichler](https://forum.inductiveautomation.com/u/john.eichler)\ **Replies:** 2\ **Last updated:** [August 5, 2020, 8:09pm UTC](https://forum.inductiveautomation.com/t/dynamic-2d-profile/37180 "2020-08-05T20:09:17Z")
Hi All I have a series of XY co-ordinates in SQL. I would like to plot a 2D profile by drawing lines between each point. e.g. Is it possible to display a dynamic 2D profile in ignition? A quick internet search brings… --- ## [InstanceName Parameter of UDT Tag Containing UDT Instances not Populating Correctly](https://forum.inductiveautomation.com/t/instancename-parameter-of-udt-tag-containing-udt-instances-not-populating-correctly/37394)
**Author:** [@jacob.marcum](https://forum.inductiveautomation.com/u/jacob.marcum)\ **Replies:** 2\ **Last updated:** [August 5, 2020, 7:22pm UTC](https://forum.inductiveautomation.com/t/instancename-parameter-of-udt-tag-containing-udt-instances-not-populating-correctly/37394 "2020-08-05T19:22:07Z")
I’m using Ignition version 8.0.14. I’ve created multiple UDT tags and placed instances of them within a parent UDT. When populating the InstanceName parameter of the parent UDT into a value of one of the UDT instance’s p… --- ## [\[Bug-16909\]Date Picker: previous month ending day numbers are incorrect](https://forum.inductiveautomation.com/t/bug-16909-date-picker-previous-month-ending-day-numbers-are-incorrect/37411)
**Author:** [@jkuhn](https://forum.inductiveautomation.com/u/jkuhn)\ **Replies:** 0\ **Last updated:** [August 5, 2020, 4:32pm UTC](https://forum.inductiveautomation.com/t/bug-16909-date-picker-previous-month-ending-day-numbers-are-incorrect/37411 "2020-08-05T16:32:45Z")
Not 100% sure this is Maker specific, but when using a date picker in Perspective runtime on my phone and looking at August 2020, it shows the last few days of July, but incorrectly counts back from 30 instead of 31. Th… --- ## [Database user source in manual mode, looking for more detail](https://forum.inductiveautomation.com/t/database-user-source-in-manual-mode-looking-for-more-detail/37376)
**Author:** [@pdixon](https://forum.inductiveautomation.com/u/pdixon)\ **Replies:** 5\ **Last updated:** [August 5, 2020, 6:51pm UTC](https://forum.inductiveautomation.com/t/database-user-source-in-manual-mode-looking-for-more-detail/37376 "2020-08-05T18:51:28Z")
I am not finding a lot of detail in setting up a database user source in manual mode. I have a table in my database that I can display in Perspective when I use the internal user source to log in. When I change the … --- ## [Syntax error on Ignition 7.9.6 when writing simple code](https://forum.inductiveautomation.com/t/syntax-error-on-ignition-7-9-6-when-writing-simple-code/36647)
**Author:** [@kade.castille](https://forum.inductiveautomation.com/u/kade.castille)\ **Replies:** 4\ **Last updated:** [July 13, 2020, 5:04pm UTC](https://forum.inductiveautomation.com/t/syntax-error-on-ignition-7-9-6-when-writing-simple-code/36647 "2020-07-13T17:04:05Z")
Hello, I am trying to write a code that enables the visibility of a button if the machine being used matches a certain IP address using an if/else statement. I’m getting a syntax error on the first line, it doesn’t like… --- ## [Stroke line animations in perspective](https://forum.inductiveautomation.com/t/stroke-line-animations-in-perspective/29909)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 2\ **Last updated:** [August 5, 2020, 6:12pm UTC](https://forum.inductiveautomation.com/t/stroke-line-animations-in-perspective/29909 "2020-08-05T18:12:32Z")
Hello I'd like to animate a SVG stroke line in perspective with CSS3 like this: .path { stroke-dasharray: 1000; stroke-dashoffset: 1000; animation: dash 5s linear forwards; } @keyframes dash { to { strok… --- ## [Web Dev Mounted Folder UNC path not working as Perspective Video Player source](https://forum.inductiveautomation.com/t/web-dev-mounted-folder-unc-path-not-working-as-perspective-video-player-source/37415)
**Author:** [@YF129701](https://forum.inductiveautomation.com/u/YF129701)\ **Replies:** 2\ **Last updated:** [August 5, 2020, 5:59pm UTC](https://forum.inductiveautomation.com/t/web-dev-mounted-folder-unc-path-not-working-as-perspective-video-player-source/37415 "2020-08-05T17:59:07Z")
I’m trying to build out a view where a user can upload files, see them in a table, click on them in a table and get a preview of the media they uploaded (image, video, etc). As the title says, I’m trying to set the sourc… --- ## [Problem Tag array](https://forum.inductiveautomation.com/t/problem-tag-array/37416)
**Author:** [@eric.avila](https://forum.inductiveautomation.com/u/eric.avila)\ **Replies:** 0\ **Last updated:** [August 5, 2020, 5:46pm UTC](https://forum.inductiveautomation.com/t/problem-tag-array/37416 "2020-08-05T17:46:48Z")
Hi, I have a tag with a query of type String Array, this tag needs other tag to make a query like: SELECT CAUSA FROM \[DBB\].\[dbo\].\[table1\] inner join \[table2\] on \[table1\].id=table2.id where text in ({\[.\]tagId.value}) … --- ## [Managing multiple asynchronous threads](https://forum.inductiveautomation.com/t/managing-multiple-asynchronous-threads/37185)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 8\ **Last updated:** [August 5, 2020, 1:39pm UTC](https://forum.inductiveautomation.com/t/managing-multiple-asynchronous-threads/37185 "2020-08-05T13:39:00Z")
I've followed this post for monitoring a directory for file changes and I think I have created more than one watch service in different threads. How do I monitor, manage, and delete these threads? --- ## [Update progress bar from within a script](https://forum.inductiveautomation.com/t/update-progress-bar-from-within-a-script/21995)
**Author:** [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Replies:** 8\ **Last updated:** [August 5, 2020, 4:22pm UTC](https://forum.inductiveautomation.com/t/update-progress-bar-from-within-a-script/21995 "2020-08-05T16:22:43Z")
I have this script on a button to copy data to a PLC from a database. Since this script takes 10 - 20 seconds to run, i would like to have the progress bar show progress. Issue I have is the progress bar updates only whe… --- ## [Data Loss MySQL Ignition History](https://forum.inductiveautomation.com/t/data-loss-mysql-ignition-history/37402)
**Author:** [@albetro.15](https://forum.inductiveautomation.com/u/albetro.15)\ **Replies:** 12\ **Last updated:** [August 5, 2020, 4:17pm UTC](https://forum.inductiveautomation.com/t/data-loss-mysql-ignition-history/37402 "2020-08-05T16:17:49Z")
Hi, Today I discovered that when I try to access the data from some tags in July the data is missing. The configuration has been kept the same all along but all the sabed data using ignition native history mode is missi… --- ## [system.util.invokeAsynchronous for perspective GUI](https://forum.inductiveautomation.com/t/system-util-invokeasynchronous-for-perspective-gui/37342)
**Author:** [@zacht](https://forum.inductiveautomation.com/u/zacht)\ **Replies:** 7\ **Last updated:** [August 5, 2020, 3:53pm UTC](https://forum.inductiveautomation.com/t/system-util-invokeasynchronous-for-perspective-gui/37342 "2020-08-05T15:53:23Z")
Does this warning from the documentation for system.util.invokeAsynchronous apply in Perspective? I ask because system.util.invokeLater isn’t usable. I think it should be ok based on some other posts I’ve read and th… --- ## [Getting following error while accessing document through URL using Web Browser Component](https://forum.inductiveautomation.com/t/getting-following-error-while-accessing-document-through-url-using-web-browser-component/37406)
**Author:** [@rushikesh.jadhav](https://forum.inductiveautomation.com/u/rushikesh.jadhav)\ **Replies:** 1\ **Last updated:** [August 5, 2020, 3:23pm UTC](https://forum.inductiveautomation.com/t/getting-following-error-while-accessing-document-through-url-using-web-browser-component/37406 "2020-08-05T15:23:08Z")
08:09:31 SEVERE: The NetworkDelegate.onBeforeURLRequest() method has thrown exception: java.lang.IllegalArgumentException: URLDecoder: Illegal hex characters in escape (%) pattern - Error at index 1 in: “d,” at java.ba… --- ## [Initialize datetimepicker value](https://forum.inductiveautomation.com/t/initialize-datetimepicker-value/37404)
**Author:** [@Tstanford](https://forum.inductiveautomation.com/u/Tstanford)\ **Replies:** 2\ **Last updated:** [August 5, 2020, 3:07pm UTC](https://forum.inductiveautomation.com/t/initialize-datetimepicker-value/37404 "2020-08-05T15:07:42Z")
I want to initialize a set of datetimepickers with the previous days shift start times when the view loads but then allow the user to change it afterwards. I was wondering if there was a simple clean way to do this? I … --- ## [Dropdown vision](https://forum.inductiveautomation.com/t/dropdown-vision/37390)
**Author:** [@malejandroreyes](https://forum.inductiveautomation.com/u/malejandroreyes)\ **Replies:** 4\ **Last updated:** [August 5, 2020, 3:07pm UTC](https://forum.inductiveautomation.com/t/dropdown-vision/37390 "2020-08-05T15:07:05Z")
Hi I´m using a dropdown list as data filter, but now I want to filtrate data making a comparison as \>, \< or equal, is this possible? Thanks --- ## [Too many sessions on Ignition OPC UA Server](https://forum.inductiveautomation.com/t/too-many-sessions-on-ignition-opc-ua-server/37399)
**Author:** [@eoursel](https://forum.inductiveautomation.com/u/eoursel)\ **Replies:** 4\ **Last updated:** [August 5, 2020, 2:47pm UTC](https://forum.inductiveautomation.com/t/too-many-sessions-on-ignition-opc-ua-server/37399 "2020-08-05T14:47:31Z")
Hi I am trying to connect to the Ignition OPC UA server (standard Gateway not edge) from a remote machine with an UA Client. I tried with UAExpert and i have a BadTooManySessions error on UaExpert Log. Is there a conf… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1317) [Next page](https://forum.inductiveautomation.com/latest.md?page=1319)