# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1428 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1429 --- ## [Calculate Kwh consumption and store it together with Kwh meter](https://forum.inductiveautomation.com/t/calculate-kwh-consumption-and-store-it-together-with-kwh-meter/14209)
**Author:** [@johan.volders](https://forum.inductiveautomation.com/u/johan.volders)\ **Replies:** 6\ **Last updated:** [May 10, 2017, 3:34pm UTC](https://forum.inductiveautomation.com/t/calculate-kwh-consumption-and-store-it-together-with-kwh-meter/14209 "2017-05-10T15:34:49Z")
Hello I store every 15 minutes the actual Kwh value of about 100 electrical meters to a database record with fields meternumber, kwhvalue, timestamp with the use of a scheduled block transaction group. Now I would like t… --- ## [Operation with dates](https://forum.inductiveautomation.com/t/operation-with-dates/14256)
**Author:** [@claudio](https://forum.inductiveautomation.com/u/claudio)\ **Replies:** 4\ **Last updated:** [May 10, 2017, 10:23pm UTC](https://forum.inductiveautomation.com/t/operation-with-dates/14256 "2017-05-10T22:23:34Z")
Hello I need to test two dates. I have placed a button with a very simple script that I copy below: date1 = system.date.getDate(system.tag.read("\[Client\]StartYY").value, system.tag.read("\[Client\]StartMM").value-1, sys… --- ## [Roc 801 Addressing Help](https://forum.inductiveautomation.com/t/roc-801-addressing-help/14227)
**Author:** [@chuck.jones](https://forum.inductiveautomation.com/u/chuck.jones)\ **Replies:** 4\ **Last updated:** [May 10, 2017, 8:48pm UTC](https://forum.inductiveautomation.com/t/roc-801-addressing-help/14227 "2017-05-10T20:48:46Z")
Looking for help on connecting a Roc 801 controller to ignition. --- ## [Lauch Ignition Using Remote Desktop Services](https://forum.inductiveautomation.com/t/lauch-ignition-using-remote-desktop-services/14072)
**Author:** [@focusengsk](https://forum.inductiveautomation.com/u/focusengsk)\ **Replies:** 4\ **Last updated:** [May 10, 2017, 5:09pm UTC](https://forum.inductiveautomation.com/t/lauch-ignition-using-remote-desktop-services/14072 "2017-05-10T17:09:43Z")
Hi All, I am currently working on aproject to introduce ACP ThinManager and ThinClients. The plant runs multiple scada platforms (ignition, WW, Factory Talk etc). Using Windows RDS (remote desk. serv.) and ACP ThinMana… --- ## [Java making outbound network requests on Mac client after launching Ignition client](https://forum.inductiveautomation.com/t/java-making-outbound-network-requests-on-mac-client-after-launching-ignition-client/14206)
**Author:** [@aschaef](https://forum.inductiveautomation.com/u/aschaef)\ **Replies:** 11\ **Last updated:** [May 10, 2017, 4:58pm UTC](https://forum.inductiveautomation.com/t/java-making-outbound-network-requests-on-mac-client-after-launching-ignition-client/14206 "2017-05-10T16:58:09Z")
I have a laptop running Mac OS 10.12.3 (Sierra) and noticed the laptop trying to make outbound connections to unknown private IP addresses. Using a combination of netstat, lsof, and Little Snitch I found my the outgoing … --- ## [Query: readt ime out exception](https://forum.inductiveautomation.com/t/query-readt-ime-out-exception/14249)
**Author:** [@claudio](https://forum.inductiveautomation.com/u/claudio)\ **Replies:** 5\ **Last updated:** [May 10, 2017, 3:58pm UTC](https://forum.inductiveautomation.com/t/query-readt-ime-out-exception/14249 "2017-05-10T15:58:34Z")
Hello I have a query that takes about 1 minute and 20 sec in the Management Studio If i put this query in a table object i receive the following exception Error running query: SQLQuery(query=MY QUERY , database=MY\_D… --- ## [Show a Timestamp in a Numeric Label](https://forum.inductiveautomation.com/t/show-a-timestamp-in-a-numeric-label/14251)
**Author:** [@jonathanlowery](https://forum.inductiveautomation.com/u/jonathanlowery)\ **Replies:** 1\ **Last updated:** [May 9, 2017, 11:37pm UTC](https://forum.inductiveautomation.com/t/show-a-timestamp-in-a-numeric-label/14251 "2017-05-09T23:37:00Z")
I am trying to do an SQL query but I only want the timestamp to display when it gets to a certain value. I cannot seem to get it to display due to datatype mismatches. I can get it in SQL manager using: SELECT \[times… --- ## [Client IP Address in Script](https://forum.inductiveautomation.com/t/client-ip-address-in-script/14235)
**Author:** [@Jayden](https://forum.inductiveautomation.com/u/Jayden)\ **Replies:** 4\ **Last updated:** [May 9, 2017, 6:52pm UTC](https://forum.inductiveautomation.com/t/client-ip-address-in-script/14235 "2017-05-09T18:52:55Z")
Hi All, I have a number of popup screens that are triggered to open from a Tag Value Change. At the moment these popups open on all clients. I'd like to only have the popup open on the relevant client. I have tried to… --- ## [Local Tags within AOI's](https://forum.inductiveautomation.com/t/local-tags-within-aois/14243)
**Author:** [@nkienzle](https://forum.inductiveautomation.com/u/nkienzle)\ **Replies:** 2\ **Last updated:** [May 9, 2017, 6:17pm UTC](https://forum.inductiveautomation.com/t/local-tags-within-aois/14243 "2017-05-09T18:17:17Z")
I'm working with add on instructions that have local tags I need for display on an Ignition screen. For a particular add on instruction, I've got a local tag that OPC-UA server can read with good quality. But another l… --- ## [Java Version on GW "Status" Page](https://forum.inductiveautomation.com/t/java-version-on-gw-status-page/14241)
**Author:** [@Keith.Britton](https://forum.inductiveautomation.com/u/Keith.Britton)\ **Replies:** 1\ **Last updated:** [May 9, 2017, 5:27pm UTC](https://forum.inductiveautomation.com/t/java-version-on-gw-status-page/14241 "2017-05-09T17:27:57Z")
After I log in as admin, I’ve noticed the Java version displayed on the “Status” page is showing up as the original version (1.8.0\_121-b13) that was installed on the gateway when we finally upgraded from Ignition 7.6 → 7… --- ## [Power Table Color Cell on value in another cell](https://forum.inductiveautomation.com/t/power-table-color-cell-on-value-in-another-cell/14242)
**Author:** [@Kuskah](https://forum.inductiveautomation.com/u/Kuskah)\ **Replies:** 2\ **Last updated:** [May 9, 2017, 5:26pm UTC](https://forum.inductiveautomation.com/t/power-table-color-cell-on-value-in-another-cell/14242 "2017-05-09T17:26:51Z")
Hey all, Looking for some help here. Trying to set the background color of a cell based upon the cell next to it. When running the code below in the configureCell extension, it colors the entire column. Where did I… --- ## [system.alarm.queryJournal return error in 7.9.2](https://forum.inductiveautomation.com/t/system-alarm-queryjournal-return-error-in-7-9-2/14239)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 3\ **Last updated:** [May 9, 2017, 2:18pm UTC](https://forum.inductiveautomation.com/t/system-alarm-queryjournal-return-error-in-7-9-2/14239 "2017-05-09T14:18:45Z")
Since we upgrade to 7.9.2, we have an error when we use system.alarm.queryJournal in the vision client. I think this issue was not in previous release :disappointed: (IA support \[#49100\]: system.alarm.queryJournal erro… --- ## [Reporting Simple Table Cell Fill Dynamic Control](https://forum.inductiveautomation.com/t/reporting-simple-table-cell-fill-dynamic-control/12775)
**Author:** [@0sm0](https://forum.inductiveautomation.com/u/0sm0)\ **Replies:** 6\ **Last updated:** [May 9, 2017, 11:33am UTC](https://forum.inductiveautomation.com/t/reporting-simple-table-cell-fill-dynamic-control/12775 "2017-05-09T11:33:11Z")
Hi Guys, In the old Reporting Module i used to use the Property Expressions on a Simple Table Cell to alter its Fill colour based on specific criteria. With the new Reporting system I cant see how to simply replicate t… --- ## [SQL Server 2012 JDBC error with int8](https://forum.inductiveautomation.com/t/sql-server-2012-jdbc-error-with-int8/14231)
**Author:** [@Dave\_Young](https://forum.inductiveautomation.com/u/Dave_Young)\ **Replies:** 3\ **Last updated:** [May 9, 2017, 3:41am UTC](https://forum.inductiveautomation.com/t/sql-server-2012-jdbc-error-with-int8/14231 "2017-05-09T03:41:32Z")
I have a simple script in a "Value Changed" event that collects a few tags and inserts them into a database as a single row. All was well when using MySQL however a decision was made to move to SQLServer 2012 and we now… --- ## [Re-Targetting Error](https://forum.inductiveautomation.com/t/re-targetting-error/14224)
**Author:** [@TruThat](https://forum.inductiveautomation.com/u/TruThat)\ **Replies:** 2\ **Last updated:** [May 6, 2017, 11:11pm UTC](https://forum.inductiveautomation.com/t/re-targetting-error/14224 "2017-05-06T23:11:04Z")
I have several TVs that have there own App running on the. Once an hour I want to retarget them to another project for 3 minutes and then have them return to their original app. I have the smarts to do the time but ge… --- ## [Script recursion issue when main window resized](https://forum.inductiveautomation.com/t/script-recursion-issue-when-main-window-resized/14221)
**Author:** [@sbrannen](https://forum.inductiveautomation.com/u/sbrannen)\ **Replies:** 2\ **Last updated:** [May 5, 2017, 7:09pm UTC](https://forum.inductiveautomation.com/t/script-recursion-issue-when-main-window-resized/14221 "2017-05-05T19:09:34Z")
Greetings… I’m having an issue with a Tab/Sub-Tab setup. The navigation script for the tabs seems to works great, but there is a serious problem if the window is resized. The popup, of course, does not resize with the … --- ## [EasyChart not displaying static value tags](https://forum.inductiveautomation.com/t/easychart-not-displaying-static-value-tags/14203)
**Author:** [@trentbliss](https://forum.inductiveautomation.com/u/trentbliss)\ **Replies:** 2\ **Last updated:** [May 4, 2017, 11:33pm UTC](https://forum.inductiveautomation.com/t/easychart-not-displaying-static-value-tags/14203 "2017-05-04T23:33:09Z")
Hi on my easycharts when the historical databases does a backup. I lose my static tag values because they haven't changed to write to database. I have selected a time recording of 1 hour but still the tags don't show aft… --- ## [Mouse-Clicked Scripting on Dropdown List](https://forum.inductiveautomation.com/t/mouse-clicked-scripting-on-dropdown-list/14195)
**Author:** [@AIO](https://forum.inductiveautomation.com/u/AIO)\ **Replies:** 2\ **Last updated:** [May 4, 2017, 9:11pm UTC](https://forum.inductiveautomation.com/t/mouse-clicked-scripting-on-dropdown-list/14195 "2017-05-04T21:11:34Z")
Hey folks, I've seen mention of this in previous posts and I wanted to see if there is a recommended solution. Mouse clicked scripting appears to work on the dropdown list as long as I do not click on the dropdown b… --- ## [Sound player object file not found raises error](https://forum.inductiveautomation.com/t/sound-player-object-file-not-found-raises-error/14212)
**Author:** [@Efernan](https://forum.inductiveautomation.com/u/Efernan)\ **Replies:** 0\ **Last updated:** [May 4, 2017, 6:30pm UTC](https://forum.inductiveautomation.com/t/sound-player-object-file-not-found-raises-error/14212 "2017-05-04T18:30:37Z")
Hi, we have an issue with an unhandled error message out of the sound player object pointing that the sound object file can not be found. This happens only after global scripts get published. Running ignition gateway 7.… --- ## [How to Program a Button inside a Template](https://forum.inductiveautomation.com/t/how-to-program-a-button-inside-a-template/14191)
**Author:** [@LonnieU](https://forum.inductiveautomation.com/u/LonnieU)\ **Replies:** 15\ **Last updated:** [May 4, 2017, 5:39pm UTC](https://forum.inductiveautomation.com/t/how-to-program-a-button-inside-a-template/14191 "2017-05-04T17:39:34Z")
Been programming in Ignition for about a year and ran into a issue I need help on. I've created a PID Tuning Screen Template for an PLC application with PV, SP, & CV vertical bars, Trend Chart, Auto/Manual Indicators,… --- ## [Tags historical scan class](https://forum.inductiveautomation.com/t/tags-historical-scan-class/14200)
**Author:** [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\ **Replies:** 2\ **Last updated:** [May 3, 2017, 8:02pm UTC](https://forum.inductiveautomation.com/t/tags-historical-scan-class/14200 "2017-05-03T20:02:15Z")
I'm trying to figure out what the difference is between selecting the Historical Scanclass Evaluate On Change option, rather than selecting a specific scan class: if I use the Evaluate On Change option, am I going to pol… --- ## [Subtract n days](https://forum.inductiveautomation.com/t/subtract-n-days/14178)
**Author:** [@adolfo.rafael.martin](https://forum.inductiveautomation.com/u/adolfo.rafael.martin)\ **Replies:** 4\ **Last updated:** [May 3, 2017, 7:06pm UTC](https://forum.inductiveautomation.com/t/subtract-n-days/14178 "2017-05-03T19:06:06Z")
This code works in the script console of the ignition designer. But, it produces an error when in a WebDev script. I'm just trying to subtract 'n' days from today's date i.e. import datetime timeNow = datetime.datet… --- ## [Set popup location for y axis only?](https://forum.inductiveautomation.com/t/set-popup-location-for-y-axis-only/14201)
**Author:** [@sbrannen](https://forum.inductiveautomation.com/u/sbrannen)\ **Replies:** 2\ **Last updated:** [May 3, 2017, 5:18pm UTC](https://forum.inductiveautomation.com/t/set-popup-location-for-y-axis-only/14201 "2017-05-03T17:18:12Z")
Greetings... I would like to set the location of a popup to x=center and y=200. How to accomplish with script? The setLocation requires two args and I only want to set one. Cheers, Steve --- ## [How to check if user has write Permission to a tag in script](https://forum.inductiveautomation.com/t/how-to-check-if-user-has-write-permission-to-a-tag-in-script/14198)
**Author:** [@thijs1](https://forum.inductiveautomation.com/u/thijs1)\ **Replies:** 0\ **Last updated:** [May 3, 2017, 2:05pm UTC](https://forum.inductiveautomation.com/t/how-to-check-if-user-has-write-permission-to-a-tag-in-script/14198 "2017-05-03T14:05:19Z")
How can we check in code / expression if a user has write permission (depending on custom permission of read only permission) on a tag? I do know about the hasRole() function, but I would like to check independent from… --- ## [Display Report Names in Dropdown List](https://forum.inductiveautomation.com/t/display-report-names-in-dropdown-list/14194)
**Author:** [@Hazmat480](https://forum.inductiveautomation.com/u/Hazmat480)\ **Replies:** 1\ **Last updated:** [May 3, 2017, 4:07am UTC](https://forum.inductiveautomation.com/t/display-report-names-in-dropdown-list/14194 "2017-05-03T04:07:16Z")
I found the script for displaying the report names as a dataset. However I am not sure where I put this in order to have it be displayed in my dropdown list. Thank you for your help. I am using Ignition 7.8. system.… --- ## [system.net.httpGet IOError](https://forum.inductiveautomation.com/t/system-net-httpget-ioerror/14176)
**Author:** [@sanskith](https://forum.inductiveautomation.com/u/sanskith)\ **Replies:** 3\ **Last updated:** [May 2, 2017, 5:54pm UTC](https://forum.inductiveautomation.com/t/system-net-httpget-ioerror/14176 "2017-05-02T17:54:19Z")
--- ## [Ignition 7.9 gets hunged and no clients can open and designer cannot load projects](https://forum.inductiveautomation.com/t/ignition-7-9-gets-hunged-and-no-clients-can-open-and-designer-cannot-load-projects/14185)
**Author:** [@caritoel27](https://forum.inductiveautomation.com/u/caritoel27)\ **Replies:** 2\ **Last updated:** [May 2, 2017, 5:23pm UTC](https://forum.inductiveautomation.com/t/ignition-7-9-gets-hunged-and-no-clients-can-open-and-designer-cannot-load-projects/14185 "2017-05-02T17:23:13Z")
Hi, I write to ask help please for diagnose about what can be the problem of this. The Ignition 7.9.0 gets hunged and then no clients can open and designer cannot load projects. I found on server on the Launch Gateway C… --- ## [Dynamic Update of Dataset in UDT Instance](https://forum.inductiveautomation.com/t/dynamic-update-of-dataset-in-udt-instance/12607)
**Author:** [@dnicoll](https://forum.inductiveautomation.com/u/dnicoll)\ **Replies:** 3\ **Last updated:** [May 1, 2017, 6:56pm UTC](https://forum.inductiveautomation.com/t/dynamic-update-of-dataset-in-udt-instance/12607 "2017-05-01T18:56:23Z")
I am probably missing something simple here. I have a UDT with and OPC Tag and a Dataset in it. I want to use the on change event on the OPC Tag to run a script which will do a bunch of OPC Reads and populate the DataSet… --- ## [Designer recent project list](https://forum.inductiveautomation.com/t/designer-recent-project-list/14170)
**Author:** [@mwaynesmith](https://forum.inductiveautomation.com/u/mwaynesmith)\ **Replies:** 0\ **Last updated:** [April 28, 2017, 10:56pm UTC](https://forum.inductiveautomation.com/t/designer-recent-project-list/14170 "2017-04-28T22:56:26Z")
I am loading the designer and the recent project list Is showing non-existing projects, some we used months prior, not on the current gateway projects. The projects are on the gateway. Where does the recent list gener… --- ## [Get UDT defs from provider?](https://forum.inductiveautomation.com/t/get-udt-defs-from-provider/14101)
**Author:** [@lstone](https://forum.inductiveautomation.com/u/lstone)\ **Replies:** 6\ **Last updated:** [April 28, 2017, 6:15pm UTC](https://forum.inductiveautomation.com/t/get-udt-defs-from-provider/14101 "2017-04-28T18:15:35Z")
I'd like to grab the UDT definitions from a given provider, the goal being a dataset comprised of the full path of every UDT definition for use in a script. I've attempted some search-fu but didn't find a post about this… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1427) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1429)