# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1584 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1585 --- ## [OPC UA tags "STALE"](https://forum.inductiveautomation.com/t/opc-ua-tags-stale/21223)
**Author:** [@adamjaworski](https://forum.inductiveautomation.com/u/adamjaworski)\ **Replies:** 0\ **Last updated:** [December 5, 2018, 3:16am UTC](https://forum.inductiveautomation.com/t/opc-ua-tags-stale/21223 "2018-12-05T03:16:59Z")
Hello, I am having trouble reading some tags from an Allen Bradley Compact Logix PLC into ignition. Ignition Designer indicates that the tag value is null and the quality is unknown. Going onto the ignition server i… --- ## [Legacy CompactLogix driver and v20.19](https://forum.inductiveautomation.com/t/legacy-compactlogix-driver-and-v20-19/19676)
**Author:** [@jciatti](https://forum.inductiveautomation.com/u/jciatti)\ **Replies:** 19\ **Last updated:** [December 4, 2018, 10:57pm UTC](https://forum.inductiveautomation.com/t/legacy-compactlogix-driver-and-v20-19/19676 "2018-12-04T22:57:24Z")
I currently have a trial Gateway setup on my laptop. Ignition: v7.9 Laptop: Windows 7 Network: Cable connected directly to PLC, Bridged network connection through VM Virtual Network Adapter on 172.22.108.xxx subnet C… --- ## [Average of Dataset Column](https://forum.inductiveautomation.com/t/average-of-dataset-column/21216)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 1\ **Last updated:** [December 4, 2018, 7:50pm UTC](https://forum.inductiveautomation.com/t/average-of-dataset-column/21216 "2018-12-04T19:50:19Z")
Continuing with this topic of conversation.. Could someone help me modify my code to filter out certain values when running an average of a column? For example, I would like to exclude any values that are zero. I'm … --- ## [Easy Way to get the Set Difference between datasets?](https://forum.inductiveautomation.com/t/easy-way-to-get-the-set-difference-between-datasets/21214)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 4\ **Last updated:** [December 4, 2018, 7:06pm UTC](https://forum.inductiveautomation.com/t/easy-way-to-get-the-set-difference-between-datasets/21214 "2018-12-04T19:06:07Z")
I have two SELECT queries returning datasets from two different tables that I know for a fact will share some id's. setA = system.db.runQuery(query1) setB = system.db.runQuery(query2) The first column of each set is … --- ## [Commiting Table Edits Without Pressing Enter](https://forum.inductiveautomation.com/t/commiting-table-edits-without-pressing-enter/21210)
**Author:** [@Alexander41](https://forum.inductiveautomation.com/u/Alexander41)\ **Replies:** 2\ **Last updated:** [December 4, 2018, 5:02pm UTC](https://forum.inductiveautomation.com/t/commiting-table-edits-without-pressing-enter/21210 "2018-12-04T17:02:55Z")
I've created a window to allow the client to edit data from my database. It queries the database for a selected row and puts the data for that row into a 1 line table. My idea is to have the table be editable and to ha… --- ## [Values pulled at certain times of day](https://forum.inductiveautomation.com/t/values-pulled-at-certain-times-of-day/21213)
**Author:** [@Schwartzds](https://forum.inductiveautomation.com/u/Schwartzds)\ **Replies:** 2\ **Last updated:** [December 4, 2018, 4:27pm UTC](https://forum.inductiveautomation.com/t/values-pulled-at-certain-times-of-day/21213 "2018-12-04T16:27:00Z")
Need values recorded at certain times of the day. Once recorded I would like output to a table for recall. Any simple way to accomplish? --- ## [Quick Start Guide](https://forum.inductiveautomation.com/t/quick-start-guide/21125)
**Author:** [@Robert.McKenzie](https://forum.inductiveautomation.com/u/Robert.McKenzie)\ **Replies:** 6\ **Last updated:** [December 4, 2018, 4:18pm UTC](https://forum.inductiveautomation.com/t/quick-start-guide/21125 "2018-12-04T16:18:08Z")
Hello and Welcome to the Ignition 8 Beta. We have created a Quick Start Guide to take you from a fresh install of Ignition through creating a basic navigation structure in a Perspective session or in a Vision Client. The… --- ## [Inductive Automation Nexus/Maven server is offline](https://forum.inductiveautomation.com/t/inductive-automation-nexus-maven-server-is-offline/21212)
**Author:** [@stephen.rosenthal](https://forum.inductiveautomation.com/u/stephen.rosenthal)\ **Replies:** 1\ **Last updated:** [December 4, 2018, 3:50pm UTC](https://forum.inductiveautomation.com/t/inductive-automation-nexus-maven-server-is-offline/21212 "2018-12-04T15:50:36Z")
Hi, My company (Seeq) integrates our product with Ignition, and we pull the Ignition libraries from your Maven server. But for the last ~24 hours at least, our developers have not been able to access http://nexus.induc… --- ## [Embedding a window in another window](https://forum.inductiveautomation.com/t/embedding-a-window-in-another-window/21209)
**Author:** [@pandreoli](https://forum.inductiveautomation.com/u/pandreoli)\ **Replies:** 2\ **Last updated:** [December 4, 2018, 3:27pm UTC](https://forum.inductiveautomation.com/t/embedding-a-window-in-another-window/21209 "2018-12-04T15:27:47Z")
I was wondering if theres a way of embedding a window in another window. I understand there are templates that serve this purpose, but templates have restrictions I find it hard to work around. I have a window that cu… --- ## [Can we install ignition 7.7 in the Windows Server 2003](https://forum.inductiveautomation.com/t/can-we-install-ignition-7-7-in-the-windows-server-2003/21192)
**Author:** [@arjunas](https://forum.inductiveautomation.com/u/arjunas)\ **Replies:** 4\ **Last updated:** [December 4, 2018, 5:53am UTC](https://forum.inductiveautomation.com/t/can-we-install-ignition-7-7-in-the-windows-server-2003/21192 "2018-12-04T05:53:18Z")
Hi, Can we install Ignition 7.7 in the Windows Server 2003 with Ram space of 4 GB and internal memory of 100 GB.Thanks in Advance. --- ## [Client Login Failover when LDAP Not Available](https://forum.inductiveautomation.com/t/client-login-failover-when-ldap-not-available/21204)
**Author:** [@Ahiero](https://forum.inductiveautomation.com/u/Ahiero)\ **Replies:** 5\ **Last updated:** [December 3, 2018, 9:09pm UTC](https://forum.inductiveautomation.com/t/client-login-failover-when-ldap-not-available/21204 "2018-12-03T21:09:00Z")
I am trying to figure out a way to handle the following problem: 1) The master server goes down along with the AD server (assume it is on the same box). 2) The backup server assumes control, and the clients are transferr… --- ## [Filling in Table Dataset From Left to Right, Insert New Row](https://forum.inductiveautomation.com/t/filling-in-table-dataset-from-left-to-right-insert-new-row/21193)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 3\ **Last updated:** [December 3, 2018, 7:20pm UTC](https://forum.inductiveautomation.com/t/filling-in-table-dataset-from-left-to-right-insert-new-row/21193 "2018-12-03T19:20:54Z")
I have a manually created dataset in a table. It has a dynamic number of columns, and starts with one empty row. I have a button that should log a time value when pressed. The time should be appended to the table's da… --- ## [Device Simulator and ignition](https://forum.inductiveautomation.com/t/device-simulator-and-ignition/20514)
**Author:** [@udayathome](https://forum.inductiveautomation.com/u/udayathome)\ **Replies:** 20\ **Last updated:** [December 1, 2018, 12:43pm UTC](https://forum.inductiveautomation.com/t/device-simulator-and-ignition/20514 "2018-12-01T12:43:00Z")
Hi All, We are new to using scada ignition software. We are building a device simulation on AWS and nseed to push the data generated from the simulation into ignition database via OPC-UA. Does anyone has any thought on… --- ## [Editable Boolean Column in Table Component Trouble](https://forum.inductiveautomation.com/t/editable-boolean-column-in-table-component-trouble/21202)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 2\ **Last updated:** [December 3, 2018, 6:16pm UTC](https://forum.inductiveautomation.com/t/editable-boolean-column-in-table-component-trouble/21202 "2018-12-03T18:16:25Z")
I have a table component that displays 3 columns from a dataset. Originally I directly put this data into the table by binding it to a SQL query. The data displayed fine. I want the user to be able to check or uncheck… --- ## [NullPointerException at NamedQuey for Insert](https://forum.inductiveautomation.com/t/nullpointerexception-at-namedquey-for-insert/21197)
**Author:** [@AGDC04](https://forum.inductiveautomation.com/u/AGDC04)\ **Replies:** 6\ **Last updated:** [December 3, 2018, 6:01pm UTC](https://forum.inductiveautomation.com/t/nullpointerexception-at-namedquey-for-insert/21197 "2018-12-03T18:01:37Z")
Hello, I’m trying to insert data at a SQL, using a NamedQuery, but showing NullPointer, but can’t see the error: This is the code at ValueChange script: if (currentValue.value != previousValue.value and currentValue.v… --- ## [Alarm and transaction group on same tag](https://forum.inductiveautomation.com/t/alarm-and-transaction-group-on-same-tag/21200)
**Author:** [@19tb21](https://forum.inductiveautomation.com/u/19tb21)\ **Replies:** 1\ **Last updated:** [December 3, 2018, 5:34pm UTC](https://forum.inductiveautomation.com/t/alarm-and-transaction-group-on-same-tag/21200 "2018-12-03T17:34:50Z")
Good Morning, I have an issue that appears to have started after I created a transaction group for a tag. The tag was already an alarm with a working alarm pipeline that sent out email notifications to the on-call ros… --- ## [Disable timers on opening window in designer](https://forum.inductiveautomation.com/t/disable-timers-on-opening-window-in-designer/21198)
**Author:** [@cmaynes](https://forum.inductiveautomation.com/u/cmaynes)\ **Replies:** 2\ **Last updated:** [December 3, 2018, 5:14pm UTC](https://forum.inductiveautomation.com/t/disable-timers-on-opening-window-in-designer/21198 "2018-12-03T17:14:14Z")
I have a window I have put a lot of work into. I accidentally set the timer to a really fast pace. I can no longer open the window without the entire designer freezing. How can I open the window, disabling all timers/scr… --- ## [Delete records older then - Transaction Group](https://forum.inductiveautomation.com/t/delete-records-older-then-transaction-group/21189)
**Author:** [@c.bertulli](https://forum.inductiveautomation.com/u/c.bertulli)\ **Replies:** 4\ **Last updated:** [December 3, 2018, 4:22pm UTC](https://forum.inductiveautomation.com/t/delete-records-older-then-transaction-group/21189 "2018-12-03T16:22:39Z")
Hi All, I have a Transaction Group set as follow: -Execution Scheduling: "Timer ( 450 ms )" -Update Mode: "OPC to DB" -Data Source: "MyDatabase" -Table Name: "MyTable" -Automatically create table: TRUE -Use custom inde… --- ## [Alarm Pipeline - Array of rosters](https://forum.inductiveautomation.com/t/alarm-pipeline-array-of-rosters/20942)
**Author:** [@pat.stave1](https://forum.inductiveautomation.com/u/pat.stave1)\ **Replies:** 1\ **Last updated:** [December 3, 2018, 4:18pm UTC](https://forum.inductiveautomation.com/t/alarm-pipeline-array-of-rosters/20942 "2018-12-03T16:18:55Z")
I have alarms that need to be sent to multipe rosters. The rosters are configured for each alarm by the users. To accomplish this i have configured it as follows: The alarm has a configured custom property "rosters" th… --- ## [Modbus RTU over TCP connection problem](https://forum.inductiveautomation.com/t/modbus-rtu-over-tcp-connection-problem/21188)
**Author:** [@poriev](https://forum.inductiveautomation.com/u/poriev)\ **Replies:** 1\ **Last updated:** [December 3, 2018, 9:34am UTC](https://forum.inductiveautomation.com/t/modbus-rtu-over-tcp-connection-problem/21188 "2018-12-03T09:34:09Z")
Hello! We have high load project on windows server. Ignition version 7.5.12. System says thad java open ~525 threads. There more 80 OPC devices on the project. We add 2 new MRTUoTCP devices, and add tags on the project.… --- ## [Questions about script modules - global variables, scope, etc](https://forum.inductiveautomation.com/t/questions-about-script-modules-global-variables-scope-etc/15191)
**Author:** [@iamthebull](https://forum.inductiveautomation.com/u/iamthebull)\ **Replies:** 7\ **Last updated:** [August 31, 2017, 7:13am UTC](https://forum.inductiveautomation.com/t/questions-about-script-modules-global-variables-scope-etc/15191 "2017-08-31T07:13:57Z")
I have a few questions about the finer details of how script modules work. Part 1 ~ In a script module (shared.testing) I have the following: x = 1 print 'before x=', x def changeX(): global x print 'before:', … --- ## [Offset of address in PLC siemens](https://forum.inductiveautomation.com/t/offset-of-address-in-plc-siemens/21174)
**Author:** [@dang-nh](https://forum.inductiveautomation.com/u/dang-nh)\ **Replies:** 4\ **Last updated:** [December 3, 2018, 6:28am UTC](https://forum.inductiveautomation.com/t/offset-of-address-in-plc-siemens/21174 "2018-12-03T06:28:18Z")
i just still learning Ignition, please help me explain what's offset mean? anyone can help me explain clearly about offset thanks everyone alot --- ## [Split expression function regex query](https://forum.inductiveautomation.com/t/split-expression-function-regex-query/21100)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 7\ **Last updated:** [December 3, 2018, 4:54am UTC](https://forum.inductiveautomation.com/t/split-expression-function-regex-query/21100 "2018-12-03T04:54:56Z")
I'm trying to use the split expression function using a regex expression, but cannot get this working... I want to pull out the R G B values from a HEX colour (e.g. "#FF23DE") using: R = split(replace({New Template.… --- ## [Interfacing using MSMQ](https://forum.inductiveautomation.com/t/interfacing-using-msmq/21137)
**Author:** [@messinm](https://forum.inductiveautomation.com/u/messinm)\ **Replies:** 3\ **Last updated:** [December 2, 2018, 10:16pm UTC](https://forum.inductiveautomation.com/t/interfacing-using-msmq/21137 "2018-12-02T22:16:30Z")
I have a project that will require interfacing to some of our existing systems using MSMQ (Microsoft Message Queue). It appears that Ignition doesn't have MSMQ capability built-in; are there third-party modules that enab… --- ## [Parsing XML using Python Guide](https://forum.inductiveautomation.com/t/parsing-xml-using-python-guide/21177)
**Author:** [@tamerplc](https://forum.inductiveautomation.com/u/tamerplc)\ **Replies:** 0\ **Last updated:** [December 1, 2018, 10:28am UTC](https://forum.inductiveautomation.com/t/parsing-xml-using-python-guide/21177 "2018-12-01T10:28:39Z")
Thanks a lot of ignition community which is amazing from support and cooperation between Ignition’s users and IA . I found below tutorial which well illustrated Python ElementTree package additional to ignition help as w… --- ## [\[Feedback\] Designer Color Contrast](https://forum.inductiveautomation.com/t/feedback-designer-color-contrast/20981)
**Author:** [@David.Reed.Schmidt](https://forum.inductiveautomation.com/u/David.Reed.Schmidt)\ **Replies:** 1\ **Last updated:** [December 1, 2018, 1:07am UTC](https://forum.inductiveautomation.com/t/feedback-designer-color-contrast/20981 "2018-12-01T01:07:17Z")
I realize that low contrast design is a popular option for many user interfaces but I think parts of the new designer are taking this approach slightly farther then I would recommend. For example, the Tags Browser pallet… --- ## [Edge Client Retarget to Controller](https://forum.inductiveautomation.com/t/edge-client-retarget-to-controller/21173)
**Author:** [@bfearnow](https://forum.inductiveautomation.com/u/bfearnow)\ **Replies:** 0\ **Last updated:** [November 30, 2018, 11:09pm UTC](https://forum.inductiveautomation.com/t/edge-client-retarget-to-controller/21173 "2018-11-30T23:09:06Z")
Thanks in advance. Looking for some assistance on a client startup script. Client fallback works great if the controller was running when the client first launches the controller application, but the issue comes about … --- ## [LIKE wildcards in Named Query](https://forum.inductiveautomation.com/t/like-wildcards-in-named-query/21169)
**Author:** [@bellm](https://forum.inductiveautomation.com/u/bellm)\ **Replies:** 5\ **Last updated:** [November 30, 2018, 10:33pm UTC](https://forum.inductiveautomation.com/t/like-wildcards-in-named-query/21169 "2018-11-30T22:33:34Z")
Quick question, is it possible to use a LIKE wildcard in a named query? If so how do you do it? --- ## [Bar Chart - Bar Labels Formats Question](https://forum.inductiveautomation.com/t/bar-chart-bar-labels-formats-question/21170)
**Author:** [@rrowe](https://forum.inductiveautomation.com/u/rrowe)\ **Replies:** 0\ **Last updated:** [November 30, 2018, 9:13pm UTC](https://forum.inductiveautomation.com/t/bar-chart-bar-labels-formats-question/21170 "2018-11-30T21:13:43Z")
Could I configure the bar chart in the reporting module to display the bar labels for the y-axis in hh:mm format? As an example here is a mockup of what I would like to see: I understand that I can get this to work with… --- ## [system.gui.inputBox with Touchscreen mode enabled](https://forum.inductiveautomation.com/t/system-gui-inputbox-with-touchscreen-mode-enabled/21146)
**Author:** [@cesrom](https://forum.inductiveautomation.com/u/cesrom)\ **Replies:** 4\ **Last updated:** [November 30, 2018, 9:03pm UTC](https://forum.inductiveautomation.com/t/system-gui-inputbox-with-touchscreen-mode-enabled/21146 "2018-11-30T21:03:54Z")
Being this the first time I work with touchscreens I just noticed that the keyboard is not shown when entering text on an input pop-up. Both system.gui.inputBox and javax.swing.JOptionPane.showInputDialog fail to summo… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1583) [Next page](https://forum.inductiveautomation.com/latest.md?page=1585)