# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1332 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1333 --- ## [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? --- ## [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… --- ## [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… --- ## [TCP Driver write back documentation](https://forum.inductiveautomation.com/t/tcp-driver-write-back-documentation/21166)
**Author:** [@messinm](https://forum.inductiveautomation.com/u/messinm)\ **Replies:** 1\ **Last updated:** [November 30, 2018, 7:27pm UTC](https://forum.inductiveautomation.com/t/tcp-driver-write-back-documentation/21166 "2018-11-30T19:27:58Z")
I found two pages of documentation that seem to conflict with regard to the TCP driver write back capability. https://docs.inductiveautomation.com/display/DOC/UDP+and+TCP+Drivers+Module says the TCP driver can write… --- ## [Ignition start/end Date property formatting using TO\_STRING Oracle](https://forum.inductiveautomation.com/t/ignition-start-end-date-property-formatting-using-to-string-oracle/21164)
**Author:** [@19tb21](https://forum.inductiveautomation.com/u/19tb21)\ **Replies:** 2\ **Last updated:** [November 30, 2018, 6:30pm UTC](https://forum.inductiveautomation.com/t/ignition-start-end-date-property-formatting-using-to-string-oracle/21164 "2018-11-30T18:30:47Z")
Has anyone had any experience formatting startDate and endDate properties from the native Ignition Date Range slider properly to use the TO\_TIMESTAMP function in an Oracle DB? SELECT "t\_stamp" as "Date/Time", SN as "S… --- ## [SQL Server did not return a response](https://forum.inductiveautomation.com/t/sql-server-did-not-return-a-response/21161)
**Author:** [@francisco.romero](https://forum.inductiveautomation.com/u/francisco.romero)\ **Replies:** 3\ **Last updated:** [November 30, 2018, 6:25pm UTC](https://forum.inductiveautomation.com/t/sql-server-did-not-return-a-response/21161 "2018-11-30T18:25:07Z")
Hi We are using Ignition version 7.9.8 (b2018060714) with java 1.8.0\_171-b11 and Windows Server 2016 We are trying to connect to SQL Server, I am using the sa account. We get the following error: Cannot create Poolab… --- ## [Inserting date and time on condition](https://forum.inductiveautomation.com/t/inserting-date-and-time-on-condition/21157)
**Author:** [@Schwartzds](https://forum.inductiveautomation.com/u/Schwartzds)\ **Replies:** 4\ **Last updated:** [November 30, 2018, 6:05pm UTC](https://forum.inductiveautomation.com/t/inserting-date-and-time-on-condition/21157 "2018-11-30T18:05:34Z")
Anyone have any quick ways of displaying current date and time once a Boolean condition is met? --- ## [What dictates the ordering of the "column attributes" data set for a given table?](https://forum.inductiveautomation.com/t/what-dictates-the-ordering-of-the-column-attributes-data-set-for-a-given-table/21121)
**Author:** [@bankeny2](https://forum.inductiveautomation.com/u/bankeny2)\ **Replies:** 4\ **Last updated:** [November 30, 2018, 4:07pm UTC](https://forum.inductiveautomation.com/t/what-dictates-the-ordering-of-the-column-attributes-data-set-for-a-given-table/21121 "2018-11-30T16:07:34Z")
I have a table that is updated when a window is opened. I have also written some logic to enable/disable column editing for a set of specified columns in the table. It seems to work (partially). However it does not updat… --- ## [Calculating the time between a DATETIME and now](https://forum.inductiveautomation.com/t/calculating-the-time-between-a-datetime-and-now/21151)
**Author:** [@bellm](https://forum.inductiveautomation.com/u/bellm)\ **Replies:** 0\ **Last updated:** [November 30, 2018, 12:20am UTC](https://forum.inductiveautomation.com/t/calculating-the-time-between-a-datetime-and-now/21151 "2018-11-30T00:20:48Z")
I have a Historical Transaction Group where I would like to calculate the time difference between two specific event triggers. Here is what my transaction group looks like: Inside of the DryTime tag I am calculating … --- ## [Trends not showing up on client computers](https://forum.inductiveautomation.com/t/trends-not-showing-up-on-client-computers/21141)
**Author:** [@Schwartzds](https://forum.inductiveautomation.com/u/Schwartzds)\ **Replies:** 2\ **Last updated:** [November 30, 2018, 2:41pm UTC](https://forum.inductiveautomation.com/t/trends-not-showing-up-on-client-computers/21141 "2018-11-30T14:41:09Z")
Deployed 1 client and everything is working except trends. Any suggestions? [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1331) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1333)