# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1307 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1308 --- ## [7.9.11 Release Date](https://forum.inductiveautomation.com/t/7-9-11-release-date/23235)
**Author:** [@ryanjmclaughlin](https://forum.inductiveautomation.com/u/ryanjmclaughlin)\ **Replies:** 5\ **Last updated:** [March 21, 2019, 3:11pm UTC](https://forum.inductiveautomation.com/t/7-9-11-release-date/23235 "2019-03-21T15:11:25Z")
Lots of bug fixes in 7.9.11. It’s been in beta for a while. Any ETA on a final release? --- ## [\[BUG-13231\] Write values to a long datatype, gets wrong value](https://forum.inductiveautomation.com/t/bug-13231-write-values-to-a-long-datatype-gets-wrong-value/23479)
**Author:** [@MartenS](https://forum.inductiveautomation.com/u/MartenS)\ **Replies:** 10\ **Last updated:** [March 21, 2019, 2:30pm UTC](https://forum.inductiveautomation.com/t/bug-13231-write-values-to-a-long-datatype-gets-wrong-value/23479 "2019-03-21T14:30:15Z")
Hi. I’m having strange issues when writing big values to an tag of datatype long. For example: If I copy this value: 20190320140538866 into my tag through “Tag Browser” it will be ok. If i write it from a script like… --- ## [Syntax for Component Property in Client Event Script](https://forum.inductiveautomation.com/t/syntax-for-component-property-in-client-event-script/23505)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 3\ **Last updated:** [March 21, 2019, 2:23pm UTC](https://forum.inductiveautomation.com/t/syntax-for-component-property-in-client-event-script/23505 "2019-03-21T14:23:57Z")
I tried using event.source.parent.getComponent in a client event script, but I get an error message that says ‘event’ is not defined. --- ## [Daylight Savings Time - Reports Bug](https://forum.inductiveautomation.com/t/daylight-savings-time-reports-bug/23507)
**Author:** [@SvbHvman](https://forum.inductiveautomation.com/u/SvbHvman)\ **Replies:** 0\ **Last updated:** [March 21, 2019, 1:35pm UTC](https://forum.inductiveautomation.com/t/daylight-savings-time-reports-bug/23507 "2019-03-21T13:35:46Z")
Scenario. Report data required to be reported monthly by day (a monthly report with data for each day). Incorrect report data occurs on the date of the time change and persists for the remainder of the month. Report s… --- ## [SQL Server on same VM as Gateway?](https://forum.inductiveautomation.com/t/sql-server-on-same-vm-as-gateway/23490)
**Author:** [@brandon.hughes](https://forum.inductiveautomation.com/u/brandon.hughes)\ **Replies:** 3\ **Last updated:** [March 20, 2019, 6:32pm UTC](https://forum.inductiveautomation.com/t/sql-server-on-same-vm-as-gateway/23490 "2019-03-20T18:32:30Z")
Hi, My company has recently purchased Ignition, and we are in the process of setting up the gateway on a VM. The question I have is, would it be practical to set up our SQL server on the same VM as our gateway? Thanks … --- ## [Running an Update Query From a Button/ SQL Jython problems](https://forum.inductiveautomation.com/t/running-an-update-query-from-a-button-sql-jython-problems/23486)
**Author:** [@ethanrendlen](https://forum.inductiveautomation.com/u/ethanrendlen)\ **Replies:** 3\ **Last updated:** [March 20, 2019, 5:39pm UTC](https://forum.inductiveautomation.com/t/running-an-update-query-from-a-button-sql-jython-problems/23486 "2019-03-20T17:39:16Z")
Hello, I am trying to do the SQL Update off of a EventHandler MousePressed. Click a button to add a entry in the MS SQL database. I want to update the database (which is one column at the moment, and the datatype is nv… --- ## [Bar Char Series Colors](https://forum.inductiveautomation.com/t/bar-char-series-colors/23487)
**Author:** [@David.Reed.Schmidt](https://forum.inductiveautomation.com/u/David.Reed.Schmidt)\ **Replies:** 1\ **Last updated:** [March 20, 2019, 5:20pm UTC](https://forum.inductiveautomation.com/t/bar-char-series-colors/23487 "2019-03-20T17:20:06Z")
I would like to customize the Series Colors on a Bar Chart component. I’m querying downtime counts by reason from an SQL database. Each downtime reason has a color associated with it. I would like the Series Color on the… --- ## [Modelling Table scrollbar](https://forum.inductiveautomation.com/t/modelling-table-scrollbar/23478)
**Author:** [@f.pinciaroli](https://forum.inductiveautomation.com/u/f.pinciaroli)\ **Replies:** 0\ **Last updated:** [March 20, 2019, 2:07pm UTC](https://forum.inductiveautomation.com/t/modelling-table-scrollbar/23478 "2019-03-20T14:07:32Z")
Hello, I would like to resize the scrollBar of a specific table. I was able to set the width with: \`event.source.parent.getComponent('TableProducts2').getVerticalScrollBar().setPreferredSize( Dimension(70, Integer.MAX… --- ## [Store and Forward for DB insert via script](https://forum.inductiveautomation.com/t/store-and-forward-for-db-insert-via-script/23324)
**Author:** [@pawel.kondol](https://forum.inductiveautomation.com/u/pawel.kondol)\ **Replies:** 2\ **Last updated:** [March 20, 2019, 7:33am UTC](https://forum.inductiveautomation.com/t/store-and-forward-for-db-insert-via-script/23324 "2019-03-20T07:33:49Z")
HI All, Can database insert through scripting for Store and Forward. Is this function available and how to enable it. There are occasions when DB is down for few minutes and I have few scripts to add manually downtime o… --- ## [Popup Calendar Display](https://forum.inductiveautomation.com/t/popup-calendar-display/23473)
**Author:** [@Dilan](https://forum.inductiveautomation.com/u/Dilan)\ **Replies:** 0\ **Last updated:** [March 20, 2019, 6:43am UTC](https://forum.inductiveautomation.com/t/popup-calendar-display/23473 "2019-03-20T06:43:46Z")
Hi All, Just a quick one, I would like to center the pop up calendar display once selected, but I seem to be missing the ability to do this. Please see attached. --- ## [Save Search Results](https://forum.inductiveautomation.com/t/save-search-results/23472)
**Author:** [@sgchris.williams](https://forum.inductiveautomation.com/u/sgchris.williams)\ **Replies:** 0\ **Last updated:** [March 20, 2019, 4:40am UTC](https://forum.inductiveautomation.com/t/save-search-results/23472 "2019-03-20T04:40:08Z")
Hi, i have a tab strip to switch between screens, the main window that i’m having an issue with has drop down boxes that i want to keep the selected name, when another tab has been selected, i have read a few posts wher… --- ## [How do I setDomainGridlineStroke - Report Viewer - Time Series Chart Scripting](https://forum.inductiveautomation.com/t/how-do-i-setdomaingridlinestroke-report-viewer-time-series-chart-scripting/23234)
**Author:** [@paulm1](https://forum.inductiveautomation.com/u/paulm1)\ **Replies:** 1\ **Last updated:** [March 19, 2019, 11:06pm UTC](https://forum.inductiveautomation.com/t/how-do-i-setdomaingridlinestroke-report-viewer-time-series-chart-scripting/23234 "2019-03-19T23:06:12Z")
In the Report environment, I am currently using the following script to change my Time Series Chart Gridline colors. from java.awt import Color from org.jfree.chart.plot import CategoryPlot plot = chart.getPlot() plo… --- ## [Lookup expression Error](https://forum.inductiveautomation.com/t/lookup-expression-error/10481)
**Author:** [@jreynolds](https://forum.inductiveautomation.com/u/jreynolds)\ **Replies:** 8\ **Last updated:** [March 19, 2019, 10:21pm UTC](https://forum.inductiveautomation.com/t/lookup-expression-error/10481 "2019-03-19T22:21:57Z")
I’m trying to pull a value from a dataset using the lookup expression, but all I get is the failover value. lookup({Root Container.bsktData},"BSKTLOC\_01",0,2) I’m wanting to grab the bskt\_id based on the BSKTLOC\_## --- ## [SQL Query with realtime tag values](https://forum.inductiveautomation.com/t/sql-query-with-realtime-tag-values/23467)
**Author:** [@joshdunstan](https://forum.inductiveautomation.com/u/joshdunstan)\ **Replies:** 3\ **Last updated:** [March 19, 2019, 9:55pm UTC](https://forum.inductiveautomation.com/t/sql-query-with-realtime-tag-values/23467 "2019-03-19T21:55:44Z")
With the query below, I’d like to use it to build a table that shows be both an offline (DB) and online (PLC) value for some recipe management. I’d like to do this with a query alone but am having issues getting a dynami… --- ## [Power Table not recognizing datetime2 fields as a date column](https://forum.inductiveautomation.com/t/power-table-not-recognizing-datetime2-fields-as-a-date-column/23372)
**Author:** [@silverbacknet](https://forum.inductiveautomation.com/u/silverbacknet)\ **Replies:** 5\ **Last updated:** [March 19, 2019, 8:19pm UTC](https://forum.inductiveautomation.com/t/power-table-not-recognizing-datetime2-fields-as-a-date-column/23372 "2019-03-19T20:19:26Z")
I’m pulling in several fields to a power table, and I’d like to both use power table’s built-in formatter and enable users to edit the date with a date picker instead of typing. Power table always sees it as a string fie… --- ## [Can't Open a Window](https://forum.inductiveautomation.com/t/cant-open-a-window/23452)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 1\ **Last updated:** [March 19, 2019, 6:28pm UTC](https://forum.inductiveautomation.com/t/cant-open-a-window/23452 "2019-03-19T18:28:25Z")
A project I am working on has a nav bar where one button points to a screen “Popup\_Help”. Trying to open this in the Designer and the Client view fail however. I know the window exists, I can see it in the Project Brow… --- ## [Use direct tag value inside a Named Query in reporting module](https://forum.inductiveautomation.com/t/use-direct-tag-value-inside-a-named-query-in-reporting-module/23443)
**Author:** [@Mr.K001](https://forum.inductiveautomation.com/u/Mr.K001)\ **Replies:** 4\ **Last updated:** [March 19, 2019, 4:19pm UTC](https://forum.inductiveautomation.com/t/use-direct-tag-value-inside-a-named-query-in-reporting-module/23443 "2019-03-19T16:19:31Z")
Hey gang, I’m just throwing this out there to see if anyone has any genius ideas… Is there a way to add a tag value inside of a Name Query without using the parameters? like in a normal Query you can include the {tag p… --- ## [Green question on tags](https://forum.inductiveautomation.com/t/green-question-on-tags/23413)
**Author:** [@sullah1](https://forum.inductiveautomation.com/u/sullah1)\ **Replies:** 3\ **Last updated:** [March 19, 2019, 4:16pm UTC](https://forum.inductiveautomation.com/t/green-question-on-tags/23413 "2019-03-19T16:16:22Z")
I see green question mark on the Tags and it shows the static value of the tag. I am using Ignition 7.9.7 version. I drag and drop the tags using OPC DA server, the values of the tags were updating but now most of them g… --- ## [Store and Forward ERROR: value too long for type character varying(255)](https://forum.inductiveautomation.com/t/store-and-forward-error-value-too-long-for-type-character-varying-255/23432)
**Author:** [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Replies:** 1\ **Last updated:** [March 19, 2019, 4:12pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-error-value-too-long-for-type-character-varying-255/23432 "2019-03-19T16:12:37Z")
Every once in a while I get this “ERROR: value too long for type character varying(255)” in the gateway log. The interesting thing is that I’ve changed all the fields in the ‘alarm\_events’ and ‘alarm\_events\_data’ from v… --- ## [Modify tab buttons](https://forum.inductiveautomation.com/t/modify-tab-buttons/23444)
**Author:** [@bchristenson](https://forum.inductiveautomation.com/u/bchristenson)\ **Replies:** 0\ **Last updated:** [March 19, 2019, 3:52pm UTC](https://forum.inductiveautomation.com/t/modify-tab-buttons/23444 "2019-03-19T15:52:52Z")
Hi, Is there any way to modify how much the tabs skip while pressing the 2 buttons ignition offers automatically? i’m talking about the buttons in my screenshot: I would like to click on it once and have it skip an en… --- ## [Progress Bar Font Color](https://forum.inductiveautomation.com/t/progress-bar-font-color/23442)
**Author:** [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Replies:** 0\ **Last updated:** [March 19, 2019, 2:46pm UTC](https://forum.inductiveautomation.com/t/progress-bar-font-color/23442 "2019-03-19T14:46:15Z")
I have read through what I could find about the progress bar, it appears that the Font Color can’t be changed. Is this correct? I have “Show Percentage” checked and I want to change that color. Thanks --- ## [Multiple conditions for a boolean tag change](https://forum.inductiveautomation.com/t/multiple-conditions-for-a-boolean-tag-change/23435)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 1\ **Last updated:** [March 19, 2019, 2:19pm UTC](https://forum.inductiveautomation.com/t/multiple-conditions-for-a-boolean-tag-change/23435 "2019-03-19T14:19:04Z")
I have a popup window that is supposed to appear and be mandatory to fill out. It is supposed to appear by either being triggered manually via a button, or automatically. The automatic part is the tricky part here - it… --- ## [Unable to login to client under administrator after power failure](https://forum.inductiveautomation.com/t/unable-to-login-to-client-under-administrator-after-power-failure/23437)
**Author:** [@readywebsolutions](https://forum.inductiveautomation.com/u/readywebsolutions)\ **Replies:** 0\ **Last updated:** [March 19, 2019, 1:51pm UTC](https://forum.inductiveautomation.com/t/unable-to-login-to-client-under-administrator-after-power-failure/23437 "2019-03-19T13:51:00Z")
Has anyone run into this problem before? After server shutdown due to power failure the Client refuses to accept any user with the Administrator’s role. I successfully log in with a user under another role (Operator, etc… --- ## [Get min/max/average values from dataset](https://forum.inductiveautomation.com/t/get-min-max-average-values-from-dataset/20988)
**Author:** [@ASF](https://forum.inductiveautomation.com/u/ASF)\ **Replies:** 11\ **Last updated:** [March 19, 2019, 12:33pm UTC](https://forum.inductiveautomation.com/t/get-min-max-average-values-from-dataset/20988 "2019-03-19T12:33:38Z")
I have a script which uses system.tag.queryTagHistory to retrieve log data in 15 minute intervals for the previous 24 hours. I run it three times, and get a minimum dataset, a maximum dataset, and an average dataset. Now… --- ## [Creating DB connection to a SQL Server using Windows Authentication for a group of Users](https://forum.inductiveautomation.com/t/creating-db-connection-to-a-sql-server-using-windows-authentication-for-a-group-of-users/18869)
**Author:** [@jayakishoreanish](https://forum.inductiveautomation.com/u/jayakishoreanish)\ **Replies:** 1\ **Last updated:** [March 19, 2019, 12:12am UTC](https://forum.inductiveautomation.com/t/creating-db-connection-to-a-sql-server-using-windows-authentication-for-a-group-of-users/18869 "2019-03-19T00:12:47Z")
Hi All, Is it possible to setup a Database connection for a group of Windows Authenticated Users to SQL Server. Under the properties of the Ignition Gateway Services , in the log on Tab, the Windows User Groups created… --- ## [Reading and Processing CSVs - intermittent errors](https://forum.inductiveautomation.com/t/reading-and-processing-csvs-intermittent-errors/23393)
**Author:** [@AIO](https://forum.inductiveautomation.com/u/AIO)\ **Replies:** 5\ **Last updated:** [March 18, 2019, 9:51pm UTC](https://forum.inductiveautomation.com/t/reading-and-processing-csvs-intermittent-errors/23393 "2019-03-18T21:51:17Z")
Hey folks, Apologies for the formatting. I have a batch of CSV files that I would like to read in to a dataset, find the line of best fit equation, then use this equation to generate a new dataset at regular intervals. … --- ## [Gateway event script running a named update query](https://forum.inductiveautomation.com/t/gateway-event-script-running-a-named-update-query/23425)
**Author:** [@dion.botha](https://forum.inductiveautomation.com/u/dion.botha)\ **Replies:** 1\ **Last updated:** [March 18, 2019, 8:42pm UTC](https://forum.inductiveautomation.com/t/gateway-event-script-running-a-named-update-query/23425 "2019-03-18T20:42:03Z")
Hi Guys, I can't get a timer (every 5 seconds) gateway event script that runs a named update query to work. If I run the same code on a button it works as expected... Any assistance would be appreciated. Named Query: … --- ## [Chart Component Blank Space](https://forum.inductiveautomation.com/t/chart-component-blank-space/23422)
**Author:** [@Phil\_B](https://forum.inductiveautomation.com/u/Phil_B)\ **Replies:** 12\ **Last updated:** [March 18, 2019, 8:14pm UTC](https://forum.inductiveautomation.com/t/chart-component-blank-space/23422 "2019-03-18T20:14:16Z")
I am trying to learn JFreeChart within the Cart component in Ignition. I have figured out most of what i wanted but i can’t seem to get the last piece of the puzzle. I am trying to remove the space between the top of the… --- ## [Twilio alarm acknowledgement stops](https://forum.inductiveautomation.com/t/twilio-alarm-acknowledgement-stops/23294)
**Author:** [@Sammy5](https://forum.inductiveautomation.com/u/Sammy5)\ **Replies:** 3\ **Last updated:** [March 18, 2019, 7:06pm UTC](https://forum.inductiveautomation.com/t/twilio-alarm-acknowledgement-stops/23294 "2019-03-18T19:06:00Z")
I have set the ‘t.TwilioNotificationProfile’ and ‘c.d.i.t.a.TwilioAckManager’ to debug levels, and while that does show in greater detail when the SMS is acknowledged, I am at this time unable to see anything for when th… --- ## [MQTT Sensor data](https://forum.inductiveautomation.com/t/mqtt-sensor-data/23423)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 0\ **Last updated:** [March 18, 2019, 5:34pm UTC](https://forum.inductiveautomation.com/t/mqtt-sensor-data/23423 "2019-03-18T17:34:54Z")
If I have sensors that can transmit data using MQTT, what do I need on Ignition’s side to be able use that data? I saw Kepware has an MQTT Client Driver, then Ignition has the Edge modules, and Cirrus Link has some optio… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1306) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1308)