# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1657 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1658 --- ## [SQL Tag Event script](https://forum.inductiveautomation.com/t/sql-tag-event-script/16907)
**Author:** [@Julio.Bautista](https://forum.inductiveautomation.com/u/Julio.Bautista)\ **Replies:** 3\ **Last updated:** [February 7, 2018, 3:03pm UTC](https://forum.inductiveautomation.com/t/sql-tag-event-script/16907 "2018-02-07T15:03:49Z")
I have a SQL tag query that looks at a table constructed by a transaction group. The following is my query in which is saved to the tag as a dataset SELECT top 2 DateTime from Cast\_Time order by DateTime desc The s… --- ## [Alarm Display Path expression missing Alarm Properties](https://forum.inductiveautomation.com/t/alarm-display-path-expression-missing-alarm-properties/16880)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 3\ **Last updated:** [February 6, 2018, 10:48pm UTC](https://forum.inductiveautomation.com/t/alarm-display-path-expression-missing-alarm-properties/16880 "2018-02-06T22:48:53Z")
Hi, Ignition 7.9.5 I've been setting the expression for the display path of alarms for tags within UDTs just fine using Alarm Properties (E.g. {PathToParentFolder}, {TagName}, etc.), however i'm trying to do the same… --- ## [Easy chart with multiple customize background](https://forum.inductiveautomation.com/t/easy-chart-with-multiple-customize-background/16897)
**Author:** [@oscar.munoz](https://forum.inductiveautomation.com/u/oscar.munoz)\ **Replies:** 0\ **Last updated:** [February 6, 2018, 10:38pm UTC](https://forum.inductiveautomation.com/t/easy-chart-with-multiple-customize-background/16897 "2018-02-06T22:38:33Z")
I want the easy chart background to be divided in three sections, green , yellow and red ,to indicate if a values are inside the desired boundaries. I am currently achieving this by using three almost transparent rectang… --- ## [Some Project Resources not publishing](https://forum.inductiveautomation.com/t/some-project-resources-not-publishing/16888)
**Author:** [@nputnam](https://forum.inductiveautomation.com/u/nputnam)\ **Replies:** 3\ **Last updated:** [February 6, 2018, 7:55pm UTC](https://forum.inductiveautomation.com/t/some-project-resources-not-publishing/16888 "2018-02-06T19:55:49Z")
I'm having an issue with ignition where when I save and publish resources not all resources are being pushed to the client. Currently we have a shared script that runs on a global timer event, pulls plex workcenter info… --- ## [Socket timeout exception](https://forum.inductiveautomation.com/t/socket-timeout-exception/16882)
**Author:** [@natcheappan](https://forum.inductiveautomation.com/u/natcheappan)\ **Replies:** 2\ **Last updated:** [February 6, 2018, 6:36pm UTC](https://forum.inductiveautomation.com/t/socket-timeout-exception/16882 "2018-02-06T18:36:07Z")
Hi, We are getting socket timeout exception error while opening the client.exe file in the client PC. We need to retry few times to get it connected to server. But if i try to open client.exe in the server, it opens wi… --- ## [Expression Function Organization](https://forum.inductiveautomation.com/t/expression-function-organization/16879)
**Author:** [@zacslade](https://forum.inductiveautomation.com/u/zacslade)\ **Replies:** 2\ **Last updated:** [February 6, 2018, 4:17pm UTC](https://forum.inductiveautomation.com/t/expression-function-organization/16879 "2018-02-06T16:17:59Z")
Hi all, This is not a big deal, but I've been curious about it for a while. In the expression editor, in the function dropdown list, the functions are organized categorically. Most dataset related functions are in the … --- ## [Issue with Audit Log dynamic dropdown](https://forum.inductiveautomation.com/t/issue-with-audit-log-dynamic-dropdown/16886)
**Author:** [@patneshubham123](https://forum.inductiveautomation.com/u/patneshubham123)\ **Replies:** 1\ **Last updated:** [February 6, 2018, 11:11am UTC](https://forum.inductiveautomation.com/t/issue-with-audit-log-dynamic-dropdown/16886 "2018-02-06T11:11:03Z")
Hi everyone, we have created audit log table where the activities of all the operator is getting logged.we want to create a dynamic dropdown where we can select the operator which we have added in user management.but whe… --- ## [Dynamic dropdown](https://forum.inductiveautomation.com/t/dynamic-dropdown/16887)
**Author:** [@patneshubham123](https://forum.inductiveautomation.com/u/patneshubham123)\ **Replies:** 0\ **Last updated:** [February 6, 2018, 11:09am UTC](https://forum.inductiveautomation.com/t/dynamic-dropdown/16887 "2018-02-06T11:09:49Z")
Continuing the discussion from Issue with Audit Log dynamic dropdown: --- ## [Display counter based on two tag values](https://forum.inductiveautomation.com/t/display-counter-based-on-two-tag-values/16858)
**Author:** [@Julio.Bautista](https://forum.inductiveautomation.com/u/Julio.Bautista)\ **Replies:** 2\ **Last updated:** [February 5, 2018, 10:04pm UTC](https://forum.inductiveautomation.com/t/display-counter-based-on-two-tag-values/16858 "2018-02-05T22:04:42Z")
I have two Boolean tags that based on their values I would like to display a running counter. What would be the best way to deal with this. --- ## [User management : Error while adding an user](https://forum.inductiveautomation.com/t/user-management-error-while-adding-an-user/16875)
**Author:** [@shwethag](https://forum.inductiveautomation.com/u/shwethag)\ **Replies:** 1\ **Last updated:** [February 5, 2018, 5:44pm UTC](https://forum.inductiveautomation.com/t/user-management-error-while-adding-an-user/16875 "2018-02-05T17:44:36Z")
Hello: I went through user manual and the videos for adding user management screen in the ignition designer. I added the user management screen and tried to create a user and I'm getting the error: "Save Failed. You are … --- ## [sendRequest and return dataset](https://forum.inductiveautomation.com/t/sendrequest-and-return-dataset/16837)
**Author:** [@Kleppe85](https://forum.inductiveautomation.com/u/Kleppe85)\ **Replies:** 3\ **Last updated:** [February 5, 2018, 3:23pm UTC](https://forum.inductiveautomation.com/t/sendrequest-and-return-dataset/16837 "2018-02-05T15:23:13Z")
Hi, Is it possible to use the system.util.sendRequest to retrieve a dataset from another gateway? I can return a single value, but if I try to return a dataset I get a timeout. The dataset I'm testing with, only has 2x… --- ## [Updated Java and now Ignition won't work](https://forum.inductiveautomation.com/t/updated-java-and-now-ignition-wont-work/16869)
**Author:** [@karen.hodgson](https://forum.inductiveautomation.com/u/karen.hodgson)\ **Replies:** 2\ **Last updated:** [February 5, 2018, 2:22pm UTC](https://forum.inductiveautomation.com/t/updated-java-and-now-ignition-wont-work/16869 "2018-02-05T14:22:33Z")
I updated to the latest version of Java and now I can't get the gateway to start from the Control Utility. When I try to restart the gateway it will not restart. I've updated the ignition.conf file to point to the Java… --- ## [Error Loading module when using JXBrowser library from teamdev in the module](https://forum.inductiveautomation.com/t/error-loading-module-when-using-jxbrowser-library-from-teamdev-in-the-module/16874)
**Author:** [@Yogini\_Marathe](https://forum.inductiveautomation.com/u/Yogini_Marathe)\ **Replies:** 1\ **Last updated:** [February 5, 2018, 1:34pm UTC](https://forum.inductiveautomation.com/t/error-loading-module-when-using-jxbrowser-library-from-teamdev-in-the-module/16874 "2018-02-05T13:34:46Z")
Hi, We are working on developing a module that uses JXBrowser library (https://www.teamdev.com/jxbrowser) for providing one of the functionalities in Vision Client Component. I have an evaluation license and building… --- ## [Be notified of LicenseState change from the vision scope context](https://forum.inductiveautomation.com/t/be-notified-of-licensestate-change-from-the-vision-scope-context/16374)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 3\ **Last updated:** [February 5, 2018, 1:05pm UTC](https://forum.inductiveautomation.com/t/be-notified-of-licensestate-change-from-the-vision-scope-context/16374 "2018-02-05T13:05:25Z")
in an AbstractVisionComponent, we have acces to VisionClientContext and to getLicenseState. In the gateway scope we can subscribe to LicenseState change with : context.getLicenseManager().addLicenseStateUpdateListen… --- ## [Información en español](https://forum.inductiveautomation.com/t/informacion-en-espanol/16870)
**Author:** [@israelz](https://forum.inductiveautomation.com/u/israelz)\ **Replies:** 0\ **Last updated:** [February 5, 2018, 2:12am UTC](https://forum.inductiveautomation.com/t/informacion-en-espanol/16870 "2018-02-05T02:12:26Z")
Que tal, quiero compartirles algo de información útil para quienes se inician en Ignition y no encuentran información en español. En el primer post se trabaja el alta de Tags con un controlador CompactLogix, espero les r… --- ## [GatewayException: Login failed](https://forum.inductiveautomation.com/t/gatewayexception-login-failed/16867)
**Author:** [@nathanmcbride](https://forum.inductiveautomation.com/u/nathanmcbride)\ **Replies:** 1\ **Last updated:** [February 5, 2018, 12:06am UTC](https://forum.inductiveautomation.com/t/gatewayexception-login-failed/16867 "2018-02-05T00:06:30Z")
I am trying to process some autologin scripts which Identify the machineName for certain HMIs to be locked to particular machines and those users and passwords are retrieved from the database. No matter what error handli… --- ## [WebDev authentication and session control](https://forum.inductiveautomation.com/t/webdev-authentication-and-session-control/16862)
**Author:** [@ctonge](https://forum.inductiveautomation.com/u/ctonge)\ **Replies:** 0\ **Last updated:** [February 3, 2018, 3:42pm UTC](https://forum.inductiveautomation.com/t/webdev-authentication-and-session-control/16862 "2018-02-03T15:42:17Z")
Hello, I've setup the webdev module with some python resources using https and auth. How does one access the active webdev sessions, where I'm assuming you can kill them if desired. It seems like once I authenticate on… --- ## [Select Window Instance with Tab Strip](https://forum.inductiveautomation.com/t/select-window-instance-with-tab-strip/16856)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 0\ **Last updated:** [February 2, 2018, 11:04pm UTC](https://forum.inductiveautomation.com/t/select-window-instance-with-tab-strip/16856 "2018-02-02T23:04:24Z")
I have a chart window with a button to create a new instance. When a new instance is created I would like to add it to the tab strip above it so they can switch between opened windows. Is this possible and what approach … --- ## [Python: file release and deletion](https://forum.inductiveautomation.com/t/python-file-release-and-deletion/16847)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 3\ **Last updated:** [February 2, 2018, 9:05pm UTC](https://forum.inductiveautomation.com/t/python-file-release-and-deletion/16847 "2018-02-02T21:05:57Z")
I'm having trouble with file close() not working as expected. If I run this sample code: import tempfile import commands import os froot = system.tag.read("\[Client\]ctAppRootDirectory").value ftemp = froot + "delete\_… --- ## [Output is not printing on the console](https://forum.inductiveautomation.com/t/output-is-not-printing-on-the-console/16855)
**Author:** [@shwethag](https://forum.inductiveautomation.com/u/shwethag)\ **Replies:** 10\ **Last updated:** [February 2, 2018, 9:05pm UTC](https://forum.inductiveautomation.com/t/output-is-not-printing-on-the-console/16855 "2018-02-02T21:05:43Z")
Hello All: I've written a script for a tag whenever there is a value change. I am trying to print new value on the console, but it is not working. Please check the code below and let me know if I am doing anything wrong … --- ## [Where's my project shortcut?](https://forum.inductiveautomation.com/t/wheres-my-project-shortcut/16854)
**Author:** [@heybales](https://forum.inductiveautomation.com/u/heybales)\ **Replies:** 1\ **Last updated:** [February 2, 2018, 8:25pm UTC](https://forum.inductiveautomation.com/t/wheres-my-project-shortcut/16854 "2018-02-02T20:25:42Z")
If you (or your operator) deletes the shortcut to a project on the desktop, relaunching from the Ignition homepage will not restore it. I created this guide for my customer and thought I should share it here. Here’s wha… --- ## [Script Resource Locked](https://forum.inductiveautomation.com/t/script-resource-locked/10070)
**Author:** [@DavidWisely](https://forum.inductiveautomation.com/u/DavidWisely)\ **Replies:** 9\ **Last updated:** [February 2, 2018, 8:20pm UTC](https://forum.inductiveautomation.com/t/script-resource-locked/10070 "2018-02-02T20:20:03Z")
I have a couple of Global Scripts that I cannot delete or edit and when I try to open them they display a ‘Script Resource Locked’ message as shown here: This came about when I copied the scripts from a project folde… --- ## [Spinner number format - show as thousands](https://forum.inductiveautomation.com/t/spinner-number-format-show-as-thousands/16852)
**Author:** [@mrogers](https://forum.inductiveautomation.com/u/mrogers)\ **Replies:** 2\ **Last updated:** [February 2, 2018, 5:13pm UTC](https://forum.inductiveautomation.com/t/spinner-number-format-show-as-thousands/16852 "2018-02-02T17:13:34Z")
I think there are other places in Ignition where you can take a number like 1,000,000 or 1,000 and turn it into "1M" and "1K" or something, but the spinner doesn't seem to be one of those places. I have a tag that stores… --- ## [Adjust date column in a table](https://forum.inductiveautomation.com/t/adjust-date-column-in-a-table/16853)
**Author:** [@pjgonzales](https://forum.inductiveautomation.com/u/pjgonzales)\ **Replies:** 0\ **Last updated:** [February 2, 2018, 5:02pm UTC](https://forum.inductiveautomation.com/t/adjust-date-column-in-a-table/16853 "2018-02-02T17:02:33Z")
I have a table pulling tag history for a few tags at 2am every morning. The problem is that the data values are actually for the previous days totals. I need to find a way to adjust the t\_stamp column by -24 hours so it … --- ## [Dataset Conversion Issue](https://forum.inductiveautomation.com/t/dataset-conversion-issue/16843)
**Author:** [@S007](https://forum.inductiveautomation.com/u/S007)\ **Replies:** 2\ **Last updated:** [February 2, 2018, 3:52pm UTC](https://forum.inductiveautomation.com/t/dataset-conversion-issue/16843 "2018-02-02T15:52:25Z")
Hi, I'm grabbing dataset off a table with changeable number of columns but one row. First column is always time\_stamp and rest are integer values. Trying to grab the five highest values and put in a new table. At the ver… --- ## [Timer function that works gloabally(gateway)](https://forum.inductiveautomation.com/t/timer-function-that-works-gloabally-gateway/16849)
**Author:** [@jbb5310](https://forum.inductiveautomation.com/u/jbb5310)\ **Replies:** 3\ **Last updated:** [February 2, 2018, 3:28pm UTC](https://forum.inductiveautomation.com/t/timer-function-that-works-gloabally-gateway/16849 "2018-02-02T15:28:25Z")
I have a timer component that runs based upon a tag Boolean and displays it onto the screen. My problem is that I would like the timer to be synchronized throughout the project. So I guess a gateway script of some sort w… --- ## [Ignition 7.9.6 Installation Issue](https://forum.inductiveautomation.com/t/ignition-7-9-6-installation-issue/16802)
**Author:** [@jim.warren](https://forum.inductiveautomation.com/u/jim.warren)\ **Replies:** 5\ **Last updated:** [February 2, 2018, 1:29pm UTC](https://forum.inductiveautomation.com/t/ignition-7-9-6-installation-issue/16802 "2018-02-02T13:29:24Z")
I have installed Java 8 64-bit and am still getting a pop up, while attempting the Ignition install, that states that Setup was unable to locate Java 8. Any direction on this? --- ## [MQTT / IIOT discussions](https://forum.inductiveautomation.com/t/mqtt-iiot-discussions/12230)
**Author:** [@R.Alamsha](https://forum.inductiveautomation.com/u/R.Alamsha)\ **Replies:** 5\ **Last updated:** [February 2, 2018, 5:36am UTC](https://forum.inductiveautomation.com/t/mqtt-iiot-discussions/12230 "2018-02-02T05:36:50Z")
Is it possible to download and merge datalogs from a remote telemetry RTU into the Ignition historian database using MQTT module?. If NOT, what's the alternative solution?. I did some deep research into Cirrus Link MQT… --- ## [Python Scripting Question](https://forum.inductiveautomation.com/t/python-scripting-question/16841)
**Author:** [@shwethag](https://forum.inductiveautomation.com/u/shwethag)\ **Replies:** 4\ **Last updated:** [February 1, 2018, 10:30pm UTC](https://forum.inductiveautomation.com/t/python-scripting-question/16841 "2018-02-01T22:30:21Z")
Hello All: I am trying to extract bits from integer by using simple python script as shown below: vaule=currentValue\>\>(7&1) system.tag.write(“PLC/SensorFailure”, currentValue) This script works with Python IDE (2.7 a… --- ## [Easy Chart ignoring values](https://forum.inductiveautomation.com/t/easy-chart-ignoring-values/16840)
**Author:** [@Nick.christensen](https://forum.inductiveautomation.com/u/Nick.christensen)\ **Replies:** 1\ **Last updated:** [February 1, 2018, 6:06pm UTC](https://forum.inductiveautomation.com/t/easy-chart-ignoring-values/16840 "2018-02-01T18:06:34Z")
I have an easy chart that is tracking thermocouple data for parts in an oven. Frequently the parts are removed and the thermocouples are unplugged causing there values to go to 770. What i would like to do is have the ea… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1656) [Next page](https://forum.inductiveautomation.com/latest.md?page=1658)