# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1333 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1334 --- ## [Add new column to a table in a report](https://forum.inductiveautomation.com/t/add-new-column-to-a-table-in-a-report/11782)
**Author:** [@jose.granero](https://forum.inductiveautomation.com/u/jose.granero)\ **Replies:** 5\ **Last updated:** [March 20, 2018, 7:08am UTC](https://forum.inductiveautomation.com/t/add-new-column-to-a-table-in-a-report/11782 "2018-03-20T07:08:52Z")
How can I add a new column to a table in a report? --- ## [Database Connection and SQL Bridge](https://forum.inductiveautomation.com/t/database-connection-and-sql-bridge/21154)
**Author:** [@renix](https://forum.inductiveautomation.com/u/renix)\ **Replies:** 1\ **Last updated:** [November 30, 2018, 10:51am UTC](https://forum.inductiveautomation.com/t/database-connection-and-sql-bridge/21154 "2018-11-30T10:51:23Z")
Hi, If I create a database connection through the gateway and log tags using INSERT command to the SQL and fetch back to SCADA using SQL query. Does it call for a SQL bridge license? --- ## [Create a list from one column in a power table](https://forum.inductiveautomation.com/t/create-a-list-from-one-column-in-a-power-table/21139)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 7\ **Last updated:** [November 29, 2018, 8:37pm UTC](https://forum.inductiveautomation.com/t/create-a-list-from-one-column-in-a-power-table/21139 "2018-11-29T20:37:43Z")
I'm trying to extract the values from only one column in a power table, create a dataset from it and write it to a tag. Basically, I want to trim the table dataset to the first column only. thanks --- ## [Designer taking longner to get open](https://forum.inductiveautomation.com/t/designer-taking-longner-to-get-open/21144)
**Author:** [@kunal.ghule](https://forum.inductiveautomation.com/u/kunal.ghule)\ **Replies:** 1\ **Last updated:** [November 29, 2018, 7:00pm UTC](https://forum.inductiveautomation.com/t/designer-taking-longner-to-get-open/21144 "2018-11-29T19:00:07Z")
While working on windows 10 laptop, ignition is working fine. It opens designer in couple of seconds. Now i installed it on server 2016, its taking way more time (haven't timed but its at least a min). I even increased c… --- ## [Access another application within Ignition](https://forum.inductiveautomation.com/t/access-another-application-within-ignition/21142)
**Author:** [@kaushik.shah](https://forum.inductiveautomation.com/u/kaushik.shah)\ **Replies:** 0\ **Last updated:** [November 29, 2018, 6:33pm UTC](https://forum.inductiveautomation.com/t/access-another-application-within-ignition/21142 "2018-11-29T18:33:08Z")
Hello Everyone, I know this would sound a bit crazy but I want to open another (third party workbench) window application on client computer through ignition scripting by giving it a user and password and then click some… --- ## [Set XValue for Easy Chart](https://forum.inductiveautomation.com/t/set-xvalue-for-easy-chart/16531)
**Author:** [@larryjones](https://forum.inductiveautomation.com/u/larryjones)\ **Replies:** 14\ **Last updated:** [November 29, 2018, 6:12pm UTC](https://forum.inductiveautomation.com/t/set-xvalue-for-easy-chart/16531 "2018-11-29T18:12:22Z")
I have a window with an Easy Chart and I use a script in the window's internalFrameActivated event handler to automatically put the Easy Chart in X-Trace mode. I would like to prevent the user from having to click in th… --- ## [Binding/Animating size/position within container](https://forum.inductiveautomation.com/t/binding-animating-size-position-within-container/19985)
**Author:** [@ASF](https://forum.inductiveautomation.com/u/ASF)\ **Replies:** 5\ **Last updated:** [November 29, 2018, 6:08pm UTC](https://forum.inductiveautomation.com/t/binding-animating-size-position-within-container/19985 "2018-11-29T18:08:09Z")
Hi all, Setting up a popup to control a motor, and my motor UDT has a parameter which defines whether it's reversible or not. If not, I show just two buttons; Start and Stop. If it is reversible, I display three: Start… --- ## [Weird Gateway restarts](https://forum.inductiveautomation.com/t/weird-gateway-restarts/21014)
**Author:** [@eduardo.ojalvo](https://forum.inductiveautomation.com/u/eduardo.ojalvo)\ **Replies:** 1\ **Last updated:** [November 29, 2018, 5:42pm UTC](https://forum.inductiveautomation.com/t/weird-gateway-restarts/21014 "2018-11-29T17:42:11Z")
We have recently started to experience weird Gateway restarts every day, more or less at the same time. After an initial diagnosis we don’t have a clue of what can be happening. The Gateway is a 7.6.7 (b2014082615) ver… --- ## [Icons in Gantt Chart](https://forum.inductiveautomation.com/t/icons-in-gantt-chart/20933)
**Author:** [@f.pinciaroli](https://forum.inductiveautomation.com/u/f.pinciaroli)\ **Replies:** 4\ **Last updated:** [November 29, 2018, 4:02pm UTC](https://forum.inductiveautomation.com/t/icons-in-gantt-chart/20933 "2018-11-29T16:02:58Z")
Hello, I have a cervellotic idea and i think it's not possible to realize... but anyway I ask u about it. I'm tryng to use the equipment schedule or the gantt chart components to realize a gantt chart of the jobsin my p… --- ## [Confirmation 1 and 0](https://forum.inductiveautomation.com/t/confirmation-1-and-0/21134)
**Author:** [@rroca](https://forum.inductiveautomation.com/u/rroca)\ **Replies:** 2\ **Last updated:** [November 29, 2018, 3:54pm UTC](https://forum.inductiveautomation.com/t/confirmation-1-and-0/21134 "2018-11-29T15:54:26Z")
Hi everyone, Is it possible to ask for a confirmation in a Momentary button using Control Value to send just one pulse ? Or maybe using other button type, but I need just one pulse after the confirmation. :pray: --- ## [Mobile Clients Running](https://forum.inductiveautomation.com/t/mobile-clients-running/21131)
**Author:** [@rrowe](https://forum.inductiveautomation.com/u/rrowe)\ **Replies:** 1\ **Last updated:** [November 29, 2018, 3:18pm UTC](https://forum.inductiveautomation.com/t/mobile-clients-running/21131 "2018-11-29T15:18:12Z")
Where can I check to see if there are mobile clients running? --- ## [Chart Tick and Format](https://forum.inductiveautomation.com/t/chart-tick-and-format/21135)
**Author:** [@luca.mori](https://forum.inductiveautomation.com/u/luca.mori)\ **Replies:** 0\ **Last updated:** [November 29, 2018, 2:48pm UTC](https://forum.inductiveautomation.com/t/chart-tick-and-format/21135 "2018-11-29T14:48:37Z")
Hi, i would like to understand something about the chart properties. I need to change the format string, as im trying to allow the costumer to adjust the X Axes Tick, but when i change the tick size from the followin… --- ## [How can I prevent a "quick" mouse click](https://forum.inductiveautomation.com/t/how-can-i-prevent-a-quick-mouse-click/21002)
**Author:** [@jsteward](https://forum.inductiveautomation.com/u/jsteward)\ **Replies:** 5\ **Last updated:** [November 29, 2018, 9:06am UTC](https://forum.inductiveautomation.com/t/how-can-i-prevent-a-quick-mouse-click/21002 "2018-11-29T09:06:19Z")
I'm designing for a touch screen and want to use the mouse pressed and mouse released events. I only want the event scripts to run if the mouse has been pressed for at least 250 ms. Is there a way to count the time a m… --- ## [Templates messy](https://forum.inductiveautomation.com/t/templates-messy/21126)
**Author:** [@Claus\_Nielsen](https://forum.inductiveautomation.com/u/Claus_Nielsen)\ **Replies:** 0\ **Last updated:** [November 29, 2018, 1:24am UTC](https://forum.inductiveautomation.com/t/templates-messy/21126 "2018-11-29T01:24:19Z")
Recently I’ve got an issue on all my templates in a project. It seems like some kind of frame has been pushed up (don’t know how to explain, see my pictures :slight\_smile:) which is messing everything up. The pictu… --- ## [Random 'Not Found' Quality Overlays while using Templates](https://forum.inductiveautomation.com/t/random-not-found-quality-overlays-while-using-templates/4657)
**Author:** [@alanb](https://forum.inductiveautomation.com/u/alanb)\ **Replies:** 11\ **Last updated:** [November 29, 2018, 12:36am UTC](https://forum.inductiveautomation.com/t/random-not-found-quality-overlays-while-using-templates/4657 "2018-11-29T00:36:17Z")
Hi I have found that when I leave a window, then return focus, the template object will randomly indicate a ‘Not Found’ quality code. These template objects are mapped to two bit states. The values are always correct an… --- ## [EasyChart Calculated Pen to convert Celsius to Fahrenheit?](https://forum.inductiveautomation.com/t/easychart-calculated-pen-to-convert-celsius-to-fahrenheit/17871)
**Author:** [@witman](https://forum.inductiveautomation.com/u/witman)\ **Replies:** 1\ **Last updated:** [May 2, 2018, 5:43pm UTC](https://forum.inductiveautomation.com/t/easychart-calculated-pen-to-convert-celsius-to-fahrenheit/17871 "2018-05-02T17:43:12Z")
We are logging temperature in Celsius with tag history. Our HMI allows clients to select their preferred units of measure and all displayed values are run through functions to display in selected units of measure. I'd li… --- ## [Edit Column Attributes Dataset](https://forum.inductiveautomation.com/t/edit-column-attributes-dataset/21120)
**Author:** [@bellm](https://forum.inductiveautomation.com/u/bellm)\ **Replies:** 3\ **Last updated:** [November 28, 2018, 8:17pm UTC](https://forum.inductiveautomation.com/t/edit-column-attributes-dataset/21120 "2018-11-28T20:17:22Z")
I am trying to edit a tables attributes with a button press script. But am getting the following error: File "event:mousePressed", line 2, in TypeError: setValue(): 1st arg can't be coerced to com.inductiveautomati… --- ## [Change row color of a table based on another table](https://forum.inductiveautomation.com/t/change-row-color-of-a-table-based-on-another-table/21098)
**Author:** [@bellm](https://forum.inductiveautomation.com/u/bellm)\ **Replies:** 4\ **Last updated:** [November 28, 2018, 6:48pm UTC](https://forum.inductiveautomation.com/t/change-row-color-of-a-table-based-on-another-table/21098 "2018-11-28T18:48:01Z")
I have seen alot of discussion on here about how to use getBackGroundAt or Backgroud Color List to change the color of a row based on a column value in the table you are displaying. Is it possible to change the color … --- ## [Get alarm property "Shelving Allowed" with script](https://forum.inductiveautomation.com/t/get-alarm-property-shelving-allowed-with-script/21110)
**Author:** [@Philcr](https://forum.inductiveautomation.com/u/Philcr)\ **Replies:** 1\ **Last updated:** [November 28, 2018, 2:43pm UTC](https://forum.inductiveautomation.com/t/get-alarm-property-shelving-allowed-with-script/21110 "2018-11-28T14:43:41Z")
Hi, is there a way to get the property "Shelving Allowed" through scripting? Thank you --- ## [Relative path to component into components bibndings](https://forum.inductiveautomation.com/t/relative-path-to-component-into-components-bibndings/8921)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 3\ **Last updated:** [November 28, 2018, 2:01pm UTC](https://forum.inductiveautomation.com/t/relative-path-to-component-into-components-bibndings/8921 "2018-11-28T14:01:01Z")
For property expression binding on component, a relative path to component (like for tag) will be very practical or a path to the current component. --- ## [system.tag.queryTagCalculations in UDT tag even script](https://forum.inductiveautomation.com/t/system-tag-querytagcalculations-in-udt-tag-even-script/21107)
**Author:** [@Kleppe85](https://forum.inductiveautomation.com/u/Kleppe85)\ **Replies:** 2\ **Last updated:** [November 28, 2018, 1:41pm UTC](https://forum.inductiveautomation.com/t/system-tag-querytagcalculations-in-udt-tag-even-script/21107 "2018-11-28T13:41:45Z")
Hi, I want to add some tag-calculation values to my UDT, based on the process value inside each UDT instance. I created a timer script that toggles a tag each hour. This tag is "mirrored" inside each UDT using an expre… --- ## [Database connection, Ingition 7.9.9, MySQL8](https://forum.inductiveautomation.com/t/database-connection-ingition-7-9-9-mysql8/21095)
**Author:** [@asap13](https://forum.inductiveautomation.com/u/asap13)\ **Replies:** 2\ **Last updated:** [November 27, 2018, 10:25pm UTC](https://forum.inductiveautomation.com/t/database-connection-ingition-7-9-9-mysql8/21095 "2018-11-27T22:25:56Z")
Hi there, I use Ignition 7.9.9, MySQL 8, connector "mysql-connector-java-8.0.13.jar" I've got db connection status error: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password… --- ## [Modify a UDT alarm configuration using a Python script?](https://forum.inductiveautomation.com/t/modify-a-udt-alarm-configuration-using-a-python-script/21093)
**Author:** [@poduzov](https://forum.inductiveautomation.com/u/poduzov)\ **Replies:** 0\ **Last updated:** [November 27, 2018, 8:24pm UTC](https://forum.inductiveautomation.com/t/modify-a-udt-alarm-configuration-using-a-python-script/21093 "2018-11-27T20:24:24Z")
There is a Python function which modifies tags' alarm configuration. system.tag.editAlarmConfig(tagPaths, alarmConfig) It works fine on regular tags instances. Is it possible to modify UDT alarm configuration using a P… --- ## [dataMap for running a script for report schedule](https://forum.inductiveautomation.com/t/datamap-for-running-a-script-for-report-schedule/18456)
**Author:** [@cobe.karhoff](https://forum.inductiveautomation.com/u/cobe.karhoff)\ **Replies:** 5\ **Last updated:** [November 27, 2018, 7:54pm UTC](https://forum.inductiveautomation.com/t/datamap-for-running-a-script-for-report-schedule/18456 "2018-11-27T19:54:11Z")
I am trying to send out an email report in the run script and I want to have the ID number stored as the file name and I know that dataMap argument is able to retrieve that value since it is used in the report. Whenever … --- ## [Write changes on a button press](https://forum.inductiveautomation.com/t/write-changes-on-a-button-press/21090)
**Author:** [@bellm](https://forum.inductiveautomation.com/u/bellm)\ **Replies:** 1\ **Last updated:** [November 27, 2018, 7:28pm UTC](https://forum.inductiveautomation.com/t/write-changes-on-a-button-press/21090 "2018-11-27T19:28:43Z")
I have a table that the user is able to edit some of the columns. Currently after editing each cell I have a script on the cell edited event that writes the change back to the database. I am being asked to change that so… --- ## [Ignition and Microsoft Access - connection valid now](https://forum.inductiveautomation.com/t/ignition-and-microsoft-access-connection-valid-now/21006)
**Author:** [@MikeBr](https://forum.inductiveautomation.com/u/MikeBr)\ **Replies:** 0\ **Last updated:** [November 21, 2018, 9:00pm UTC](https://forum.inductiveautomation.com/t/ignition-and-microsoft-access-connection-valid-now/21006 "2018-11-21T21:00:04Z")
Hello Ignition Community, I'm using Ignition 7.9.7 and am tasked with connecting to a MS Access database (.accdb)....yes, I'd much rather it was MSSQL but the guy who has the Access db will not change it. Options to in… --- ## [List component filtering and Highlighting](https://forum.inductiveautomation.com/t/list-component-filtering-and-highlighting/21075)
**Author:** [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Replies:** 6\ **Last updated:** [November 27, 2018, 5:52pm UTC](https://forum.inductiveautomation.com/t/list-component-filtering-and-highlighting/21075 "2018-11-27T17:52:30Z")
Is this possible with List component? Ok, I’m sure that’s possible in Ignition, it’s just that I don’t know how to do it… :innocent: Edit: here is the link where I found this: https://www.logicbig.com/tutorials/java-… --- ## [Total Info output to a table daily](https://forum.inductiveautomation.com/t/total-info-output-to-a-table-daily/20879)
**Author:** [@Schwartzds](https://forum.inductiveautomation.com/u/Schwartzds)\ **Replies:** 3\ **Last updated:** [November 27, 2018, 5:22pm UTC](https://forum.inductiveautomation.com/t/total-info-output-to-a-table-daily/20879 "2018-11-27T17:22:55Z")
I am working on a project where I want to get totals from tags each day. Then at 00:01 the totals get logged into another tag. Then this info could be dumped into a table for a month period. Does anyone have any easy way… --- ## [SQL connection for ARM ignition package in Raspberry Pi 3](https://forum.inductiveautomation.com/t/sql-connection-for-arm-ignition-package-in-raspberry-pi-3/21074)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 2\ **Last updated:** [November 27, 2018, 4:13pm UTC](https://forum.inductiveautomation.com/t/sql-connection-for-arm-ignition-package-in-raspberry-pi-3/21074 "2018-11-27T16:13:07Z")
Hi I'm a little confuse regards ARM ignition package for Raspberry Pi 3. Does this package include both ignition pro and ignition edge? I have a project with 35 tags and need to log data for 1 year and simple HMI on m… --- ## [Display Image from LAN](https://forum.inductiveautomation.com/t/display-image-from-lan/21080)
**Author:** [@c.bertulli](https://forum.inductiveautomation.com/u/c.bertulli)\ **Replies:** 2\ **Last updated:** [November 27, 2018, 4:09pm UTC](https://forum.inductiveautomation.com/t/display-image-from-lan/21080 "2018-11-27T16:09:06Z")
Hi All, I need to display an image dynamically from a network. All the clients have the permissions to access that network. I can't, of course, take all the images and put them inside Ignition ( because the folder wher… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1332) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1334)