# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1632 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1633 --- ## [Last Update Date](https://forum.inductiveautomation.com/t/last-update-date/4139)
**Author:** [@cbabb](https://forum.inductiveautomation.com/u/cbabb)\ **Replies:** 0\ **Last updated:** [March 13, 2012, 12:47pm UTC](https://forum.inductiveautomation.com/t/last-update-date/4139 "2012-03-13T12:47:16Z")
I was looking for an easy way to display the last update date for a table in my database... This was a quick way I found to do so... Just a SQL query on the text property of a Label object (my DB is MS SQL Server 20… --- ## [License Upgrade Issue](https://forum.inductiveautomation.com/t/license-upgrade-issue/4131)
**Author:** [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Replies:** 3\ **Last updated:** [March 12, 2012, 11:31pm UTC](https://forum.inductiveautomation.com/t/license-upgrade-issue/4131 "2012-03-12T23:31:46Z")
Purchase Upgrade protection for an existing license to cover V7.4. Returned the existing license using web connected activation. Installed V7.4 upgrade. Reactivate license and now get following warning: --- ## [SQL Table Filtering With IF Statement](https://forum.inductiveautomation.com/t/sql-table-filtering-with-if-statement/4115)
**Author:** [@jlr573](https://forum.inductiveautomation.com/u/jlr573)\ **Replies:** 4\ **Last updated:** [March 12, 2012, 6:50pm UTC](https://forum.inductiveautomation.com/t/sql-table-filtering-with-if-statement/4115 "2012-03-12T18:50:57Z")
I'm trying to create some filtering options for the user to allow them to filter the data the see in the table. Here is what I have: WHERE projects.state = {Root Container.drpStateSel.selectedValue} AND {Root Cont… --- ## [Null Pointer error When Copying Folder In Transaction Groups](https://forum.inductiveautomation.com/t/null-pointer-error-when-copying-folder-in-transaction-groups/4086)
**Author:** [@aidamcg](https://forum.inductiveautomation.com/u/aidamcg)\ **Replies:** 3\ **Last updated:** [March 12, 2012, 5:59pm UTC](https://forum.inductiveautomation.com/t/null-pointer-error-when-copying-folder-in-transaction-groups/4086 "2012-03-12T17:59:55Z")
Hi I noticed recently that a null pointer error is generated when trying to copy a folder of transaction groups. Aidan version 7.3.3 --- ## [Ignition 7.3.3 stops to work with error](https://forum.inductiveautomation.com/t/ignition-7-3-3-stops-to-work-with-error/3967)
**Author:** [@koval\_yuriy](https://forum.inductiveautomation.com/u/koval_yuriy)\ **Replies:** 30\ **Last updated:** [March 11, 2012, 12:51pm UTC](https://forum.inductiveautomation.com/t/ignition-7-3-3-stops-to-work-with-error/3967 "2012-03-11T12:51:11Z")
Hi! I have a project wich gateway data between two OPC. System start to work and work a few hours. After this the tags stops to updates and writes to another tags and the errors occures in console. What is the reason? L… --- ## [Grouping components](https://forum.inductiveautomation.com/t/grouping-components/3724)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 12\ **Last updated:** [March 9, 2012, 10:46pm UTC](https://forum.inductiveautomation.com/t/grouping-components/3724 "2012-03-09T22:46:00Z")
I'm trying to group a bunch of components and the container that hold them. I can group the contents of the container. This creates a new "group" item in the container and places the items below it creating a new level. … --- ## [Table Image Mapping](https://forum.inductiveautomation.com/t/table-image-mapping/4128)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 4\ **Last updated:** [March 9, 2012, 8:21pm UTC](https://forum.inductiveautomation.com/t/table-image-mapping/4128 "2012-03-09T20:21:27Z")
I must be missing something obvious, but if I use image mapping on a table, is there a way to display no image on certain values? For instance, if the value is zero, display no image, if one, display image 1, if two, dis… --- ## [Contrologix Connection: - OPC server or Ignition Driver](https://forum.inductiveautomation.com/t/contrologix-connection-opc-server-or-ignition-driver/4127)
**Author:** [@kevin.keefe](https://forum.inductiveautomation.com/u/kevin.keefe)\ **Replies:** 2\ **Last updated:** [March 9, 2012, 3:21pm UTC](https://forum.inductiveautomation.com/t/contrologix-connection-opc-server-or-ignition-driver/4127 "2012-03-09T15:21:05Z")
Greetings. My first post here so please bear with me. I am in a bit of a quandry at present as to the best way to communicate with a Contrologix PLC. We currently run Topserver as a opc server, communicating with a numb… --- ## [Module SDK & DBQuery](https://forum.inductiveautomation.com/t/module-sdk-dbquery/4117)
**Author:** [@bryan\_cook](https://forum.inductiveautomation.com/u/bryan_cook)\ **Replies:** 4\ **Last updated:** [March 8, 2012, 6:38pm UTC](https://forum.inductiveautomation.com/t/module-sdk-dbquery/4117 "2012-03-08T18:38:32Z")
I just started tinkering with this now, haven't fully grasped how to use it yet so correct me if this is already possible ... I think it'd be pretty nifty to, instead of using ... query.addTable("Table"); query.add… --- ## [7.4 upgrade](https://forum.inductiveautomation.com/t/7-4-upgrade/4114)
**Author:** [@Joseph\_Mendonca](https://forum.inductiveautomation.com/u/Joseph_Mendonca)\ **Replies:** 6\ **Last updated:** [March 8, 2012, 5:23pm UTC](https://forum.inductiveautomation.com/t/7-4-upgrade/4114 "2012-03-08T17:23:13Z")
Will there be an online training video or example project available soon? --- ## [Field 'alertExpressionSource' is required](https://forum.inductiveautomation.com/t/field-alertexpressionsource-is-required/4107)
**Author:** [@ecujak](https://forum.inductiveautomation.com/u/ecujak)\ **Replies:** 7\ **Last updated:** [March 8, 2012, 4:43pm UTC](https://forum.inductiveautomation.com/t/field-alertexpressionsource-is-required/4107 "2012-03-08T16:43:57Z")
\[size=150\]\[color=#FF0000\]Field 'alertExpressionSource' is required.\[/color\]\[/size\] I see this but there isn't documentation for this in the manual. I am trying to set up a Distribution alert. Having trouble with set… --- ## [OPC-UA in JAVA](https://forum.inductiveautomation.com/t/opc-ua-in-java/4120)
**Author:** [@SamJaimes](https://forum.inductiveautomation.com/u/SamJaimes)\ **Replies:** 1\ **Last updated:** [March 8, 2012, 12:19pm UTC](https://forum.inductiveautomation.com/t/opc-ua-in-java/4120 "2012-03-08T12:19:43Z")
Does anybody knows if opc-ua module is totally in java or in a lower level include another language like c++? Regards --- ## [Upgrade redundant system](https://forum.inductiveautomation.com/t/upgrade-redundant-system/4104)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 7\ **Last updated:** [March 7, 2012, 10:23pm UTC](https://forum.inductiveautomation.com/t/upgrade-redundant-system/4104 "2012-03-07T22:23:25Z")
What is the proper procedure for upgrading a redundant ignition system so the clients do not get kicked off? upgrade the master first or the backup? --- ## [Background print window](https://forum.inductiveautomation.com/t/background-print-window/4110)
**Author:** [@fadihindi](https://forum.inductiveautomation.com/u/fadihindi)\ **Replies:** 1\ **Last updated:** [March 7, 2012, 3:23am UTC](https://forum.inductiveautomation.com/t/background-print-window/4110 "2012-03-07T03:23:28Z")
What would be a simple method of printing a window in the background without it opening up on the client? In other words at a specific time each day I would like a target window to be populated with all current data, and… --- ## [Inconsistent window/component sizing/placement using scripts](https://forum.inductiveautomation.com/t/inconsistent-window-component-sizing-placement-using-scripts/3841)
**Author:** [@Greg.Buehler](https://forum.inductiveautomation.com/u/Greg.Buehler)\ **Replies:** 7\ **Last updated:** [March 7, 2012, 1:05am UTC](https://forum.inductiveautomation.com/t/inconsistent-window-component-sizing-placement-using-scripts/3841 "2012-03-07T01:05:45Z")
I’m encountering some issues with sizing and placement of windows and components using scripting. For example, the following window never resized when it was opened by the user and the bottom part of the popup is “cut of… --- ## [Custom Data Driven Provider is showing stale tags](https://forum.inductiveautomation.com/t/custom-data-driven-provider-is-showing-stale-tags/4108)
**Author:** [@Greg.Buehler](https://forum.inductiveautomation.com/u/Greg.Buehler)\ **Replies:** 1\ **Last updated:** [March 7, 2012, 12:14am UTC](https://forum.inductiveautomation.com/t/custom-data-driven-provider-is-showing-stale-tags/4108 "2012-03-07T00:14:15Z")
I'm looking into driving a custom driver and the values for my tags within Ignition are updating, but they are 'stale'. From my understanding of the custom driver whitepaper, I need to: - update the tag value and th… --- ## [Expression length limit?](https://forum.inductiveautomation.com/t/expression-length-limit/4105)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 3\ **Last updated:** [March 6, 2012, 7:29pm UTC](https://forum.inductiveautomation.com/t/expression-length-limit/4105 "2012-03-06T19:29:18Z")
is the length of the expression limited ? I try to use it to compute a group of alarm tag for each equipement with 9 defects: ({\[.\]Defauts/Affichage.AlertCurrentSeverity}=4)|| ({\[.\]Defauts/AnnonceSonore.AlertCurrentSever… --- ## [Problems connecting to new OPC server](https://forum.inductiveautomation.com/t/problems-connecting-to-new-opc-server/4106)
**Author:** [@dfenter](https://forum.inductiveautomation.com/u/dfenter)\ **Replies:** 1\ **Last updated:** [March 6, 2012, 4:17pm UTC](https://forum.inductiveautomation.com/t/problems-connecting-to-new-opc-server/4106 "2012-03-06T16:17:29Z")
I am having problem connecting to a new OPC server that we have set up. It is a Kepware server. I have gone through the configuration, and verified that the IP address, security policy, and message security mode are c… --- ## [DataBase write interval](https://forum.inductiveautomation.com/t/database-write-interval/4096)
**Author:** [@DennisWomack](https://forum.inductiveautomation.com/u/DennisWomack)\ **Replies:** 4\ **Last updated:** [March 5, 2012, 4:15pm UTC](https://forum.inductiveautomation.com/t/database-write-interval/4096 "2012-03-05T16:15:11Z")
I have some tags marked as historical. They are in the default scanclass and the rate is set at 10 seconds. The values are pulled out of a PLC and change once per hour. These tags are pulled into Easy Chart. When … --- ## [Example of code and location for exporting to an excel sheet](https://forum.inductiveautomation.com/t/example-of-code-and-location-for-exporting-to-an-excel-sheet/4098)
**Author:** [@amr123](https://forum.inductiveautomation.com/u/amr123)\ **Replies:** 3\ **Last updated:** [March 5, 2012, 3:22pm UTC](https://forum.inductiveautomation.com/t/example-of-code-and-location-for-exporting-to-an-excel-sheet/4098 "2012-03-05T15:22:59Z")
I need an example of where, how and what sytax to use for sending my alert log to an excel file ever 24 hours at mid night. I can make it create and send to excel by clicking a button with the code below in the event h… --- ## [Gradient Tools](https://forum.inductiveautomation.com/t/gradient-tools/4100)
**Author:** [@Joseph\_Mendonca](https://forum.inductiveautomation.com/u/Joseph_Mendonca)\ **Replies:** 1\ **Last updated:** [March 3, 2012, 6:15pm UTC](https://forum.inductiveautomation.com/t/gradient-tools/4100 "2012-03-03T18:15:34Z")
Trying to vary the colors in a circle and maintain the same gradient. However, the style customizer does not have the gradient tool box for the fill paint properties in the drop down menu. Also, unable to alter the fi… --- ## [Alerting and linking and the file trail](https://forum.inductiveautomation.com/t/alerting-and-linking-and-the-file-trail/4099)
**Author:** [@tailfire](https://forum.inductiveautomation.com/u/tailfire)\ **Replies:** 1\ **Last updated:** [March 3, 2012, 4:25am UTC](https://forum.inductiveautomation.com/t/alerting-and-linking-and-the-file-trail/4099 "2012-03-03T04:25:28Z")
I have 3 basic questions. Where in the “online manual” is alerting discussed? How can I send someone a link in an e-mail that will directly link to a project and launch it? Where are the settings if any to not l… --- ## [SelectedXValue on Easy Chart plotting other plots](https://forum.inductiveautomation.com/t/selectedxvalue-on-easy-chart-plotting-other-plots/4094)
**Author:** [@ryanbeno](https://forum.inductiveautomation.com/u/ryanbeno)\ **Replies:** 0\ **Last updated:** [March 2, 2012, 4:35pm UTC](https://forum.inductiveautomation.com/t/selectedxvalue-on-easy-chart-plotting-other-plots/4094 "2012-03-02T16:35:11Z")
We are looking for an enhancement where selectedXValue can plot on any plot not just the top plot in an Easy Chart. This will allow for us to utilize more information pertaining to verious data points within a subplot. --- ## [Ubuntu Upgrade to 7.3.4](https://forum.inductiveautomation.com/t/ubuntu-upgrade-to-7-3-4/4077)
**Author:** [@pphillips](https://forum.inductiveautomation.com/u/pphillips)\ **Replies:** 4\ **Last updated:** [March 2, 2012, 2:56pm UTC](https://forum.inductiveautomation.com/t/ubuntu-upgrade-to-7-3-4/4077 "2012-03-02T14:56:54Z")
I'm running Ubuntu 11.10 64bit and attempted to upgrade to 7.3.4 today with Synaptic Package Manager. The upgrade failed apparently because the installation tried to use the administrator account I was logged in with, bu… --- ## [Ignition Redundancy Setup Problem](https://forum.inductiveautomation.com/t/ignition-redundancy-setup-problem/3995)
**Author:** [@Dodonnell999](https://forum.inductiveautomation.com/u/Dodonnell999)\ **Replies:** 4\ **Last updated:** [March 2, 2012, 10:31am UTC](https://forum.inductiveautomation.com/t/ignition-redundancy-setup-problem/3995 "2012-03-02T10:31:03Z")
I have an Ignition 7.3.2 (b533) system and I want to set the system up with redundancy, I have a second server and second licence but can't seem to get it to work. Both servers are in a DMZ and have a second NIC facing o… --- ## [Convert tag types](https://forum.inductiveautomation.com/t/convert-tag-types/3770)
**Author:** [@Greg.Buehler](https://forum.inductiveautomation.com/u/Greg.Buehler)\ **Replies:** 2\ **Last updated:** [March 2, 2012, 12:53am UTC](https://forum.inductiveautomation.com/t/convert-tag-types/3770 "2012-03-02T00:53:33Z")
It would be really useful to have an option (maybe in the right-click menu) to convert a DB tag to an OPC tag, and vice versa. --- ## [Expression error](https://forum.inductiveautomation.com/t/expression-error/4089)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 2\ **Last updated:** [March 1, 2012, 11:01pm UTC](https://forum.inductiveautomation.com/t/expression-error/4089 "2012-03-01T23:01:35Z")
why do i keep getting this error when the data changes for this expression? if I take out the round it works fine with no error. if(toint({Root Container.Container\_1.lblDist2YearsAgo.text},0)=0,0,round(toint({Root Con… --- ## [Audit creation missing important field](https://forum.inductiveautomation.com/t/audit-creation-missing-important-field/4011)
**Author:** [@jantonevich](https://forum.inductiveautomation.com/u/jantonevich)\ **Replies:** 1\ **Last updated:** [March 1, 2012, 7:43pm UTC](https://forum.inductiveautomation.com/t/audit-creation-missing-important-field/4011 "2012-03-01T19:43:56Z")
The audit is/ will be a great tool, Now all thats missing(as far as I can tell) from this useful audit tool is just a field in the table for the workstation a keypress has come from. For such a widespread-able system you… --- ## [AlarmScreen Errors from ExampleProject on Server](https://forum.inductiveautomation.com/t/alarmscreen-errors-from-exampleproject-on-server/2414)
**Author:** [@noel](https://forum.inductiveautomation.com/u/noel)\ **Replies:** 5\ **Last updated:** [March 1, 2012, 1:29am UTC](https://forum.inductiveautomation.com/t/alarmscreen-errors-from-exampleproject-on-server/2414 "2012-03-01T01:29:03Z")
I want to use the AlarmScreen from the ExampleProject and it appeared fine on my laptop (note I have not altered it from the ExProj) but when I imported my project to my server it started generating errors. I get an Err… --- ## [Write only tags](https://forum.inductiveautomation.com/t/write-only-tags/3715)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 4\ **Last updated:** [February 29, 2012, 3:37pm UTC](https://forum.inductiveautomation.com/t/write-only-tags/3715 "2012-02-29T15:37:36Z")
Many different protocols have the write only concept. Supporting this in SQLTags would make supporting these protocols easier. eg: write a 1 to a control point. The feedback (if any) would be a different point that wou… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1631) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1633)