# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=613 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 614 --- ## [Date format ORA-01830](https://forum.inductiveautomation.com/t/date-format-ora-01830/76156)
**Author:** [@jamshidzade](https://forum.inductiveautomation.com/u/jamshidzade)\ **Replies:** 3\ **Last updated:** [July 10, 2023, 8:39pm UTC](https://forum.inductiveautomation.com/t/date-format-ora-01830/76156 "2023-07-10T20:39:33Z")
I have updated my ignition from7.9.1 to 7.9.21 but I got an error in my query would you please help me --- ## [Try() expression doesn't catch dividing by zero?](https://forum.inductiveautomation.com/t/try-expression-doesnt-catch-dividing-by-zero/76149)
**Author:** [@cole\_thorthon](https://forum.inductiveautomation.com/u/cole_thorthon)\ **Replies:** 8\ **Last updated:** [July 10, 2023, 8:30pm UTC](https://forum.inductiveautomation.com/t/try-expression-doesnt-catch-dividing-by-zero/76149 "2023-07-10T20:30:09Z")
try(4/0,99) Is there anyway to stop dividing by zero errors? --- ## [Ignition 8.1.5 - Perspective Table - How to populate Data Property (Dataset vs JSON)?](https://forum.inductiveautomation.com/t/ignition-8-1-5-perspective-table-how-to-populate-data-property-dataset-vs-json/47281)
**Author:** [@mudbay](https://forum.inductiveautomation.com/u/mudbay)\ **Replies:** 11\ **Last updated:** [July 10, 2023, 7:33pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-5-perspective-table-how-to-populate-data-property-dataset-vs-json/47281 "2023-07-10T19:33:31Z")
I have been reviewing other forum threads on this, but can’t seem to find good “guidance” on how best to work with the Perspective Table Component when it comes to mapping data to the Data property in the component… The… --- ## [Gauge properties](https://forum.inductiveautomation.com/t/gauge-properties/75335)
**Author:** [@dan\_mueller](https://forum.inductiveautomation.com/u/dan_mueller)\ **Replies:** 6\ **Last updated:** [July 10, 2023, 7:15pm UTC](https://forum.inductiveautomation.com/t/gauge-properties/75335 "2023-07-10T19:15:39Z")
Is it possible to add an additional value to a gauge? I want to add another needle. --- ## [Perspective Table : How to change cell's background color based on cell's value](https://forum.inductiveautomation.com/t/perspective-table-how-to-change-cells-background-color-based-on-cells-value/37900)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 4\ **Last updated:** [July 10, 2023, 7:00pm UTC](https://forum.inductiveautomation.com/t/perspective-table-how-to-change-cells-background-color-based-on-cells-value/37900 "2023-07-10T19:00:46Z")
Ignition 8.0.16-RC1 With the Perspective Table, I would like to change the cell’s background color based on cell’s value. (As a side note, the property data of the table component is binded to a dataset). (I try to ha… --- ## [Error in ignition 7.9.21](https://forum.inductiveautomation.com/t/error-in-ignition-7-9-21/76096)
**Author:** [@Nickolas\_Brown](https://forum.inductiveautomation.com/u/Nickolas_Brown)\ **Replies:** 4\ **Last updated:** [July 10, 2023, 6:46pm UTC](https://forum.inductiveautomation.com/t/error-in-ignition-7-9-21/76096 "2023-07-10T18:46:47Z")
Hello I have an error in ignition 7.9.21 that I cannot figure out. I am new to ignition. The script and error are below. The error is coming from a button press that is linked to the script. In the script tools there is … --- ## [Alarm Roster emails getting delayed](https://forum.inductiveautomation.com/t/alarm-roster-emails-getting-delayed/76125)
**Author:** [@conrad.fernandez](https://forum.inductiveautomation.com/u/conrad.fernandez)\ **Replies:** 2\ **Last updated:** [July 10, 2023, 5:41pm UTC](https://forum.inductiveautomation.com/t/alarm-roster-emails-getting-delayed/76125 "2023-07-10T17:41:58Z")
We are seeing an unexplained delay when ignition sends out email to people on a roster. Our audit log shows that the emails are initiated, but in the pipeline status there's message saying the emails are waiting 1hour b… --- ## [Stop Designer from stealing focus?](https://forum.inductiveautomation.com/t/stop-designer-from-stealing-focus/76136)
**Author:** [@ian.sebryk](https://forum.inductiveautomation.com/u/ian.sebryk)\ **Replies:** 9\ **Last updated:** [July 10, 2023, 4:37pm UTC](https://forum.inductiveautomation.com/t/stop-designer-from-stealing-focus/76136 "2023-07-10T16:37:25Z")
every few minutes Designer pops up the taskbar and flashes for attention, which hides the bottom of other windows we're working in. is there any way we can get Designer to stop doing this? i've been tracking this behav… --- ## [Project Library Script Scope Issues in Gateway Scheduled Script](https://forum.inductiveautomation.com/t/project-library-script-scope-issues-in-gateway-scheduled-script/76137)
**Author:** [@Brandon\_Peterson](https://forum.inductiveautomation.com/u/Brandon_Peterson)\ **Replies:** 4\ **Last updated:** [July 10, 2023, 3:30pm UTC](https://forum.inductiveautomation.com/t/project-library-script-scope-issues-in-gateway-scheduled-script/76137 "2023-07-10T15:30:56Z")
I'm getting a repeated error in a gateway scheduled script that doesn't make sense to me. Starting over the weekend, an hourly scheduled script just stopped finding the project library script and errors every time it run… --- ## [Expression Tag - Expression with Tags Path](https://forum.inductiveautomation.com/t/expression-tag-expression-with-tags-path/75948)
**Author:** [@dion.botha](https://forum.inductiveautomation.com/u/dion.botha)\ **Replies:** 10\ **Last updated:** [July 10, 2023, 2:56pm UTC](https://forum.inductiveautomation.com/t/expression-tag-expression-with-tags-path/75948 "2023-07-10T14:56:52Z")
Hello, I have the same name expression tags in different id folders. Is it possible to extract the expression tags path for use within the expression? If possible, would mean I could copy and past the tag into a differe… --- ## [Create a docked view with custom corner priority](https://forum.inductiveautomation.com/t/create-a-docked-view-with-custom-corner-priority/76130)
**Author:** [@vasanth.p](https://forum.inductiveautomation.com/u/vasanth.p)\ **Replies:** 4\ **Last updated:** [July 10, 2023, 2:32pm UTC](https://forum.inductiveautomation.com/t/create-a-docked-view-with-custom-corner-priority/76130 "2023-07-10T14:32:49Z")
There is a requirement for me to have a custom corner priority as shown in the picture. But options I noticed are: Any possible work arounds? --- ## [How are container components ordered?](https://forum.inductiveautomation.com/t/how-are-container-components-ordered/75993)
**Author:** [@ian.sebryk](https://forum.inductiveautomation.com/u/ian.sebryk)\ **Replies:** 12\ **Last updated:** [July 10, 2023, 2:31pm UTC](https://forum.inductiveautomation.com/t/how-are-container-components-ordered/75993 "2023-07-10T14:31:49Z")
i come from a long webdev background. in my containers (which i see as \s \[thank you @pascal.fragnoud\]), i drop in components but have no idea how they are ordered. so if i want to target items with CSS, i'm not su… --- ## [Error in ignition 7.9](https://forum.inductiveautomation.com/t/error-in-ignition-7-9/76094)
**Author:** [@Nickolas\_Brown](https://forum.inductiveautomation.com/u/Nickolas_Brown)\ **Replies:** 4\ **Last updated:** [July 10, 2023, 2:03pm UTC](https://forum.inductiveautomation.com/t/error-in-ignition-7-9/76094 "2023-07-10T14:03:50Z")
Hello I have a traceback error that I can not solve when running a project in ignition the error is below and the code for this. This is in ignition 7.9.21 Traceback (most recent call last): File "event:actionPerforme… --- ## [system.tag.storeTagHistory not able to store Timestamp as Required](https://forum.inductiveautomation.com/t/system-tag-storetaghistory-not-able-to-store-timestamp-as-required/76121)
**Author:** [@Learner\_Ignition](https://forum.inductiveautomation.com/u/Learner_Ignition)\ **Replies:** 4\ **Last updated:** [July 10, 2023, 9:34am UTC](https://forum.inductiveautomation.com/t/system-tag-storetaghistory-not-able-to-store-timestamp-as-required/76121 "2023-07-10T09:34:14Z")
Hi, I have tags for that historian is enabled and I want to write value with timestamp using system.tag.storeTagHistory, by using this value is storing in the database but timestamp is storing with current date & time a… --- ## [Ignition - Siemens String Addressing](https://forum.inductiveautomation.com/t/ignition-siemens-string-addressing/40401)
**Author:** [@kaushik.shah](https://forum.inductiveautomation.com/u/kaushik.shah)\ **Replies:** 5\ **Last updated:** [July 10, 2023, 7:49am UTC](https://forum.inductiveautomation.com/t/ignition-siemens-string-addressing/40401 "2023-07-10T07:49:24Z")
Hello There, I found something very strange while configuring the tags today. PLC - S7-300 Ignition - 8.0.10 I have a STRING tag sitting in a DB memory with the address - DB36,STRING0 When I try to map this tag t… --- ## [Problem with duplicates in MySql](https://forum.inductiveautomation.com/t/problem-with-duplicates-in-mysql/76086)
**Author:** [@Miguel\_Gomez](https://forum.inductiveautomation.com/u/Miguel_Gomez)\ **Replies:** 6\ **Last updated:** [July 10, 2023, 4:09am UTC](https://forum.inductiveautomation.com/t/problem-with-duplicates-in-mysql/76086 "2023-07-10T04:09:42Z")
Hello friends, Im trying to send some data to a DataBase but the problem is that when the data is inserted it is savig 3 times the same information Ok, this is what I have, In a Vision Window I Have 2 calendar boxes, … --- ## [Generate a list of alarm display paths in project?](https://forum.inductiveautomation.com/t/generate-a-list-of-alarm-display-paths-in-project/76103)
**Author:** [@tACO](https://forum.inductiveautomation.com/u/tACO)\ **Replies:** 8\ **Last updated:** [July 10, 2023, 2:48am UTC](https://forum.inductiveautomation.com/t/generate-a-list-of-alarm-display-paths-in-project/76103 "2023-07-10T02:48:51Z")
Ignition newbie here, so sorry if this is obvious. I'd like a list of alarms that the project can generate. Is there a way to generate a list of display paths in the project? --- ## [Accessing Vision Client Connection info from Gateway](https://forum.inductiveautomation.com/t/accessing-vision-client-connection-info-from-gateway/76113)
**Author:** [@AIO](https://forum.inductiveautomation.com/u/AIO)\ **Replies:** 2\ **Last updated:** [July 9, 2023, 10:42pm UTC](https://forum.inductiveautomation.com/t/accessing-vision-client-connection-info-from-gateway/76113 "2023-07-09T22:42:47Z")
Hey folks, I need to do some gateway tag event scripting, and in doing so need to reference the active user at a given terminal. I know I can get the active user via message, or create a table to store all active client… --- ## [How to Install Ignition Edge on Ubuntu Linux](https://forum.inductiveautomation.com/t/how-to-install-ignition-edge-on-ubuntu-linux/29426)
**Author:** [@tyler.bennett](https://forum.inductiveautomation.com/u/tyler.bennett)\ **Replies:** 12\ **Last updated:** [July 9, 2023, 7:07pm UTC](https://forum.inductiveautomation.com/t/how-to-install-ignition-edge-on-ubuntu-linux/29426 "2023-07-09T19:07:21Z")
I have looked and I cannot find any clear instructions for installing Ignition 8.05 Edge on Ubuntu Linux 18.04 LTS. Does that exist? I am happy to be corrected (and hang my head in shame) if I have just overlooked it som… --- ## [WebDev API methods query](https://forum.inductiveautomation.com/t/webdev-api-methods-query/75986)
**Author:** [@Learner\_Ignition](https://forum.inductiveautomation.com/u/Learner_Ignition)\ **Replies:** 12\ **Last updated:** [July 9, 2023, 12:21pm UTC](https://forum.inductiveautomation.com/t/webdev-api-methods-query/75986 "2023-07-09T12:21:29Z")
Hi, I want to know the methods in WebDev i.e doGET is for reading the data or writing the data to the endpoint. I used doGET and pass parameters(tags values) to the endpoints, so other system can use the JSON data and… --- ## [Message handler running but behind required timing](https://forum.inductiveautomation.com/t/message-handler-running-but-behind-required-timing/76098)
**Author:** [@Cameron\_Nickle](https://forum.inductiveautomation.com/u/Cameron_Nickle)\ **Replies:** 2\ **Last updated:** [July 9, 2023, 7:20am UTC](https://forum.inductiveautomation.com/t/message-handler-running-but-behind-required-timing/76098 "2023-07-09T07:20:40Z")
Hi all, I'm currently working on a user management page and I'm working on a 'Remove User' button. In this button it calls an 'openPopup' function to ask the user to confirm that they want to remove the selected user. T… --- ## [Import project labels, images, translation missing](https://forum.inductiveautomation.com/t/import-project-labels-images-translation-missing/76091)
**Author:** [@chen\_zhe](https://forum.inductiveautomation.com/u/chen_zhe)\ **Replies:** 2\ **Last updated:** [July 9, 2023, 5:53am UTC](https://forum.inductiveautomation.com/t/import-project-labels-images-translation-missing/76091 "2023-07-09T05:53:17Z")
Import from ont computer to another computer ,project labels, images, translation missing --- ## [Ignition Edge Linux](https://forum.inductiveautomation.com/t/ignition-edge-linux/75959)
**Author:** [@jacob.ramirez](https://forum.inductiveautomation.com/u/jacob.ramirez)\ **Replies:** 11\ **Last updated:** [July 8, 2023, 11:45pm UTC](https://forum.inductiveautomation.com/t/ignition-edge-linux/75959 "2023-07-08T23:45:15Z")
I'm having trouble having Ignition edge start on power up. I can install Ignition and its running but after the device is restarted Ignition doesn't run and the gwcmd -r does not work. Can anyone help in figuring out why… --- ## [Documentation site TLS certificate expired?](https://forum.inductiveautomation.com/t/documentation-site-tls-certificate-expired/76097)
**Author:** [@user69](https://forum.inductiveautomation.com/u/user69)\ **Replies:** 1\ **Last updated:** [July 8, 2023, 8:03pm UTC](https://forum.inductiveautomation.com/t/documentation-site-tls-certificate-expired/76097 "2023-07-08T20:03:14Z")
The TLS certificate for the documentation subdomain appears to be expired: LetsEncrypt seems to be operational. Might be IA-side ACME. Is it ok to browse the docs right now? --- ## [Perspective table column filter with date render](https://forum.inductiveautomation.com/t/perspective-table-column-filter-with-date-render/75983)
**Author:** [@Max\_Tymoshenko](https://forum.inductiveautomation.com/u/Max_Tymoshenko)\ **Replies:** 1\ **Last updated:** [July 8, 2023, 7:47am UTC](https://forum.inductiveautomation.com/t/perspective-table-column-filter-with-date-render/75983 "2023-07-08T07:47:51Z")
Good day to everyone! I tried to use feature of separate column filtering in Perspective table component and ran into a little problem. While "string" render columns work good, "date" render columns don't work. I think… --- ## [How to use a drop-down list to filter data in a table?](https://forum.inductiveautomation.com/t/how-to-use-a-drop-down-list-to-filter-data-in-a-table/75305)
**Author:** [@Cristian\_Gomez](https://forum.inductiveautomation.com/u/Cristian_Gomez)\ **Replies:** 13\ **Last updated:** [July 8, 2023, 7:46am UTC](https://forum.inductiveautomation.com/t/how-to-use-a-drop-down-list-to-filter-data-in-a-table/75305 "2023-07-08T07:46:43Z")
I would like to know if there is a way to filter the data that I have in a Dataset with an external dorpdown to the table, inside the data of the table there is one or several columns with the information to filter, that… --- ## [Vision client vs perspective session in accessing csv files](https://forum.inductiveautomation.com/t/vision-client-vs-perspective-session-in-accessing-csv-files/76068)
**Author:** [@michael.black](https://forum.inductiveautomation.com/u/michael.black)\ **Replies:** 3\ **Last updated:** [July 7, 2023, 11:39pm UTC](https://forum.inductiveautomation.com/t/vision-client-vs-perspective-session-in-accessing-csv-files/76068 "2023-07-07T23:39:46Z")
Doing work for a customer where they are running a gateway using vision on a computer and then also running three vision clients from that vision gateway computer. I have a script running for each client that looks for … --- ## [Installing Requests library for python in Ignition](https://forum.inductiveautomation.com/t/installing-requests-library-for-python-in-ignition/76089)
**Author:** [@a.beltran](https://forum.inductiveautomation.com/u/a.beltran)\ **Replies:** 2\ **Last updated:** [July 7, 2023, 11:32pm UTC](https://forum.inductiveautomation.com/t/installing-requests-library-for-python-in-ignition/76089 "2023-07-07T23:32:49Z")
I'm trying to install the Requests library for Python to script a code for logging into Microsoft SharePoint. I successfully installed the library in my local Python environment using pip, and I also downloaded the .tar … --- ## [How to restrict the mouse operation within popup window](https://forum.inductiveautomation.com/t/how-to-restrict-the-mouse-operation-within-popup-window/27794)
**Author:** [@dawei.liu](https://forum.inductiveautomation.com/u/dawei.liu)\ **Replies:** 8\ **Last updated:** [July 7, 2023, 11:23pm UTC](https://forum.inductiveautomation.com/t/how-to-restrict-the-mouse-operation-within-popup-window/27794 "2023-07-07T23:23:25Z")
Hi, I have a window with some buttons in it. When clicking one button, it will pop out a popup window. The focus will be switched to the pop out window, but we still can move the cursor outside the popup window and do o… --- ## [Vision Easy Chart Runtime X-Trace mode](https://forum.inductiveautomation.com/t/vision-easy-chart-runtime-x-trace-mode/76084)
**Author:** [@dwoo](https://forum.inductiveautomation.com/u/dwoo)\ **Replies:** 1\ **Last updated:** [July 7, 2023, 9:26pm UTC](https://forum.inductiveautomation.com/t/vision-easy-chart-runtime-x-trace-mode/76084 "2023-07-07T21:26:02Z")
Is there a scripting method of toggling the RunTime graph's X-Trace mode on and off? This is for a touch screen without a mouse application. [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=612) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=614)