# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=968 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 969 --- ## [\[Bug-2887\] Named Query throws exception on commented out UDF](https://forum.inductiveautomation.com/t/bug-2887-named-query-throws-exception-on-commented-out-udf/50430)
**Author:** [@Tim.Johnson](https://forum.inductiveautomation.com/u/Tim.Johnson)\ **Replies:** 1\ **Last updated:** [August 30, 2021, 4:16pm UTC](https://forum.inductiveautomation.com/t/bug-2887-named-query-throws-exception-on-commented-out-udf/50430 "2021-08-30T16:16:58Z")
So here’s an interesting one. This one had me scratching my head for a while… Here’s a simple Named Query with a UDF that returns a DateTime: SELECT :dateValue AS TestDate ,FORMAT(dbo.udf\_WeekEnding(:dateValue), 'yyy… --- ## [Error running action 'dom.onClick' NameError: global name 'strip' is not defined](https://forum.inductiveautomation.com/t/error-running-action-dom-onclick-nameerror-global-name-strip-is-not-defined/50438)
**Author:** [@Kfoldesi](https://forum.inductiveautomation.com/u/Kfoldesi)\ **Replies:** 14\ **Last updated:** [August 30, 2021, 4:13pm UTC](https://forum.inductiveautomation.com/t/error-running-action-dom-onclick-nameerror-global-name-strip-is-not-defined/50438 "2021-08-30T16:13:37Z")
Trying to use Python .strip() when cleaning data from a perspective form. Script runs on a \[Create\] button on the form. Anyone know why the I can’t use this command? --- ## [Perspective xychart issue](https://forum.inductiveautomation.com/t/perspective-xychart-issue/50445)
**Author:** [@r.pallares](https://forum.inductiveautomation.com/u/r.pallares)\ **Replies:** 0\ **Last updated:** [August 30, 2021, 3:42pm UTC](https://forum.inductiveautomation.com/t/perspective-xychart-issue/50445 "2021-08-30T15:42:12Z")
I’m trying to get an XYChat compnent to display date on the xaxis and time on the yaxis. I’ve managed to get the xaxis to display the date(I’m doing it in column style) but for the yaxis I can’t get it to display time. I… --- ## [3rd Part OPC Server Tag Quality Issue](https://forum.inductiveautomation.com/t/3rd-part-opc-server-tag-quality-issue/50442)
**Author:** [@bmyers](https://forum.inductiveautomation.com/u/bmyers)\ **Replies:** 5\ **Last updated:** [August 30, 2021, 3:41pm UTC](https://forum.inductiveautomation.com/t/3rd-part-opc-server-tag-quality-issue/50442 "2021-08-30T15:41:47Z")
I am using a 3rd party OPC server from OTTO Motors, whenever I write to a tag the quality goes from good to unknown and back to good. Any thoughts what I could look at to elimate ? The scanclass is 1500ms, OPC data mode… --- ## [Specifying Modules on Gateway Docker Compose](https://forum.inductiveautomation.com/t/specifying-modules-on-gateway-docker-compose/50361)
**Author:** [@kissamcorrina](https://forum.inductiveautomation.com/u/kissamcorrina)\ **Replies:** 3\ **Last updated:** [August 30, 2021, 3:06pm UTC](https://forum.inductiveautomation.com/t/specifying-modules-on-gateway-docker-compose/50361 "2021-08-30T15:06:35Z")
I noticed on @kcollins1 Docker Hub, there’s an environment variable to specify the which modules are enabled GATEWAY\_MODULES\_ENABLED. Is there any way to accomplish this with the Inductive’s Docker Hub? Restoring a gate… --- ## ["system.gui.transform" does not respect layout in container](https://forum.inductiveautomation.com/t/system-gui-transform-does-not-respect-layout-in-container/50436)
**Author:** [@informatica](https://forum.inductiveautomation.com/u/informatica)\ **Replies:** 1\ **Last updated:** [August 30, 2021, 1:35pm UTC](https://forum.inductiveautomation.com/t/system-gui-transform-does-not-respect-layout-in-container/50436 "2021-08-30T13:35:46Z")
Good afternoon. In Ignition 8.0.14, I have created a container and I have inserted an instance of a template at the bottom. I have configured the layout of the template instance so that when resizing the container, the… --- ## [\[Annoyance\] 8.1.9 Style Editor window doesn't have title bar](https://forum.inductiveautomation.com/t/annoyance-8-1-9-style-editor-window-doesnt-have-title-bar/50424)
**Author:** [@peter](https://forum.inductiveautomation.com/u/peter)\ **Replies:** 2\ **Last updated:** [August 30, 2021, 1:05pm UTC](https://forum.inductiveautomation.com/t/annoyance-8-1-9-style-editor-window-doesnt-have-title-bar/50424 "2021-08-30T13:05:24Z")
This is with 8.1.9 running under Ubuntu 20.04.3 LTS When I invoke the style editor on a style defined under the Styles node of the project browser, the editor window has a title bar that allows me to drag the windows ar… --- ## [Changing color/text of Momentary button based on indicator value](https://forum.inductiveautomation.com/t/changing-color-text-of-momentary-button-based-on-indicator-value/50375)
**Author:** [@jeff.ryan](https://forum.inductiveautomation.com/u/jeff.ryan)\ **Replies:** 2\ **Last updated:** [August 30, 2021, 12:40pm UTC](https://forum.inductiveautomation.com/t/changing-color-text-of-momentary-button-based-on-indicator-value/50375 "2021-08-30T12:40:02Z")
I’ve seen a couple of previous posts that are close, but nothing that has got me quite there yet, but if I want to change the state, the color/text of a Momentary button, based on an indicator value? What is the best wa… --- ## [Power Table with three dropdowns](https://forum.inductiveautomation.com/t/power-table-with-three-dropdowns/33874)
**Author:** [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Replies:** 21\ **Last updated:** [August 30, 2021, 4:00am UTC](https://forum.inductiveautomation.com/t/power-table-with-three-dropdowns/33874 "2021-08-30T04:00:00Z")
In the Power table is it possible to have ONLY, for example, THREE dropdowns in the column? Like in this example from somewhere else, not Ignition… I can create dropdowns in the configureEditor, but only for the ent… --- ## [Issue in query result from database](https://forum.inductiveautomation.com/t/issue-in-query-result-from-database/50234)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 1\ **Last updated:** [August 24, 2021, 4:50pm UTC](https://forum.inductiveautomation.com/t/issue-in-query-result-from-database/50234 "2021-08-24T16:50:29Z")
Hi, I have column called data ( datatype - numeric) value in column = 0.000000000000000000000004567 when i query the column from database i am getting only 0 digit after float is not showing when i query please any… --- ## [Slow response on my tags approx 5 seconds](https://forum.inductiveautomation.com/t/slow-response-on-my-tags-approx-5-seconds/50423)
**Author:** [@craigdugal185](https://forum.inductiveautomation.com/u/craigdugal185)\ **Replies:** 3\ **Last updated:** [August 29, 2021, 4:41pm UTC](https://forum.inductiveautomation.com/t/slow-response-on-my-tags-approx-5-seconds/50423 "2021-08-29T16:41:26Z")
I am having issues with my tags being delayed by about 5 seconds. If anyone can help running 8.1.9. Thanks, Craig Dugal --- ## [Return Last N records from Tag Historian Query](https://forum.inductiveautomation.com/t/return-last-n-records-from-tag-historian-query/50346)
**Author:** [@knadiminti](https://forum.inductiveautomation.com/u/knadiminti)\ **Replies:** 4\ **Last updated:** [August 28, 2021, 10:25pm UTC](https://forum.inductiveautomation.com/t/return-last-n-records-from-tag-historian-query/50346 "2021-08-28T22:25:43Z")
Is there any way to retrieve last N records from tag historian tables? I would like to retrieve the data as is without applying any aggregations. One alternative is to query the tables directly but as the tables are par… --- ## [Perspective data - bandwidth usage?](https://forum.inductiveautomation.com/t/perspective-data-bandwidth-usage/50416)
**Author:** [@rpavlicek](https://forum.inductiveautomation.com/u/rpavlicek)\ **Replies:** 0\ **Last updated:** [August 28, 2021, 8:09pm UTC](https://forum.inductiveautomation.com/t/perspective-data-bandwidth-usage/50416 "2021-08-28T20:09:15Z")
We are beginning to develop with Perspective for mobile app usage, and we have a very simple data entry form right now. My concern is the amount of data usage I’m seeing. It seems to mostly come from the initial project … --- ## [Trying to install Ignition 8.1 on Win 10 Laptop](https://forum.inductiveautomation.com/t/trying-to-install-ignition-8-1-on-win-10-laptop/50410)
**Author:** [@TetonManDan](https://forum.inductiveautomation.com/u/TetonManDan)\ **Replies:** 0\ **Last updated:** [August 28, 2021, 4:49pm UTC](https://forum.inductiveautomation.com/t/trying-to-install-ignition-8-1-on-win-10-laptop/50410 "2021-08-28T16:49:22Z")
Trying to install Ignition 8.1 and it has a message “Gateway backup cannot be created because the gateway is not running Would you like to continue the install?” No / Yes, clicked yes At the end of install the following… --- ## [Documentation bug in module icons linking to descriptions](https://forum.inductiveautomation.com/t/documentation-bug-in-module-icons-linking-to-descriptions/50407)
**Author:** [@peter](https://forum.inductiveautomation.com/u/peter)\ **Replies:** 0\ **Last updated:** [August 28, 2021, 2:43pm UTC](https://forum.inductiveautomation.com/t/documentation-bug-in-module-icons-linking-to-descriptions/50407 "2021-08-28T14:43:10Z")
I just discovered a weird bug in the online documentation for 8.1 when browsing via OS X 11.4, Safari 14.1.1 In this page: Core Modules The icons for each of the core modules are also links to that modules description.… --- ## [V8.1.9 Maker connection to MS Access DB](https://forum.inductiveautomation.com/t/v8-1-9-maker-connection-to-ms-access-db/50403)
**Author:** [@ymontero](https://forum.inductiveautomation.com/u/ymontero)\ **Replies:** 0\ **Last updated:** [August 28, 2021, 2:40am UTC](https://forum.inductiveautomation.com/t/v8-1-9-maker-connection-to-ms-access-db/50403 "2021-08-28T02:40:45Z")
Good evening friends, I know this is a bit old issue but I need your possible assistance. I am using version 8.1.9 of Ignition Maker and for a personal project, I want to connect to Ms Access. I understand that these l… --- ## [Missing "undo" for many actions makes development extremely difficult](https://forum.inductiveautomation.com/t/missing-undo-for-many-actions-makes-development-extremely-difficult/49160)
**Author:** [@ordosays](https://forum.inductiveautomation.com/u/ordosays)\ **Replies:** 6\ **Last updated:** [August 27, 2021, 10:54pm UTC](https://forum.inductiveautomation.com/t/missing-undo-for-many-actions-makes-development-extremely-difficult/49160 "2021-08-27T22:54:10Z")
I found a previous thread about undo being notoriously inconsistent, but really found a nasty one while working with complex SVG’s. Deleting an element is not undo-able. Now imagine you accidentally delete an element or … --- ## [Perspective App issue on Android 7 device](https://forum.inductiveautomation.com/t/perspective-app-issue-on-android-7-device/50254)
**Author:** [@cnevalga](https://forum.inductiveautomation.com/u/cnevalga)\ **Replies:** 5\ **Last updated:** [August 27, 2021, 9:38pm UTC](https://forum.inductiveautomation.com/t/perspective-app-issue-on-android-7-device/50254 "2021-08-27T21:38:22Z")
Hi! We are encountering an issue in the perspective app for android on device running on android 7. Project is stuck at the loading screen when trying to load a project. We are authenticating users through active di… --- ## [\[IGN-2495\] Directing a User to a URL depending on login in Perspective](https://forum.inductiveautomation.com/t/ign-2495-directing-a-user-to-a-url-depending-on-login-in-perspective/50398)
**Author:** [@mark.dowd](https://forum.inductiveautomation.com/u/mark.dowd)\ **Replies:** 1\ **Last updated:** [August 27, 2021, 9:13pm UTC](https://forum.inductiveautomation.com/t/ign-2495-directing-a-user-to-a-url-depending-on-login-in-perspective/50398 "2021-08-27T21:13:07Z")
I would like to know how to direct a user to a specific URL after logging in. Is this possible? Example : User A would like to see “Widget Production Page” after logging in. User B would like to see “Johnson Rods Page” … --- ## [Multiple Lines Same Backend?](https://forum.inductiveautomation.com/t/multiple-lines-same-backend/50396)
**Author:** [@jbpingston](https://forum.inductiveautomation.com/u/jbpingston)\ **Replies:** 1\ **Last updated:** [August 27, 2021, 7:45pm UTC](https://forum.inductiveautomation.com/t/multiple-lines-same-backend/50396 "2021-08-27T19:45:14Z")
Hello, I am setting up database connection for a system that has multiple lines. I am using postgreSQL and the PLCs on each line have the same IP address.Line 1 plc is 10.0.0.112, Line 2 plc is 10.0.0.112, Line 3 plc is… --- ## [Using buttons to navigate through a database in a window?](https://forum.inductiveautomation.com/t/using-buttons-to-navigate-through-a-database-in-a-window/50394)
**Author:** [@Brit](https://forum.inductiveautomation.com/u/Brit)\ **Replies:** 2\ **Last updated:** [August 27, 2021, 7:35pm UTC](https://forum.inductiveautomation.com/t/using-buttons-to-navigate-through-a-database-in-a-window/50394 "2021-08-27T19:35:08Z")
Hi, I’m trying to figure out if there is a way to navigate between rows in a database using buttons on a window. Below is an example of what it looks like. The idea is that the data in the row is shown in the middle and … --- ## [Connectring to Pi](https://forum.inductiveautomation.com/t/connectring-to-pi/50391)
**Author:** [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\ **Replies:** 3\ **Last updated:** [August 27, 2021, 5:49pm UTC](https://forum.inductiveautomation.com/t/connectring-to-pi/50391 "2021-08-27T17:49:13Z")
Hello all! We need to connect Ignition to a Pi server using OPC-HDA. I have 2 redundant gateways (8.1.3). How would you proceed? 1- Install the Pi OPC-HDA bridge on both Ignition server. No need to configure DCOM sin… --- ## [IHM blocked if diagnostics popup is opened and messageBox](https://forum.inductiveautomation.com/t/ihm-blocked-if-diagnostics-popup-is-opened-and-messagebox/7132)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 11\ **Last updated:** [August 27, 2021, 3:44pm UTC](https://forum.inductiveautomation.com/t/ihm-blocked-if-diagnostics-popup-is-opened-and-messagebox/7132 "2021-08-27T15:44:01Z")
Ignition 7.6.2 Win 7. when the standard "Help/diagnostics popup" is opened in the vision client, if we click on a button on windows with a system.gui.messageBox command : As a result the screen is blocked : - can't clo… --- ## [\[SOLVED\] Does Ignition allow the user to create SQL EXPLICIT TRANSACTIONS?](https://forum.inductiveautomation.com/t/solved-does-ignition-allow-the-user-to-create-sql-explicit-transactions/50362)
**Author:** [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Replies:** 13\ **Last updated:** [August 27, 2021, 3:12pm UTC](https://forum.inductiveautomation.com/t/solved-does-ignition-allow-the-user-to-create-sql-explicit-transactions/50362 "2021-08-27T15:12:16Z")
Ignore the red circle :slight\_smile: I have created some BEGIN TRAN / COMMIT TRAN queries I run on a tag change script and the customer is showing me evidence the transactions are not ATOMIC… this got me looking at I… --- ## [Siemens S7-300 Request timeout](https://forum.inductiveautomation.com/t/siemens-s7-300-request-timeout/50219)
**Author:** [@kaushik.shah](https://forum.inductiveautomation.com/u/kaushik.shah)\ **Replies:** 4\ **Last updated:** [August 27, 2021, 2:44pm UTC](https://forum.inductiveautomation.com/t/siemens-s7-300-request-timeout/50219 "2021-08-27T14:44:13Z")
Hello There, I’m not sure why but, suddenly I have the issue with siemens PLC. It shows that the request is timing out. The PLC is been working very normal so far and its just started doing it all the sudden. My memory … --- ## [\[IGN-1830\] Icon image change](https://forum.inductiveautomation.com/t/ign-1830-icon-image-change/50381)
**Author:** [@valentinocori5](https://forum.inductiveautomation.com/u/valentinocori5)\ **Replies:** 3\ **Last updated:** [August 27, 2021, 2:37pm UTC](https://forum.inductiveautomation.com/t/ign-1830-icon-image-change/50381 "2021-08-27T14:37:14Z")
Hello, I wanted to ask if it was possible to change the vision client icon with its own image. I tried in the project properties but it doesn’t seem to work. --- ## [Perspective email table data as xls](https://forum.inductiveautomation.com/t/perspective-email-table-data-as-xls/28597)
**Author:** [@craigb](https://forum.inductiveautomation.com/u/craigb)\ **Replies:** 4\ **Last updated:** [August 27, 2021, 2:28pm UTC](https://forum.inductiveautomation.com/t/perspective-email-table-data-as-xls/28597 "2021-08-27T14:28:42Z")
It took me a while to get this one to work, many forum searches later. To save someones pain, here is how to export table data as XLS and email it in perspective. If you unhash the download line and hash everything below… --- ## [Issues positioning containers](https://forum.inductiveautomation.com/t/issues-positioning-containers/50355)
**Author:** [@erines](https://forum.inductiveautomation.com/u/erines)\ **Replies:** 5\ **Last updated:** [August 27, 2021, 1:28pm UTC](https://forum.inductiveautomation.com/t/issues-positioning-containers/50355 "2021-08-27T13:28:58Z")
Hi! I am having an issue positioning containers in a window and having them show up properly on our HMI. Our interface is on a 1920x1080 display. I have a top status bar, main body section, and lower menu. The top st… --- ## [Issues re-establishing a session with external OPC server after the external server is rebooted or restarted](https://forum.inductiveautomation.com/t/issues-re-establishing-a-session-with-external-opc-server-after-the-external-server-is-rebooted-or-restarted/36765)
**Author:** [@aiyer](https://forum.inductiveautomation.com/u/aiyer)\ **Replies:** 21\ **Last updated:** [August 27, 2021, 1:18pm UTC](https://forum.inductiveautomation.com/t/issues-re-establishing-a-session-with-external-opc-server-after-the-external-server-is-rebooted-or-restarted/36765 "2021-08-27T13:18:22Z")
At our company, we connect ignition to another OPC UA server that are setup on other VMs that are hosted by us. Ignition is the client in this case. The tags associated with the server are pulled into an ignition proje… --- ## [V8.1.9 installer won't run](https://forum.inductiveautomation.com/t/v8-1-9-installer-wont-run/50323)
**Author:** [@alex.ferrell](https://forum.inductiveautomation.com/u/alex.ferrell)\ **Replies:** 11\ **Last updated:** [August 27, 2021, 1:05pm UTC](https://forum.inductiveautomation.com/t/v8-1-9-installer-wont-run/50323 "2021-08-27T13:05:38Z")
Hi all- I am running into a new problem and I am not sure where to look for the cause. I have a server running Server 2012. Ignition v7.9.6 is currently installed. I upgraded the license to support v8.1.x and already ref… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=967) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=969)